Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... 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

Forensic Accounting

Authors: Robert Rufus, Laura Miller, William Hahn

1st Edition

133427528, 133050475, 9780133427523, 978-0133050479

More Books

Students also viewed these Accounting questions