WORKPLACE BOSS CHALLENGES · ORIGINAL EXERCISE
The campaign debrief
For Search and Social combined (rows 2–3), calculate total spend per customer, rounded to two decimals.
This quest practices Marketing project using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| Channel | Visits | Trials | Customers | Spend |
|---|---|---|---|---|
| Search | 1800 | 180 | 36 | 540 |
| Social | 2400 | 120 | 12 | 600 |
| Referral | 800 | 120 | 30 | 150 |
| 1100 | 165 | 33 | 220 | |
| Direct | 950 | 95 | 19 | 0 |
Hints to get you started
- Use combined spend and combined customers.
- Average channel CPAs would weight them equally.
- Divide the E total by the D total, then round.
Show the worked solution
=ROUND(SUM(E2:E3)/SUM(D2:D3),2)A blended cost per acquisition is the ratio of total spend to total customers.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →