Instructions now to open the spreadsheet $-$ it will open in a separate browser tab. Your work will save automatically in the Microsoft Excel Online spreadsheet.

If you need help navigating Excel or knowing how to complete the tasks related to this problem, please click here to access Microsoft Support.

Open spreadsheet

Scenario customer acquisition cost for each of the company's six advertising channels. After some further calculation, you have estimated that lifetime gross margin per customer averages $$34.$ these campalgns and would like an estimate ahead of time.

Questions

Refer to the Filtering for Positive Customer Lifetime Value $($CLV$)$ data table. Without making any changes to the table, what two advertising channels have positive CLV$?$

Television and magazines

Facebook and Google AdWords

Television and YouTube

Facebook and local radio

Magazines and Google AdWords customer acquisition cost of YouTube to $$30.$ How does this change the CLV$?$

CLV turns positive

CLV goes to zero $($or reaches the breakeven point$)$

CLV remains negative the ad channels you found to have positive CLV $($after updating the YouTube customer acquisition cost to $$30).$ Divide the $$1,800,000$ ad budget evenly between the ad channels with positive CLV $-$ input the values in the Ad in each city?

$16\%$

$23\%$

$42\%$

$70\%$