Trusted by 1,600+ marketing teams and agencies
What you can do with this monthly SEO report
Five jobs this report does. Click one to see its view on demo data, then paste its prompt into the same Claude chat.
Report the period in one table
Search Console and GA4 KPIs side by side against the previous period, so a client sees the whole picture in one place.
- Did clicks and organic sessions grow?
- Did more visits turn into key events?
Show clicks, impressions, CTR and average position from Search Console and organic sessions, engagement rate and key events from GA4 for the last 7 days against the 7 days before.Also built for this: Client SEO dashboard template
Check whether clicks grew day by day
Daily clicks this week against last week, so you see whether growth held or came from one good day.
- Did clicks grow every day or just once?
- Which day did the change start?
Chart daily Search Console clicks for the last 7 days against the same weekdays the week before.Also built for this: Google Search Console dashboard template
See if organic visits followed the clicks
Daily GA4 organic sessions this week against last, so you know whether more clicks became more visits.
- Did organic sessions follow clicks?
- Is there a gap worth checking?
Chart daily GA4 sessions where Session default channel group is Organic Search, last 7 days against the 7 days before.Also built for this: GA4 SEO dashboard template
Find the queries that moved most
The queries with the biggest change in clicks, so you know what to mention first in the report.
- Which queries gained or lost the most clicks?
- Did their position change too?
List the 10 queries with the biggest change in clicks, last 7 days against the 7 days before, with impressions and position change.Also built for this: Keyword ranking dashboard template
Find the pages that moved most
The pages with the biggest change in clicks, so you can show what your work moved.
- Which pages gained or lost the most clicks?
- Is one page behind most of the change?
List the 10 pages with the biggest change in clicks, last 7 days against the 7 days before, with impressions and position change.Also built for this: SEO dashboard template
How to set up the monthly SEO report in Claude
You need a Search Console and a GA4 property your Google account can open, a free Porter account and Claude Pro, Max, Team or Enterprise for Claude Dashboards. The whole setup takes about 10 minutes.
Connect Search Console and GA4 in Porter
Sign up free at Porter, open Data sources, connect Google Search Console and Google Analytics 4 and choose your property in each. The Search Console to Claude tutorial and the GA4 to Claude tutorial show each click.
Pick the Search Console sites Claude can read, then save. Add Porter to Claude
In Claude, go to Customize → Connectors → Add custom connector, paste https://mcp.portermetrics.com/mcp and name it Porter Metrics. Click Continue, then sign in to Porter and allow access.
In Claude: Customize, Connectors, Add custom connector, then paste Porter’s MCP URL Paste the install prompt
Open a new chat in Claude, paste this prompt and replace the site in brackets. Claude reads both sources through Porter and builds the report.
Install promptDuplicate this Claude dashboard template and keep its layout, views and styling: https://claude.ai/artifact/CjhoaBnW4JxxbUVjaETKmB Then rebuild it with my own data through Porter: an SEO progress report for [site] for the last 14 days: the last 7 days vs the 7 days before for Search Console clicks, impressions, CTR and average position and GA4 organic sessions, engagement rate and key events, daily clicks and organic sessions this week vs last, and the queries and pages that moved most.
Open in Claude with this prompt 
The first thing Claude builds: the KPI table for your own site. Demo data shown.
Build a Google Search Console dashboard with Claude
Monthly SEO report fields and data
The report joins Search Console’s Performance data with GA4 sessions from the Organic Search channel. Porter reads 27 Search Console fields and 285 GA4 fields if you need more.
Top 5 monthly SEO KPIs to watch
Trailgear demo data · last 7 days vs the 7 before
- Clicks18,209+6.0%
Lead the report with this, then show the queries and pages that moved it.
- Organic sessions21,619+3.9%
Clicks that turned into visits. A gap between the two is worth a question.
- Key events702+12.5%
Visits that did something: the number a client cares about most.
- CTR2.46%vs 2.48%
A small dip while impressions grow usually means you showed up for new, broader queries.
- Average Position14.30.6 better
Watch the direction across several reports, not one week.
How the numbers are calculated
- Change
- (This period − previous period) ÷ previous period. Position change shows as “better” when the number drops.
- Organic sessions
- GA4 sessions where Session default channel group is Organic Search.
- Engagement rate
- Engaged sessions ÷ sessions, Organic Search only.
- CTR
- Clicks ÷ impressions.
- Average position
- Google’s average top position for your pages, weighted by impressions. Lower is better.
Data sources
Metrics
Clicks- Impressions
- CTR
- Average Position
Sessions- Engagement rate
- Key events
Dimensions
- Date
- Query
- Page URL
- Session default channel group
- Landing page + query string
See all fields:Google Search Console · 27 fieldsGoogle Analytics 4 · 285 fields
What makes this monthly SEO report different
What you get that Search Console and GA4 exports pasted into slides can’t give you.
Skip the monthly copy-paste
A refresh updates Search Console and GA4 numbers together, so nobody rebuilds the slides.
Change the period in one sentence
Ask for the last 28 days or the same month last year; paid plans read the full history.
Answer the client’s follow-up on the spot
Ask Claude why a page dropped and get the numbers behind it in the same chat.
Send it on your logo
Publish it as a Porter dashboard to add your logo and email it on a set day.
Report every site the same way
Run the same prompt for each client so every report has one layout.
Share a link instead of a file
Clients open the published dashboard in their browser, without a Claude account.
What the report includes
- A KPI table with Search Console and GA4 metrics against the previous period
- Daily clicks and organic sessions, this week against last
- The queries and pages that moved most
- Share by link, PDF and scheduled email once published in Porter
Related dashboard templates
ClaudeClient SEO dashboard template
Report clicks, sessions and key events against each client’s goals.
ClaudeSEO dashboard template
See which Search Console clicks turn into GA4 sessions and key events.
ClaudeKeyword ranking dashboard template
Track which keywords reach page one and what moved this week.
ClaudeGA4 SEO dashboard template
See which landing pages bring organic sessions and key events.Browse more Claude dashboard templates
Data Studio
Google Sheets
ChatGPTGet your free monthly SEO report
Sign up free, connect Search Console and GA4 and paste the prompt. Your own data fills the same layout as the demo.
Free plan · 14-day trial · No card needed