KKPI Formulas
Excel formulas

Marketing KPI Excel Formulas

Copy Excel formulas for common marketing KPIs and adapt them for your spreadsheet or dashboard.

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.

Marketing Excel KPI books Books that help you understand Marketing Excel KPI and related business metrics more deeply. Explore resources → Marketing Excel KPI audiobooks Audiobook searches for learning Marketing Excel KPI 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 Marketing Excel KPI into reports, dashboards, and business decisions. Explore resources →

Marketing formulas for Excel

KPIFormulaExcel
Customer Acquisition Cost (CAC)Sales and Marketing Cost / New Customers=IFERROR(B2/C2,0)
ROASRevenue from Ads / Advertising Cost=IFERROR(B2/C2,0)
CPACampaign Cost / Number of Acquisitions=IFERROR(B2/C2,0)
Cost per Lead (CPL)Campaign Cost / Number of Leads=IFERROR(B2/C2,0)
Click-Through Rate (CTR)Clicks / Impressions=IFERROR(B2/C2,0)
Conversion RateConversions / Visitors or Leads=IFERROR(B2/C2,0)
Marketing ROI(Revenue from Marketing - Marketing Cost) / Marketing Cost=IFERROR((B2-C2)/C2,0)
Cost per Click (CPC)Ad Cost / Clicks=IFERROR(B2/C2,0)
Cost per Mille (CPM)(Ad Cost / Impressions) × 1000=IFERROR((B2/C2)*1000,0)
Lead Conversion RateConverted Leads / Total Leads=IFERROR(B2/C2,0)
Website Conversion RateWebsite Conversions / Website Visitors=IFERROR(B2/C2,0)
Email Open RateEmails Opened / Emails Delivered=IFERROR(B2/C2,0)
Email Click RateEmail Clicks / Emails Delivered=IFERROR(B2/C2,0)
Bounce RateSingle-Page Sessions / Total Sessions=IFERROR(B2/C2,0)
Impression ShareImpressions Received / Eligible Impressions=IFERROR(B2/C2,0)