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’s “Example” tab, filled in with the case of a payroll firm.

The template in figures

5 figures a month, nothing more
12 months on the same sheet
3 automatically calculated figures: cost per contact, CAC, and ROI
Leave us these three details and the download will appear right here, instantly.
Name *
Business email *
Company *

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.