Here to LEARN? Check out The Blueprint Training

Learn SEO from the best

Let’s Go

STEAL OUR PROVEN

SEO BLUEPRINT


Video training series detailing how we took a client from 3k to 100k organic visits in 8 months.

SHOW ME!

How to Build Your Own SEO Report (Steal Our Reporting Template)

seo report template

Ryan Stewart

I have an unhealthy obsession with being considered the world's BEST internet marketer. I'm highly active on social media and love a good debate.

Every month, we send an “SEO report” to our clients.

We went through dozens of tools before we decided to build our own reporting template using Google Data Studio.

We used Data Studio for a 3 simple reasons:

 

Connection to Google properties

Built in pulls from all of the data sources you need to build a proper report. Simply build the visual dashboard for how you want it to look and pull through key data.

google-data-studio-seo-template

 

Connection to non-Google properties

You can export data from other tools in Google Sheets (i.e. keyword rank tracking, project management info, CRM data, etc) and push into Data Studio. In other words, you can pull data from everywhere and format it into a branded, automated SEO reporting template.

customizable-seo-report

 

It’s 100% free to use

You can read more about that here.

 

UPDATED!!! August, 2019

This post will walk you through the exact monthly reporting template we built, including:

  • The key data, KPIs and metrics to include in your SEO reports
  • Page by page run down of our custom built report
  • A link to download the report

NOTE:

If you aren’t familiar with Google Data Studio, watch this video from MeasureSchool to give you context.

GET THE REPORT

Watch me break down the report, step by step…

1. Summary page

Why include this page?

  • An intro page is a good way to summarize and communication key items in the campaign

reporting summary page

What’s measured on this page?

  • Major deliverables completed that reporting period
  • Open action items that require attention
  • Summary of increases (or decreases) in organic traffic
  • Upcoming meetings, tasks, etc

This is a great page to add data from your project management tool. Pull down data into Google Sheets and pull through your updated project plan.

More resources

GET THE REPORT

2. Organic traffic summary report

Why include this page?

  • A high-level traffic summary allows you to see organic traffic trends over time
  • Monthly and yearly comparison scorecards of organic traffic, bounce rate and time on page
  • Key organic landing pages from the reporting period

organic dashboard trends

What’s measured on this page?

  • Complete history of organic traffic trends
  • Organic sessions and pageviews during the reporting period, previous month and previous year
  • Organic page views during the reporting period, previous month and previous year
  • Organic average time on page and bounce rate
  • Top landing pages from organic traffic and their engagement metrics

More resources

GET THE REPORT

3. Organic traffic breakdown

Why include this page?

  • Get granular insights in regards to how organic traffic is engaging with your website
  • Deep dive into how mobile, tablet and desktop organic traffic differ
  • Understand the demographics of your SEO traffic

organic traffic engagements

What’s measured on this page?

  • A trend line of your organic traffic by device (mobile, desktop, tablet)
  • Organic traffic by location and device type
  • Organic traffic by age, sex and device type
  • Engagement rates like time on page, bounce rate and pages per session segmented by device type

More resources

  • N/A

GET THE REPORT

4. Organic landing pages

Why include this page?

  • Understand your best (and worst) pages as a result of your SEO efforts
  • See which landing pages are driving conversions and engaged visits

seo landing pages report

What’s measured on this page?

  • A list of all the entry pages from organic search along with their engagement rates
  • The CTR of your top landing pages in Google
  • A list of the landing pages driving the most sales or leads

More resources

  • N/A

GET THE REPORT

5. Channel comparison

Why include this page?

  • Get a head to head picture how organic search is performing against other channels

channel comparison breakdowns

What’s measured on this page?

  • Comparison of sessions, engagement metrics and conversions of organic search, referral traffic, direct traffic, social traffic, email, paid traffic and (other)

More resources

  • N/A

GET THE REPORT

6. eCommerce conversion and revenue analysis

Why include this page?

  • A deep dive into how organic traffic is impacting the sales on your website (if you’re managing an ecommerce site)
  • A head to head comparison of organic traffic vs non organic traffic and how they affect various aspects of your sales
  • Quickly understand metrics like average order value and revenue per page

organic revenue reporting

What’s measured on this page?

  • Overall ecommerce conversion rate (organic vs non organic traffic)
  • Overall eCommerce conversion rate (organic vs non organic traffic)
  • Revenue from organic search (this month, last month and last year)
  • Transactions (aka purchases) from organic search (this month, last month and last year)
  • Average order value (AOV) from organic search  (this month, last month and last year)
  • The top organic landing pages on your site by sessions and conversion rate (compared to the previous reporting period)

More resources:

GET THE REPORT

7. Organic revenue report

Why include this page?

  • Visualizations on how organic traffic is impacting your revenue
  • Key landing pages and device types affecting sales

revenue and purchases by devie

What’s measured on this page?

  • A chart with organic traffic to product revenue over time
  • Breakdown of organic revenue from mobile vs desktop
  • The top landing pages driving purchases, revenue per user and conversion rate

More resources:

GET THE REPORT

8. Organic revenue by demographic

Why include this page?

  • The breakdown of age, sex and location of your website’s customers from organic traffic

seo organic revenue reporting

What’s measured on this page?

  • Purchases from organic search by age
  • Revenue by location (Country)
  • Revenue by gender
  • Revenue by new vs returning users

More resources:

  • N/A

GET THE REPORT

9. Lead generation and conversion analysis

Why include this page?

  • If you run a lead generation website (or one whose conversions are based on goals, not Ecommerce sales), this page focuses specifically on goal conversions from organic search
  • Get a deep understanding of the pages that are driving the goal conversions on your website compared to non organic channels

organic leads dashboard

What’s measured on this page?

  • Goal conversion rate (organic traffic vs. non organic traffic)
  • Total number of goal conversions (organic traffic vs. non organic traffic)
  • Organic traffic plotted against organic conversions over a long trend period

More resources:

GET THE REPORT

10. Lead generation by entry page

Why include this page?

  • How the top entry pages are affecting your lead generation efforts

organic leads report

What’s measured on this page?

  • A big list of your organic landing pages segmented with data on goal completions, goal conversion rate, bounce rate, pages per session and avg time on page

More resources:

  • N/A

GET THE REPORT

11. Organic leads by demographic

Why include this page?

  • The breakdown of age, sex and location of your website’s leads from organic traffic

leads from seo dashboard

What’s measured on this page?

  • Leads from organic search by age
  • Leads by location (Country)
  • Leads by gender
  • Leads by new vs returning users

More resources:

  • N/A

GET THE REPORT

12. Local SEO reporting breakdown

Why include this page?

  • For businesses with a physical location (verified in Google My Business), this page gives you insights into performance in your local market
  • This page needs a local URL on your website to work (example 👉 https://webris.org/locations/boston-seo/)

local seo reporting

What’s measured on this page?

  • The trend of organic vs goal completions on your local landing page
  • Goal conversion rate for your local pages
  • A complete list of your local landing pages organic performance

More resources:

GET THE REPORT

13. Keyword visibility progression

Why include this page?

  • Tracking how keyword rankings in the top 3 positions have progressed since your SEO campaign started
  • Overall keyword ranking trends on position and impressions from Google Search Console

kw visibility report

What’s measured on this page?

  • The number of keywords in the top 3 positions this month, last month and campaign start
  • The average position of your website in Google over time
  • The number of impressions your website is receiving in Google over time

More resources:

GET THE REPORT

14. Keyword performance report

Why include this page?

  • The exact search queries (i.e. keywords) that are driving traffic to your website
  • How “non branded” queries are trending over time (aka commercial intent keywords)

keyword performance report

What’s measured on this page?

  • The search queries visitors are using to find your website
  • The rankings of top keywords across your website displayed as this month vs previous month vs campaign start
  • How traffic from “non branded” queries are trending over the life of your campaign

More resources:

  • N/A

GET THE REPORT

15. Links and content published

Why include this page?

  • Link building and content generation are a key part of SEO growth. We built in a custom page that displays how many links and pieces of content were published during that reporting period
  • This page is optional and since Data Studio is so easy to customize, you can alter based on how you report / build links and content

links and content report

What’s measured on this page?

  • Links landed this month
  • Links landed to date
  • Articles published this month
  • Articles published to date

GET THE REPORT

Wrapping it up

Did we miss anything? What else would like to see out of our reporting template?

GET THE REPORT

Want more traffic?

Find out how we can get your website performance.

Schedule Consult

Comments

  • Robert Rogers Says

    Awesome post, yet again – this report is SUPER helpful for my firm!

  • Denver Says

    Thank you for sharing superb informations. Your website is very cool. I’m impressed by the details that you have on this website.

  • Allan Says

    This is really fantastic. I am studying Data Studio as of now for my client. I have one question, do you have any guidelines or tutorials on how to track keyword rankings that auto update periodically using Data Studio? I really want to include that on the Data studio I am doing.

  • Johanna Says

    Great post, I am just wondering if this report comes with any support? If I download it and get stuck, will there be anyone to ask for assistance?

    Many thanks,

    • Hey Johanna,

      Yes, we offer email support for any issues you may encounter.

  • ariel Says

    Hi, you say that the template is free. but I couldn’t find any link to access to the template for free.
    Can you share the link, please?

    Thanks

  • Zee Says

    Hi, do you have a template that shows the URL’s or website’s mobile friendly, page speed on desktop and mobile?

  • ELi J Says

    Hey, nice breakdown of GDS. I like the KPIs mentioned and how you prepared the dashboard, but like the other comments mentioend- your title is 100% misleading in that there is no free report

  • Paul McCann Says

    Yeah im confused, the page title etc all says free report and steal our report, but actually its $99??

    Im happy to pay for quality templates and guides, but this feels a little disingenuous and clickbaity which sadly doesnt infer confidence in other products. Any chance you can explain why its referred to as free to clear up any confusion?

  • Leave a Comment

    Your email address will not be published. Required fields are marked *