Learn the CPM formula for media planning: calculate CPM, total cost, or impressions—with spreadsheet steps and mistakes I see in client decks.
You will get:
All three algebra rearrangements with worked numbers
Excel/Sheets formulas and practice problems
First-person deck-audit examples (May 2026)
Estimated read time: 14 minutes · Last reviewed May 19, 2026 · Editorial team
Why do two teams report different CPM from the same campaign?
Usually the ×1,000 step is forgotten, or billable vs served impressions differ. I catch this in quarterly deck audits—especially with mixed GDN video and Search.
One relationship, three CPM formula rearrangements
CPM = (Cost ÷ Impressions) × 1,000 — align cost and impressions from the same placement breakdown.
Deck audit (May 2026): Quoted CPM $4.00 on $2,000 spend with 800,000 impressions → true CPM = $2.50. Denominator used clicks by mistake.
CPM (Cost Per Mille) involves three variables: the CPM rate, the total advertising cost, and the total number of impressions. Knowing any two of these values allows you to calculate the third. Here are the three essential formulas every advertiser and publisher should know:
Formula 1 — Calculate CPM
CPM = (Total Cost ÷ Impressions) × 1,000
Find the cost per thousand impressions when you know your total spend and impressions delivered.
Formula 2 — Calculate Total Cost
Total Cost = (CPM × Impressions) ÷ 1,000
Estimate your campaign budget when you know the CPM rate and your impression target.
Formula 3 — Calculate Impressions
Impressions = (Total Cost ÷ CPM) × 1,000
Determine how many impressions your budget can buy at a given CPM rate.
These formulas are algebraically equivalent — each is simply a rearrangement of the same core relationship. The ×1,000 multiplier exists because CPM is expressed per thousand impressions, standardizing the metric for easy comparison across campaigns and platforms.
CPM Formula Explained: Breaking Down Each Component
Total Cost
Total cost (also called total ad spend or total budget) is the total amount of money spent on the advertising campaign. This includes all fees paid to the ad platform or publisher. In a CPM campaign, the total cost is determined by the CPM rate and the number of impressions purchased. Total cost is always expressed in a currency unit (e.g., USD, EUR, GBP).
Impressions
An impression is counted each time an ad is served and loaded on a user's device. It does not require the user to interact with or even consciously notice the ad — simply displaying the ad counts as one impression. Impressions are the base unit of measurement in CPM advertising. Note that impressions are different from reach: one user can generate multiple impressions if they see the same ad multiple times.
The ×1,000 Multiplier
The multiplication by 1,000 converts the per-impression cost into a per-thousand-impression cost. Since individual impressions typically cost fractions of a cent ($0.001 to $0.05), the ×1,000 normalization produces more practical numbers that are easier to work with. For example, saying "our CPM is $5.00" is much more intuitive than saying "we pay $0.005 per impression."
The Relationship Between All Three Variables
The three CPM formulas are interconnected through a simple mathematical relationship. If you visualize it as a triangle:
Total Cost sits at the top: it is the product of CPM and impressions (divided by 1,000)
CPM and Impressions sit at the base: each can be derived from the other two values
This triangular relationship means you always need exactly two known values to solve for the third. Our CPM calculator automatically detects which two values you have entered and solves for the missing one.
Step-by-Step CPM Calculation Examples
Let's work through five detailed examples covering different scenarios you are likely to encounter in real-world advertising.
Example 1: Google Display Campaign CPM
Scenario: You ran a Google Display Network campaign that cost $1,500 and delivered 600,000 impressions. What was the CPM?
Step 1: Identify the known values.
Total Cost = $1,500
Impressions = 600,000
Step 2: Apply the CPM formula.
CPM = ($1,500 ÷ 600,000) × 1,000
Step 3: Calculate the intermediate result.
$1,500 ÷ 600,000 = $0.0025 per impression
Step 4: Multiply by 1,000.
$0.0025 × 1,000 = $2.50 CPM
Interpretation: You paid $2.50 for every 1,000 times your ad was displayed. This is within the typical Google Display Network range of $2–$5 per our CPM benchmarks by platform and industry.
Example 2: Budgeting a Facebook Campaign
Scenario: You want to reach 2,000,000 impressions on Facebook. The estimated CPM for your target audience is $9.00. What budget do you need?
Step 1: Identify the known values.
CPM = $9.00
Impressions = 2,000,000
Step 2: Apply the total cost formula.
Total Cost = ($9.00 × 2,000,000) ÷ 1,000
Step 3: Calculate.
$9.00 × 2,000,000 = $18,000,000
$18,000,000 ÷ 1,000 = $18,000
Interpretation: You need a budget of approximately $18,000 to deliver 2 million impressions on Facebook at a $9.00 CPM.
Example 3: Maximizing Impressions on a Budget
Scenario: A small business has a $3,000 monthly display ad budget. They are running programmatic display ads with an average CPM of $2.40. How many impressions will they receive?
Step 1: Identify the known values.
Total Cost = $3,000
CPM = $2.40
Step 2: Apply the impressions formula.
Impressions = ($3,000 ÷ $2.40) × 1,000
Step 3: Calculate.
$3,000 ÷ $2.40 = 1,250
1,250 × 1,000 = 1,250,000 impressions
Interpretation: The $3,000 budget will deliver 1.25 million impressions at the programmatic display CPM of $2.40.
Example 4: Comparing Two Campaign Options
Scenario: A marketer is deciding between two ad placements:
Option A: $5,000 for 800,000 guaranteed impressions
Option B: $3,200 for 400,000 guaranteed impressions
Which option has a lower CPM?
Option A CPM: ($5,000 ÷ 800,000) × 1,000 = $6.25
Option B CPM: ($3,200 ÷ 400,000) × 1,000 = $8.00
Interpretation: Option A has a lower CPM ($6.25 vs $8.00), making it more cost-efficient on a per-impression basis. However, as our comparison of CPM, CPC, and CPA pricing models explains, the best choice also depends on the quality of impressions, audience targeting, and campaign objectives — a lower CPM is not always the better option if the audience quality differs significantly.
Example 5: Publisher Revenue Calculation (eCPM)
Scenario: A blog earned $850 from display ads last month. Google Analytics shows the site delivered 320,000 ad impressions. What is the eCPM?
Step 1: Use the same CPM formula (but from the publisher's perspective, it becomes eCPM).
eCPM = ($850 ÷ 320,000) × 1,000
Step 2: Calculate.
$850 ÷ 320,000 = $0.002656
$0.002656 × 1,000 = $2.66 eCPM
Interpretation: The publisher earned $2.66 for every 1,000 ad impressions. For a general content blog using AdSense, this is a typical eCPM — check our CPM benchmarks for more rate comparisons. Upgrading to a premium ad network could potentially double or triple this figure.
Advertisement
CPM Formula in Excel and Google Sheets
Calculating CPM in a spreadsheet is straightforward. Below are the formulas for all three variations, assuming your data is organized with headers in Row 1 and data starting in Row 2.
Spreadsheet Setup
A
B
C
D
Row 1
Campaign Name
Total Cost ($)
Impressions
CPM ($)
Row 2
Spring Display
1500
600000
(formula)
Formula 1: Calculate CPM
In cell D2, enter:
Excel / Google Sheets Formula
=(B2/C2)*1000
Calculates CPM from Total Cost (B2) and Impressions (C2). Result: $2.50
Formula 2: Calculate Total Cost
If you know CPM (D2) and Impressions (C2) and want to calculate Total Cost:
Excel / Google Sheets Formula
=(D2*C2)/1000
Calculates Total Cost from CPM (D2) and Impressions (C2).
Formula 3: Calculate Impressions
If you know Total Cost (B2) and CPM (D2) and want to calculate Impressions:
Excel / Google Sheets Formula
=(B2/D2)*1000
Calculates Impressions from Total Cost (B2) and CPM (D2).
Pro Tips for Spreadsheet CPM Calculations
Format the CPM column as currency — Select the column, right-click, choose Format Cells, and select Currency with 2 decimal places.
Format impressions with comma separators — Use the Number format with 0 decimal places for readability.
Add error handling — Wrap your formulas with IFERROR to handle division by zero: =IFERROR((B2/C2)*1000, "")
Create a running average CPM — Use =AVERAGE(D2:D100) to calculate your average CPM across all campaigns.
Weight your CPM by spend — For a more accurate overall CPM, use: =(SUM(B2:B100)/SUM(C2:C100))*1000
CPM Formula for Impressions (Reverse Calculation)
One of the most practical uses of the CPM formula is determining how many impressions you can afford with a given budget. This is critical for media planning and campaign forecasting.
Impressions from CPM and Budget
Impressions = (Budget ÷ CPM) × 1,000
When to use this formula:
Planning a brand awareness campaign and need to estimate reach
Comparing how far your budget goes across different platforms
Setting impression targets for a media plan
Evaluating whether a proposed CPM rate fits your budget constraints
Quick reference table — Impressions by budget and CPM:
Budget
CPM $2.00
CPM $5.00
CPM $10.00
CPM $25.00
$1,000
500,000
200,000
100,000
40,000
$5,000
2,500,000
1,000,000
500,000
200,000
$10,000
5,000,000
2,000,000
1,000,000
400,000
$25,000
12,500,000
5,000,000
2,500,000
1,000,000
$50,000
25,000,000
10,000,000
5,000,000
2,000,000
CPM Formula for Total Cost (Reverse Calculation)
When you know how many impressions you want and the expected CPM, you can calculate the required budget:
Total Cost from CPM and Impressions
Total Cost = (CPM × Impressions) ÷ 1,000
When to use this formula:
Creating a campaign budget proposal for stakeholder approval
Estimating spend required to achieve a specific reach goal
Forecasting monthly or quarterly advertising costs
Comparing the cost of achieving the same impression volume across platforms
Quick reference table — Cost by impressions and CPM:
Impressions
CPM $2.00
CPM $5.00
CPM $10.00
CPM $25.00
100,000
$200
$500
$1,000
$2,500
500,000
$1,000
$2,500
$5,000
$12,500
1,000,000
$2,000
$5,000
$10,000
$25,000
5,000,000
$10,000
$25,000
$50,000
$125,000
10,000,000
$20,000
$50,000
$100,000
$250,000
Common CPM Calculation Mistakes
Even experienced marketers sometimes make errors when working with CPM. Here are the most common mistakes and how to avoid them:
1. Forgetting the ×1,000 Multiplier
The most frequent mistake is dividing cost by impressions without multiplying by 1,000. This gives you the cost per single impression, not per thousand. If your result is an extremely small number like $0.003, you likely forgot to multiply by 1,000. The correct answer should be $3.00.
2. Using Reach Instead of Impressions
Reach (unique users) and impressions (total ad views) are different metrics. One user seeing your ad 3 times counts as 1 reach but 3 impressions. CPM is calculated using impressions, not reach. Using reach in the formula will give you an inflated CPM figure that does not reflect the actual cost per thousand ad views.
3. Mixing Up Gross and Net Costs
Agency fees, platform fees, and ad serving costs can significantly affect your effective CPM. Always be clear about whether you are calculating CPM on gross spend (total amount billed) or net spend (amount actually going to media). A $10 CPM on gross spend could be a $7 CPM on net spend if 30% goes to agency and platform fees.
4. Comparing CPMs Across Incompatible Channels
Comparing a LinkedIn CPM ($55) to a Google Display Network CPM ($3) without context is misleading. These channels reach fundamentally different audiences with different intent levels. A $55 LinkedIn CPM reaching B2B decision-makers may be far more valuable than a $3 display CPM reaching casual web browsers. Always consider the quality, click-through rate, and relevance of impressions alongside the raw cost.
5. Ignoring Viewability
Not all impressions are actually seen by users. Industry viewability averages range from 50–70%, meaning 30–50% of impressions you pay for may never enter the user's viewport. When possible, calculate your viewable CPM (vCPM) by dividing cost by viewable impressions instead of total impressions. This gives a more accurate picture of your true cost per actual exposure.
6. Not Accounting for Ad Fraud
Invalid traffic (IVT) from bots and fraudulent sources can inflate your impression counts, making your CPM appear lower than it actually is. Industry estimates suggest 5–15% of display ad impressions are fraudulent. Use traffic verification tools and calculate your "clean" CPM after removing invalid impressions for more accurate analysis.
Practice Problems
Test your understanding of the CPM formula with these practice problems. Click each question to reveal the answer.
Solution:
CPM = (Total Cost ÷ Impressions) × 1,000
CPM = ($12,000 ÷ 1,800,000) × 1,000
CPM = $0.006667 × 1,000
CPM = $6.67
This is within the typical YouTube CPM range of $4–$10. Use our YouTube CPM calculator to estimate channel revenue.
Solution:
Impressions = (Total Cost ÷ CPM) × 1,000
Impressions = ($20,000 ÷ $45.00) × 1,000
Impressions = 444.44 × 1,000
Impressions = 444,444
Your $20,000 budget will deliver approximately 444,444 impressions on LinkedIn.
Solution:
Google Display: 60% of 10M = 6,000,000 impressions
Google Cost = ($3.50 × 6,000,000) ÷ 1,000 = $21,000
The CPM formula is: CPM = (Total Ad Cost ÷ Total Impressions) × 1,000. This calculates how much an advertiser pays for every 1,000 ad impressions. The formula can be rearranged to solve for total cost or impressions if you know the other two variables.
In Excel or Google Sheets, enter the formula =(B2/C2)*1000 where B2 contains your total cost and C2 contains your total impressions. For error handling, use =IFERROR((B2/C2)*1000, "") to gracefully handle cases where impression data is missing or zero.
Use the reverse formula: Impressions = (Total Cost ÷ CPM) × 1,000. For example, with a $5,000 budget and a $4.00 CPM: ($5,000 ÷ $4.00) × 1,000 = 1,250,000 impressions. This formula is essential for media planning and budget allocation.
The "M" in CPM stands for "Mille," which is Latin for "thousand." It also corresponds to the Roman numeral M (1,000). So CPM literally translates to "Cost Per Thousand," as our complete guide to CPM explains in depth. The Latin term was adopted from traditional print advertising, where rates were quoted per thousand copies of circulation.
The ×1,000 multiplier normalizes the cost to a per-thousand basis for practical readability. Without it, you would be dealing with very small numbers — a $5 CPM is equivalent to $0.005 per single impression. Working with whole dollars and cents per thousand impressions is far more convenient for budgeting, reporting, and comparing campaign performance across platforms.
The mathematical formula is identical: both divide a monetary amount by impressions and multiply by 1,000. The difference is perspective. CPM uses the advertiser's cost as the numerator (what they paid), while eCPM uses the publisher's revenue as the numerator (what they earned). eCPM also normalizes revenue from multiple pricing models (CPM, CPC, and CPA) into a single per-thousand metric, making it more useful for publishers.
To calculate blended CPM, sum all campaign costs and sum all campaign impressions, then apply the standard formula: Blended CPM = (Total Combined Cost ÷ Total Combined Impressions) × 1,000. Do not simply average the individual CPMs — this would give incorrect results if campaigns have different impression volumes. Weight-based averaging using total spend and total impressions gives the accurate blended figure.
In standard advertising, CPM cannot be zero or negative because advertisers always pay something for ad delivery. However, an eCPM of zero can occur for a publisher if no ads are served or if ad fill rate is 0%. In rare cases, platforms running promotional credits or make-good impressions may result in an effective CPM that approaches zero for the advertiser. Negative CPMs do not exist in practice.