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
- Lead with the summary. Three sentences at the top: what happened, why, and what you will do next. Most readers stop there.
- Report fewer numbers. Three to seven KPIs tied to the business goal beat a page of every metric your tools can export.
- Always compare. A number means little alone. Show it against a target and against the previous period.
- Explain, don't just show. For every number that moved, say why. A report that only lists results is a dashboard, not a report.
- Finish with actions. Each report should end with decisions or next steps, each with an owner and a date.
- Keep the definitions fixed. Define each metric once (what counts as a lead, which revenue counts) and use the same definition every month.
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 report | Marketing dashboard | Marketing analytics | |
|---|---|---|---|
| What it is | A summary for a period with an explanation and next steps | A live screen of numbers that updates on its own | The work of digging into data to find out why something happened |
| Answers | How did we do, why, and what now? | Where do things stand right now? | What is causing this, and what would change it? |
| Written for | Owners, leaders, clients | The people running the channels day to day | The marketing team |
| Includes words? | Yes: the summary, the reasons and the actions | Rarely | Often, as notes and findings |
| How often | Weekly, monthly, quarterly or per campaign | Always on | When 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.
| Reader | What they care about | What to show them |
|---|---|---|
| Owner or CEO | Is 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 team | Progress toward the quarter's goals and anything at risk | Results against targets, the trend over recent months, risks and the plan to fix them |
| Sales team | The number and quality of leads | Leads, qualified leads, how many sales accepted, and where the best leads came from |
| Client (for agencies) | What they are getting for the fee | Results against what was agreed, the work done, what worked, and the plan for next month |
| Marketing team | Which channels and campaigns to change | Channel 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
| Report | How often | Usual reader | What it focuses on |
|---|---|---|---|
| Weekly report | Every week | Marketing team | Short-term numbers, spend pacing, campaigns that need attention this week |
| Monthly marketing report | Every month | Owner, leadership, clients | Results against monthly targets, trends, what worked, next month's plan |
| Quarterly report | Every three months | Leadership, board | Progress on goals, return on spend, budget decisions for the next quarter |
| Campaign report | At the end of a campaign (and part-way for long ones) | Marketing team, owner | What the campaign cost, what it produced, and what to repeat or drop |
| Channel report | Monthly | Channel owner | One channel in depth: SEO, paid search, paid social, email or social |
| Client report | Monthly, sometimes weekly | Agency clients | Results against the agreed goals, work completed, next steps |
| Annual report | Once a year | Leadership | The 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:
- Summary. Two to four sentences: the headline result, the main reason, and the main action. Write it last, put it first.
- 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.
- 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.
- Results by channel. Spend, leads, customers and revenue for each channel, with cost per lead and return on spend.
- 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.
- Next steps. The actions you will take, each with an owner and a date, and any decision you need from the reader.
- 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:
- Reach: website sessions, impressions.
- Interest: leads, lead conversion rate.
- Quality: marketing qualified leads, sales qualified leads.
- Results: new customers, revenue from marketing.
- Efficiency: cost per lead, customer acquisition cost, return on marketing spend.
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:
- What counts as a lead? A form fill, a booked call, a free trial? Do repeat sign-ups count?
- What counts as a qualified lead? Which job titles, company sizes or budgets?
- Which revenue counts as marketing's? Revenue from customers whose first contact came from marketing, or every customer who touched marketing at any point?
- What counts as spend? Only ad spend, or also tools, freelancers and staff time?
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:
- Your analytics tool records the actions that count as leads (form sends, bookings, sign-ups) as conversions.
- Links in emails, social posts and ads carry UTM tags (small labels added to the end of the address, such as
utm_source=newsletter,utm_medium=emailandutm_campaign=april), so visits are credited to the right channel and campaign. - Your CRM records where each lead came from, so you can follow a lead through to a customer and revenue.
- Ad accounts, your email tool and your CRM use the same time zone and currency as your report.
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.
| KPI | What it tells you | Formula |
|---|---|---|
| Website sessions | How many visits your site had | Counted by your analytics tool |
| Leads | How many people raised their hand | Count of form sends, bookings, sign-ups (as you define them) |
| Lead conversion rate | How well the site turns visits into leads | Leads ÷ sessions |
| Marketing qualified leads (MQLs) | Leads that fit the customer you want | Leads that meet your agreed definition |
| Sales qualified leads (SQLs) | Leads sales has accepted | Leads accepted by sales |
| Lead-to-customer rate | How many leads end up buying | New customers ÷ leads |
| New customers | Customers marketing brought in | Count, using your attribution rule |
| Revenue from marketing | Revenue those customers brought | Sum, using your attribution rule |
| Cost per lead (CPL) | What one lead cost | Marketing spend ÷ leads |
| Customer acquisition cost (CAC) | What one new customer cost | Marketing (and sales) spend ÷ new customers |
| Return on ad spend (ROAS) | Revenue for each dollar of ad spend | Revenue ÷ ad spend |
| Marketing ROI | What you earned back after taking off the cost | (Revenue − marketing spend) ÷ marketing spend |
| Click-through rate (CTR) | How often people who saw something clicked it | Clicks ÷ impressions |
| Cost per click (CPC) | What each paid click cost | Ad spend ÷ clicks |
| Customer lifetime value (LTV) | What a customer is worth over the whole relationship | Average 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
| Channel | Metrics 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 search | Spend, clicks, CTR, CPC, conversions, cost per lead, ROAS |
| Paid social | Spend, reach, CTR, cost per lead, ROAS, how often the same people saw the ad (frequency) |
| List 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 social | Followers, engagement on posts, clicks to the site, leads from social |
| Content | Visits to new articles, leads from content, which topics brought leads |
| Events and webinars | Registrations, 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
| Measure | March | February | Change | Target | Status |
|---|---|---|---|---|---|
| Website sessions | 11,200 | 10,400 | +8% | 11,000 | On track |
| Leads | 191 | 177 | +8% | 180 | On track |
| Lead conversion rate | 1.71% | 1.70% | +0% | 1.60% | On track |
| Sales qualified leads | 39 | 34 | +15% | 40 | Close |
| New customers | 25 | 23 | +9% | 25 | On track |
| Revenue from marketing | $31,800 | $29,000 | +10% | $30,000 | On 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 spend | 308% | 297% | +4% | 250% | On track |
By channel
| Channel | Spend | Leads | Customers | Revenue | Cost per lead | ROAS |
|---|---|---|---|---|---|---|
| Organic search | $1,500 | 63 | 8 | $9,600 | $23.81 | 6.4x |
| Paid search | $3,500 | 52 | 7 | $9,100 | $67.31 | 2.6x |
| Paid social | $2,500 | 26 | 1 | $1,200 | $96.15 | 0.5x |
| Organic social | $0 | 10 | 1 | $1,300 | – | – |
| $300 | 28 | 5 | $7,000 | $10.71 | 23.3x | |
| Referral | $0 | 12 | 3 | $3,600 | – | – |
| Total | $7,800 | 191 | 25 | $31,800 | $40.84 | 4.1x |
What worked and what did not
- Worked: organic search leads rose 15% after two new guides went live. Email brought 28 leads and 5 customers for $300 of tool costs.
- Did not work: paid social spent $2,500 for 26 leads (about $96 each) and one customer. The new video ads had a low click-through rate.
Next steps
| Action | Owner | Due |
|---|---|---|
| Move $1,000 a month from paid social to paid search | Ads lead | 3 April |
| Publish two more guides on the topics that brought leads in March | Content lead | 24 April |
| Test two new subject lines in the welcome emails | Email lead | 17 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 show | Use | Avoid |
|---|---|---|
| A trend over time | A line chart of the last 6 to 12 months | A chart of only two months |
| A comparison between channels or campaigns | A bar chart, sorted from largest to smallest | A pie chart with more than four slices |
| Progress toward a target | The number with its target and a status color | A gauge or speedometer graphic |
| How leads move through stages | A simple funnel or a table of stages with conversion rates | 3D 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:
- First touch: all credit goes to the first channel. Good for seeing what brings new people in.
- Last touch: all credit goes to the last channel before the sale. Simple, but undervalues the channels that started the relationship.
- Linear: credit is shared equally across every channel the customer touched.
- Data-driven: an analytics tool shares the credit based on patterns in your data. Google Analytics 4 uses this as its default.
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:
- Weekly for the marketing team: spend pacing, campaigns to pause or boost.
- Monthly for owners, leadership and clients: results against targets and next month's plan. This is the core report.
- Quarterly for leadership or a board: progress on goals and budget for the next quarter.
- At the end of each campaign: what it cost, what it produced and whether to run it again.
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
- Reporting everything. Forty metrics hide the five that matter. Keep the scorecard short.
- Numbers without comparisons. Always show the target and the previous period.
- No explanation. Charts without the "why" leave the reader to guess, and they often guess wrong.
- Changing definitions quietly. If you change what counts as a lead, the trend breaks. Say so.
- Hiding bad results. Readers notice, and stop trusting the good news too.
- Taking credit for everything. Claiming every customer for marketing invites pushback from sales. Use an agreed attribution rule.
- No next steps. A report that ends with the numbers changes nothing.
- A new layout every month. Keep the structure fixed so readers know where to look.
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:
- A spreadsheet (Excel or Google Sheets) to collect the numbers and build the report. It is flexible, free or cheap, and easy to share. Our template is a ready-made starting point.
- Your analytics tool, such as Google Analytics, for website visits, conversions and traffic sources.
- Google Search Console for clicks, impressions and rankings from Google search.
- The reporting built into each channel: ad platforms, your email tool, social networks.
- Your CRM for leads, qualified leads, customers and revenue, so you can follow marketing through to sales.
- A dashboard tool that pulls the numbers together automatically, once you report on many channels or clients and the copying takes too long.
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:
- Opens with a summary of three or four sentences: what happened, why, what next.
- Shows three to seven KPIs tied to the business goal.
- Compares every KPI with a target and the previous period.
- Explains every big change and every missed target.
- Names what didn't work, not only what did.
- Ends with actions, each with one owner and one date, and any decision you need.
- Uses the same definitions and attribution rule as last time, or says what changed.
- Has been checked for tracking errors and numbers that don't add up.
- Goes out on the usual day, in the usual layout.
A marketing report template you can use
Our free marketing report template for Excel has everything in this guide ready to fill in:
- A Report sheet with the summary, a scorecard that compares each KPI with last month and its target and marks it On track, Close or Behind, a channel table and two charts. Pick a month and it all updates.
- A Channel data sheet where you add each channel's spend, clicks, leads, customers and revenue, with cost per click, cost per lead and return on ad spend worked out for you.
- A Monthly data sheet that builds the trend for the year, with a target for each measure.
- A Campaigns tracker, a KPI definitions sheet with every formula, and a short guide.
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.