1. We have a product that you are preparing to launch. We have spent 10.000 Euro once....
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 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
Forensic Accounting
ISBN: 978-0133050479
1st Edition
Authors: Robert Rufus, Laura Miller, William Hahn