Google Business Profile
Google Looker Studio
Monitor and analyze your Google reviews, ratings, and customer feedback trends to improve your local reputation and engagement.
View TemplateTrack key metrics for your Google Business Profile including search views, map views, actions, and local SEO performance in Looker Studio.
View Template
Porter✓ No-code marketing data warehouse |
Others✓ Connectors & ETL |
|
|---|---|---|
| Storage | Built-in, self-managed BigQuery with automated transformations, transfers, queries, and costs included. | Requires setting up your own BigQuery project, managing tables, transfers, and costs. |
| Data syncing | Switch between stored BigQuery and real-time API data in the same connection. | Either stored (manual BigQuery setup) or real-time, not both. |
| Data blending | Blend reviews, impressions, and conversions across multiple locations and time periods in one dashboard. | Manual table selection and field mapping for each metric and location. |
| Destinations | Looker Studio + Google Sheets in one subscription. | Separate price per destination. |
Step 1: Choose the Google Business Profile connector on Porter Metrics
Step 2: Log in with the Google account you use on Looker Studio
Step 3: Click Add Account and grant permissions to the Google account managing your locations
Step 4: Select one or multiple locations to connect, then click Create Report
Step 5: When Looker Studio opens, save and share your interactive report to monitor and analyze your Google Business Profile data
Full tutorial: How to connect Google Business Profile to Looker Studio
See all Meta Ads fields documentation.
Access every Google Business Profile field—over 100 in total—including account, location, reviews, posts, media, and calculated metrics like review response time and post engagement, not available natively.
Retrieve every metric with full aggregation options: by location, device, platform, and time. For example: impressions by Maps vs Search, mobile vs desktop, and actions by week or month.
Analyze every supported date range—day, week, month, quarter, year, or custom—so you can compare performance over time and track trends for any period, all in one dashboard.
Porter retrieves all review data—reviewer name, comment, rating, creation date, and your replies—so you can monitor reputation, response time, and customer feedback in one place.
Fields are named just as in Google Business Profile, so locations, reviews, and posts are familiar to marketers. Standardized naming enables easy blending with GA4, CRM, and PPC data.
Segment data by location, device, platform, post, review, date, hour, and every other breakdown supported by Google, for detailed analysis across all your business locations.
Account Name
Account Status
Location Name
Address
Phone Number
Search Impressions
Website Visits
Driving Directions
Average Rating
Total Reviews
Latest Review
Post Summary
Post Type
Event Dates
Media Views
Total Media Items
Date
Month
Year
