How to Automate Your Monthly SEO Report in Google Looker Studio

By Emily Redmond, Data Analyst at Emilytics · April 2026

TL;DR: Use Looker Studio to blend GA4 and Google Search Console data. Build a report template, set up monthly email scheduling, and spend zero minutes on manual reporting.

Why Automate Your SEO Report

Manual SEO reporting is a grind. You copy data from Search Console, paste it into a sheet, calculate percentage changes by hand, and write narrative around it. Then next month, you do it all over again.

Automation cuts this to zero minutes of busywork. You spend time on actual analysis and insight, not data formatting.

An automated report also ensures consistency: same metrics, same format, same send date every month. Your team knows what to expect.

What You'll Build

A monthly SEO report that:

• Pulls organic traffic from GA4
• Pulls clicks, impressions, and CTR from Google Search Console
• Calculates month-over-month change automatically
• Highlights top-performing keywords and pages
• Emails to your team on the 1st of each month
• Requires zero manual work after setup

Step 1: Connect Your Data Sources

Connect GA4

1. Go to looker.google.com
2. Click "Create" > "Data Source"
3. Choose "Google Analytics 4"
4. Select your GA4 property
5. Click "Create"

Name it "GA4 - [Your Site]" for clarity.

Connect Google Search Console

1. Click "Create" > "Data Source" again
2. Choose "Google Search Console"
3. Select your Search Console property
4. Click "Create"

Name it "Search Console - [Your Site]".

Step 2: Create Your SEO Report Template

Create a New Report

1. Click "Create" > "Report"
2. Name it "Monthly SEO Report - [Your Site]"
3. Add your GA4 data source

Build the Report Structure

Section 1: Key Metrics (Top of Page)

Add a table with these columns:

• Metric
• This Month
• Last Month
• Change
• Status

Add four rows:

• Organic Traffic
• Conversion Rate
• Clicks (from Search Console)
• Average Position (from Search Console)

Use Looker Studio's scorecard charts for these—they're easy to scan and show comparison automatically.

Section 2: Organic Traffic Trend

1. Click "Insert Chart" > "Time Series"
2. Metric: "Sessions" (filtered to organic traffic only)
3. Dimension: "Date"
4. Date range: "Last 90 days"

This shows momentum. Is organic traffic increasing or decreasing?

Section 3: Top Landing Pages

1. Click "Insert Chart" > "Table"
2. Dimensions: "Page Title" or "Page Path"
3. Metrics: "Users," "Conversion Rate," "Goal Completions"
4. Sort by: "Users" (descending)
5. Limit: 10 rows

This shows which pages drive the most traffic and conversions.

Section 4: Top Keywords (Search Console)

1. Click "Insert Chart" > "Table"
2. Data source: Search Console
3. Dimensions: "Query"
4. Metrics: "Clicks," "Impressions," "Average Position"
5. Sort by: "Clicks" (descending)
6. Limit: 15 rows

This is the heart of the SEO report. Which keywords drive clicks? Are positions improving?

Section 5: Conversion Opportunity

1. Create a table showing:
   • Queries with high impressions (>100) but low CTR (<2%)
   • These are ranking opportunities: you're visible but not clickable

Use a filter: "Average Position" < 10 AND "Average Click Through Rate" < 2%

Step 3: Add Month-over-Month Comparison

To show comparison automatically:

1. Add a date-range filter at the top of the report
2. Create two comparison cards:
   • This month: Use "Last Month" date range
   • Last month: Use "2 Months Ago" date range
3. Looker Studio calculates the percentage change automatically

Example setup:

• Metric: Organic Sessions
• Date range: "Last 30 days" vs. "30–60 days ago"
• Looker Studio will show: "5,240 (↑ 18%)"

Step 4: Add Narrative Context

Looker Studio dashboards are visual, not narrative. Add context manually each month:

1. Insert a text box at the top of the report
2. Write 3–4 bullet points:
   • Headline: What's the main story? (e.g., "Organic traffic up 18%, driven by new blog content strategy")
   • Context: What caused the change? (e.g., "Published 8 new guides, 3 ranked within first week")
   • Opportunity: What's next? (e.g., "Targeting 20 high-impression, low-CTR keywords with title/meta optimization")
   • Risk: What to watch? (e.g., "Average position slipped on core branded keyword—competitor outranking us")

Update this text box each month with new insights.

💡 Emily's take: I see a lot of teams build beautiful dashboards and then never touch the narrative. A dashboard without narrative is just numbers. The narrative is what makes it actionable. Yes, you have to update it manually. Yes, it's worth it. A 30-second update once a month beats a 2-hour manual report.

Step 5: Set Up Email Scheduling

1. Click the three-dot menu (top right)
2. Select "Schedule"
3. Set frequency: "Monthly" on the 1st of each month
4. Set time: 8:00 AM (when your team reads email)
5. Add recipients (your team, leadership, etc.)
6. Choose format: "Attached PDF" (easier to file) or "Link to interactive report" (allows exploration)
7. Click "Create"

Step 6: Optional—Add a Page-Level Deep Dive

If you want more detail, create a second page in the same report:

1. Click "Page 1" at the bottom
2. Add "New Page"
3. Name it "Page-Level Analysis"
4. Add a table with:
   • Page title
   • Sessions
   • Conversion rate
   • Goal completions
   • Revenue (if you track it in GA4)

Filter by traffic source: "Organic Search" only.

This becomes your deep-dive section for teams that want to debug performance.

Template: What Your Report Should Look Like

Page 1: Monthly Overview

Section: Key Metrics (scorecard table) Section: Narrative text box (3–4 bullet points) Section: Organic traffic trend (time series chart, last 90 days) Section: Top keywords (table from Search Console) Section: Top landing pages (table from GA4)

Page 2: Detailed Analysis (Optional)

Section: Page-level breakdown Section: Keyword opportunity list (high impressions, low CTR) Section: Conversion funnel (landing page > form > goal)

Common Issues and Fixes

Issue 1: Search Console data isn't showing.

Make sure you're connected to the right Search Console property. Search Console requires you to be logged in with an account that has access to the property. Also, Search Console has a 3-day data lag, so if you're pulling today's data, it won't be there.

Issue 2: Organic traffic filter isn't working.

In GA4, use the filter: "Session Default Channel Group" = "Organic Search." Not "Organic Traffic." The naming is confusing, but that's the right field.

Issue 3: Month-over-month comparison is showing the wrong dates.

Make sure you're using "Last Month" and "2 Months Ago" date ranges, not specific calendar dates. Looker Studio's relative date ranges update automatically.

Issue 4: The report is too slow to load.

You're probably pulling too much data. Reduce the number of rows in your tables (instead of 100 top keywords, use 15). Limit the date range where possible. Use filters to narrow the dataset.

Frequently Asked Questions

Q: Should I schedule this for the 1st of the month or the 5th?

A: The 5th is better. GA4 data has a 24–48 hour latency, and Search Console has a 3-day latency. By the 5th, you have complete data for the previous month. Scheduling for the 1st will give you incomplete data.

Q: Can I automate the narrative commentary?

A: Not directly in Looker Studio. But you can use Emilytics or similar AI tools to generate insights automatically. Otherwise, block 15 minutes each month to update the text box with key findings.

Q: How do I know if my SEO report is actually useful?

A: Ask: "Did we change anything based on this report?" If the answer is no, the report isn't useful. Redesign it to highlight actionable insights (opportunities to improve keywords, ranking gaps, traffic sources).

Q: Should I include Search Console data or just GA4?

A: Include both. GA4 shows traffic and behavior. Search Console shows visibility and opportunity. Together, they tell the full story.

Q: Can I add paid search or other channels to this report?

A: Yes. Add filters to include or exclude channels. But I'd recommend keeping the SEO report focused on organic. If you want a multi-channel report, create a separate one.

The Bottom Line

Set this up once. Run it for a month. Then never touch it again (except to update the narrative commentary).

The time saved per year: 20+ hours. The quality gained: consistent, comparable month-to-month data that makes trends obvious.

For more on setting up GA4 connections, check out our GA4 to Looker Studio guide. For deeper analysis, see how to write analytics insights.

Emily Redmond is a data analyst at Emilytics — AI analytics agent watching your GA4, Search Console, and Bing data around the clock. 8 years experience. Say hi →