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 template 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
Export from Search Console
Export your data from Search Console as a CSV or Excel file and upload it to Mammoth.
Step 2
Paste the template
Copy the sentence at the top of this page into Mammoth. It builds the same dashboard from your data.
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?

Export your data from Search Console as a CSV or Excel file and upload it to Mammoth. Then paste the template sentence from the top of this page. Mammoth builds the same numbers and charts from your data.

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?

Not with a ready-made connector, so this template reads an export. Upload a new Search Console performance export when you want the numbers brought up to date.

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.