SEO Analytics
BigQuery-driven performance dashboards for organic search, keyword positioning, office-location pages, and long-range historical trends.
Pages ranking in positions 1-20 where actual click-through rate is below
benchmark. Improving title tags, meta descriptions, and SERP features on
these pages could recover estimated monthly clicks without any ranking
change. Sorted by the size of that opportunity.
Total Potential Clicks / Month
-
Pages Below Benchmark
-
Median CTR Gap
-
Loading CTR opportunities...
Daily organic clicks and impressions for the last 90 days. Vertical
markers show milestone events (redesigns, BoFu launches, GBP changes)
so you can visually correlate interventions with performance movements.
Comparison window:
Loading comparison...
Daily Clicks & Impressions (90 days)
Loading site performance...
Comparison window:
Top queries — the actual search terms driving
clicks, sorted by clicks in the current window. Use Prior/Last/% to spot
seasonal trends (tax-season queries, end-of-year spikes, etc.) and
content that's building or losing momentum.
Loading top queries...
Top pages — page-level performance with prior-period
comparison. A green arrow on MoM Position means the page improved in the
rankings (lower position = better).
Loading keyword performance...
Performance of the six office-location pages (
/locations/*)
over the last 28 days. Use this to spot which markets are producing
search visibility vs. which need more local signal building.
Clicks by Office Location (28 days)
Loading location chart...
Loading location table...
Homepage (
/), practice-area pages
(/practice-areas/*) and location pages
(/locations/*) are the money-maker URLs. This tab tracks
them as a group so you can see conversion-driving pages improve or decline
against total organic.
Comparison window:
Loading summary cards...
Monthly Clicks by Page Type (last 12 months)
Loading trend chart...
Top Movers. Pages and queries with the biggest absolute
change in clicks vs the prior window. Gains in green, losses in red.
Uses the comparison window selected above.
Top Mover Pages
Loading top movers (pages)...
Top Mover Queries
Loading top movers (queries)...
Filter:
Loading page detail...
Queries routing to these pages (28 days). Which search
terms are putting impressions on the homepage, practice-area, and
location URLs. Use the filter pills above to narrow by bucket. Queries
with fewer than 5 impressions in the window are hidden.
Loading query detail...
A 90-day window smooths out weekly noise and surfaces trends that a 28-day
view can't see. Use this to validate which pages / queries are
sustaining traffic vs. spiking briefly, and to give recently-launched
content time to accumulate enough data to judge.
Loading 90-day summary...
Top queries (last 90 days). Filters out queries with fewer than 20 impressions in the window.
Loading top queries...
Top pages (last 90 days).
Loading top pages...
Homepage & BoFu per-page detail (last 90 days).
Same filter pills as the 28-day BoFu tab.
Filter:
Loading BoFu detail...
Long-range monthly performance stitched from historical exports
(
kylerobbinslaw.com era) into live daily BigQuery data.
Bars show imported monthly rollups; the solid line shows live data.
All milestone events (domain migration, redesigns, BoFu launches)
are annotated as vertical lines.
Monthly Organic Clicks (Historical + Live)
Loading historical view...