Data Studio Connector for GMB
Please complete to get your access token for the connector:
Not a trial. No credit card. Free forever.
Reporting to clients on your SEO efforts and how consumers are interacting with the Google My Business profile can now sit beside your Google Analytics, Google Ads or any other source in Data Studio.
Understanding how you are performing at a local level is an integral part of your digital strategy. Get GMB Posts, Driving Direction, Searches, Photos, Map and Phone Call data.
The connector fetches data from your GMB account and uses Location Groups for the data source. If you have multiple locations this makes displaying reports for each location in a single chart or table very easy.
Google My Business Connector Fields
| Index | Field | Type | Description |
|---|---|---|---|
| 1 |
Chain (Brand) searches |
 Number
|
Number of times a location was shown as a result of a search for the chain (brand) it belongs to. |
| 2 |
Customer photo views |
Number
|
Number of times a photo added by a customer has been viewed |
| 3 |
Customer photos |
Numeric
|
Total number of photos added by customers |
| 4 |
Date |
 Date (YYYMMDD)
|
|
| 5 |
Day of Week |
Day of Week (D)
|
|
| 6 |
Direct searches |
Number
|
Number of times customers found this listing by searching for the business name or address on Google Search or Maps |
| 7 |
Directions actions |
Number
|
Number of times customers have requested directions from this listing |
| 8 |
Discovery searches |
Number
|
Number of times customers found this listing by searching for the category, product or service on Google Search or Maps |
| 9 |
Local post call to action |
Number
|
Number of times the local post call to action has been clicked |
| 10 |
Local post search views |
Number
|
Number of times this local post has been viewed in search |
| 11 |
Location |
 Text
|
|
| 12 |
Location Name |
Text
|
|
| 13 |
Maps views |
Number
|
Number of times this listing has been viewed on Google Maps |
| 14 |
Month |
Month (MM)
|
|
| 15 |
Owner photo views |
Number
|
Number of times a photo added by an owner has been viewed |
| 16 |
Owner photos |
Number
|
Total number of photos added by listing owner |
| 17 |
Phone call actions |
Number
|
Number of times customers have called the business from this listing |
| 18 |
Search views |
Number
|
Number of times this listing has been viewed on Google Search |
| 19 |
Store Code |
Text
|
|
| 20 |
Time Zone |
Text
|
|
| 21 |
Total actions |
Number
|
Total of Website Actions, Phone Call Actions and Direction Actions. Does not include Local Post Actions |
| 22 |
Total searches |
Number
|
Total of Direct and Discovery searches. |
| 23 |
Total views |
Number
|
Total of Map Views and Search Views. Does not include Local Post Views |
| 24 |
Website actions |
Number
|
Number of times customers have visited the website from this listing |
| 25 |
Year |
Year (YYYY)
|
|
| 26 |
Year Month |
Year Month (YYYYMM)
|
Google My Business Connector Review Fields
| Index | Field | Type | Description |
|---|---|---|---|
| 1 |
Comment |
Text
|
|
| 2 |
Created Date |
Date (YYYYNNDD)
|
|
| 3 |
Location |
Text
|
|
| 4 |
Location Name |
Text
|
|
| 5 |
Reply |
Text
|
|
| 6 |
Review Count |
Number
|
Number of reviews |
| 7 |
Review ID |
Text
|
|
| 8 |
Review Replied To |
 Boolean
|
Has the review been replied to? |
| 9 |
Reviewer Display Name Code |
Text
|
|
| 10 |
Reviewer Photo URL |
Text
|
|
| 11 |
Star Rating |
Text
|
Rating given by reviewer as a string |
| 12 |
Star Rating Value |
Number
|
Rating given by reviewer as a number |
| 13 |
Store Code |
Text
|
|
| 14 |
Updated Date |
Date (YYYYNNDD)
|
Single or Multiple Location Filtering
Only want to display a single location? Use the Data Studio in-built filters to make a report on a single location.
1. Is it really free?
Yes! We built the connector because we were experimenting with Google My Business as a data source for our App and decided that we would offer it for free, forever. Absolutely no catch. We don't use your data for any purposes, we only hope that you might browse around and see if our App would be of interest to you.
2. How do I filter data from a single location?
If you have multiple locations, you have several options for filtering data for your reports. For example, you could create a filter based on the Location Name or Store Code for a static report. Alternatively you can create a filter control if you want the report to be dynamic.
If your GMB Account has Location Groups, there is a checkbox in the settings to allow you to edit the Location Group from inside the report, referred to as Business Accounts, and is in the parameters section inside the report.
3. Do you have other Data Studio connectors?
We only have the two connectors, Reviews and Insights. Our current focus is building our App and no other connectors are currently planned.
4. Why is the connector asking me for edit permissions?
In short, there is only one permission scope. For us to access your Google My Business data we use the API (Application Programming Interface) which is considered private, as a formal application needs to be submitted before you can gain access to the API. Because of this, Google has only one permission setting for accessing data via the API which is why edit/delete access is requested. The connector only reads information and absolutely no editing or deleting requests will be made to your account.
5. Why are there separate connectors for reviews and Insights?
When we originally built the GMB Insights connector we didn't cater for reviews and trying to make both work together was going to compromise the existing connector. Therefore, we built the review connector separately due to popular demand and now you have the choice of using one or the other.
6. Whats the difference between the free connector and the Data Warehouse?
When we first released the Data Studio connector we wanted to make it free for everyone. This caused us to make a few design decisions that make the connector slow down for long date periods, cause a few intermittent errors if lots of users are creating reports at the same and not scalable for a large amount of locations.
Need faster loading reports than the free connectors or want to take control of your GMB data and store it for easy reporting?
Create a Data Warehouse of your GMB data for
$1 per location per month on top of any Plan.
Full flexibility and pay only for the amount of locations you want to create a Data Warehouse for.
Scalable to any number of locations, you can ensure that reporting is smooth and fast.
Utilising Google Big Query the setup takes less than 5 minutes for all your locations.
