The Ultimate Free SEO & GEO Report Template

Instantly level up your SEO reporting with a customizable Looker Studio dashboard that is simple, focused, and built for a world with AI.

  • Set up in < 5 minutes

  • GA4 & GSC ready out-of-the-box

  • 100% customizable - zero paywall
Impressions Growth
LLM Logos

Wait, What's GEO?

GEO stands for Generative Engine Optimization, an emerging term for how to get your website mentioned by generative AI chatbots. It's also known as answer engine optimization (AEO), large language optimization (LLO), AI search, and ChatGPT SEO.

This Looker dashboard template -- like Search to Sale's Content Intelligence software -- helps optimize your site for both traditional search and generative AI.

Video Walkthrough

Get Started Now:
AUDIENCE

Who This Template is For

S2S Alt Icon Reviews

Agency Account Manager

Deliver clean, client-ready SEO reports that map content to ROI.

S2S Alt Icon AI

In-House Marketing Lead

One home for all SEO data & an answer when leadership asks "How's ChatGPT traffic doing?".

S2S Alt Icon Rocket

SaaS Growth Marketer

Connect organic performance directly to trial sign-ups or product conversions.

S2S Alt Icon Development

Freelance Copywriter

Show clients the measurable impact of your content—no spreadsheets.

Who It's Definitely Not For

Sophisticated SEO Agencies

You'll need our full-funnel Content-Intel suite (or your own custom dashboard).

Learn More

Websites with 50+ High-Value Pages

Complex libraries call for page-level monitoring & Al-driven optimisation.

Learn More

Specialised Functions

  • Local SEO
  • Technical SEO
  • Backlink Ops

(And yes, we do offer those as services.)

Learn More

Get Started Now:

What's Inside

chart

Organic Clicks Per Month

A month-to-month view of organic clicks from Google.

eye

Organic Impressions Per Month

A month-to-month view of organic impressions in Google search results.

store

Unbranded Search Focus

SEO is about getting traffic from people who are looking for your category, but not your brand.

map

Keyword Clusters

We provide instructions to score every keyword and cluster them using AI, and then the report measures Potential Traffic per cluster.

search

Highest-Potential Keywords

The provided template includes a formula that scores every keyword for its potential to drive traffic to your site.

credit-card

Find Poorly-Converting Pages

The report digs into Google Analytics and finds the pages that convert the worst so you can improve these and get more value from your content.

number-1

First Page Push

The template includes a report that identifies pages that are on the cusp of ranking well enough to get traffic and LLM citations. A little improvement to these goes a long way.

generative

Referral Traffic from LLMs

The final page of the dashboard uses Google Analytics to show which LLM chatbots send referral traffic to which pages on your site. Pretty cool. 😎

Step-by-Step Setup Guide

(Detailed version included in download.)

  1. Copy Google Sheet template
  2. Use Ahrefs/SEMrush + ChatGPT for keyword research (no APIs required)
  3. Import data to Google Sheet for calculations
  4. Copy Looker Studio template
  5. Connect Looker to your Google Sheet, Google Search Console, and Google Analytics
  6. Update a few filters and settings in the Looker dashboard
  7. Gain insights that'll help you increase traffic and sales from Google search and LLM chatbots!
SO YOU'RE KIND OF A BIG DEAL?

Need something more advanced?

Learn about Content Intel

Our full software does cool stuff like measure the impact of keywords on conversion:

2.1 Keywords Driving Conversion

Get Started Now:

🤓 Advanced Tips & Customization

Ideas for where to go next once you set up the free template:

  • Download the Looker dashboard as a PDF, give it to AI, and give it this prompt: “Look at this report and give me suggestions about 1) what to report to my [client/boss/CMO/CEO] and 2) what content projects to focus on next.”
  • Work in DTC eCommerce? Copy report 3.1 and make a version that filters on just your product detail pages and their add-to-cart conversions.
  • Need local SEO insights? Copy report 1.1, 1.2, or 2.2 and make a version that filters just local searches.
FAQ

Frequently asked questions:

What is the best SEO report template?

The best SEO report template is one that 1) is simple to set up, 2) connects to live data, 3) offers actionable insights, 4) applies to a variety of websites, and 5) helps you get cited by LLMs. We think ours achieves all these!

How do I create an SEO dashboard in Looker Studio?

Looker Studio is a simple, free tool that can connect to many data sources. For SEO reporting you'll need to connect it to Google Search Console and Google Analytics. And to include national or global search volume data (beyond your site's current ranked keywords) you'll want to stage data from Ahrefs/Semrush in a Google Sheet. Our template helps you do all this!

What should an SEO audit report include?

An SEO audit report should include 1) how well your site ranks for the most relevant keywords, 2) which keywords drive traffic, and 3) how well your ranked pages engage, convert, or drive sales.

Is this report suitable for local SEO?

The template we built doesn't have anything that's focused on local SEO, but you can create a version of reports 1.1, 1.2, and/or 2.2 and add a filter for just local search terms.

Can I use this for monthly SEO reporting?

Yes! The template includes instructions for setting up an automatic monthly email delivery of the entire dashboard.