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

_______________

Find the number of active users (1-day, 7-day, 14-day, and 28-day) during January 2019.

1-day - 1,917daily average 1,917

7-day - 11,317daily average 1,617

14-day - 21,127daily average 1,509

28-day - 40,955daily average 1,463

Calculate the ratio of 1-day active users to 28-day active users, expressed as a percentage.

1917 : 40955 = 4.7 %

Also, compare the graphs for 1-day active users to 28-day active users. What conclusions can you derive?

It won't let me attach the graph but I am trying to answer the above question.