It’s the Google Merchandise Store’s quarterly performance meeting, and you’re charged with presenting the website’s Q3 performance to the entire company. To do so, you need to answer the following questions: Is the site meeting its audience’s needs? Is it helping the company sell more Google products? What is it doing well? What is it doing poorly? What recommendations do you have for how the website can improve?
To answer these questions, open
https://datastudio.google.com/reporting/cf2b48dd-8f6b-44fe-a741-cd85c98c72a3
in Google Data Studio. (you can access it by logging in with a Gmail account)
This is a two-page report: The first page is focuses on the site’s content and performance, and the second page focuses on the audience itself. You have three objectives:
- Convert this monthly template into a quarterly report. To do that, change the wording and the dates. You should set the date range to July1 to September 30, 2019. (I’ve already done this)
- Change at least four metrics/visualizations. Some of the metrics/data visualizations you see aren’t useful for a quarterly performance report. Change at least two metrics/charts/graphs/visualizations per page (so four in total) to ones that are more appropriate for your quarterly performance presentation. This is more about common sense than it is about right or wrong. Think about what you think Google managers need to see in order to understand how their site has been performing for the past three months, and go from there. Do not just change the color or font size/style.
- Provide three actionable insights on each page (six total). These should be data-driven recommendations focused on what to change or how to move forward knowing what we know about the site, its content, its performance and its audience.
Directions - To browse and change metrics, simply click on any chart. To the right, you can edit the metrics the chart displays as well as how it looks. This data pulls directly from Google Analytics, so play around until you find the metrics you want.
- Use the data in the report you’ve made to fill in the Insights sections. Again, you must offer three insights on each page. Your insights should be data-driven, clear, specific and actionable. For example: “The products that earn the most revenue earn traffic from Twitter and not very much from Facebook, so we should increase our marketing campaign budget in Twitter and decrease it in Facebook.”
- To submit the report and respond to this question, share the link to your report in the field below. To get the report link, click the “Share” button in the top right, then click “Get link.” “Anyone with the link”. Now, click “Copy link”. That’s the link you need to paste below. Make sure the report is set so that it can be accessed by anyone. If I cannot load it, you will not get credit for it.
- In your response, write down which metrics/visualizations you changed.
Ientify one audience attribute for which a metric does not currently exist. Why do you think this attribute is important? Why isn’t it currently being measured? How much the lack of an existing metric be affecting our understanding of the media environment?
Important: Draw on topics and/or readings from the previous modules to support your answer.
Sample Solution
