How Do You Calculate CPM With the CPM Formula?

What Is the CPM Formula?

The CPM formula has one form and three solvable directions:

CPM = (Total Ad Spend ÷ Impressions) × 1,000

Multiplying by 1,000 turns the per-impression cost into a per-thousand-impression cost, which is what advertisers, publishers, and platforms all report on. The CPM calculator on the homepage solves all three directions instantly when you enter any two values; the CPM impressions calculator is purpose-built for the budget-to-reach reverse direction.

How to Calculate CPM Step by Step

1. Pick a clean date range. Use the same start and end date for spend and impressions. Mixing weekly spend with monthly impressions inflates CPM by ~4x.
2. Confirm the impression definition. Match delivered impressions with delivered impressions, or viewable with viewable. Never mix the two.
3. Use one currency only. Convert all spend to a single currency before dividing. Multi-currency totals produce silent errors.
4. Divide spend by impressions. Take ad spend and divide it by the impression count. The result is cost per impression — usually a small decimal like 0.0035.
5. Multiply by 1,000. Cost per impression × 1,000 = CPM. In the example above, 0.0035 × 1,000 = $3.50 CPM.
6. Format as currency. In Excel or Google Sheets, format the result cell as currency so the unit is visible and audit-safe.

How to Solve for Each Variable

Two values determine the third. Use the matching rearrangement:

CPM Formula Examples

Worked through several common scenarios:

• $500 spend, 100,000 impressions. CPM = ($500 ÷ 100,000) × 1,000 = $5.00
• $2,000 budget at a $10 target CPM. Impressions = ($2,000 ÷ $10) × 1,000 = 200,000
• 500,000 impressions wanted at a $25 CPM. Spend = (500,000 ÷ 1,000) × $25 = $12,500
• $2,500 spend, 400,000 impressions. CPM = ($2,500 ÷ 400,000) × 1,000 = $6.25

CPM Formula in Excel and Google Sheets

For spreadsheet workflows, the formula in cell form:

// Cell A: spend, Cell B: impressions, Cell C: CPM
C1 = A1 / B1 * 1000

// Solve for spend (CPM in C, impressions in B):
A1 = (B1 / 1000) * C1

// Solve for impressions (spend in A, CPM in C):
B1 = (A1 / C1) * 1000

Format the result cells as currency for spend/CPM and as Number with thousands separator for impressions. This makes audits faster — you can spot a unit mistake in a single glance.

Common Mistakes When Calculating CPM

1. Mixing date windows. Spend for the last 7 days but impressions for the last 30 will inflate CPM by roughly 4×.
2. Mixing impression definitions. Delivered impressions versus viewable impressions can differ by 30–50%. Match like with like.
3. Forgetting to multiply by 1,000. If your CPM looks like 0.0075, you forgot the multiplier and just calculated cost per impression.
4. Mixing currencies. EUR spend with USD spend without converting silently produces wrong CPMs that can hide for weeks.
5. Comparing across incompatible inventory. A YouTube CPM and a programmatic display CPM are not directly comparable — placement, format, and audience shift the auction.

For the step-by-step audit version of this checklist see how to calculate CPM step by step; for benchmarks that turn the result into a decision see Good CPM Rates 2026.

Frequently asked questions about How Do You Calculate CPM With the CPM Formula?