Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Digital Marketing Foundations › Beginner

Calculating Core Metrics from a Campaign Export

A calculation exercise on a small, invented campaign export. You work out the four core ratios for each campaign, read them as a chain to see which link explains each result, and turn the numbers into a short, reasoned budget recommendation.
ExerciseBeginner levelModule 3: Metrics and a first campaign brief5 minUpdated

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.

Illustrative example — not a real result

Brightside Bikes: last month's export

CampaignFormatImpressionsClicksSpendConversions
Brand searchSearch ads on the shop's name4,000600£18048
Service searchSearch ads on "bike service" and "bike repair" plus the town20,000900£81054
Spring commuterPaid social video to local adults interested in cycling150,0001,200£60012

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

  1. 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.
  2. Calculate the same four metrics for all three campaigns combined.
  3. For each campaign, say which link in the chain best explains its cost per acquisition.
  4. Write two sentences: which campaign should get more budget, and why.

Worked answer

The calculations

Illustrative example — not a real result

Brightside Bikes: calculated metrics

CampaignCTRCPCCVRCPA
Brand search600 ÷ 4,000 = 15.0%£180 ÷ 600 = £0.3048 ÷ 600 = 8.0%£180 ÷ 48 = £3.75
Service search900 ÷ 20,000 = 4.5%£810 ÷ 900 = £0.9054 ÷ 900 = 6.0%£810 ÷ 54 = £15.00
Spring commuter1,200 ÷ 150,000 = 0.8%£600 ÷ 1,200 = £0.5012 ÷ 1,200 = 1.0%£600 ÷ 12 = £50.00
All three combined2,700 ÷ 174,000 = 1.6%£1,590 ÷ 2,700 = £0.59114 ÷ 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 CTR and CVR 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 CPC 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 CPA 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.

Illustrative example — not a real result

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.

Pages this lesson applies

Terms used on this page

Also related

Related