Calculate Cost per Mille
Result—
Formula
(Ad Cost / Impressions) × 1000Excel formula
=IFERROR((B2/C2)*1000,0)Power BI DAX measure
CPM =
DIVIDE([Ad Cost], [Impressions]) * 1000KPI calculator
Cost per Mille Calculator
Enter your values to calculate Cost per Mille. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.
Affiliate resources
Ideas for You
Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.
Cost per Mille books
Books that help you understand Cost per Mille and related business metrics more deeply.
Explore resources →
Cost per Mille audiobooks
Audiobook searches for learning Cost per Mille while commuting, walking, or working.
Explore resources →
Marketing dashboard resources
Excel-focused resources for building KPI trackers and dashboard workflows.
Explore resources →
Digital marketing analytics
Practical resources for turning Cost per Mille into reports, dashboards, and business decisions.
Explore resources →