← ClaudeAtlas

gmb-multi-location-looker-studio-dashboardlisted

Builds or monthly-refreshes a multi-location Google Business Profile (GBP / GMB) performance dashboard in Looker Studio from the GBP bulk Insights export, then verifies every number against the sheet and the live GBP console. Covers the monthly bulk export, the per-profile keyword panel, a review/rating snapshot, modelling into a long fact table, the two-page Looker build, a four-leg verification (sheet, dashboard, live console, filters) and the monthly refresh. Use when asked to build or refresh a "GMB dashboard", "GBP performance report", "Google Business Profile dashboard", "local SEO dashboard", or any multi-location Business Profile report in Looker Studio / Data Studio.
savenjudesajen/seo-aeo-agent-skills-tools · ★ 0 · Data & Documents · score 73
Install: claude install-skill savenjudesajen/seo-aeo-agent-skills-tools
# Multi-location Google Business Profile -> Looker Studio dashboard Home page: [unilytics.ai/skills/gmb-multi-location-looker-studio-dashboard](https://unilytics.ai/skills/gmb-multi-location-looker-studio-dashboard/), the canonical source of this skill. ## 0. What this skill delivers A 2-page Looker Studio report over N Business Profile locations: - **Page 1 - Performance overview:** KPI tiles (Impressions, Interactions, Engagement rate, Locations), monthly trend line, impressions by state (or region) bar, and a state -> location pivot with month-over-month % delta. - **Page 2 - Engagement detail:** action-type tiles (Website, Calls, Directions), actions-mix-by-month stacked column, engagement rate by location bar, and (if collected) a top-keywords table + branded/non-branded split. - **Optional reputation block:** total reviews, review-weighted rating, rating and review count by location (Section 3b). Source of truth is a single **long-format Google Sheet / Excel file** (one row per location x month), connected to Looker Studio. **The last step is always verification (Section 6). It is the most important step and it is not optional.** ## 1. Standing facts about GBP data (read first) Tell the client these before you build, not after. 1. **The bulk Insights export has no keyword data.** It has 16 columns: 4 impression splits (Search mobile/desktop, Maps mobile/desktop) + Calls, Messages, Bookings, Directions, Website clicks, Food orders, Food menu clicks,