gmb-multi-location-looker-studio-dashboardlisted
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,