Subject: Confidential MemoCompanyOne From: Ying Bao
Directions: Review and answer the following questions, which have been assigned to you in the CompanyOne case. You will need to capture screenshots to complete these questions; if necessary, review these instructions on capturing screenshots.
Question 1
Find the number of active users (1-day, 7-day, 14-day, and 28-day) during January 2019. Calculate the ratio of 1-day active users to 28-day active users, expressed as a percentage. Typically, this ratio is considered a measure of the “stickiness” or retention of users for your website. It should be 10% or higher for sites where content is refreshed daily, like news sites, or where the site derives its revenue primarily from advertising. For social sites like Facebook and WhatsApp, the ratio could be a lot higher (> 50%). For e-commerce sites like CompanyOne, where usage is less frequent but of higher monetary value, the ratio is typically lower than 10%.
Also, compare the graphs for 1-day active users to 28-day active users. What conclusions can you derive? Provide a screenshot to support your analysis.
Note: Active users refers to the number of users who visited the CompanyOne website within the last 1, 7, 14, or 28 days looking back from the last day of the period, which in this case is January 31, 2019.
The metrics in the report are relative to the last day in the date range. Given that your date range is January 1 to January 31:
1-day active users: The number of unique users who initiated sessions on your site or app on January 31 (the last day of your date range).
7-day active users: The number of unique users who initiated sessions on your site or app from January 25 through January 31 (the last 7 days of your date range).
14-day active users: The number of unique users who initiated sessions on your site or app from January 18 through January 31 (the last 14 days of your date range).
28-day active users: The number of unique users who initiated sessions on your site or app from January 4 through January 31 (the entire 28 days of your date range).
Question 2
Plot graphs of 1-day active users for the first quarter in 2018 and the first quarter in 2019. Compare the number of active users for both periods from the two plots. What do you conclude about the change in marketing effectiveness, if any, from 2018-Q1 to 2019-Q1? Provide a screenshot to support your analysis.
Question 3
Compare bounce rate for 2019-Q1 to 2018-Q1. What do you conclude? Similarly, compare page views for 2019-Q1 to 2018-Q1. Provide screenshots to support your analysis.
Question 4
CompanyOne wants to focus on younger users (1824 and 2534) who shopped during the 2018 holiday shopping season. Has the share of younger users changed from the holiday shopping season in 2017? Note: November 1 and December 31 are the start and end dates for the holiday shopping season for CompanyOne. How about changes in the proportions of older users during the same period? Provide screenshots to support your answer.Need to answer 10 questions using Google Analytics
Recent Comments