Jepto

Pricing

Blog

Sign In

Try For Free

Create GMB reports in Google Data Studio

Collect data from up to 10 Google My Business locations and create a report in minutes.

Filter by location and date

Filter by Location and Date

Reports can aggregate data from multiple locations or a single location with filters.

Top level metrics

Top Level Metrics

Get an overview of how your GMB locations are performing with a high level summary.

Centralised Review Reporting

Centralized Review Reporting

Easily establish which locations are getting good reviews and which ones are underperforming.

For Agencies

Report on your client's GMB performance across multiple locations in a single chart.

For Businesses

Get visibility of your GMB performance at a local level or as a while across multiple metrics.

Use the two GMB connectors for free

Filter by location and date

GMB Insights

Use this connector to report on GMB data relating to searches, posts, maps, photos, directions, views, and actions.

See In Data Studio

Filter by location and date

Google Reviews

Use this connector to create reports on Google Reviews, including the Reviewer, Replies and Rating.

See In Data Studio

Get access with a free token in 3 simple steps:

1. Fill out the form
2. Get the code via email
3. Put the code into the Data Studio Connector Authorization screen
NEW badge

GMB Pro — For users with more than 10 locations

If you have more than 10 GMB locations try GMB Pro for $10 per month + $1 for each location.

GMB Pro

LEARN MORE ABOUT GMB PRO

fields

Access more fields with GMB Pro

Get complete access to your GMB data for full reporting, including daily insights and up to 8 years of historic data.

Free GMB Connector VS GMB Pro


GMB Free

GMB Pro

GMB Data Fields

Additional fields are available for Pro; including Posts, Questions, Answers and listing information

26

93

Maximum Locations

Free reports are limited to 10 locations per Location Group whereas Pro is unlimited

10

Unlimited

Speed

GMB Pro utilizes preprocessed data fetching and is accelerated through Google BI Engine

Slow

Fast

Timezone

Set the Location timezone to ensure data matches the GMB dashboard

UTC

Localized

Location Filtering

GMB Pro allows you to easily manage user access control

Price

The cost for reporting on your GMB data

Free

$10 + $1 per Location

Data fields for GMB Connector and GMB Pro

Answer

Field Type GMB Free GMB Pro Description

totalAnswerCount

NumericNumeric Not Available Available The total number of answers posted for this question.

topAnswers

TextString Not Available Available A list of answers to the question, sorted by upvotes.

answer

TextString Not Available Available The answer to the question.

Local Post

Field Type GMB Free GMB Pro Description

localPostViewsOnSearch

NumericInteger Available Available The number of times the local post was viewed on Google Search.

localPostPhoneClicks

NumericInteger Available Available The number of times the call-to-action button was clicked on Google.

postId

TextString Not Available Available Google identifier for this post in the form: accounts/{accountId}/locations/{locationId}/localPosts/{postId}

postLanguageCode

TextString Not Available Available The language of the local post.

postSummary

TextString Not Available Available Description/body of the local post.

postCallToAction

TextString Available Available The URL that users are sent to when clicking through the promotion.

postEventTitle

TextString Not Available Available Title of the post event.

postEventDetails

TextString Not Available Available Event information.

postState

TextString Not Available Available The state of the post, indicating what part of its lifecycle it is in.

postMedia

TextString Not Available Available The media associated with the post.

postMediaUrl

TextString Not Available Available The media URL associated with the post.

postSearchUrl

TextString Not Available Available The link to the local post in Google search.

postTopicType

TextString Not Available Available The topic type of the post: standard, event, offer, or alert.

postAlertType

TextString Not Available Available The type of alert the post is created for.

postOffer

TextString Not Available Available Additional data for offer posts.

Location

Field Type GMB Free GMB Pro Description

followers

NumericInteger Not Available Available Total number of followers for the location

totalReviewCount

NumericInteger Not Available Available The total number of reviews in a location

locationAverageRating

NumericInteger Not Available Available The location's average rating

name

TextString Available Available Google identifier for this location in the form: accounts/{accountId}/locations/{locationId}

locationId

TextString Not Available Available Location ID

entityType

TextString Not Available Available Entity type

storeCode

TextString Available Available 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

TextString Available Available 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

TextString Not Available Available Category that best describes the core business this location engages in.

primaryPhone

TextString Not Available Available A phone number that connects to your individual business location as directly as possible.

additionalPhones

TextString Not Available Available 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

TextString Not Available Available A precise, accurate address to describe your business location.

additionalCategories

TextString Not Available Available Additional categories to describe your business.

websiteUrl

TextString Not Available Available A URL for this business.

regularHours

TextString Not Available Available Operating hours for the business.

specialHours

TextString Not Available Available Special hours for the business.

serviceArea

TextString Not Available Available Service area businesses provide their service at the customer's location.

locationKey

TextString Not Available Available A collection of keys that link this business to other Google properties, such as a Google+ page and Google Maps Places.

labels

TextString Not Available Available A collection of free-form strings to allow you to tag your business.

adWordsLocationExtensions

TextString Not Available Available Additional information that is surfaced in AdWords.

latlng

TextString Not Available Available User-provided latitude and longitude. When creating a location, this field is ignored if the provided address geocodes successfully.

openInfo

TextString Not Available Available Indicates the location other information

openInfoStatus

TextString Not Available Available A flag that indicates whether the location is currently open for business.

locationState

TextString Not Available Available A set of booleans that reflects the state of a location.

attributes

TextString Not Available Available Attributes for this location.

metadata

TextString Not Available Available Additional non-user-editable information.

languageCode

TextString Not Available Available The language of the location.

priceLists

TextString Not Available Available Describes your business in your own voice and shares with users the unique story of your business and offerings.

profile

TextString Not Available Available Describes your business in your own voice and shares with users the unique story of your business and offerings.

relationshipData

TextString Not Available Available All locations and chain related to this one.

date

CalendarTimestamp Available Available Date represented in ISO 8601 extended format (hh:mm)

Location Insight

Field Type GMB Free GMB Pro Description

directSearches

NumericInteger Available Available The number of times resource was shown when searching for location directly

discoverySearches

NumericInteger Available Available The number of times the resource was shown as a result of a categorical search (for example, restaurant).

brandedSearches

NumericInteger Available Available 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

NumericInteger Available Available The number of times the resource was viewed on Google Maps.

viewsOnSearch

NumericInteger Available Available The number of times the resource was viewed on Google Search.

websiteClicks

NumericInteger Not Available Available The number of times the website was clicked.

phoneClicks

NumericInteger Not Available Available The number of times the phone number was clicked.

requestDirection

NumericInteger Available Available The number of times driving directions were requested.

photosViewsMerchant

NumericInteger Available Available The number of views on media items uploaded by the merchant.

photosViewsCustomers

NumericInteger Available Available The number of views on media items uploaded by customers.

photosCountCustomers

NumericInteger Available Available The total number of media items that are currently live that have been uploaded by customers.

photosCountMerchant

NumericInteger Available Available The total number of media items that are currently live that have been uploaded by the merchant.

totalPostViewsOnSearch

NumericInteger Not Available Available The number of times all local posts were viewed on Google Search

totalPostPhoneClicks

NumericInteger Not Available Available The total number of times the call-to-action button was clicked on Google.

Media

Field Type GMB Free GMB Pro Description

mediaFormat

TextString Not Available Available The format of this media item.

mediaLocationAssociation

TextString Not Available Available Describes how this media item is connected to its location.

mediaGoogleUrl

TextString Not Available Available Google-hosted URL for this media item.

mediaThumbnailUrl

TextString Not Available Available Where provided, the URL of a thumbnail image for this media item.

mediaDimensions

TextString Not Available Available The dimensions (width and height) in pixels.

mediaInsights

TextString Not Available Available Statistics for this media item.

mediaDescription

TextString Not Available Available Description for this media item.

Media Customer

Field Type GMB Free GMB Pro Description

mediaCustomerMediaFormat

TextString Not Available Available The format of this media customer item.

mediaCustomerLocationAssociation

TextString Not Available Available Describes how this media item is connected to its location.

mediaCustomerGoogleUrl

TextString Not Available Available Google-hosted URL for media customer item.

mediaCustomerThumbnailUrl

TextString Not Available Available Where provided, the URL of a thumbnail image for media customer item.

mediaCustomerDimensions

TextString Not Available Available The dimensions (width and height) in pixels.

mediaCustomerInsights

TextString Not Available Available Statistics for media customer item.

mediaCustomerDescription

TextString Not Available Available Description for media customer item.

mediaCustomerAttribution

TextString Not Available Available Attribution information for customer media items.

mediaCustomerSourceUrl

TextString Not Available Available A publicly accessible URL where the media item can be retrieved from.

mediaCustomerDataRef

TextString Not Available Available A reference to media item binary data as obtained by the media.

Question & Answer

Field Type GMB Free GMB Pro Description

questionUpvoteCount

NumericInteger Not Available Available The number of upvotes for the question.

answerUpvoteCount

NumericInteger Not Available Available The number of upvotes for the answer.

questionAuthorDisplayName

TextString Not Available Available The author of the of question

answerAuthorDisplayName

TextString Not Available Available Display name of the author of the answer

answerAuthorProfilePhotoUrl

TextString Not Available Available Photo URL of the author of the answer

questionAuthorProfilePhotoUrl

TextString Not Available Available Photo URL of the author of the question

question

TextString Not Available Available The content of the question.

Review

Field Type GMB Free GMB Pro Description

starRating

NumericInteger Available Available The star rating of the review.

reviewId

TextString Not Available Available The encrypted unique identifier.

reviewerProfilePhotoUrl

TextString Available Available The reviewer profile photo URL

reviewerDisplayName

TextString Available Available The reviewer display name

reviewReply

TextString Available Available Reply on the review

reviewComment

TextString Available Available The body of the review as plain text with markups.

Frequently asked questions

1. Is it really free?

Yes! We built the free 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 free Data Studio connectors?

We only have the two free GMB connectors, reviews and insights.

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 both.

6. What's the difference between the free connectors and GMB Pro?

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 and increase the speed dramatically if we store the data. However instead of storing the data on our own servers, we push data to your own hosted account, so you will always own your data.