REPORTING & ANALYSIS · ORIGINAL EXERCISE
The acquisition cost
Calculate Search-channel spend per customer, rounded to two decimals.
This quest practices Cost per acquisition 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
- Spend divided by customers gives acquisition cost.
- Search is on row 2.
- Wrap E2/D2 inside ROUND with 2 decimals.
Show the worked solution
=ROUND(E2/D2,2)CPA measures channel spend per acquired customer; it is not revenue or profit.
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 →