Templates

Marketing report template

A monthly marketing report in Excel: pick a month and the scorecard, channel table and charts fill themselves in. Add your notes and next steps, and send it.

Download for Excel (XLSX). Free to use, no sign-up needed.

MeasureThis monthLast monthChangeTargetStatus
Leads191177+8%180On track
Sales qualified leads3934+15%40Close
New customers2523+9%25On track
Revenue from marketing$31,800$29,000+10%$30,000On track
Cost per lead$40.84$41.24−1%$45On track
Return on marketing spend308%297%+4%250%On track

What is a marketing report template?

A marketing report template is a ready-made layout for reporting how your marketing performed over a month, a quarter or a campaign: the key numbers against their targets, results by channel, an explanation of what happened and the next steps. Using the same template every time makes each report faster to put together and easier to read, because everyone knows where to look.

This one is built for a monthly marketing report in Excel. You add your numbers once, choose the month, and the report sheet works out the totals, rates, comparisons and charts. New to marketing reports? Our guide on how to report marketing explains what to include, which KPIs to use and how to write the summary, with a full worked example.

What is in the template

SheetWhat it does
ReportThe page you send. Choose the month at the top and the scorecard, the channel table and two charts update. Write the summary, what worked, what did not and next month's actions in the boxes provided.
Monthly dataA year of results, month by month, with a target for each measure and whether higher or lower is better. Leads, customers, revenue and spend are added up for you from Channel data.
Channel dataOne row per channel per month: spend, impressions, clicks, leads, new customers and revenue. Click-through rate, cost per click, cost per lead and return on ad spend fill themselves in.
CampaignsAn optional tracker for individual campaigns: dates, budget, spend, leads, customers, revenue, cost per lead, return on ad spend and how much of the budget is used.
KPI definitionsWhat each measure means, how it is worked out and where to find the number.
SetupYour company name, the year, who prepares the report and the names of your channels.

The scorecard tracks website sessions, leads, lead conversion rate, marketing and sales qualified leads, new customers, revenue from marketing, marketing spend, cost per lead, customer acquisition cost, return on marketing spend, email subscribers and social followers. For each one it shows this month, last month, the change, the target, the percentage of target and a status: On track, Close (within 10%) or Behind. For costs, lower is better, so a cost under its target counts as on track.

How to use this marketing report template

  1. Fill in Setup. Add your company name and the year, and rename the channels to match how you report (for example Organic search, Paid search, Paid social, Email).
  2. Set your targets. On Monthly data, give each measure a monthly target in the Target column.
  3. Add each month's results by channel. On Channel data, add one row per channel with spend, impressions, clicks, leads, new customers and revenue.
  4. Add the other monthly numbers. On Monthly data, type website sessions, qualified leads, email subscribers and social followers in the yellow cells.
  5. Choose the month on the Report sheet. Everything on the sheet updates.
  6. Write the words. A three or four sentence summary (what happened, why, what next), what worked, what did not, and next month's actions with an owner and a date for each.
  7. Send it. Save the Report sheet as a PDF, or share the file.

The file comes filled in with made-up example figures for January to March, so you can see how it works. Replace them with your own, or clear the yellow cells to start from scratch. Yellow cells are for typing; the others calculate themselves.

Which numbers to report

Keep the top of the report to three to seven measures that show progress toward your business goal, usually leads, new customers, revenue from marketing and what each cost. The rest can stay in the channel detail. The KPI definitions sheet lists every formula, for example:

For more on choosing KPIs, setting targets and the attribution rule behind "revenue from marketing", see how to report marketing. To work out return on investment for a single campaign, try our ROI calculator.

Using it as a digital marketing or client report

The channel names are yours to change, so the same file works as a digital marketing report (search, paid social, email, display), a report for a single channel, or a client report for an agency, with one copy per client. Agencies often add the work completed that month under "What worked", and the client's goals as the targets.

Turning the report into action

A report only helps if the next steps get done. In Coavon, a recurring task in Flow reminds you to send the report on the same day each month, and each action from the report can become a task with an owner and a due date. Keep the spreadsheet in Drive next to the project or client it belongs to, and track the deals your marketing brings in with Scope, whose Analytics page shows revenue won and win rate. For campaigns still in the planning stage, start with our marketing brief template.

Frequently asked questions

Is this marketing report template free?

Yes. You can download the Excel file and use it without creating an account.

Does it work in Google Sheets?

It is built for Excel. When you open it in Google Sheets the formulas, drop-downs and status colors generally work, but the two charts may need to be redrawn with Insert > Chart.

What should a monthly marketing report include?

A short summary, a scorecard of your key measures against targets and last month, results by channel, notes on what worked and what did not, and next month's actions with owners and dates. This template has a place for each.

Can I add more channels or measures?

You can rename the eight channels on the Setup sheet. To add a measure, insert a row on Monthly data and copy a row of the scorecard on the Report sheet, changing the row it points to.

How do I report on more than one year?

Save a copy of the file for each year, or for each client if you report for several. Keeping last year's file makes it easy to compare the same month year on year.

Where can I learn how to write the report itself?

Our guide on how to report marketing covers what to include, ten steps to write a report, the KPIs worth reporting with their formulas, and a full worked example that uses the same figures as this template.

Coavon · Blog · Templates · Features · Pricing