Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise Problem statement You have recently been hired as a product manager at Mindstorm Studios. Your main product is a Chat stories app (Imagine a

image text in transcribed

Exercise Problem statement You have recently been hired as a product manager at Mindstorm Studios. Your main product is a Chat stories app (Imagine a netflix type design for reading stories) that allows subscribers to unlock all stories in the app and read them at any time. The app primarily targets female professionals in their 30s and 40s that want to read interesting stories while they are commuting to their workplace. They pay $5 a month to access all content (that includes different types of story categories like Comedy, Horror, and Romance). After signing-up users can enjoy that content free of charge for 30 days (trial) after which they must pay the $5 a month fee to keep access to all content The cost of development of the app is $2,000 per month. The app has just launched yesterday and we have a starting user base of 2,000 users. To acquire users, we run a campaign in Google Ads (for the keywords"Story apps") with a cost-per-ad click of $2 and a monthly marketing budget of $1,000. All users that click on the ad, land in our sign-up form which 25% of them complete. The app's retention curve looks like this for existing and new users acquired in a given month. Retention is expressed as a percentage of the initially acquired users per cohort. App's monthly cohort retention Month Retention Comments MO 100% Month 0 retention defined as % users who log in the app at least once in the first 30 days after sign M1 35% Month 1 retention defined as % users who log in the app at least once from Day 31 to 60 after sign M2 25% Month 2 retention defined as % users who log in the app at least once from Day 61 to 90 after sign M3 20% Month 3 retention defined as % users who log in the app at least once from Day 91 to 120 after sig M4 15% Month 4 retention defined as % users who log in the app at least once from Day 121 to 150 after sig M5 12% Month 5 retention defined as % users who log in the app at least once from Day 151 to 180 after sig M6 11% Month 6 retention defined as % users who log in the app at least once from Day 181 to 210 after sig M7 9% Month 7 retention defined as % users who log in the app at least once from Day 211 to 240 after sig M8 8% Month 8 retention defined as % users who log in the app at least once from Day 241 to 270 after sig M9 6% Month 9 retention defined as % users who log in the app at least once from Day 271 to 300 after sig M10 5% Month 10 retention defined as % users who log in the app at least once from Day 301 to 330 after s M11 3% Month 11 retention defined as % users who log in the app at least once from Day 331 to 360 after s M12 0% Month 12 retention defined as % users who log in the app at least once from Day 361 to 390 after Question Build your model in a spreadsheet to explain the situation and give recommendations Exercise Problem statement You have recently been hired as a product manager at Mindstorm Studios. Your main product is a Chat stories app (Imagine a netflix type design for reading stories) that allows subscribers to unlock all stories in the app and read them at any time. The app primarily targets female professionals in their 30s and 40s that want to read interesting stories while they are commuting to their workplace. They pay $5 a month to access all content (that includes different types of story categories like Comedy, Horror, and Romance). After signing-up users can enjoy that content free of charge for 30 days (trial) after which they must pay the $5 a month fee to keep access to all content The cost of development of the app is $2,000 per month. The app has just launched yesterday and we have a starting user base of 2,000 users. To acquire users, we run a campaign in Google Ads (for the keywords"Story apps") with a cost-per-ad click of $2 and a monthly marketing budget of $1,000. All users that click on the ad, land in our sign-up form which 25% of them complete. The app's retention curve looks like this for existing and new users acquired in a given month. Retention is expressed as a percentage of the initially acquired users per cohort. App's monthly cohort retention Month Retention Comments MO 100% Month 0 retention defined as % users who log in the app at least once in the first 30 days after sign M1 35% Month 1 retention defined as % users who log in the app at least once from Day 31 to 60 after sign M2 25% Month 2 retention defined as % users who log in the app at least once from Day 61 to 90 after sign M3 20% Month 3 retention defined as % users who log in the app at least once from Day 91 to 120 after sig M4 15% Month 4 retention defined as % users who log in the app at least once from Day 121 to 150 after sig M5 12% Month 5 retention defined as % users who log in the app at least once from Day 151 to 180 after sig M6 11% Month 6 retention defined as % users who log in the app at least once from Day 181 to 210 after sig M7 9% Month 7 retention defined as % users who log in the app at least once from Day 211 to 240 after sig M8 8% Month 8 retention defined as % users who log in the app at least once from Day 241 to 270 after sig M9 6% Month 9 retention defined as % users who log in the app at least once from Day 271 to 300 after sig M10 5% Month 10 retention defined as % users who log in the app at least once from Day 301 to 330 after s M11 3% Month 11 retention defined as % users who log in the app at least once from Day 331 to 360 after s M12 0% Month 12 retention defined as % users who log in the app at least once from Day 361 to 390 after Question Build your model in a spreadsheet to explain the situation and give recommendations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Count Down The Past, Present And Uncertain Future Of The Big Four Accounting Firms

Authors: Jim Peterson

2nd Edition

1787147010, 9781787147010

More Books

Students also viewed these Accounting questions

Question

Demonstrate knowledge of the company/organization and the position.

Answered: 1 week ago

Question

=+3. What are the components of a social media communication audit?

Answered: 1 week ago