Why this matters
Platforms calculate these ratios for you, so why do it by hand? Because the person who understands where each number comes from can see which link in the chain moved, and the person who only reads the dashboard cannot. The core metrics guide sets out the chain from spend to conversions and the formula for each ratio. This exercise makes you use them on data where the obvious answer is wrong.
Two conventions from that guide apply throughout: state the denominator of every rate, and compare rates only within the same format. Keep them in mind when you reach the social campaign.
The campaign export
Brightside Bikes is an invented independent bike shop that sells bikes and runs a servicing workshop. Last month it ran three campaigns, each optimised for the same conversion: a booked workshop service, recorded when the online booking form is submitted.
Brightside Bikes: last month's export
| Campaign | Format | Impressions | Clicks | Spend | Conversions |
|---|---|---|---|---|---|
| Brand search | Search ads on the shop's name | 4,000 | 600 | £180 | 48 |
| Service search | Search ads on "bike service" and "bike repair" plus the town | 20,000 | 900 | £810 | 54 |
| Spring commuter | Paid social video to local adults interested in cycling | 150,000 | 1,200 | £600 | 12 |
Notes from the account: the brand campaign already shows for nearly every search for the shop's name. The owner has worked out that a booked service can cost up to £25 to acquire and still be worth having.
Task
- For each campaign, calculate click-through rate, cost per click, conversion rate (per click) and cost per acquisition. Check your figures with the CTR calculator and the CPA calculator.
- Calculate the same four metrics for all three campaigns combined.
- For each campaign, say which link in the chain best explains its cost per acquisition.
- Write two sentences: which campaign should get more budget, and why.
Worked answer
The calculations
Brightside Bikes: calculated metrics
| Campaign | CTR | CPC | CVR | CPA |
|---|---|---|---|---|
| Brand search | 600 ÷ 4,000 = 15.0% | £180 ÷ 600 = £0.30 | 48 ÷ 600 = 8.0% | £180 ÷ 48 = £3.75 |
| Service search | 900 ÷ 20,000 = 4.5% | £810 ÷ 900 = £0.90 | 54 ÷ 900 = 6.0% | £810 ÷ 54 = £15.00 |
| Spring commuter | 1,200 ÷ 150,000 = 0.8% | £600 ÷ 1,200 = £0.50 | 12 ÷ 1,200 = 1.0% | £600 ÷ 12 = £50.00 |
| All three combined | 2,700 ÷ 174,000 = 1.6% | £1,590 ÷ 2,700 = £0.59 | 114 ÷ 2,700 = 4.2% | £1,590 ÷ 114 = £13.95 |
Rates are rounded to one decimal place and costs to the nearest penny.
Reading the chain
Brand search has the best figures on every line, and that is expected: the people searching for Brightside by name have already decided. Its high CTRShare of impressions that result in a click. and CVRShare of visits or clicks that convert. describe the audience more than the ads. The note matters most here. The campaign already appears for nearly every brand search, so extra budget has nothing more to buy.
Service search has a lower click-through rate than brand search, which is normal for people who have not yet chosen a shop, and a higher CPCAverage cost of each click. because other shops bid on the same terms. Its conversion rate is still healthy, so the landing page and the offer are doing their job. The resulting CPACost of each conversion. sits well below the owner's ceiling.
Spring commuter has cheaper clicks than service search but converts far fewer of them. The weak link is conversion: people who were scrolling, not looking for a service, rarely book one on the spot. Its click-through rate cannot be compared with the search campaigns at all, because it is a different format shown to people doing something else. Judged on booked services, its cost per acquisition is above the ceiling, but booked services may not be its job.
The combined line looks comfortable, and it hides everything. A blended cost per acquisition below the ceiling conceals one campaign above it and one that cannot scale.
The recommendation
Service search should get more budget: it captures people actively looking for a repair at a cost per booking well under the ceiling, and unlike brand search it has room to grow. The commuter campaign should not be cut on this evidence alone; it should be given a job it can be judged on, such as reach among local cyclists, or moved to a different conversion before its budget is decided.
What an extra £300 might buy
At the service campaign's current £15.00 cost per acquisition, an extra £300 would buy about 20 more bookings, if the rate held. It probably would not hold exactly: auctions get more expensive as spend rises, so treat the figure as a ceiling to test against, not a promise. Even if the cost per acquisition rose to £20 on the extra spend, the campaign would still sit under the owner's £25 ceiling, which is why it is the safer place for new budget than either of the other two campaigns.
Common mistakes
- Choosing the lowest CPA. Brand search wins on every ratio and is the wrong answer, because it cannot absorb more spend and its buyers would likely have booked anyway.
- Comparing CTR across formats. A social video's click-through rate and a search ad's measure different situations; the core metrics guide is explicit about this.
- Trusting the blended line. Totals average away the differences that budget decisions depend on.
- Forgetting the denominator. Conversion rate here is per click. Per session would give a different number, and the report should say which.
- Judging without a target. A cost per acquisition only means something next to the ceiling, which is why the campaign brief guide fixes the target and the KPI before launch. The beginner level overview shows how this feeds the capstone.
