Trusted by 1,600+ marketing teams and agencies
What you can do with this keyword ranking report
Six jobs this report does. Click one to see its view on demo data, then paste its prompt into the same Claude chat.
Count your keywords on page one
How many queries sit in positions 1–3, 4–10 and 11–20, so you see progress without checking keywords one by one.
- How many keywords are on page one?
- Did more move into the top 3?
Count my queries in positions 1–3, 4–10 and 11–20 for the last 7 days against the 7 days before.Also built for this: Client SEO dashboard template
Track your average position over time
Average position per day against the previous period, so you spot a slide early.
- Is my average position improving?
- When did it change?
Chart my average position per day for the last 7 days against the 7 days before. Lower is better.Also built for this: Monthly SEO dashboard template
See every top query with its ranking page
Your top 100 queries with the page that ranks for each, so you know which page to work on.
- Which page ranks for each keyword?
- Which keywords sit just off page one?
List my top 100 queries by clicks with the ranking page, average position, position change, clicks and impressions.Also built for this: Google Search Console dashboard template
Find the keywords that climbed
Queries whose position improved most, so you can see what your changes moved.
- Which keywords moved up most?
- Did the climb bring clicks?
List the 10 queries whose average position improved most, last 7 days against the 7 days before, with clicks for each.Also built for this: SEO dashboard template
Catch the keywords that dropped
Queries whose position fell most, so you can check the page before clicks fall too.
- Which keywords lost the most positions?
- Which pages rank for them?
List the 10 queries whose average position dropped most, last 7 days against the 7 days before, with the ranking page and clicks.Also built for this: Client SEO dashboard template
Compare rankings on mobile and desktop
Position and clicks by device, so you know whether mobile ranks worse than desktop.
- Do I rank lower on mobile?
- Where do most clicks come from?
Show average position, clicks and impressions by device for the last 7 days against the 7 days before.Also built for this: Google Search Console dashboard template
How to set up the keyword ranking report in Claude
You need a Search Console 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 8 minutes.
Connect Google Search Console in Porter
Sign up free at Porter, open Data sources, pick Google Search Console and choose your property. The Search Console to Claude tutorial shows 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 with your property. Claude queries Search Console through Porter and builds the dashboard.
Install promptDuplicate this Claude dashboard template and keep its layout, views and styling: https://claude.ai/artifact/PEG2vBKJ72nnCmnUTKGrSJ Then rebuild it with my own data through Porter: a keyword ranking report for [site] from Search Console for the last 14 days: average position, clicks and impressions for my top 100 queries, each query's ranking page, how many queries sit in positions 1–3, 4–10 and 11–20, and the biggest gainers and losers, last 7 days vs the 7 days before.
Open in Claude with this prompt 
The first thing Claude builds: position and page-one KPI cards for your own site. Demo data shown.
Build a Google Search Console dashboard with Claude
Keyword ranking report fields and data
Every position comes from Search Console’s Performance report, not a rank tracker, so it reflects real searches. Porter reads 27 Search Console fields.
Top 5 keyword ranking KPIs to watch
Trailgear demo data · last 14 days vs the 14 before
- Average Position14.61.2 better
Watch the direction, not one day. A falling number means your pages are moving up.
- Queries in positions 1–313of top 100
Where most clicks go. Losing a keyword here costs more than anywhere else.
- Queries in positions 4–1042+3
On page one but lower down. A better title can lift these fastest.
- Queries in positions 11–2045+3
Just off page one. A content fix can push these onto it.
- Clicks35,388+9.6%
The check on every ranking change: did moving up bring more visits?
How the numbers are calculated
- Average position
- Google’s average top position for your pages, weighted by impressions. Lower is better.
- Position buckets
- Queries counted by their average position for the period: 1–3, 4–10 or 11–20.
- Position change
- Previous position − current position, shown as “better” when the number drops.
- Top 100 queries
- Your 100 queries with the most clicks in the period.
- Gainers and losers
- The queries with the biggest position change against the previous period.
Data sources
Metrics
Average Position- Clicks
- Impressions
Dimensions
- Date
- Query
- Page URL
- Device
See all fields:Google Search Console · 27 fields
What makes this keyword ranking report different
What you get that a rank tracker or a Search Console export can’t give you.
See positions from real searches
Positions come from Search Console, so they reflect what people actually saw, not one simulated search.
Track every keyword you rank for
No keyword list to set up or pay for: the top 100 queries come from your own data.
Ask why a keyword moved
Ask Claude which page ranks for it and how its clicks changed, in the same chat.
Compare any two periods
The last 7 days against the 7 before, last month or the weeks around an update.
Send it on your logo
Publish it as a Porter dashboard and email it to a client on a set day.
Skip the CSV downloads
A refresh pulls the latest days Google has published.
What the report includes
- KPI cards for average position, clicks, impressions and queries in positions 1–3, 4–10 and 11–20
- A daily average position trend
- Top 100 queries with their ranking page
- Biggest gainers and losers
- Position and clicks by device
- Share by link, PDF and scheduled email once published in Porter
Related dashboard templates
ClaudeGoogle Search Console dashboard template
Find queries close to page one and fix low CTR by page and device.
Claude
SEO dashboard template
See which Search Console clicks turn into GA4 sessions and key events.
ClaudeMonthly SEO dashboard template
Show month-on-month SEO results and the pages that moved them.
ClaudeClient SEO dashboard template
Report clicks, sessions and key events against each client’s goals.Browse more Claude dashboard templates
Data Studio
Google Sheets
ChatGPTGet your free keyword ranking report
Sign up free, connect Search Console and paste the prompt. Your own data fills the same layout as the demo.
Free plan · 14-day trial · No card needed