CPM Calculator for One or Multiple Campaigns
Solve one campaign immediately, or switch to a spreadsheet-ready audit for true blended CPM.
Enter any two values. The calculator solves the blank field.
Paste four spreadsheet columns: campaign, cost, impressions, CPM. Leave one numeric cell blank on each row.
Start with the ordinary CPM calculation
Enter any two of campaign cost, impressions, and CPM. The blank value is solved with the standard equation, while three completed fields are checked for consistency instead of silently overwritten.
Audit multiple campaigns without averaging CPMs
For a portfolio, true blended CPM is total cost ÷ total impressions × 1,000. The multiple-campaign mode solves one missing value per row, keeps invalid physical lines visible, and calculates totals from valid rows only.
See the average-CPM bias direction
The result intentionally compares blended CPM with the naive arithmetic mean of row CPMs. It reports whether that shortcut overstates or understates the portfolio value and shows each campaign's spend and impression contribution.
One shared currency, with no hidden conversion
The selected currency is a label for every campaign in the current calculation. ToolNeko does not fetch exchange rates here, so convert mixed-currency costs before running a combined audit.
Frequently asked questions
How do you calculate CPM?
Divide campaign cost by impressions, then multiply by 1,000. The standard formula is CPM = cost / impressions × 1,000. Enter any two values here to solve the third.
How do you calculate blended or weighted CPM?
Add the costs from every valid campaign, add their impressions, then divide total cost by total impressions and multiply by 1,000. Do not average the individual campaign CPM values unless every row has exactly the same number of impressions.
Why is the average CPM different from blended CPM?
A simple average gives a small campaign and a large campaign equal influence. Blended CPM uses the actual portfolio totals. This audit shows whether the simple average overstates or understates the weighted value.
Can I paste campaigns from Excel or Google Sheets?
Yes. Copy four columns in this order: campaign name, cost, impressions, and CPM. The browser receives tab-separated rows, preserves physical line numbers, and can solve one blank numeric cell per row.
Can I mix currencies in one audit?
No. The currency selector is only a shared label; it does not perform foreign-exchange conversion. Convert every campaign to the same currency before comparing or totaling them.
What happens when all three campaign values are filled?
The calculator checks whether cost and impressions imply the entered CPM within a small display tolerance. A conflicting row is marked instead of silently replacing one of your values.