Blog / Marketing and SEO

How to Report Marketing: A Step-by-Step Guide to Marketing Reports, With Examples and a Free Template

The Coavon team · · 17 min read

Key takeaways

To report marketing, start from the business goal, choose three to seven measures that show progress toward it, compare each one with a target and with the last period, explain why the numbers moved, and end with the actions you will take next. A good marketing report answers three questions in its first few lines: what happened, why it happened and what we will do about it. Everything else (charts, channel tables, campaign details) is there to back those answers up.

This guide covers what a marketing report is, who reads it, the main types, the KPIs worth reporting with their formulas, how to write a report in ten steps, a complete worked example and the mistakes that make reports go unread. If you want the layout ready made, download our free marketing report template for Excel. It has a scorecard, a channel table and charts that fill themselves in when you pick a month.

Short on time? Jump to what to include, the ten steps, the KPIs and formulas, the worked example or the free template.

What is a marketing report?

A marketing report is a regular summary of how marketing performed over a period, measured against its goals, with an explanation of the results and the next steps. It usually covers a week, a month, a quarter or a single campaign, and it is written for a particular reader: a business owner, a leadership team, a client or the marketing team itself.

Marketing reporting is the ongoing practice behind it: collecting the numbers from each channel, keeping their definitions consistent, and turning them into a report on a fixed schedule. The aim is not to prove marketing is busy. It is to help people decide where to put the next dollar and the next hour.

Marketing report vs dashboard vs analytics

The three words are often used as if they mean the same thing. They don't, and knowing the difference makes reports better.

Marketing reportMarketing dashboardMarketing analytics
What it isA summary for a period with an explanation and next stepsA live screen of numbers that updates on its ownThe work of digging into data to find out why something happened
AnswersHow did we do, why, and what now?Where do things stand right now?What is causing this, and what would change it?
Written forOwners, leaders, clientsThe people running the channels day to dayThe marketing team
Includes words?Yes: the summary, the reasons and the actionsRarelyOften, as notes and findings
How oftenWeekly, monthly, quarterly or per campaignAlways onWhen a question comes up

A dashboard is a good source for a report, but it is not the report. The report is where someone has looked at the numbers and written down what they mean.

Who reads a marketing report, and what they want from it

The same results need a different report for each reader. Before you write, decide who it is for.

ReaderWhat they care aboutWhat to show them
Owner or CEOIs marketing bringing in customers and revenue at a sensible cost?Revenue from marketing, new customers, cost to win a customer, return on spend, and the one or two decisions you need from them
Leadership teamProgress toward the quarter's goals and anything at riskResults against targets, the trend over recent months, risks and the plan to fix them
Sales teamThe number and quality of leadsLeads, qualified leads, how many sales accepted, and where the best leads came from
Client (for agencies)What they are getting for the feeResults against what was agreed, the work done, what worked, and the plan for next month
Marketing teamWhich channels and campaigns to changeChannel and campaign detail: cost per lead, conversion rates, click-through rates, tests and their results

A useful habit is to write one report with layers: a short summary and scorecard for senior readers at the top, and the channel and campaign detail below for the people who run them.

Types of marketing reports

ReportHow oftenUsual readerWhat it focuses on
Weekly reportEvery weekMarketing teamShort-term numbers, spend pacing, campaigns that need attention this week
Monthly marketing reportEvery monthOwner, leadership, clientsResults against monthly targets, trends, what worked, next month's plan
Quarterly reportEvery three monthsLeadership, boardProgress on goals, return on spend, budget decisions for the next quarter
Campaign reportAt the end of a campaign (and part-way for long ones)Marketing team, ownerWhat the campaign cost, what it produced, and what to repeat or drop
Channel reportMonthlyChannel ownerOne channel in depth: SEO, paid search, paid social, email or social
Client reportMonthly, sometimes weeklyAgency clientsResults against the agreed goals, work completed, next steps
Annual reportOnce a yearLeadershipThe year's results, what was learned and next year's plan and budget

For most small and mid-sized businesses, the monthly marketing report is the one that matters most. It is frequent enough to change course and long enough for the numbers to settle.

What to include in a marketing report

Whatever the type, a clear marketing report has the same seven parts, in this order:

  1. Summary. Two to four sentences: the headline result, the main reason, and the main action. Write it last, put it first.
  2. Scorecard. Your three to seven KPIs, each with this period, the last period, the change, the target and a status such as On track, Close or Behind.
  3. Trends. One or two charts showing the main KPIs over the last six to twelve months, so a good or bad month is seen in context.
  4. Results by channel. Spend, leads, customers and revenue for each channel, with cost per lead and return on spend.
  5. What worked and what did not. Short notes that explain the numbers: a campaign that took off, a page that started ranking, an ad that flopped.
  6. Next steps. The actions you will take, each with an owner and a date, and any decision you need from the reader.
  7. Appendix (optional). Campaign details, definitions of each metric, and notes on the data, such as a tracking problem or a change in how something is counted.

Our marketing report template follows exactly this order on one Excel sheet, with the detail on separate tabs.

How to report marketing in 10 steps

1. Start from the business goal

Every marketing report should connect to something the business wants: more customers, more revenue, more sales meetings, a new product launched, more people in a new market. Write the goal at the top of your planning notes, for example "Win 75 new customers this quarter at under $350 each". Every number you report should help show progress toward it. If a number doesn't, leave it out or move it to the appendix.

2. Decide who the report is for

Pick the main reader and write for them. An owner wants revenue, customers and cost. A channel manager wants click-through rates and cost per click. If you have several readers, keep the top of the report for the most senior and put channel detail lower down. When in doubt, ask the reader what decision they make with the report.

3. Choose three to seven KPIs

A KPI (key performance indicator) is a measure that shows progress toward the goal. Pick one or two from each stage of the funnel that matters to you, for example:

Everything else (likes, page views, open rates) can sit in the channel detail. The KPI table below has the formula for each.

4. Set targets and comparison periods

A number on its own tells the reader nothing. Is 191 leads good? Only if you know the target was 180 and last month was 177. For every KPI, show the target and the previous period. For seasonal businesses, add the same month last year, because comparing December with November can mislead.

Targets should come from the plan: if you want 75 customers this quarter, that is 25 a month, and if one lead in eight becomes a customer, you need about 200 leads a month. If you don't have targets yet, use your recent average as a starting point and set real ones next quarter. Our guide to writing objectives covers how to set them.

5. Define every metric, once

Most arguments about marketing reports are really arguments about definitions. Agree them in writing before the first report and keep them the same:

Write the answers in a definitions list at the end of the report (the template has a KPI definitions sheet for this). When you change a definition, say so in the report, because the trend will jump.

6. Set up tracking before you need it

You can only report what you measure. Before the period starts, check that:

7. Collect and check the data

Pull the numbers on the same day each period, from the same places. Then sense-check them before anyone else sees them: a channel that doubled overnight is more often a tracking change than a breakthrough. Look for gaps (a missing week), double counting (the same lead in two channels) and numbers that don't add up across sources. If something is wrong and can't be fixed in time, report it with a note rather than leaving it out.

A spreadsheet is the simplest place to collect it all. In the template you add one row per channel per month, and the totals, rates and charts are worked out for you.

8. Explain why the numbers moved

This is the step most reports skip, and the one readers value most. For every KPI that moved noticeably, or missed its target, write one or two sentences in this pattern:

What moved → why it moved → what we will do about it. For example: "Paid social cost $96 a lead, more than double our $45 target, because the new video ads had a low click-through rate. We will move $1,000 a month to paid search, which brought customers at a lower cost."

Be honest about what didn't work. A report that only shows good news is quickly ignored, and the failures are often where the next improvement comes from.

9. Write the summary and the next steps

Now write the summary at the top: the headline result, the main reason and the main action, in three or four sentences. Then list the next steps, each with one owner and one date. If you need a decision from the reader (more budget, approval for a new channel, a change of target), ask for it clearly in the summary, not on page four.

10. Send it on a fixed schedule, and follow up

Send the report on the same day each period, for example the third working day of the month. Keep the same layout so readers know where to look. Go through it in a short meeting if decisions are needed, and start the next report by checking whether last month's actions were done. A recurring task ("Send the March marketing report") is the easiest way to keep the habit.

Marketing KPIs to report, with formulas

These are the measures most marketing reports draw from. You won't need all of them: pick the few that match your goal for the scorecard, and keep the rest for the channel detail.

KPIWhat it tells youFormula
Website sessionsHow many visits your site hadCounted by your analytics tool
LeadsHow many people raised their handCount of form sends, bookings, sign-ups (as you define them)
Lead conversion rateHow well the site turns visits into leadsLeads ÷ sessions
Marketing qualified leads (MQLs)Leads that fit the customer you wantLeads that meet your agreed definition
Sales qualified leads (SQLs)Leads sales has acceptedLeads accepted by sales
Lead-to-customer rateHow many leads end up buyingNew customers ÷ leads
New customersCustomers marketing brought inCount, using your attribution rule
Revenue from marketingRevenue those customers broughtSum, using your attribution rule
Cost per lead (CPL)What one lead costMarketing spend ÷ leads
Customer acquisition cost (CAC)What one new customer costMarketing (and sales) spend ÷ new customers
Return on ad spend (ROAS)Revenue for each dollar of ad spendRevenue ÷ ad spend
Marketing ROIWhat you earned back after taking off the cost(Revenue − marketing spend) ÷ marketing spend
Click-through rate (CTR)How often people who saw something clicked itClicks ÷ impressions
Cost per click (CPC)What each paid click costAd spend ÷ clicks
Customer lifetime value (LTV)What a customer is worth over the whole relationshipAverage revenue per customer per year × years they stay (or see our LTV calculator)

Two notes on these. ROAS and ROI are not the same: a ROAS of 4.0x means $4 of revenue for every $1 spent, while the ROI on the same campaign is 300%, because ROI takes the spend back off. And both use revenue, not profit, unless you say otherwise; if your margins are thin, a campaign can show a good ROAS and still lose money. Our ROI calculator and guide to how to calculate ROI go into this in more detail.

Channel metrics worth tracking

ChannelMetrics for the channel detail
SEO (organic search)Clicks and impressions from Google Search Console, rankings for your main terms, leads from organic visits, pages that brought the most leads
Paid searchSpend, clicks, CTR, CPC, conversions, cost per lead, ROAS
Paid socialSpend, reach, CTR, cost per lead, ROAS, how often the same people saw the ad (frequency)
EmailList size, click rate, unsubscribe rate, leads and revenue from email. Treat open rates with care: some email apps load messages automatically, which counts them as opened
Organic socialFollowers, engagement on posts, clicks to the site, leads from social
ContentVisits to new articles, leads from content, which topics brought leads
Events and webinarsRegistrations, attendance rate, leads and customers from attendees, cost per attendee

Vanity metrics vs useful metrics

A vanity metric looks good but doesn't help anyone decide anything. Likes, impressions and total page views can all go up while sales stay flat. That doesn't mean they are useless: they belong in the channel detail as early signs, not on the scorecard. A quick test: if this number doubled, would we do anything differently? If not, it isn't a KPI.

Marketing report example: a monthly report

Here is a complete monthly marketing report for a made-up business, as it would look in our Excel template. The business sells to other businesses, wants to win 25 customers a month and spends about $8,000 a month on marketing. All figures are examples.

Summary

"March brought in 191 leads, 8% more than February, and 25 new customers, which meets the customer target. Organic search and email drove most of the growth. Paid social cost $96 a lead and brought one customer, so in April we will move $1,000 of its budget to paid search, which brings customers at a lower cost."

Scorecard

MeasureMarchFebruaryChangeTargetStatus
Website sessions11,20010,400+8%11,000On track
Leads191177+8%180On track
Lead conversion rate1.71%1.70%+0%1.60%On track
Sales qualified leads3934+15%40Close
New customers2523+9%25On track
Revenue from marketing$31,800$29,000+10%$30,000On track
Marketing spend$7,800$7,300+7%$8,000 (at most)On track
Cost per lead$40.84$41.24−1%$45 (at most)On track
Customer acquisition cost$312$317−2%$320 (at most)On track
Return on marketing spend308%297%+4%250%On track

By channel

ChannelSpendLeadsCustomersRevenueCost per leadROAS
Organic search$1,500638$9,600$23.816.4x
Paid search$3,500527$9,100$67.312.6x
Paid social$2,500261$1,200$96.150.5x
Organic social$0101$1,300––
Email$300285$7,000$10.7123.3x
Referral$0123$3,600––
Total$7,80019125$31,800$40.844.1x

What worked and what did not

Next steps

ActionOwnerDue
Move $1,000 a month from paid social to paid searchAds lead3 April
Publish two more guides on the topics that brought leads in MarchContent lead24 April
Test two new subject lines in the welcome emailsEmail lead17 April

Notice what makes it work: the summary gives the result, the reason and the decision in three sentences; every number has a comparison; the one weak channel is named, not hidden; and each action has one owner and a date.

How to present marketing data

Charts help when they make a pattern obvious at a glance. Pick the chart for the question:

To showUseAvoid
A trend over timeA line chart of the last 6 to 12 monthsA chart of only two months
A comparison between channels or campaignsA bar chart, sorted from largest to smallestA pie chart with more than four slices
Progress toward a targetThe number with its target and a status colorA gauge or speedometer graphic
How leads move through stagesA simple funnel or a table of stages with conversion rates3D charts of any kind

Use the same colors for the same channels every month, label the axes, and put the key takeaway in the chart title ("Organic search now brings a third of our leads") rather than a label like "Leads by channel".

Attribution: which channel gets the credit?

Most customers touch several channels before they buy: they find a guide through search, follow you on social, then click an email and book a call. Attribution is the rule for deciding which channel gets credit for the sale. Common rules are:

There is no perfect rule. What matters for reporting is to choose one, say which one you use, and keep it the same, so month-to-month changes reflect real changes and not a new way of counting.

How often should you report marketing?

Match the rhythm to the decisions each reader makes:

Reporting more often than people can act on the numbers just adds noise. Most lead and revenue numbers need at least a month to settle.

Common marketing reporting mistakes

Using AI to help write marketing reports

AI writing tools are useful for the slow parts of reporting: turning a table of numbers into a first draft of the summary, suggesting reasons for a change you can then check, or rewriting a channel manager's notes for a senior reader. Two rules keep it safe: check every number in the draft against your data, because these tools can state a wrong figure confidently, and write the reasons yourself or confirm them, because the AI only knows what you give it. Don't paste private customer data into a tool your company hasn't approved.

Tools for marketing reporting

You don't need special software to start. Most teams combine a few of these:

Where Coavon fits

Coavon is not a marketing analytics tool: it does not connect to ad platforms or Google Analytics, so the numbers still come from those tools. It is where the reporting work and the follow-up live. In Flow a recurring task reminds you to send the report on the same day every month, and the actions at the end of each report become tasks with an owner and a due date. In Scope, the CRM, the Analytics page shows revenue won, win rate and a forecast for the deals your marketing brought in. You can write the report in Docs and send it as Word or PDF, keep the spreadsheet in Drive next to the client or project it belongs to, and share it with the team in Chat.

Marketing report checklist

Before you send it, check that the report:

A marketing report template you can use

Our free marketing report template for Excel has everything in this guide ready to fill in:

It comes filled in with the example from this guide, so you can see how it works before adding your own numbers.

Frequently asked questions

How do you report marketing?

Start from the business goal, choose three to seven KPIs that show progress toward it, compare each with a target and the previous period, explain why the numbers moved, and finish with next steps that each have an owner and a date. Put a three or four sentence summary at the top: what happened, why and what you will do next.

What should be included in a marketing report?

A summary, a scorecard of key KPIs against targets and the previous period, trend charts, results by channel, notes on what worked and what did not, next steps with owners and dates, and optionally an appendix with campaign detail and metric definitions.

How do I write a marketing report?

Collect the numbers for the period, check them for tracking errors, fill in the scorecard and channel table, write one or two sentences explaining each important change, list the next steps, then write the summary last and put it at the top. A template with a fixed layout makes each report faster.

What KPIs should be in a monthly marketing report?

Pick three to seven that match your goal. A common set is website sessions, leads, lead conversion rate, qualified leads, new customers, revenue from marketing, marketing spend, cost per lead, customer acquisition cost and return on marketing spend. Keep channel metrics such as click-through rate and cost per click in the channel detail.

How often should marketing be reported?

Monthly for owners, leaders and clients; weekly for the marketing team if they manage paid campaigns; quarterly for a board or leadership review; and at the end of each campaign. Report only as often as someone can act on the numbers.

What is the difference between a marketing report and a marketing dashboard?

A dashboard shows live numbers that update on their own. A report covers a set period, compares the results with targets, explains why they changed and says what happens next. Dashboards are a good source for a report but do not replace the explanation.

How long should a marketing report be?

Short enough that the main reader gets the point in a minute: a summary and a scorecard on the first page. Channel and campaign detail can follow on later pages or tabs for the people who need it.

How do you report marketing results to a CEO or business owner?

Lead with revenue, new customers, customer acquisition cost and return on spend, compared with targets. Explain the main reason for the result in a sentence, ask clearly for any decision you need, and keep channel detail out of the first page.

How do you show the ROI of marketing in a report?

Divide revenue from marketing minus marketing spend by marketing spend. Say which revenue you counted (your attribution rule) and which costs you included, and keep both the same each period so the trend is meaningful.

Is there a free marketing report template?

Yes. Coavon has a free marketing report template for Excel with a scorecard, channel table, charts, a campaign tracker and KPI definitions. It is free to download with no sign-up at coavon.com/templates/marketing-report-template.

Coavon · Blog · Templates · Features · Pricing