Data Studio Connector for GMB
Please complete to get your access token for the connector:
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.
Fetch data from your Google My Business locations and create a report in minutes
Reports can aggregate data from multiple locations or a single location with filters
Get an overview of how your GMB location is performing with a high level summary
Track your progress across a range of metrics with time comparisons
If you take Local SEO seriously and need all your GMB data
Create reports on any number of locations, with simple pricing and fast loading of data.
Free vs Data Warehouse Comparison
Free
Price
Affordable access to your GMB data at any scale
FREE
Data Fields
Additional fields are available for posts, Q&A, location info and more
26
Maximum Locations
Free reports are limited to 20 locations per Location Group
20
Speed
Data fetching is accelerated from the data warehouse as its preprocessed
Slow
Timezone
Timezone adjustment will ensure data matches the GMB dashboard
UTC
Location Filtering
Data Warehouses allows you to separate data with user access control
Data Warehouse
Price
Affordable access to your GMB data at any scale
$1 per Location
Data Fields
Additional fields are available for posts, Q&A, location info and more
93
Maximum Locations
Free reports are limited to 20 locations per Location Group
Unlimited
Speed
Data fetching is accelerated from the data warehouse as its preprocessed
Fast
Timezone
Timezone adjustment will ensure data matches the GMB dashboard
Localized
Location Filtering
Data Warehouses allows you to separate data with user access control
NOTE: Access to the Data Warehouse requires an active Jepto plan.
Get access to additional fields, complete historic data, faster loading reports and store everything in your own hosted database.
$1 per location per month with any Plan.
The report creation process in Data Studio is the same as any other connector
Full flexibility and pay only for the locations you want to create reports for.
Scalable to any number of locations, with superfast loading regardless of the time frame
Answer
| Field | Type | Free Connector | Data Warehouse | Description |
|---|---|---|---|---|
|
totalAnswerCount |
 Numeric
|
| 
| The total number of answers posted for this question. |
|
topAnswers |
 String
|
|
| A list of answers to the question, sorted by upvotes. |
|
answer |
String
|
|
| The answer to the question. |
Local Post
| Field | Type | Free Connector | Data Warehouse | Description |
|---|---|---|---|---|
|
localPostViewsOnSearch |
Integer
|
|
| The number of times the local post was viewed on Google Search. |
|
localPostPhoneClicks |
Integer
|
|
| The number of times the call-to-action button was clicked on Google. |
|
postLanguageCode |
String
|
|
| The language of the local post. |
|
postSummary |
String
|
|
| Description/body of the local post. |
|
postCallToAction |
String
|
|
| The URL that users are sent to when clicking through the promotion. |
|
postEventTitle |
String
|
|
| Title of the post event. |
|
postEventDetails |
String
|
|
| Event information. |
|
postState |
String
|
|
| The state of the post, indicating what part of its lifecycle it is in. |
|
postMedia |
String
|
|
| The media associated with the post. |
|
postMediaUrl |
String
|
|
| The media URL associated with the post. |
|
postSearchUrl |
String
|
|
| The link to the local post in Google search. |
|
postTopicType |
String
|
|
| The topic type of the post: standard, event, offer, or alert. |
|
postAlertType |
String
|
|
| The type of alert the post is created for. |
|
postOffer |
String
|
|
| Additional data for offer posts. |
Location
| Field | Type | Free Connector | Data Warehouse | Description |
|---|---|---|---|---|
|
followers |
Integer
|
|
| Total number of followers for the location |
|
totalReviewCount |
Integer
|
|
| The total number of reviews in a location |
|
locationAverageRating |
Integer
|
|
| The location's average rating |
|
name |
String
|
|
| Google identifier for this location in the form: accounts/{accountId}/locations/{locationId} |
|
locationId |
String
|
|
| Location ID |
|
entityType |
String
|
|
| Entity type |
|
storeCode |
String
|
|
| External identifier for this location, which must be unique inside a given account. This is a means of associating the location with your own records. |
|
locationName |
String
|
|
| Location name should reflect your business's real-world name, as used consistently on your storefront, website, and stationery, and as known to customers. |
|
primaryCategory |
String
|
|
| Category that best describes the core business this location engages in. |
|
primaryPhone |
String
|
|
| A phone number that connects to your individual business location as directly as possible. |
|
additionalPhones |
String
|
|
| Up to two phone numbers (mobile or landline, no fax) at which your business can be called, in addition to your primary phone number. |
|
address |
String
|
|
| A precise, accurate address to describe your business location. |
|
additionalCategories |
String
|
|
| Additional categories to describe your business. |
|
websiteUrl |
String
|
|
| A URL for this business. |
|
regularHours |
String
|
|
| Operating hours for the business. |
|
specialHours |
String
|
|
| Special hours for the business. |
|
serviceArea |
String
|
|
| Service area businesses provide their service at the customer's location. |
|
locationKey |
String
|
|
| A collection of keys that link this business to other Google properties, such as a Google+ page and Google Maps Places. |
|
labels |
String
|
|
| A collection of free-form strings to allow you to tag your business. |
|
adWordsLocationExtensions |
String
|
|
| Additional information that is surfaced in AdWords. |
|
latlng |
String
|
|
| User-provided latitude and longitude. When creating a location, this field is ignored if the provided address geocodes successfully. |
|
openInfo |
String
|
|
| Indicates the location other information |
|
openInfoStatus |
String
|
|
| A flag that indicates whether the location is currently open for business. |
|
locationState |
String
|
|
| A set of booleans that reflects the state of a location. |
|
attributes |
String
|
|
| Attributes for this location. |
|
metadata |
String
|
|
| Additional non-user-editable information. |
|
languageCode |
String
|
|
| The language of the location. |
|
priceLists |
String
|
|
| Describes your business in your own voice and shares with users the unique story of your business and offerings. |
|
profile |
String
|
|
| Describes your business in your own voice and shares with users the unique story of your business and offerings. |
|
relationshipData |
String
|
|
| All locations and chain related to this one. |
|
date |
 Timestamp
|
|
| Date represented in ISO 8601 extended format (hh:mm) |
Location Insight
| Field | Type | Free Connector | Data Warehouse | Description |
|---|---|---|---|---|
|
directSearches |
Integer
|
|
| The number of times resource was shown when searching for location directly |
|
discoverySearches |
Integer
|
|
| The number of times the resource was shown as a result of a categorical search (for example, restaurant). |
|
brandedSearches |
Integer
|
|
| The number of times a resource was shown as a result of a search for the chain it belongs to, or a brand it sells. |
|
viewsOnMap |
Integer
|
|
| The number of times the resource was viewed on Google Maps. |
|
viewsOnSearch |
Integer
|
|
| The number of times the resource was viewed on Google Search. |
|
websiteClicks |
Integer
|
|
| The number of times the website was clicked. |
|
phoneClicks |
Integer
|
|
| The number of times the phone number was clicked. |
|
requestDirection |
Integer
|
|
| The number of times driving directions were requested. |
|
photosViewsMerchant |
Integer
|
|
| The number of views on media items uploaded by the merchant. |
|
photosViewsCustomers |
Integer
|
|
| The number of views on media items uploaded by customers. |
|
photosCountCustomers |
Integer
|
|
| The total number of media items that are currently live that have been uploaded by customers. |
|
photosCountMerchant |
Integer
|
|
| The total number of media items that are currently live that have been uploaded by the merchant. |
|
totalPostViewsOnSearch |
Integer
|
|
| The number of times all local posts were viewed on Google Search |
|
totalPostPhoneClicks |
Integer
|
|
| The total number of times the call to action button was clicked on Google. |
Media
| Field | Type | Free Connector | Data Warehouse | Description |
|---|---|---|---|---|
|
mediaFormat |
String
|
|
| The format of this media item. |
|
mediaLocationAssociation |
String
|
|
| Describes how this media item is connected to its location. |
|
mediaGoogleUrl |
String
|
|
| Google-hosted URL for this media item. |
|
mediaThumbnailUrl |
String
|
|
| Where provided, the URL of a thumbnail image for this media item. |
|
mediaDimensions |
String
|
|
| The dimensions (width and height) in pixels. |
|
mediaInsights |
String
|
|
| Statistics for this media item. |
|
mediaDescription |
String
|
|
| Description for this media item. |
Media Customer
| Field | Type | Free Connector | Data Warehouse | Description |
|---|---|---|---|---|
|
mediaCustomerMediaFormat |
String
|
|
| The format of this media customer item. |
|
mediaCustomerLocationAssociation |
String
|
|
| Describes how this media item is connected to its location. |
|
mediaCustomerGoogleUrl |
String
|
|
| Google-hosted URL for media customer item. |
|
mediaCustomerThumbnailUrl |
String
|
|
| Where provided, the URL of a thumbnail image for media customer item. |
|
mediaCustomerDimensions |
String
|
|
| The dimensions (width and height) in pixels. |
|
mediaCustomerInsights |
String
|
|
| Statistics for media customer item. |
|
mediaCustomerDescription |
String
|
|
| Description for media customer item. |
|
mediaCustomerAttribution |
String
|
|
| Attribution information for customer media items. |
|
mediaCustomerSourceUrl |
String
|
|
| A publicly accessible URL where the media item can be retrieved from. |
|
mediaCustomerDataRef |
String
|
|
| A reference to media item binary data as obtained by the media. |
Question
| Field | Type | Free Connector | Data Warehouse | Description |
|---|---|---|---|---|
|
questionUpvoteCount |
Integer
|
|
| The number of upvotes for the question. |
|
answerUpvoteCount |
Integer
|
|
| The number of upvotes for the answer. |
|
questionAuthorDisplayName |
String
|
|
| The author of the of question |
|
answerAuthorDisplayName |
String
|
|
| Display name of the author of the answer |
|
answerAuthorProfilePhotoUrl |
String
|
|
| Photo URL of the author of the answer |
|
questionAuthorProfilePhotoUrl |
String
|
|
| Photo URL of the author of the question |
|
question |
String
|
|
| The content of the question. |
Review
| Field | Type | Free Connector | Data Warehouse | Description |
|---|---|---|---|---|
|
starRating |
Integer
|
|
| The star rating of the review. |
|
reviewId |
String
|
|
| The encrypted unique identifier. |
|
reviewerProfilePhotoUrl |
String
|
|
| The reviewer profile photo URL |
|
reviewerDisplayName |
String
|
|
| The reviewer display name |
|
reviewReply |
String
|
|
| Reply on the review |
|
reviewComment |
String
|
|
| The body of the review as plain text with markups. |
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. What's 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. For this reason we chose to fetch data directly from GMB without storing it. The ramifications of this is that the connector can be slow and suffer from intermittent errors if lots of users are creating reports at the same. This may be acceptable for some users, however we're able to offer far more data points and increase the speed dramatically if we store the data. However Instead of storing the data on our own servers, the data pipelines you set up push data to your own hosted account so if you decide to stop paying you will always own your data.
