SEO & Local Performance Dashboard
Data Period
Last 90 Days
Load Your Data
Pull live data from connected sources or upload export files manually.
▶
Or upload files manually (fallback)
Data Sources: GSC provides search queries, pages, clicks, impressions, CTR, and position data. GA4 provides landing page sessions, engagement, and bounce rates. GBP provides local visibility metrics by office location. SEMrush provides keyword rankings by city. All data from uploaded files — no numbers fabricated.
▶
How to Export Data for This Dashboard (4 sources)
Click to expand
Daily Search Performance
Clicks and impressions over time from Google Search Console
SOURCE: GSC "Chart" sheet. Each point = one day. Clicks = users who clicked through to your site. Impressions = times your pages appeared in search results.
Top Queries by Clicks
Keywords driving the most traffic
SOURCE: GSC "Queries" sheet, "Top queries" column. Sorted by clicks descending. Top 20 shown.
Top Pages by Clicks
Which pages get the most search traffic
SOURCE: GSC "Pages" sheet, "Top pages" column. Sorted by clicks descending. Top 15 shown.
Device Breakdown
Search clicks by device type
SOURCE: GSC "Devices" sheet. Values as reported by Google.
Highest CTR Pages
Pages converting impressions to clicks most efficiently (min 100 impressions)
SOURCE: GSC "CTR" sheet. Top 10 shown.
Organic Search Tab — Data Sources & Methodology
Data Source: Google Search Console export (.xlsx) — all sheets (Chart, Queries, Pages, Devices, Countries).
Total Clicks: Sum of "Clicks" column from Queries sheet.
Total Impressions: Sum of "Impressions" column from Queries sheet.
Avg CTR: Total Clicks / Total Impressions (not an average of individual CTRs).
Avg Position: Simple average of "Position" column across all queries.
Daily Chart: "Chart" sheet with one row per day, showing clicks trend over the export period.
No numbers are estimated or fabricated. All values come directly from Google Search Console.
Total Clicks: Sum of "Clicks" column from Queries sheet.
Total Impressions: Sum of "Impressions" column from Queries sheet.
Avg CTR: Total Clicks / Total Impressions (not an average of individual CTRs).
Avg Position: Simple average of "Position" column across all queries.
Daily Chart: "Chart" sheet with one row per day, showing clicks trend over the export period.
No numbers are estimated or fabricated. All values come directly from Google Search Console.
Top Landing Pages
Pages with the most sessions from all traffic sources
SOURCE: GA4 "Landing page" report. Columns: Sessions, Active users, New users, Avg engagement time, Key events, Bounce rate. All values directly from GA4 export.
Engagement Leaders
Pages with highest avg engagement time (min 50 sessions)
SOURCE: GA4 "Average engagement time per session" column. Filtered to pages with 50+ sessions for statistical relevance.
Highest Bounce Rate
Pages losing visitors fastest (min 50 sessions)
SOURCE: GA4 "Bounce rate" column. High bounce = visitors leave without interacting. Filtered to 50+ sessions.
Website Pages Tab — Data Sources & Methodology
Data Source: GA4 Landing Pages export (.csv).
Sessions/Users/New Users: Direct sums of respective GA4 columns.
Avg Bounce Rate: Average of "Bounce rate" column across all pages (0-1 scale, displayed as %).
Engagement Time: GA4 "Average engagement time per session" in seconds.
Key Events: GA4 conversion events (form fills, calls, etc. if configured).
Filters: Engagement and bounce charts filter to pages with 50+ sessions for statistical relevance.
Note: This GA4 export shows ALL traffic sources, not just organic. For organic-only data, see the Organic Search tab (GSC).
Sessions/Users/New Users: Direct sums of respective GA4 columns.
Avg Bounce Rate: Average of "Bounce rate" column across all pages (0-1 scale, displayed as %).
Engagement Time: GA4 "Average engagement time per session" in seconds.
Key Events: GA4 conversion events (form fills, calls, etc. if configured).
Filters: Engagement and bounce charts filter to pages with 50+ sessions for statistical relevance.
Note: This GA4 export shows ALL traffic sources, not just organic. For organic-only data, see the Organic Search tab (GSC).
Performance by Office Location
Google Business Profile metrics for each Shiner Law Group office
SOURCE: GBP Insights Performance Report CSV. All metrics are for the date range in the export (approx. last 90 days). Search = profile views on Google Search. Maps = profile views on Google Maps.
Location Comparison
Side-by-side metrics across all offices
Local SEO / GBP Tab — Data Sources & Methodology
Data Source: Google Business Profile Insights Performance Report (.csv).
Search Views: GBP "Google Search - Mobile" + "Google Search - Desktop" columns.
Maps Views: GBP "Google Maps - Mobile" + "Google Maps - Desktop" columns.
Calls/Directions/Website: Direct values from GBP "Calls", "Directions", "Website clicks" columns.
Total Actions: Calls + Directions + Website Clicks.
Action Rate: Total Actions / Total Profile Views (Search + Maps). Measures conversion from visibility to engagement.
Location names: Derived from "Address" column by matching city name. All metrics are aggregated for the export date range.
Search Views: GBP "Google Search - Mobile" + "Google Search - Desktop" columns.
Maps Views: GBP "Google Maps - Mobile" + "Google Maps - Desktop" columns.
Calls/Directions/Website: Direct values from GBP "Calls", "Directions", "Website clicks" columns.
Total Actions: Calls + Directions + Website Clicks.
Action Rate: Total Actions / Total Profile Views (Search + Maps). Measures conversion from visibility to engagement.
Location names: Derived from "Address" column by matching city name. All metrics are aggregated for the export date range.
Keyword Rankings by City
Enter SEMrush ranking data manually or review uploaded PDF
SOURCE: SEMrush Organic Positions report by city. Position = current Google ranking for that keyword in that city. Diff = change from previous period. Volume = estimated monthly searches. Data from the uploaded SEMrush PDF.
AI Visibility Audit Logger
Manually check if Shiner Law Group appears in AI search results and log the findings. Track presence over time across ChatGPT, Perplexity, Google AI Overview, and Gemini.
HOW TO USE: Search for your target keywords on each AI platform. Log whether Shiner Law Group was mentioned, ranked in the top 3, partially referenced, or not found. Over time, this builds a visibility tracking dataset that no automated tool can provide yet. Data is saved in your browser and persists across page refreshes on this device.
AI Visibility Recommendations
How to improve your presence in AI search results
Why this matters: AI platforms like ChatGPT, Perplexity, and Google's AI Overview are increasingly answering legal questions directly. If Shiner Law Group isn't appearing in these answers, you're invisible to a growing segment of potential clients.
What drives AI visibility:
1. Topical authority — comprehensive content covering your practice areas end-to-end (you're doing well here with your injury library)
2. Structured data / Schema markup — LocalBusiness, Attorney, FAQ schema on your pages helps AI systems understand your firm
3. E-E-A-T signals — Author pages (like Brandon Billmaier's page driving 5,400+ GSC clicks), credentials, case results, and reviews
4. Citations in authoritative sources — mentions on Avvo, Justia, FindLaw, Florida Bar, and legal directories
5. Recency — regularly updated content signals active expertise
Action items:
1. Add FAQ schema to your top 20 landing pages — AI platforms heavily favor FAQ-formatted content
2. Create a "Frequently Asked Questions" section on every practice area page with 5-10 questions
3. Ensure your Google Business Profile has complete, up-to-date info across all 5 locations
4. Publish monthly blog posts answering common PI questions in a conversational Q&A format
5. Run monthly AI visibility audits using the logger above — track progress over time
What drives AI visibility:
1. Topical authority — comprehensive content covering your practice areas end-to-end (you're doing well here with your injury library)
2. Structured data / Schema markup — LocalBusiness, Attorney, FAQ schema on your pages helps AI systems understand your firm
3. E-E-A-T signals — Author pages (like Brandon Billmaier's page driving 5,400+ GSC clicks), credentials, case results, and reviews
4. Citations in authoritative sources — mentions on Avvo, Justia, FindLaw, Florida Bar, and legal directories
5. Recency — regularly updated content signals active expertise
Action items:
1. Add FAQ schema to your top 20 landing pages — AI platforms heavily favor FAQ-formatted content
2. Create a "Frequently Asked Questions" section on every practice area page with 5-10 questions
3. Ensure your Google Business Profile has complete, up-to-date info across all 5 locations
4. Publish monthly blog posts answering common PI questions in a conversational Q&A format
5. Run monthly AI visibility audits using the logger above — track progress over time
Shiner Law Group - SEO & Local Performance Dashboard
💬