Question: There are two questions. Data relevant to these questions can be found in the bottom of the page. 1. We have a product that you
There are two questions. Data relevant to these questions can be found in the bottom of the page. 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 20% margin on D14 according to 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 below questions accordingly. All the campaigns are running for the same time period. Given data might be updated afterwards, 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
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
