Paste multiple campaign data rows to calculate CPM for all of them at once. Export results to CSV or PDF for reporting.
Exchange rates fixed as of October 2026. For live rates, verify with your payment provider.
Supported formats: CSV, TSV, or space-separated. First column can be campaign name (optional). Numbers only in cost and impressions columns.
Managing a single campaign is straightforward, but most media buyers and agencies juggle dozens of campaigns simultaneously across multiple platforms. Calculating CPM for each campaign individually is time-consuming and error-prone. A batch CPM calculator lets you process all your campaign data at once, giving you an instant overview of cost efficiency across your entire portfolio.
Common use cases for bulk CPM calculation include:
The batch CPM calculator accepts multiple input formats to make it easy to paste data from any source. Here are the supported formats:
The most common format. Separate each field with a comma. You can include or omit the campaign name:
With campaign names:
If you copy data directly from a spreadsheet, it will typically be tab-separated. The calculator handles this automatically:
If you only have cost and impressions data without campaign names, paste just two columns. The calculator will label rows automatically:
After calculating CPM for all your campaigns, the results table shows each campaign's cost, impressions, and CPM side by side. The summary statistics at the top provide key insights:
The mean CPM across all campaigns in your batch. This represents your overall cost efficiency. If your average CPM is significantly higher than platform benchmarks (for example, above $14 for Facebook or above $10 for YouTube), you may need to broaden your targeting or improve ad relevance.
The lowest CPM in your batch. This identifies your most cost-efficient campaign in terms of raw reach. However, the cheapest CPM is not always the best outcome if that campaign targets a low-value audience or generates poor engagement.
The highest CPM in your batch. This flags your most expensive campaign for reach. A high CPM may be justified if the campaign targets a premium audience in a high-value niche (like finance or B2B) or if it drives strong conversions despite higher reach costs.
These aggregate figures show the combined spend and reach across all campaigns. Use them to understand the overall scale of your advertising investment and to calculate a blended CPM for the entire batch.
Click "Export CSV" to download your results as a spreadsheet-compatible file. This is ideal for inserting into client reports, sharing with team members, or archiving historical data. Use "Print / PDF" to generate a clean, print-ready version of your results table for presentations or documentation.
Methodology: Batch CPM Calculator uses the standard formula CPM = (Total Cost / Total Impressions) × 1000. Supports multiple input formats for flexibility. Exchange rates from open.er-api.com.
Disclaimer: This calculator provides estimates for reference purposes only and does not constitute financial or business advice. Actual costs and results may vary based on market conditions, targeting, competition, and other factors. Exchange rates are approximate and not real-time financial data. Industry benchmarks are derived from publicly available third-party reports and should be interpreted with caution. Always consult with qualified advertising professionals before making budget decisions.