Jepto

Pricing

Blog

Sign In

Try For Free

Free Google Business Profile Looker Studio Connector

Free for up to 10 GBP properties.
No trial. No credit card. Free forever.

circle-4circle-3circle-1circle-2
circle-4circle-3circle-1circle-2

Create Google Business Profile reports in Looker Studio

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

Filter by location and date

Aggregate Locations

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

Top level metrics

Top Level Metrics

Performance metrics allow you to monitor brand visibility and track progress over time.

Centralised Review Reporting

Centralized Reporting

Easily establish which locations are get psoitive reviews and which ones are underperforming.

For Agencies

Report on your client's Business Profile performance across multiple locations.

For Businesses

Get visibility on they key metrics and reviews for your Google Business Profile.

Use the Google Business Profile connector for free

GBP Insights

Business Profile Insights

Create reports with data relating to search and map impressions, actions and more.

See In Data Studio

Google Reviews

Google Reviews

Create reports with Google reviews, including the reviewer, replies and star rating.

See In Data Studio

Get access with a free token in 3 simple steps:

Fill out the form

1. Fill out the form

Get the code via email

2. Get the code via email

Put the code into the Data Studio Connector Authorization screen

3. Put the code into the Looker Studio Connector Authorization screen

Have more than 10 Business Profiles?
Create accelerated reports with a Data Warehouse, set up in minutes

If you have more than 10 GBP locations try the Jepto Basic Plan for $10 per month + $1 for each location.

GBP Pro

Access all of your Google Business Profile data with the Jepto Data Warehouse.

Get complete access to your Business Profile data for full reporting, including keyword ranking data and breakdown of performance metrics.

fields

Google Business Profile (aka GMB) Keyword Data

All Google Business Profile pipelines have been automatically updated to include Keyword data. These new fields allow you to report on the keywords that triggered your Business Profile to show in the SERP. This data is available on a monthly basis and is backfilled so you can see your performance over time.

Google Business Profile (aka GMB) Keyword Data

By using the Jepto Data Warehouse you will unlock your Google Business Profile Keyword data. These new fields allow you to report on the keywords that trigger your Business Profile to show in the Search Engine Results Page (SERP).

Filter by location and date

Develop a keyword strategy

Gain visibility into the keywords that customers are using to find your business.

Top level metrics

Brand and product search terms

See how many times your business profile was shown for branded and unbranded keywords.

Centralised Review Reporting

Track keyword vizibility over time

Measure your Business Profile optimizations by tracking keywords and search volume over time.

Free Connector VS Data Warehouse

Free Connector

Data Warehouse

Maximum Locations

Free reports are limited to 10 locations, whereas the Data Warehouse can scale to any limit.

10

Unlimited

Price

The cost for reporting on your Google Business Profile data.

Free

$10 Plan + $1 per Location

Speed

Storing your data in a Warehouse accelerates reports through Google's BI Engine for fast loading Looker Studio reports at any scale.

Slow

Fast

Data Fields

Additional fields available for the Data Warehouse include: profile information, posts, questions, answers and detailed impression data.

15

100+

Keywords

See the keywords and search volume your business profile ranks for.

Location Filtering

Only pay for the locations you want to report on and share access securely.

Timezone

Set the Location timezone to ensure data matches the GBP dashboard.

UTC

Localized

Data fields for GMB Free Connector and Data Warehouse

Location
Field Type Free Data Warehouse Description

name

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

locationId

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

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.

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

CalendarDate Available Available Date represented as YYYY-MM-DD

dateTime

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

followers

TextString Not Available Available Total number of followers for the location.

locationAverageRating

NumericNumeric Not Available Available The location's average rating

totalReviewCount

TextString Not Available Available The daily total number of reviews in a location. NOTE: To display the total number of reviews in Data Studio, use the MAX aggregation. For the number of reviews over a given time period use the reviewId metric with COUNT aggregation.

insertId

TextString Not Available Available For Jepto Use only
Performance
Field Type Free Data Warehouse Description

mapsImpressionsDesktop

NumericInteger Not Available Available Business impressions on Google Maps on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression.

searchImpressionsDesktop

NumericInteger Not Available Available Business impressions on Google Search on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression.

searchImpressionsMobile

NumericInteger Not Available Available Business impressions on Google Search on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression.

mapsImpressionsMobile

NumericInteger Not Available Available Business impressions on Google Maps on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression.

conversations

NumericInteger Not Available Available The number of message conversations received on the business profile.

directionRequests

NumericInteger Available Available The number of times a direction request was requested to the business location.

callClicks

NumericInteger Available Available The number of times the business profile call button was clicked.

webClicks

NumericInteger Available Available The number of times the business profile website was clicked.

bookings

NumericInteger Not Available Available The number of bookings received from the business profile.

foodOrders

NumericInteger Not Available Available The number of food orders received from the business profile.

desktopImpressions

NumericInteger Not Available Available Impressions on Google Search and Maps on Desktop devices. Multiple impressions by a unique user within a single day are counted once.

mobileImpressions

NumericInteger Not Available Available Impressions on Google Search and Maps on Mobile devices. Multiple impressions by a unique user within a single day are counted once.

searchImpressions

NumericInteger Available Available Impressions on Google Search on Mobile and Desktop devices. Multiple impressions by a unique user within a single day are counted once.

mapsImpressions

NumericInteger Available Available Impressions on Google Maps on Mobile and Desktop devices. Multiple impressions by a unique user within a single day are counted once.
Media
Field Type Free Data Warehouse 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.

mediaDescription

TextString Not Available Available Description for this media item.
Media Customer
Field Type Free Data Warehouse 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.

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.
Local Post
Field Type Free Data Warehouse Description

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

postPublishDate

CalendarTimestamp Not Available Available Time of the creation of the post.
Question
Field Type Free Data Warehouse 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.

questionAuthorProfilePhotoUrl

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

question

TextString Not Available Available The content of the question.

questionAuthorDisplayName

TextString Not Available Available The author of the of question.
Answer
Field Type Free Data Warehouse Description

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

topAnswers

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

totalAnswerCount

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

answer

TextString Not Available Not Available The answer to the question.
Review
Field Type Free Data Warehouse Description

reviewId

TextString Available Available The encrypted unique identifier.

reviewerProfilePhotoUrl

TextString Not Available Available The reviewer profile photo URL

reviewerDisplayName

TextString Available Available The reviewers name

reviewReply

TextString Available Available Reply on the review

reviewReplyDate

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

starRating

NumericInteger Available Available The star rating of the review.

reviewComment

TextString Available Available The body of the review as plain text with translation into English (if applicable).
Search Keyword
Field Type Free Data Warehouse Description

searchKeyword

TextString Not Available Available The lower-cased string that the user entered.

searchThreshold

NumericInteger Not Available Available A threshold that indicates that the actual value is below this threshold.

searchVolume

NumericInteger Not Available Available The sum of the number of unique users that used the keyword in a month, aggregated for each month requested.

Frequently asked questions

1. Is it really free?

Yes! We built the free connector because we were experimenting with Google Business Profile 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 GBP 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?

No, we only have the this free GBP connector.

4. Why is the connector asking me for edit permissions?

In short, there is only one permission scope. For us to access your Google Business Profile 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. What's the difference between the free connectors and the paid GBP offering?

The free version is a Data Studio Connector that fetches data directly from Google each time you load the report, this causes limits on speed and the amount of data fields. The paid offering is a fully manage No Code Data Warehouse that fetches new data every data and stores it in a database purpose built for reporting, which allows faster speeds and increases the umber of data fields for reliable and rich reporting.