Google Digital Marketing and E-commerce Professional Certificate • STUDY MODE

WEEKLY CHALLENGE 4

QUESTION 1 OF 52

Which of the following are reasons why stakeholders might be important to a project or campaign? Select all that apply.

Stakeholders coordinate marketing activities and initiatives.

Stakeholders often analyze the data from a campaign.

Stakeholders strongly influence the success of a project or campaign.Correct Answer

Stakeholders often fund projects or operate budgets for campaigns.Correct Answer

QUESTION 2 OF 52

Which of the following might be reasons to create a stakeholder map? Select all that apply.

To help coordinate marketing activities and initiatives and identify target audiences through research

To allow for people to better manage stakeholders’ expectations and avoid information overloadCorrect Answer

To help people work effectively without having the process consume too much of their time or energyCorrect Answer

To make it easier to identify the type and amount of interaction needed to maintain each stakeholderCorrect Answer

QUESTION 3 OF 52

Which of the following are spreadsheet features that support preparing data to be shared? Select all that apply.

Acquiring

Pivot tables (CORRECT

SortingCorrect Answer

FilteringCorrect Answer

QUESTION 4 OF 52

What is the purpose of a pivot table?

Pivot tables display individual measurements in a vertical column.

Pivot tables display how a metric changes over an extended time connected with a continuous line.

Pivot tables change the view of data in a spreadsheet to a different perspective to categorize it, or to identify an insight or trend.Correct Answer

Pivot tables display individual data points that have been categorized into ranges, with the frequency of each range represented by the height of a unique column.

QUESTION 5 OF 52

Which of the following visualizations shows individual data points that have been categorized into ranges, with the frequency of each range represented by the height of a unique column?

pivot table

spreadsheet

histogramCorrect Answer

pie chart

QUESTION 6 OF 52

A marketer is creating a presentation using marketing analytics data. How can they use data to lead their audience to agree with their final conclusion? Select all that apply.

Include all the data collected about the topic of their presentation

Omit most of the data collected and put together a short presentation

Include the most relevant metrics that led to their insightsCorrect Answer

Develop a clear outline or flow for their presentationCorrect Answer

QUESTION 7 OF 52

On a marketing team, who is responsible for running campaigns, identifying target audiences through research, and evaluating trends?

Stakeholder

Customer service agent

Marketing coordinatorCorrect Answer

Sales manager

QUESTION 8 OF 52

Which of the following would enable a data analyst to communicate with databases developed by different vendors and hosted on multiple platforms?

Structured query languageCorrect Answer

Spreadsheets

Filtering

Sorting

QUESTION 9 OF 52

Which of the following resources help marketers visualize data with custom reports and dashboards? Select all that apply.

Google Sheets

Microsoft Excel

Google Data StudioCorrect Answer

TableauCorrect Answer

QUESTION 10 OF 52

Imagine a marketer is working on a campaign and wants to request a change to the budget. Which of the following presentation best practices should they use to get this change approved by stakeholders? Select all that apply.

Do not allow any time for questions

Start with a general status of the campaign and then move on to the specifics of making a change to the budgetCorrect Answer

Create visualizations of the data using titles that relate back to the insightsCorrect Answer

End the presentation with changing the budget as a call to action for stakeholdersCorrect Answer

QUESTION 11 OF 52

Which of the following are important to understand when interacting with a stakeholder about a project? Select all that apply.

What the stakeholder thinks about project team members on the project

Which communication methods a stakeholder prefersCorrect Answer

The stakeholder’s interest in the project and what their needs areCorrect Answer

When to communicate with a stakeholderCorrect Answer

QUESTION 12 OF 52

Imagine that a marketer is working with a dataset in a spreadsheet. They want to view the data from a new perspective to help them categorize it and identify insights or trends. What spreadsheet tool should they use?

Data visualization

Values

Pivot tableCorrect Answer

Columns

QUESTION 13 OF 52

Which of the following charts represents data in the same way as a line chart, but with the space under the line filled in to form a visual area?

Histogram

Area chartCorrect Answer

Horizontal bar chart

Pie chart

QUESTION 14 OF 52

Which of the following tasks would a marketing coordinator be responsible for? Select all that apply.

Applying statistical methods to data

Identifying target audiences through researchCorrect Answer

Running campaignsCorrect Answer

Evaluating trendsCorrect Answer

QUESTION 15 OF 52

Which of the following is a visual analytics platform that makes it easier to explore and manage data, and to create custom dashboards that incorporate different data visualizations in one place?

Google Sheets

TableauCorrect Answer

Microsoft Office

PowerPoint

QUESTION 16 OF 52

Which of the following are considered best practices when creating slides for a presentation? Select all that apply.

Progress from specific to general topics

Repeat the insights when presenting the relevant, supporting dataCorrect Answer

Introduce data visualizations using titles that relate back to the insightsCorrect Answer

Allow time for questions so the audience can reach the same conclusionCorrect Answer

QUESTION 17 OF 52

Which of the following describes the relationship between stakeholders and marketing coordinators?

Stakeholders collect data, apply statistical methods, and create data visualization. Marketing coordinators identify target audiences through research, run campaigns, and evaluate trends.

Marketing coordinators collect data, apply statistical methods, and create data visualization. Stakeholders identify target audiences through research, run campaigns, and evaluate trends.

Marketing coordinators fund projects and ensure a project’s success. Stakeholders keep the marketing coordinator informed about a project’s progress, ongoing metrics, and insights.

Stakeholders fund projects and ensure a project’s success. Marketing coordinators keep stakeholders informed about a project’s progress, ongoing metrics, and insights.Correct Answer

QUESTION 18 OF 52

Which of the following visualizations includes individual data points for a changing variable connected by a continuous line?

line chartCorrect Answer

single column chart

vertical bar chart

pie chart

QUESTION 19 OF 52

Fill in the blank A _____ could blend a marketing coordinator and a data analyst role into a single marketing specialist role.

stakeholder role

new role

hybrid roleCorrect Answer

traditional role

QUESTION 20 OF 52

Which method keeps track of the influence and needs of stakeholders and the level of communication required to keep them informed?

Newsletter

Stakeholder mapCorrect Answer

Histogram

Pivot table

QUESTION 21 OF 52

On a marketing team, who is responsible for running database queries, applying statistical methods to data, and creating data visualizations?

Human resources representative

Data analystCorrect Answer

Accountant

Customer service agent

QUESTION 22 OF 52

Which of the following best describes a stakeholder?

Someone who sells products or services for a company

Someone who strongly influences the success of a project or campaign through fundingCorrect Answer

Someone who analyzes marketing data

Someone who purchases products or services from a company

QUESTION 23 OF 52

How do marketers and stakeholders work together?

Marketers access data to create campaigns. Stakeholders advise on creative assets.

Stakeholders have access to data that marketers do not. Marketers receive data from stakeholders to create campaigns.

Marketers summarize campaign data and inform stakeholders of a campaign’s progress. Stakeholders fund campaigns and have an interest in their success.Correct Answer

Stakeholders set goals and KPIs for a campaign. Marketers fund campaigns to reach the goals.

QUESTION 24 OF 52

Why would a marketer sort data in a spreadsheet?

It helps them automatically remove irrelevant data.

It helps them find new patterns and relationships within data sets.Correct Answer

It helps them display data that match specific criteria.

It helps them present campaign data with visualizations.

QUESTION 25 OF 52

What are the three main fields used to categorize data in a pivot table?

Function, Name, Menu

Rows, Columns, ValuesCorrect Answer

Display, Columns, Filter

Filter, Units, Rows

QUESTION 26 OF 52

Fill in the blank A benefit of _____ is that you can easily copy and paste them into slides when you need to share data insights with others.

spreadsheet chartsCorrect Answer

vertical columns

campaign assets

marketing plans

QUESTION 27 OF 52

Which of the following guidelines should a marketer follow when working with stakeholders in a marketing campaign?

Understand why the stakeholder is interested in the campaignCorrect Answer

Identify which team members the stakeholder has worked with before

Provide limited information to the stakeholder to manage their expectations

Create a map to understand previous campaign stakeholders

QUESTION 28 OF 52

A marketer determines what type of interaction each stakeholder requires from them during a campaign. What visual assistance helps them gather this information?

Stakeholder dashboard

Budget dashboard

Stakeholder mapCorrect Answer

Campaign overview

QUESTION 29 OF 52

A marketer uses a chart to compare two variables side-by-side. The chart displays each variable as a bar. What type of chart did the marketer create?

Pivot chart

Histogram

Vertical column chartCorrect Answer

Line chart

QUESTION 30 OF 52

Which of the following is an example of a way a pie chart can be used to represent data?

Represent individual data points for a changing variable connected with a continuous line

Represent individual data points categorized into ranges, with the frequency of each range represented by the height of a unique column

Represent a large spike in new users with a horizontal bar

Represent percentages of data in sections, all adding up to one hundred percentCorrect Answer

QUESTION 31 OF 52

A business hires someone to analyze data and create and monitor marketing campaigns. What is this role known as?

Data specialist role

Marketing coordinator role

Hybrid roleCorrect Answer

Data analyst

QUESTION 32 OF 52

An e-commerce business hires someone to organize its marketing activities and initiatives. Who is typically responsible for these tasks?

A marketing coordinatorCorrect Answer

A data specialist

A marketing analyst

A marketing strategist

QUESTION 33 OF 52

Why would a marketer create a data dashboard?

To analyze data and create visualizations for statistical calculations

To communicate with databases developed by different vendors on multiple platforms

To track, analyze, and display KPIs, metrics, and real-time data in a centralized viewCorrect Answer

To create and manage large data sets and analyze custom data visualizations

QUESTION 34 OF 52

A marketer uses a graph to show how a metric changes over an extended period. The chart displays a connected series of data points. What type of chart did the marketer create?

Vertical column chart

Horizontal bar chart

Histogram

Line chartCorrect Answer

QUESTION 35 OF 52

When would you use a horizontal bar chart instead of a vertical column chart?

To compare how one metric changes over time in a single column

To compare two metrics side-by-side in a column

To compare measurements with a significant differenceCorrect Answer

To compare how a metric or variable changes

QUESTION 36 OF 52

What programming language allows you to access large databases for analysis?

SQLCorrect Answer

Data Studio

Tableau

Search console

QUESTION 37 OF 52

Which three steps should you follow when creating an effective presentation using marketing analytics?

Learn about stakeholders, include all campaign data in the presentation, and use an interactive template

Introduce data visualizations, include all campaign data, and share insights at the end of the presentation

Develop a clear outline of the presentation, choose the correct data, and include the most relevant metricsCorrect Answer

Find an interactive template, gather insights from previous campaigns, and include all metrics

QUESTION 38 OF 52

What role do stakeholders typically play in a campaign?

Stakeholders approve the creative used in a campaign.

Stakeholders track and analyze data about a campaign’s success.

Stakeholders fund a project or manage a campaign budget.Correct Answer

Stakeholders create campaigns and related social media efforts.

QUESTION 39 OF 52

Why would a marketer create a stakeholder map?

To help organize stakeholders into a graph according to their budget and experience with campaigns

To determine which stakeholder is a reliable source for campaign queries and obstacles

To identify which stakeholder is the most influential and to share frequent updates with them

To help manage stakeholder expectations and effectively share relevant information with themCorrect Answer

QUESTION 40 OF 52

What feature can a marketer use to hide data in a pivot table?

Columns

FilterCorrect Answer

Sort

Values

QUESTION 41 OF 52

When would a marketing team use Tableau?

To track, analyze, and display KPIs, metrics, and insights in a centralized view

To access and manage large databases, gather insights, and create visualizationsCorrect Answer

To create KPIs and metrics for a real-time interactive dashboard

To learn coding or programming skills to create interactive visualizations

QUESTION 42 OF 52

A marketer is working with a spreadsheet. What can they do to display only data that meets a certain condition and hide all non-matching data?

Delete the data that does not match

Sort the data in ascending order

Copy and paste the data

Filter the data in a columnCorrect Answer

QUESTION 43 OF 52

How is an area chart different from a line chart?

The space under the line is shaded in with colors or textures.Correct Answer

Area charts can only be single or stacked.

Area charts can show data with partial and whole results.

The changing variable connects on a continuous line.

QUESTION 44 OF 52

Why would an e-commerce business hire a marketing coordinator?

To design visual assets for campaigns, print ads, and create websites

To manage the company’s social media accounts

To collect data, query databases, and create data visualizations

To identify target audiences, create campaigns, and evaluate trendsCorrect Answer

QUESTION 45 OF 52

An e-commerce business hires someone to collect and analyze data as well as create visualizations. What role does this describe?

Marketing coordinator

Data analystCorrect Answer

Graphic designer

Project manager

QUESTION 46 OF 52

A data analyst uses visual analytics software to analyze data and create unique dashboards and visualizations. What software does this refer to?

Python

SQL

TableauCorrect Answer

QUESTION 47 OF 52

Which of the following is a best practice when creating slides for a presentation?

Use generic titles for data visualizationsCorrect Answer

Include all data you collected

End the presentation with the most surprising insight

Progress from general to specific topics

QUESTION 48 OF 52

A marketer shares campaign insights with a director because the director funds the campaign and plans to make decisions based on its results. What is likely the director’s role in the campaign?

Marketer

Data analyst

StakeholderCorrect Answer

Campaign advisor

QUESTION 49 OF 52

In which of the following scenarios would a horizontal bar chart be most useful?

To save space because there is a large difference between the measurements being comparedCorrect Answer

To show data points categorized into ranges, with the frequency represented by the height of a unique column

To show how a metric changes over an extended period of time

To show data that has partial and whole results

QUESTION 50 OF 52

A marketing team member queries databases, applies statistical methods to data, and creates data visualizations. What role does this describe?

Copywriter

Stakeholder

Data analystCorrect Answer

Office manager

QUESTION 51 OF 52

A marketer is working with a spreadsheet. What can they do to uncover new patterns and relationships within datasets that they might miss otherwise?

Copy data

Sort dataCorrect Answer

Acquire data

Input data

QUESTION 52 OF 52

Which of the following changes your view of data in a spreadsheet to a different perspective to categorize it, or to identify an insight or trend?

Pivot tableCorrect Answer

Histogram

Area table

Spreadsheet

Ready to test your recall?

Which of the following are reasons why stakeholders might be important to a project or campaign? Select all that apply.

💡Select all 2 correct answers before submitting (0 of 2 selected).

Stakeholders coordinate marketing activities and initiatives.

Stakeholders often analyze the data from a campaign.

Stakeholders strongly influence the success of a project or campaign.

Stakeholders often fund projects or operate budgets for campaigns.

How confident are you in this answer?