Skip to content
Join the waitlist

Free tool

Agency SEO Report Template A client report that leads with revenue, under your brand.

Enter your agency, your client, the month and a currency, and pick an accent. The preview follows as you type. The report keeps Known, Influenced and Modeled revenue on separate rows, never adds them together, and shows which changes were verified. Open the PDF sample with no sign-up, or get the editable Excel file for your email.

  • Made in your browser
  • Email for the editable file
  • PDF sample, no sign-up

Customise the report template

How it works

  1. Make it yoursYour agency, the client, the month, a currency and an accent. Example values fill the figures so the report reads finished.
  2. Check the previewThe report beside the fields follows every change. A PDF sample opens with no sign-up.
  3. Take the fileLeave your email for the editable Excel file. It is made in your browser with your choices and is never emailed.
Agency SEO Report Template

Make it yours

Accent

Fills the figures with invented ones so the report reads finished. Switch off for empty cells you fill with your client’s own.

Get the editable file

An Excel workbook with seven sheets, set up with your choices. It is made in your browser and is never emailed.

Get the editable file

We add this email to the waitlist and use it only to tell you about early access, as our Privacy Policy describes. Every email has a link to leave the list.

The editable file is made in your browser, so this step needs JavaScript. The PDF sample opens without it.

The file ends with one credit line. You can delete it.

Report Preview

Example
Open the PDF sample

Example: invented figures for an invented client, not anybody’s results. Replace them with your client’s own. A fixed sample with example values. No sign-up.

Monthly SEO Report

Your Agency

Client NameMonth Year

ExampleExample values. Replace the figures below with your client's own.

Summary

What Search Earned

Organic search earned more Known revenue than last month, led by the category pages. The Modeled figure is an estimate, not a result.

What Changed

Four changes are listed on the Work and Results sheet. One is Verified, with a lift above its baseline; one had no effect.

What's Next

Refresh the pages that lost clicks and extend the guides that earned the most.

Revenue

Known, Influenced and Modeled revenue are different kinds. They are never added together, so there is no total.

  • Known

    Measured directly and stored as the source reported it, with nothing estimated.

    This Period

    $48,200

    Previous Period $41,900Change +$6,300

    How You Measured It. Orders from organic search visits in the store reports

  • Influenced

    Measured, but organic search was only one of the things that led to it.

    This Period

    $12,600

    Previous Period $11,800Change +$800

    How You Measured It. Orders where organic search was one of several visits

  • Modeled

    An estimate worked out from other figures, not a measurement; its inputs are named.

    This Period

    $9,400

    Previous Period $8,100Change +$1,300

    How You Measured It. Estimate from assisted conversions × average order value

Search

Clicks
18,400
Previous Period 16,900
Change +1,500
Impressions
612,000
Previous Period 590,000
Change +22,000
CTR
3.0%
Previous Period 2.9%
Change +0.1 pts
Average Position
8.4
Previous Period 9.1
Change −0.7

Pages

Top 10 Pages
  • /category/espresso-machines/2,410+220
  • /guides/choose-a-grinder/1,980+220
  • /category/grinders/1,620+80
  • /guides/grind-size-chart/1,310+140
  • /category/milk-jugs/980+40
  • /blog/home-coffee-corner/870+80
  • /category/scales/760+40
  • /guides/descale-a-machine/640+60
  • /category/kettles/590−20
  • /blog/dial-in-espresso/540+70
Pages Losing Clicks

  • /blog/coffee-trends/410 to 220

    Impressions down, position about the same

  • /category/filters/480 to 310

    Position fell by about two places

  • /blog/bean-storage/260 to 150

    CTR down at a similar position

Work and Results

Incremental: Verified changes only

  • Merged two overlapping grinder guides

    /guides/choose-a-grinder/ Week 1

    VerifiedIncremental$2,400 to $4,000

  • Rewrote the titles of the category pages

    /category/ Week 2

    Being Measured

  • Added product structured data

    /category/espresso-machines/ Week 3

    Shipped

  • Refreshed an old comparison page

    /blog/coffee-trends/ Week 1

    No Effect

Next Month

  • Refresh the pages that lost clicks

    /blog/coffee-trends/

    Modeled$800 to $2,400

    Inputs Behind the Estimate. Past lift on refreshed pages

  • New guide on milk steaming

    /guides/

    Modeled$1,200 to $3,600

    Inputs Behind the Estimate. Search volume and an average conversion rate

Definitions

Known
Measured directly and stored as the source reported it, with nothing estimated.
Influenced
Measured, but organic search was only one of the things that led to it.
Modeled
An estimate worked out from other figures, not a measurement; its inputs are named.
Incremental
The lift above the baseline after a change that was verified.
Template version 1.0Made with the free template at queryrev.com

What a revenue-first report is

A revenue-first SEO report opens with what organic search earned for the client, then uses clicks, impressions and positions to explain it. It ends with the work that was done and whether it was verified. The order tells the client what mattered before it shows how it was measured.

The template fixes that order. Revenue comes first, as three separate rows. Search Console figures follow, then the pages, the work and its results, and next month. For what each section holds and how to word it, read the guide to an SEO report template.

Three kinds of revenue, never added

The Revenue sheet has one row for each kind, with its meaning beside it and a column for how you measured it. There is no total row.

Known
Measured directly and stored as the source reported it, with nothing estimated.
Influenced
Measured, but organic search was only one of the things that led to it.
Modeled
An estimate worked out from other figures, not a measurement; its inputs are named.

Adding the three would count a measured order and an estimate as the same thing. Keeping them apart lets the client see how much of the story is measured. How revenue gets its label is the subject of organic revenue attribution.

Verified changes, and nothing else

The Work and Results sheet lists each change with a status: Shipped, Being Measured, Verified or No Effect. A change that was published is not an outcome. The two Incremental Revenue columns, Low and High, are for Verified changes only, and a check beside them says so when either is filled for any other status.

The template does not decide that a change is Verified. You do, once you have compared the result with a baseline. Say how you measured it, and name the inputs behind any estimate in the Next Month sheet.

How to use the file

  1. Fill the shaded cells. Everything else is set up. Search figures come from Search Console, revenue from your client’s own store or analytics reports.

  2. Find pages losing clicks. The Pages sheet points to the free Content Decay Finder, which reads a Search Console export in your browser.

  3. Make it yours. The workbook is plain Excel, so it opens in Excel, Numbers and Google Sheets. Put your logo in the Report sheet. The last line of the Definitions sheet reads “Made with the free template at queryrev.com”; delete it if you like.

In the QueryRev App

The template is filled in by hand once a month. The app builds the report from connected data and goes on to the proof.

  • In the App

    Monthly Automated Client Reports

    Each client’s report is built every month from their connected search, analytics and revenue data, under your brand.

    See QueryRev for Agencies

  • In the App

    Revenue Attached

    Known, influenced and modeled revenue arrive with their labels, from the client’s own sources, and are never added together.

    See Revenue Intelligence

  • In the App

    Verification

    Each change is checked against a baseline after it ships, and counts as incremental only once it is verified.

    See Verification

Join the waitlist

Early access opens in stages.

Keep exploring

Early access

Be first to see what your SEO really earns.

Early access opens in stages. For in-house teams and agencies: leave your work email, we write when your place comes up, and nothing is charged.

optional

optional

You workoptional

We use these details only to tell you about early access, as our Privacy Policy describes. Every email has a link to leave the list.

Next: confirm your email with the link we send. We write when your place comes up, and nothing is charged.