Free template

SEO report template

A free, ready-made SEO report built from a Google Search Console export: clicks, impressions, CTR and non-brand clicks, by month, query and page. Copy the template into Mammoth, upload your export, and get the same report on your own site.

Use this with my Search Console Book a demo

14-day Pro trial · No credit card · Viewers are always free

The template: paste this into Mammoth

SEO report from Google Search Console: clicks, impressions, CTR, non-brand clicks, queries and pages as KPIs, clicks and impressions by month, clicks by query, and clicks by page

The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

In production at

What is an SEO report template?

An SEO report template is a ready-made report for your search performance, with the numbers and charts already chosen. This one reads a Google Search Console export: upload it and it fills in with clicks, impressions, click-through rate and non-brand clicks, by month, query and page. It shows how much traffic search brings and which searches and pages bring it.

What's on it

What's in the SEO report template

Six numbers at the top and three charts below them.

Six numbers at the top

Clicks: Clicks from Google Search to your site.
Impressions: How often your pages appeared in results.
CTR: Clicks ÷ impressions.
Non-brand clicks: Clicks from searches that do not include your brand name.
Queries: How many different searches you got clicks or impressions from.
Pages: How many of your pages appeared in results.

Clicks and impressions by month

Clicks as bars and impressions as a line, one point a month.

Clicks by query

The searches that brought the most clicks, highest first.

Clicks by page

The pages that got the most clicks, highest first.

How it works

How to use this SEO report template

Step 1
Start with the template
Sign up and the SEO report opens on sample data, so you can see it before you connect anything.
Step 2
Sign in with Search Console
One sign-in. Your data arrives as one tidy table, the dashboard moves onto it, and it refreshes every day.
Step 3
Share or schedule it
Share a link, or have it emailed every week. Viewers are free.

Compare

SEO report templates compared

This template in Mammoth, Search Console's own report, and a Data Studio template. Data Studio is Google's free report builder, called Looker Studio until recently.

Mammoth template

For an SEO report next to your sales, ads or CRM data, sent to clients or your team.

✓Ready-made template
~FreeFree plan for uploaded files
✕Connects to Search Console directly
✓Revenue or CRM data in the same report
✓Change it by asking in plain words

Search Console

For checking queries and pages inside Google.

~Ready-made templateStandard performance report
✓Free
✓Connects to Search Console directly
✕Revenue or CRM data in the same report
✕Change it by asking in plain words

Data Studio template

For a free report when most of your data is Google's.

✓Ready-made template
✓Free
✓Connects to Search Console directly
~Revenue or CRM data in the same reportNeeds a partner connector for most sources
✕Change it by asking in plain words

SEO report template questions

What should an SEO report include?

Clicks, impressions, click-through rate and non-brand clicks at the top, then clicks and impressions by month, and the queries and pages that bring the most clicks. Add average position or clicks by country when you need to find out why a number moved.

How do I export data from Search Console?

Open the Performance report, set the date range, and choose Export, then Download CSV. For this template, export by date, query and page so each row has all three.

How do I use this SEO report template?

Sign up with this template and it opens on sample data. Sign in with Search Console and it moves onto your own data, or upload a Search Console performance export as a CSV or Excel file instead.

Is the template free?

Yes. The template is free to copy, and building it from an uploaded Search Console performance export works on Mammoth's free plan.

Can I change the template?

Yes. Ask for the change in plain words, such as "add clicks by device" or "show last month only", and Mammoth updates the dashboard.

Can Mammoth connect to Search Console directly?

Yes. Sign in with Search Console from the template and the dashboard reads your account directly and refreshes every day. An uploaded Search Console performance export works too.

Can I combine Search Console with other sources?

Yes. Upload the Search Console performance export and connect GA4, an ad account or a CRM alongside it, join them in Mammoth, and build one dashboard across all of them.

Can I share it with clients?

Yes. Share a link or have it emailed on a schedule, and viewers are free on every plan. On the Mammoth Pro plan you can put your own logo and domain on it.

Is the data on this page real?

No. It is sample data for an invented brand, in the same columns a Search Console performance export uses. The dashboard itself is real: it was built in Mammoth, and you can open it live.