How this instrument works
Cost per click and cost per 1,000 impressions come from the same three numbers — spend, clicks, and impressions — divided two different ways. CPC prices what actually got clicked; CPM prices the exposure the ad bought regardless of clicks. A third figure, click-through rate, falls out of the same three inputs and ties the other two together: it is the only one of the three that never touches the spend figure at all, since it only compares clicks against impressions.
The person running this sheet is usually managing a self-serve Google or Meta account directly rather than buying media through an agency — a small-business owner, a freelancer, a solo marketer — pulling a weekly or campaign-level export and checking three ratios against last period's numbers before deciding whether to keep a campaign running as-is. That is a narrower job than pricing a media buy against a rate card or testing which headline earns more attention; here the three numbers describe one campaign's health at a glance, not a comparison across platforms or ad copy.
The specific trap this dashboard guards against is judging CPC by itself. Two campaigns can land on an identical cost per click while one needed ten times the impressions to earn it — CPC alone hides that difference completely, and only CTR reveals which campaign reached a broad, loosely matched audience versus a narrow, well-targeted one. None of the three figures shows what happened after the click; pair them with a conversion count from the same platform before judging whether the spend earned its keep.
- Enter Ad spend, $ — the total amount charged for the campaign or date range being checked.
- Enter Clicks — the total the ad platform recorded for that same window.
- Enter Impressions — the total number of times the ad was served over that same window.
- Read Cost per click (CPC) and Cost per thousand impressions (CPM) side by side — both divide the identical spend figure two different ways.
- Check Click-through rate (CTR), % against that pair before deciding whether a cheap CPC reflects real efficiency or just a much larger audience.
Worked example — one $500 campaign, three readings
A weekly export shows $500 in Ad spend, 250 Clicks, and 50,000 Impressions for a single campaign. Entering those three figures returns a Cost per click (CPC) of $2.00, a Cost per thousand impressions (CPM) of $10.00, and a Click-through rate (CTR), % of 0.5% — three readings of the identical $500, and none of them optional if the goal is judging whether that spend landed well.
Now imagine a second campaign that also posts a $2.00 CPC but needed only 5,000 impressions to generate those same 250 clicks — its click-through rate reads 5%, ten times higher, because it reached a far smaller, better-matched audience to earn an identical number of clicks. CPC alone would call the two campaigns equally efficient; CTR is what shows one of them found its audience with a tenth of the exposure the other required.
Questions
Why show CPC, CPM, and CTR on one page instead of three?
Because all three fall out of the same three numbers — spend, clicks, and impressions — and reading only one invites a misleading comparison. Two campaigns can post an identical CPC while one needed ten times the impressions to earn it; CTR is what exposes that gap, so pulling all three from one export catches what a single metric alone would miss.
Can two campaigns share the same CPC and still perform differently?
Yes, routinely. CPC only measures spend against clicks earned, so a campaign needing 50,000 impressions to generate 250 clicks and one needing only 5,000 can both post an identical $2.00 CPC. Click-through rate — 0.5% against 5% — is what separates a broadly targeted campaign from a tightly matched one, even though the cost-per-click line looks identical.
Does a low CPC mean the campaign is doing well?
Not on its own. CPC only says how much each click cost, not whether it came from an interested viewer or led anywhere afterward. A cheap click on a loosely matched audience can cost less than a well-targeted one and still be worth less, since CPC says nothing about what happened once the visitor arrived on the landing page.
What is the practical difference between CPC and CPM here?
CPM prices exposure — every 1,000 times the ad was served, whether or not anyone clicked — while CPC prices only the clicks that actually happened. A campaign can carry a cheap CPM and an expensive CPC at once if it is shown widely but earns few clicks relative to that reach; the two figures answer different questions from the same spend.
Why do CPC and CPM move independently of CTR?
CPC and CPM both divide spend by a volume figure — clicks or impressions — while CTR divides clicks by impressions and never touches spend at all. Raising the budget with clicks and impressions held constant moves CPC and CPM together but leaves CTR exactly where it was, which is why spend alone tells nothing about how well an ad is targeted.
Does this account for conversions or revenue from the clicks?
No, deliberately. These three figures describe the cost and reach of earning a click, not what that click was worth afterward. Pair a low CPC or CPM against a conversion rate and revenue-per-click figure pulled from the same platform before judging whether the spend paid for itself; this sheet stops at the click.
References
- U.S. Small Business Administration — Marketing and sales guide
- U.S. Small Business Administration — Business Guide
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.