# Directions: Please review and answer the following questions, which have been assigned to you in the CompanyOne case.

Directions: Please 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) for December 2018. Calculate the daily average number of active users for each of the four time periods. For example, the daily average for the 28-day period will be the number of active users reported by Google Analytics divided by 28. Based on your calculations, what conclusions can you derive? (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 is December 31, 2018.)

The metrics in the report are relative to the last day in the date range you are using for the report. Thus, your date range is December 1 to December 31:

• 1-day active users—the number of unique users who initiated sessions on your site or app on December 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 December 25 through December 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 December 18 through December 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 December 4 through December 31 (the entire 28 days of your date range).

Question 2

Plot graphs of 1-day active users for the 31 days in December 2017 and in December 2018. 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 December 2017 to December 2018? Please provide a screenshot to support your analysis.

Question 3

Plot a graph of the bounce rate for the 31 days in December 2018 and compare it with the same time period in December 2017. What do you conclude? Please provide screenshots to support your analysis..

Question 4

If you focus on the demographics of younger users (18-24 and 25-34), what do you observe? Has the number of younger users as a proportion of total users changed from 2017 to 2018? (Note: January 1 and December 31 are the start and end dates for a whole year comparison.) How about changes in the proportions of older users during the same time period? Please provide

Question 5

CompanyOne’s objective was to attract a larger proportion of female visitors (displayed as a percentage in the pie chart) to the online store in 2018 as compared to 2017. Was that objective met? Please provide a screenshot to support your answer.

Question 6

CompanyOne needs to analyze gender differences in more depth, especially in the new user segment. Did CompanyOne attract more or fewer new users in 2018 as compared with 2017, irrespective of gender? What about new male users? What about new female users? Please provide screenshots to support your answer.

Question 7

As you have confirmed, CompanyOne was not successful in attracting a larger number of new female visitors to its website in 2018 as compared with the previous year. When parsing the category of new female users, by age group, was CompanyOne more successful in certain age group(s) of female users in 2018 as compared with 2017? Please provide a screenshot to support

Question 8

CompanyOne wishes to target high-value users in future marketing campaigns. These are user groups with the highest e-commerce conversion rate or average order value. Which age group generated the highest revenue for CompanyOne in 2018 in dollars? How much was the revenue from this age group? Which age group generated the least revenue? Which age group had the highest average order value? Which age group had the highest e-commerce conversion rate? Based on these observations, which age group or groups should be the focus of CompanyOne’s marketing efforts during 2019? In other words, which age group is likely to provide the most bang for the buck? Provide a screenshot to support your answer.

Question 9

CompanyOne wishes to understand its site visitors better in order to fine-tune its future marketing efforts. Understanding audience composition in terms of gender, age, and interests will allow CompanyOne to develop the right creative content and decide the media buys to make.

Google Analytics has the following ten default affinity categories:

• shoppers / value shoppers
• lifestyles and hobbies / business professionals
• sports and fitness / health and fitness buffs
• technology / technophiles
• banking and finance / avid investors
• travel / travel buffs