Question
1. We have a product that you are preparing to launch. We have spent 10.000 Euro once. Our aim is to run campaigns with a
1. We have a product that you are preparing to launch. We have spent 10.000 Euro once. Our aim is to run campaigns with a 20% margin on D14 according to the below Days: D0 D1 D2 D3 D4 D5…. What is the maximum CPI (CPI rates are at the bottom of the page) limit to reach your aim?
Daily Retention
D0 D1 D2 D3 D4 D5 D6 D7 D8 D9 D10 D11 D12 D13 D14
100% 48% 33% 24% 17% 12% 9% 7% 6% 5% 4% 4% 4% 4% 4%
2. You will see revenue and spending data at the bottom of the page. Please answer the below questions accordingly. All the campaigns are running for the same time period. Given data might be updated afterward, we prefer your calculations on Excel are valid with updated data too.
• What is the total number of installs of Product A?
• What is the total revenue of Product B Hello users?
• Which campaign optimizations could be made to maximize ROAS (Return of Assets)?
Revenue App Device Source Campaign *D7 *D30
Product A Hello Ad Network X A-Hello-X 0.34 0.48
Product A Hello Ad Network Y A-Hello-Y 0.27 0.48
Product A Hello Ad Network Z A-Hello-Z 0.31 0.37
Product A Hello Ad Network W A-Hello-W 0.5 0.56
Product A Hello Ad Network T A-Hello-T 0.33 0.42
Product A Ciao Ad Network X A-Ciao-X 0.22 0.31
Product A Caio Ad Network Y A-Ciao-Y 0.23 0.33
Product B Hello Ad Network X B-Hello-X 0.26 0.40
Product B Hello Ad Network Y B-Hello-Y 0.22 0.35
Product B Hello Ad Network Z B-Hello-Z 0.30 0.30
Product B Hello Ad Network W B-Hello-W 0.55 0.56
Product B Hello Ad Network T B-Hello-T 0.30 0.40
Product B Ciao Ad Network X B-Ciao-X 0.25 0.30
Product B Ciao Ad Network Y B-Ciao-Y 0.25 0.35 Cost App Device Source Campaign CPI Expenditures (Euro)
Product A Hello Ad Network X A-Hello-X 0.40 90600.6
Product A Hello Ad Network Y A-Hello-Y 0.35 2805.15
Product A Hello Ad Network Z A-Hello-Z 0.31 4915
Product A Hello Ad Network W A-Hello-W 0.35 16324
Product A Hello Ad Network T A-Hello-T 0.22 3000
Product A Ciao Ad Network X A-Ciao-X 0.25 9500
Product A Caio Ad Network Y A-Ciao-Y 0.25 20300
Product B Hello Ad Network X B-Hello-X 0.20 55900
Product B Hello Ad Network Y B-Hello-Y 0.20 22020
Product B Hello Ad Network Z B-Hello-Z 0.25 14356
Product B Hello Ad Network W B-Hello-W 0.27 19054
Product B Hello Ad Network T B-Hello-T 0.30 10000
Product B Ciao Ad Network X B-Ciao-X 0.20 15450
Product B Ciao. Ad Network Y B-Ciao-Y 0.21 20000
Step by Step Solution
3.67 Rating (173 Votes )
There are 3 Steps involved in it
Step: 1
1 The maximum CPI limit to reach the aim of a 20 margin on D14 is 04 This can be calculated by takin...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started