Jepto

Pricing

Blog

Sign In

Try For Free

Jepto

Pricing

BLOG

Sign In

Try For Free

For agencies

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.

For businesses

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.

Single/Multi location

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.

Use the two connectors for the low price of free

Google My Business Insights Data Studio Connector

GMB Insights

This connector will allow you to report on GMB data relating to Searches, Posts, Maps, Photos, Directions, Views and Actions.

see in DATA STUDIO

Google My Business Reviews Data Studio Connector

Google Reviews

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

see in data studio

To get your token for the connectors
follow 3 simple steps:

Google My Business Connector Fields

Index Field Type Description
1

Chain (Brand) searches

NumericNumber Number of times a location was shown as a result of a search for the chain (brand) it belongs to.
2

Customer photo views

NumericNumber Number of times a photo added by a customer has been viewed
3

Customer photos

NumericNumeric Total number of photos added by customers
4

Date

CalendarDate (YYYMMDD)
5

Day of Week

CalendarDay of Week (D)
6

Direct searches

NumericNumber Number of times customers found this listing by searching for the business name or address on Google Search or Maps
7

Directions actions

NumericNumber Number of times customers have requested directions from this listing
8

Discovery searches

NumericNumber 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

NumericNumber Number of times the local post call to action has been clicked
10

Local post search views

NumericNumber Number of times this local post has been viewed in search
11

Location

TextText
12

Location Name

TextText
13

Maps views

NumericNumber Number of times this listing has been viewed on Google Maps
14

Month

CalendarMonth (MM)
15

Owner photo views

NumericNumber Number of times a photo added by an owner has been viewed
16

Owner photos

NumericNumber Total number of photos added by listing owner
17

Phone call actions

NumericNumber Number of times customers have called the business from this listing
18

Search views

NumericNumber Number of times this listing has been viewed on Google Search
19

Store Code

TextText
20

Time Zone

TextText
21

Total actions

NumericNumber Total of Website Actions, Phone Call Actions and Direction Actions. Does not include Local Post Actions
22

Total searches

NumericNumber Total of Direct and Discovery searches.
23

Total views

NumericNumber Total of Map Views and Search Views. Does not include Local Post Views
24

Website actions

NumericNumber Number of times customers have visited the website from this listing
25

Year

CalendarYear (YYYY)
26

Year Month

CalendarYear Month (YYYYMM)

Google My Business Connector Fields

Index Field Type Description
1

Chain (Brand) searches

NumericNumber Number of times a location was shown as a result of a search for the chain (brand) it belongs to.
2

Customer photo views

NumericNumber Number of times a photo added by a customer has been viewed
3

Customer photos

NumericNumeric Total number of photos added by customers
4

Date

CalendarDate (YYYMMDD)
5

Day of Week

CalendarDay of Week (D)
6

Direct searches

NumericNumber Number of times customers found this listing by searching for the business name or address on Google Search or Maps
7

Directions actions

NumericNumber Number of times customers have requested directions from this listing
8

Discovery searches

NumericNumber 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

NumericNumber Number of times the local post call to action has been clicked
10

Local post search views

NumericNumber Number of times this local post has been viewed in search
11

Location

TextText
12

Location Name

TextText
13

Maps views

NumericNumber Number of times this listing has been viewed on Google Maps
14

Month

CalendarMonth (MM)
15

Owner photo views

NumericNumber Number of times a photo added by an owner has been viewed
16

Owner photos

NumericNumber Total number of photos added by listing owner
17

Phone call actions

NumericNumber Number of times customers have called the business from this listing
18

Search views

NumericNumber Number of times this listing has been viewed on Google Search
19

Store Code

TextText
20

Time Zone

TextText
21

Total actions

NumericNumber Total of Website Actions, Phone Call Actions and Direction Actions. Does not include Local Post Actions
22

Total searches

NumericNumber Total of Direct and Discovery searches.
23

Total views

NumericNumber Total of Map Views and Search Views. Does not include Local Post Views
24

Website actions

NumericNumber Number of times customers have visited the website from this listing
25

Year

CalendarYear (YYYY)
26

Year Month

CalendarYear Month (YYYYMM)

Google My Business Connector Review Fields

Index Field Type Description
1

Comment

TextText
2

Created Date

CalendarDate (YYYYNNDD)
3

Location

TextText
4

Location Name

TextText
5

Reply

TextText
6

Review Count

NumericNumber Number of reviews
7

Review ID

TextText
8

Review Replied To

BooleanBoolean Has the review been replied to?
9

Reviewer Display Name Code

TextText
10

Reviewer Photo URL

TextText
11

Star Rating

TextText Rating given by reviewer as a string
12

Star Rating Value

NumericNumber Rating given by reviewer as a number
13

Store Code

TextText
14

Updated Date

CalendarDate (YYYYNNDD)

Google My Business Connector Review Fields

Index Field Type Description
1

Comment

TextText
2

Created Date

CalendarDate (YYYYNNDD)
3

Location

TextText
4

Location Name

TextText
5

Reply

TextText
6

Review Count

NumericNumber Number of reviews
7

Review ID

TextText
8

Review Replied To

BooleanBoolean Has the review been replied to?
9

Reviewer Display Name Code

TextText
10

Reviewer Photo URL

TextText
11

Star Rating

TextText Rating given by reviewer as a string
12

Star Rating Value

NumericNumber Rating given by reviewer as a number
13

Store Code

TextText
14

Updated Date

CalendarDate (YYYYNNDD)

Single or Multiple Location Filtering

GMB Data Studio Location Filtering

Only want to display a single location? Use the Data Studio in-built filters to make a report on a single location.

Frequently asked questions

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.