Question 1

L’acier wants to run their one-time discount ads during the time period with the most conversions. you can find this information by sorting the data in the conversions column. which day and time had the most conversions?

Accepted Answer

Wednesday at 10:00 om (Correct)

Question 2

Which of the following are important to understand when working with stakeholders on a project? select all that apply.

Accepted Answer

Stakeholders needs, When to inform stakeholders, How to communicate with stakeholders (Correc)

Question 3

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

Accepted Answer

Stakeholders often fund projects or operate budgets for campaigns, Stakeholders strongly influence the success of a project or campaign (Correct)

Question 4

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

Accepted Answer

Which communication methods a stakeholder prefers, The stakeholder's interest in the project and what their needs are, When communication with a stakeholders (Correct)

Question 5

Which of the following describes the proportion of ink (or pixels in digital content) that is used to present actual data compared to the total amount of ink (or pixels) used in the entire visualization?

Accepted Answer

Data-ink ratio (Correct)

Question 6

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

Accepted Answer

Stakeholders strongly influence the success of a project or campaign, Stakeholders often fund projects or operate budgets for campaigns. (CORRECT)

Question 7

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

Accepted Answer

To allow for people to better manage stakeholders’ expectations and avoid information overload, To help people work effectively without having the process consume too much of their time or energy, To make it easier to identify the type and amount of interaction needed to maintain each stakeholder (CORRECT)

Question 8

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

Accepted Answer

Pivot tables, Sorting, Filtering (CORRECT)

Question 9

What is the purpose of a pivot table?

Accepted Answer

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)

Question 10

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?

Accepted Answer

histogram (CORRECT)

Question 11

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.

Accepted Answer

Include the most relevant metrics that led to their insights, Develop a clear outline or flow for their presentation (CORRECT)

Question 12

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

Accepted Answer

Marketing coordinator (CORRECT)

Question 13

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

Accepted Answer

Structured query language (CORRECT)

Question 14

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

Accepted Answer

Google Data Studio, Tableau (CORRECT)

Question 15

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.

Accepted Answer

Start with a general status of the campaign and then move on to the specifics of making a change to the budget, Create visualizations of the data using titles that relate back to the insights, End the presentation with changing the budget as a call to action for stakeholders (CORRECT)

Question 16

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

Accepted Answer

Which communication methods a stakeholder prefers, The stakeholder’s interest in the project and what their needs are, When to communicate with a stakeholder (CORRECT)

Question 17

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?

Accepted Answer

Pivot table (CORRECT)

Question 18

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?

Accepted Answer

Area chart (CORRECT)

Question 19

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

Accepted Answer

Identifying target audiences through research, Running campaigns, Evaluating trends (CORRECT)

Question 20

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?

Accepted Answer

Tableau (CORRECT)

Question 21

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

Accepted Answer

Repeat the insights when presenting the relevant, supporting data, Introduce data visualizations using titles that relate back to the insights, Allow time for questions so the audience can reach the same conclusion (CORRECT)

Question 22

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

Accepted Answer

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

Question 23

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

Accepted Answer

line chart (CORRECT)

Question 24

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

Accepted Answer

hybrid role (CORRECT)

Question 25

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

Accepted Answer

Filtering, Sorting, Pivot tables (CORRECT)

Question 26

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

Accepted Answer

Stakeholder map (CORRECT)

Question 27

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

Accepted Answer

Data analyst (CORRECT)

Question 28

Which of the following best describes a stakeholder?

Accepted Answer

Someone who strongly influences the success of a project or campaign through funding (CORRECT)

Question 29

How do marketers and stakeholders work together?

Accepted Answer

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

Question 30

Why would a marketer sort data in a spreadsheet?

Accepted Answer

It helps them find new patterns and relationships within data sets. (CORRECT)

Question 31

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

Accepted Answer

Rows, Columns, Values (CORRECT)

Question 32

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.

Accepted Answer

spreadsheet charts (CORRECT)

Question 33

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

Accepted Answer

Understand why the stakeholder is interested in the campaign (CORRECT)

Question 34

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

Accepted Answer

Stakeholder map (CORRECT)

Question 35

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?

Accepted Answer

Vertical column chart (CORRECT)

Question 36

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

Accepted Answer

Represent percentages of data in sections, all adding up to one hundred percent (CORRECT)

Question 37

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

Accepted Answer

Hybrid role (CORRECT)

Question 38

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

Accepted Answer

A marketing coordinator (CORRECT)

Question 39

Why would a marketer create a data dashboard?

Accepted Answer

To track, analyze, and display KPIs, metrics, and real-time data in a centralized view (CORRECT)

Question 40

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?

Accepted Answer

Line chart (CORRECT)

Question 41

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

Accepted Answer

To compare measurements with a significant difference (CORRECT)

Question 42

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

Accepted Answer

SQL (CORRECT)

Question 43

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

Accepted Answer

Develop a clear outline of the presentation, choose the correct data, and include the most relevant metrics (CORRECT)

Question 44

What role do stakeholders typically play in a campaign?

Accepted Answer

Stakeholders fund a project or manage a campaign budget. (CORRECT)

Question 45

Why would a marketer create a stakeholder map?

Accepted Answer

To help manage stakeholder expectations and effectively share relevant information with them (CORRECT)

Question 46

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

Accepted Answer

Filter (CORRECT)

Question 47

When would a marketing team use Tableau?

Accepted Answer

To access and manage large databases, gather insights, and create visualizations (CORRECT)

Question 48

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?

Accepted Answer

Filter the data in a column (CORRECT)

Question 49

How is an area chart different from a line chart?

Accepted Answer

The space under the line is shaded in with colors or textures. (CORRECT)

Question 50

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

Accepted Answer

To identify target audiences, create campaigns, and evaluate trends (CORRECT)

Question 51

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

Accepted Answer

Data analyst (CORRECT)

Question 52

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

Accepted Answer

Tableau (CORRECT)

Question 53

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

Accepted Answer

Use generic titles for data visualizations (CORRECT)

Question 54

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?

Accepted Answer

Stakeholder (CORRECT)

Question 55

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

Accepted Answer

To save space because there is a large difference between the measurements being compared (CORRECT)

Question 56

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

Accepted Answer

Data analyst (CORRECT)

Question 57

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

Accepted Answer

Sort data (CORRECT)

Question 58

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?

Accepted Answer

Pivot table (CORRECT)

COURSE 5 – ASSESS FOR SUCCESS: MARKETING ANALYTICS AND MEASUREMENT QUIZ ANSWERS

Week 4: Share Metrics and Insights with Stakeholders

Google Digital Marketing & E-commerce Professional Certificate

Complete Coursera Answers & Study Guide

table of CONTENT

Share Metrics and Insights with Stakeholders INTRODUCTION

Learning Objectives

TEST YOUR KNOWLEDGE: STAKEHOLDER NEEDS AND COMMUNICATION STRATEGIES

1. What is a stakeholder?

2. Which of the following are important to understand when working with stakeholders on a project? Select all that apply.

3. What is the relationship between internal stakeholders and external stakeholders?

4. What is a stakeholder map used for?

5. Which of the following can help establish a high level of trust with stakeholders? Select all that apply.

6. In business, what is a stakeholder?

TEST YOUR KNOWLEDGE: SPREADSHEET FEATURES

1. Which of the following are reasons to sort data in a spreadsheet? Select all that apply.

2. Fill in the blank: _____ calculates how long users spent interacting with a site before leaving.

3. Which of the following happens to data when it is filtered in a column? Select all that apply.

4. What spreadsheet tool changes the view of data in a spreadsheet to a different perspective to categorize it, or to identify an insight or trend?

5. Imagine that you need to work with a large dataset. Instead of manually counting instances, what function can you use to return the number of non-blank cells in a range?

6. L’Acier wants to run their one-time discount ads during the time period with the most conversions. You can find this information by sorting the data in the Conversions column. Which day and time had the most conversions?

7. L’Acier wants to understand how many days and times had over 1,000 conversions. You can find this information by filtering the data for greater than 1,000 conversions and counting the rows. How many rows had over 1,000 conversions?

TEST YOUR KNOWLEDGE: CHARTS IN SPREADSHEETS

1. Which of the following are basic visualizations found in spreadsheets? Select all that apply.

2. Which of the following tasks would a data analyst be responsible for? Select all that apply.

3. On a marketing team, who arranges activities and initiatives, identifies target audiences through research, runs campaigns, and evaluates trends?

4. Fill in the blank: _____ is used to communicate with databases developed by different vendors and hosted on multiple platforms.

5. Which tool tracks, analyzes, and displays KPIs, metrics, and insights dynamically based on interactive user criteria?

6. What are the three basic parts of a pivot table?

7. What visualization is useful for showing how a metric changes over an extended period of time?

TEST YOUR KNOWLEDGE: BEST PRACTICES TO PRESENT DATA

1. When creating a presentation, what data should you include?

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

3. Which of the following are benefits to communicating insights at the beginning of a presentation? Select all that apply.

4. Which of the following describes the proportion of ink (or pixels in digital content) that is used to present actual data compared to the total amount of ink (or pixels) used in the entire visualization?

Google Digital Marketing & E-commerce Professional Certificate

ASSESS FOR SUCCESS: MARKETING ANALYTICS AND MEASUREMENT WEEKLY CHALLENGE 4

1. Which of the following best describes a stakeholder?

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

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

4. What is the purpose of a pivot table?

5. Fill in the blank: Line charts, area charts, and pie charts are all examples of _____.

6. 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?

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

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

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

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

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

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

13. 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?

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

15. 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.

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

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

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

19. 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?

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

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

22. 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.

23. 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?

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

25. 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?

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

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

28. Which of the following best describes a stakeholder?

29. How do marketers and stakeholders work together?

30. Why would a marketer sort data in a spreadsheet?

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

32. 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.

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

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

35. 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?

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

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

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

39. Why would a marketer create a data dashboard?

40. 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?

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

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

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