Google Business Profile Data Connector User Guide

Google Business Profile Data Connector User Guide

Info
Google Business Profile (formerly known as Google My Business) is a powerful tool for businesses to manage their online presence across Google, including Search and Maps. This guide will walk you through how to connect and use Google Business Profile data in Power My Analytics, enabling you to gain valuable insights into your business's local search performance and customer interactions.



Prerequisites

Before you begin, ensure you have:
  1. A Google account with Owner or Manager access to the Google Business Profile account you want to connect

Adding Google Business Profile as a Data Source

  1. Log out of all Google accounts except the one you want to connect.
  2. In your Power My Analytics Hub, navigate to Sources in the menu.
  3. Click + New Data Source and select Google from the gallery.
  4. Sign in to your Google account when prompted.
  5. Grant Power My Analytics the required permissions (See, edit, create, and delete your Google Business listings) for your Google account. Power My Analytics will never edit, create, or delete anything in your Google Business Profile account; Google does not provide a read-only option.


Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your Google Business Profile data:
  1. In your Power My Analytics Hub, go to Reports > Looker Studio
  2. Select Google Business Profile under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
  3. Google Looker Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g., "Google Business Profile - Your Business Name")
      2. Select your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2: 
      1. User Account: Select your Google Business Profile account for real data or "Sample Account" for sample data
      2. Click Next
    3. Step 3:
      1. Choose only one of "Accounts" or "Individual Locations" for your reports
      2. Optional: Allow "Accounts" or "Individual Locations" modification in reports
      3. Click Connect in the top right
    4. Step 4:
      1. Click Create Report in the top right
For a quick start, use our pre-built Google Business Profile demo template.

Key Reports and Fields

Google Business Profile offers a wealth of data. Here are some popular metrics you can include in your reports:
  1. Call Metrics: Calls made from your Business Profile
  2. Message Metrics: Business Messages
  3. Booking Metrics: Business Bookings
  4. Direction Metrics: Direction requests from your Business Profile
  5. Website Click Metrics: Website clicks made from your Business Profile
  6. Review Metrics: Review comments, Star ratings
  7. Location Metrics: Views, Website visits, Calls, Directions, Activity
For a complete list of available Google Business Profile fields in Power My Analytics, consult the Schema Explorer.

Billing

Google Business Profile billing is unique because you are charged per location instead of per account. Locations are billed as follows:


Single
Business
Pro
Enterprise
Locations included
1
10
500
1,000
Price per extra location
$0.95
$0.85
$0.25
$1.50

For more information, please see What Are Business Locations?

Limitations and Important Considerations

  1. Backfilling: Power My Analytics can backfill up to 18 months of data, with an initial backfill of 13 months when you first connect.
    1. Historical data: Accumulate up to 2 years of historical data over time.
  2. Data delay: Data may be delayed by up to 4 days.
  3. Reviews: Review data may take several hours to populate when you first connect.
  4. Searches Breakdown [dimension] and Searches Total [scorecard]: These fields only provide aggregated monthly data and are not available by day.
  5. Searches scorecard: Only Searches Total [scorecard] can be used as a scorecard.
  6. Search impressions: Monthly Search Impressions with under 15 impressions will report as 0.
  7. Review counts: May differ from the Google Business Profile UI by up to 1% due to deleted and contested reviews.
  8. Business Food Orders deprecated: The Business Food Orders field will no longer receive new data as of September 16, 2024. This field will be removed on March 30, 2025.

Unavailable Data

  1. Queries data
  2. Realtime data
  3. Custom fields

Reporting Across Multiple Months

When you select multiple months in your reports, Google Business Profile data will be totaled across the entire period rather than providing granular month-by-month data. To view your data broken down by individual months, you'll need to create:
  1. Separate charts for each month in Looker Studio reports.



  2. Individual reports for each month in Google Sheets, Microsoft Excel, or other spreadsheet destinations.

Report Average Star Rating in Looker Studio

To report your business's star rating in Looker Studio as it appears on Google:
  1. Add a scorecard with the metric Star Rating. Set the metric's aggregation to "Average".
  2. Set the beginning of the scorecard's date range to the opening of your business.


Troubleshooting

See our article Troubleshooting Google Connectors for information on issues that may affect Google connectors.


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • Google Ads Data Connector User Guide

        Google Ads is a powerful online advertising platform that allows businesses to reach potential customers across Google's vast network. This guide will walk you through how to connect your Google Ads data to Power My Analytics, create reports in ...

      • What Are Business Locations?

        Business Locations apply only to Google Business Profile reports. A Business Location in Google Business Profile refers to each brick-and-mortar office or storefront location at which a business operates. Google Business Profile tracks separate ...

      • Mailchimp Data Connector User Guide

        Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...

      • Error: Missing Google Business Profile Scopes

        When creating a report using your Google Business Profile account in Power My Analytics, you may encounter an error message stating "Missing Google Business Profile Scopes." This guide will help you understand the cause of this error and provide ...

      • Google My Business Is Now Google Business Profile

        Google My Business has now become Google Business Profile. The website and mobile apps completed their rebranding at the end of 2022 and reporting will now begin to include the newly available data. This article will cover everything you need to know ...