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

Answer rating: 100% (QA)

1 The maximum CPI limit to reach the aim of a 20 margin on D14 is 04 This can be calculated by takin... View the full answer