Your template, ready
Download it and open the “Example” tab first: you’ll see how to fill it in before you start.
We’ve received your request. We’ll review the information and contact you with the next step as soon as possible.
Marketing KPI template: the monthly report for management
Free marketing KPI template in Excel: the monthly report management asks for, with leads, customers, cost per customer and ROI against target.
The template in figures
Which marketing KPIs are included in the template
Those that answer management’s question: how much did it cost and what did it deliver?
Five figures per month
Marketing investment, visits, new contacts, new customers, and their revenue. Next to each one, it says where to get the data.
Target in green or red
Below contacts, customers, and revenue is the monthly target. The month turns green if you reach it and red if you don’t.
Marketing cost and ROI
Cost per contact, cost per new customer (CAC), and marketing ROI, calculated automatically each month and for the year as a whole.
Year to date, at the top
Contacts, customers, and revenue against their targets, plus cumulative ROI. It is the first thing management sees.
How to create the monthly marketing report using the template
Ten minutes a month, when you finalize the figures.
Fill in the month’s column
Five figures: invoices, Google Analytics, and your CRM or contact list.
Enter the targets
The contacts, customers, and revenue you expect each month. You can enter the same figure for all twelve months.
Look at the color
Green means the month meets the target; red means it falls short. Below, the cost of each contact and each customer.
Print it for management
It fits on one page, in landscape format, with all twelve months and the year to date.
Frequently asked questions about marketing KPIs
Answers to your most common questions
What is a marketing KPI template for?
To show management what marketing has delivered on one page, see which months hit the target and which don’t, know how much each new customer costs you (the CAC) and set realistic targets for next year.
What is a KPI in marketing?
A KPI (key performance indicator) is a figure that shows whether marketing is meeting its objective: how many contacts it brings in, how many become customers, and how much each one costs. Not everything that is measured is a KPI: visits alone do not show whether sales are increasing.
Which marketing KPIs should be presented to management?
Those that connect spending to sales: investment, new contacts, new customers, revenue from those customers, customer acquisition cost (CAC), and ROI. The rest helps identify where people drop off.
What is marketing ROI and how is it calculated?
It is what is earned above the amount invested, expressed as a percentage: revenue from new customers minus the amount invested, divided by the amount invested. An ROI of 200% means that for every euro invested, two more come in. In the template, it is calculated based on revenue.
What is the difference between cost per contact and CAC?
Cost per contact divides the amount invested by the number of new contacts; CAC divides it by the number of new customers. CAC is what matters to management, because a cheap contact who doesn’t buy is of no use.
How often should you prepare the KPI report?
Once a month, when the figures are finalized. Having all twelve months on the same sheet, each one next to its target, is what allows you to see whether anything changes.
What do I need to use the template?
Excel and the month’s figures: invoices, Google Analytics, and the CRM or your contact list. It comes with instructions and nine months of sample data from a payroll firm.



