SEO Reporting: What a Monthly SEO Report Should Include (With a Template)

You pay for SEO every month and a report lands every month, and the two don't always meet. The sessions line is up, the rankings table is green, and the question you actually have, which is what the spend produced, is still open. Most SEO reporting looks like this because the tools hand over sessions and positions by default, and pipeline has to be built on purpose.

This piece sets out the monthly SEO report we'd want to receive if we were the client: a ten-line template you can copy, the five KPIs that matter for B2B, the three questions to ask when the report arrives, and what to do if your agency doesn't produce it yet. It is the same thinking behind our reporting dashboards service.

The short version

• A monthly SEO report should fit on one page and read like a profit and loss statement for the channel: spend, CRM-sourced leads, pipeline, revenue with the sales-cycle lag noted, market share against five named competitors, and cost per qualified lead next to paid.
• Five KPIs carry a B2B report; rankings, sessions and domain authority belong in an appendix, and a report that ends without three next actions was a newsletter.
• We build this kind of reporting for companies that want search judged on pipeline and revenue, with the logic settled before anyone opens a dashboard tool.

What should a monthly SEO report include?

One page that reads top to bottom, then an appendix for everything else. Here is the template, ten lines in order. Copy it as it stands.

• 1. Spend. The retainer plus any content, tooling or link costs, as one number. If the report doesn't start with what it cost, nothing below it can be judged.
• 2. Leads, from the CRM. Qualified enquiries with organic as the original source in HubSpot or Salesforce, not GA4 or Google Ads conversions. The platform figure is what the platform believes it caused; the CRM figure is what your sales team actually received.
• 3. Pipeline created. The value of opportunities opened from those leads this month.
• 4. Revenue closed, with the lag noted. If your sales cycle is 90 days, this month's revenue belongs to work done in the spring. Say so on the page, every month, so the right quarter gets the credit.
• 5. Market share against named competitors. Your share of the category's clicks versus the five firms you actually lose deals to. The method is in market share as a marketing metric.
• 6. Cost per qualified lead, next to paid. Spend divided by CRM leads, beside the same number for Google Ads. This is the line the finance director reads first.
• 7. What moved, and why. Two or three sentences on the biggest change, with seasonality and any known market factors shown rather than asserted.
• 8. What shipped against scope. Pages with URLs, technical changes, link placements, each against what the contract says a month contains.
• 9. Three actions for next month. Each tied to a line above.
• 10. Appendix. Rankings for the commercial terms, sessions, the full changelog. Useful for the people doing the work, never the headline.

The technical bit that makes lines two to four possible is a source field on every contact record and lifecycle stages the sales team actually moves deals through. In plain English: the CRM has to know a lead came from organic search, and what happened to it afterwards. Without those two fields the report can't be built; more on that at the end.

Our rule is build the logic before the dashboard. Decide what counts as a qualified lead, which competitors sit on the market share list and how the lag is handled before anyone opens Looker Studio. A dashboard built first is just a nicer place to be wrong. The full method is in our attribution guide.

Market share earns its line because it is the one number on the page that can't flatter anyone. Leads can rise because the market grew. Sessions can rise because you published a glossary. Share against five named competitors only rises if you took clicks from them, and it will fall in a good year if they moved faster. That is probably why it is rarely on the page, and why it is worth asking for.

Which SEO KPIs matter for B2B, and which can you drop?

Five KPIs carry a B2B report, lines two to six of the template: organic sales-qualified leads, organic pipeline value, organic revenue closed with the lag stated, share of category clicks against named competitors, and cost per qualified lead compared with paid. Five numbers, monthly, from the CRM rather than the analytics account. Five other things are fine in an appendix and misleading at the top of the page.

Rankings tables. Positions move daily, vary by device and location, and a page can climb from 40 to 12 and produce nothing. A headline rankings table usually means the commercial numbers haven't been wired up yet, which is a gap rather than a verdict.

Sessions without leads. A thousand visitors to a glossary page is a thousand people who will probably never buy from you. Traffic on its own is the number we trust least, because it is the easiest one to grow without growing the business.

Domain authority scores. DA is a third-party estimate that Google doesn't use. Headlining it is reporting on the tool rather than the business.

"Content pieces" without URLs. Twelve pieces of content is an invoice line. Every piece should have a URL, a target query and, after three months, a position and a lead count against it.

"Link building" without placements. Same rule. Which domain, which page, and whether it is the sort of site you'd be glad to be seen on: that is the report.

One more that isn't a metric: paid search figures inside a "search" report without being separated from organic. The first sign of over-reliance on Google Ads is usually a report where paid is carrying the total and the organic line underneath has been flat for a year.

How do you read an SEO report when it lands?

Ask three questions, in the same order, every month. Your agency will learn to answer them before you ask.

1. What did the spend produce this month?

Leads and pipeline against cost. If the answer is "sessions were up 18%", ask again.

40% or more: The gap we regularly find between reported conversions and CRM-qualified leads on accounts we inherit, because form spam, job applicants and existing customers all count as conversions in GA4 and none of them count in a sales pipeline.

Source: Clear Click, from the B2B search accounts we have taken over.

2. What moved, and do we know why?

The number matters less than the explanation. There are a few things analytics won't tell us. A 20% drop in organic leads in August might be your agency, or it might be the whole category going quiet for the summer. So we put seasonality and the market factors we know about on the same page, so the MD isn't reading a bad month as a bad agency, or a good month as a good one.

3. What are you changing next month because of this?

A report that ends without a decision was a newsletter. Three actions, each tied to a line on the page: "cost per qualified lead is £210 against £160 on paid, so we're rebuilding the two commercial pages that carry 60% of organic leads". If the actions are the same as last month, ask what happened to last month's.

Do you need a dashboard or a monthly narrative?

Both, and they do different jobs. A dashboard answers "where are we today" for anyone who looks; the monthly narrative answers "what happened, why, and what next" for the person paying. One without the other either leaves the client doing the interpreting or leaves a broken form unnoticed for a month.

The shape we aim for came from a client who ran three in-person courses back to back, in three different cities, and wanted to know whether each one broke even. The temptation was three reports. We treated it as one campaign, segmented by location, set tiered goals for each city so the first milestone was "covers the venue" rather than "sells out", and pulled all three into one dashboard. The MD had a reading before each event, rather than a retrospective after it.

That is the shape every good report has: one view, segmented by whatever the business actually decides on, with goals set where a decision can be made this month. The first version was a spreadsheet fed by HubSpot exports, built in a week. Manual first, automate when the volume justifies it.

How should an SEO report reconcile to the invoice?

Line for line. If the invoice says content, technical and outreach, line eight of the report should show the content URLs, the technical changelog and the link placements for the same month, against the scope you signed.

The version we run: the contract states what a month contains, say four commercial pages, twelve technical hours and eight outreach placements at a named seniority. The report lists what actually shipped against each, and where it fell short, why and what carries over. Three documents that agree with each other: scope, invoice, report.

If you can't tell what the money buys, a reporting gap is usually much easier to fix than a performance one, so ask for the reconciliation before drawing conclusions about the work. What a one-line invoice looks like, and what to ask for instead, is in how to choose an SEO agency, and the same rules apply to the agency you already have.

What changes for B2B versus ecommerce reporting?

The revenue line and the lag. Everything else stays the same.

In ecommerce, revenue is on the page the same month: organic revenue, orders, average order value and revenue per session by category, with paid alongside for the cost per order comparison. The trap is brand. Strip branded searches out before you credit the agency with them, because the people typing your name were sent by your marketing as a whole. Realistically, 40% to 70% of "organic revenue" in the ecommerce accounts we see is brand.

In B2B, the revenue line lags by the length of your sales cycle, so pipeline created is the number you manage monthly and revenue is the number you check quarterly. Lead quality matters more than count, so the page shows sales-qualified leads rather than form fills, and names the pages those leads came from. That is the argument in SEO for B2B: it is a pipeline discipline, and the report should look like one.

What if your agency can't produce this?

Ask for it in writing, send the ten lines above, and give them a month. That is a fair timescale for a first version.

One thing worth checking first. Around half the time we're asked to build this report for a new client, the block sits in the client's CRM rather than at the agency: the source field is blank on 30% of records, sales are closing deals without moving them through stages, or the form tool never passed the landing page through. None of that is anyone's fault; it is what happens when a CRM set up for sales is asked to serve marketing too. So offer CRM access and a written definition of a qualified lead at the same time.

If the block turns out to be a blank source field in your CRM, that is a fix we can help with directly. See how we handle CRM revenue operations

It doesn't need to be expensive, and it is fixable. If what comes back after 30 days is still rankings and sessions, that is the next conversation, and a much easier one once the request has been made clearly.

Questions we get asked

What should an SEO report include?

Spend, qualified leads from the CRM, pipeline created, revenue closed with the lag noted, market share against named competitors and cost per qualified lead against paid, followed by what moved, what shipped and three next actions. Rankings and sessions go in an appendix behind it.

How often should an SEO agency report?

A one-page report and a call every month, and a quarterly review where the plan is re-scored against what happened. Weekly reporting on organic is noise, because the data moves too slowly to act on. Anything that breaks, a form or a tracking tag, should be flagged the day it happens rather than saved for the deck.

What are the most important SEO KPIs?

For B2B: organic sales-qualified leads, organic pipeline value, organic revenue closed with the sales-cycle lag stated, share of category clicks against named competitors, and cost per qualified lead compared with paid. Rankings for the 20 to 30 commercial terms that carry the pipeline are a useful diagnostic in the appendix, not a table of 400 keywords.

Is there a template for a monthly SEO report?

The ten lines in the first section of this piece are the template we use, and you are welcome to copy them. The order matters more than the formatting: cost first, then what it produced, then why, then what shipped, then what changes next.

Why does our SEO report show traffic up but leads flat?

Usually because the traffic is landing on informational pages that were never going to produce an enquiry, or because branded searches are being counted as organic growth. Occasionally it is tracking, with the form tool failing to pass the source through to the CRM. Ask for leads by landing page and the answer tends to be obvious within a month.

Where we fit

We build reporting for companies that want search judged on pipeline and revenue: the logic first, the CRM plumbing second, then a dashboard the MD reads in five minutes. That is our reporting dashboards service, part of our wider data and analytics work. For Edinburgh Whisky Academy, centralising customer data in one CRM cut manual admin by 40%, and that plumbing is what makes a report like this possible.

If your current report can't answer what the spend produced last month, send it to us and we'll tell you what's missing and what it would take to fill the gap. It is often less than you'd expect.