Transferring your GMB data into Google Big Query is quick and hassle-free. To make analyzing easy in Data Studio the data is broken down into entities in a single table. Each entity represents a type of data.

The process of moving your data into Big Query begins by fetching your historic data, with the timeframes of each entity shown below. After this a daily update is performed, some entities have a delay to when new data is available and is also shown in the table below.

Data Studio Report Template -To make it easy to get started, copy this template https://datastudio.google.com/reporting/3006aaf4-50bb-4d1e-967c-560de2e9516a

Entity date ranges for syncing

Entity Historic Data Period Daily Update Schedule

Review

From 96 months ago up to 1 day ago 1 day ago

Insight

From 17 months ago up to 4 days ago 4 days ago

Local Post

From 17 months ago up to 1 day ago 1 day ago

Media

From 17 months ago up to 1 day ago 1 day ago

Media Customer

From 17 months ago up to 1 day ago 1 day ago

Question

From 17 months ago up to 1 day ago 1 day ago

Answer

From 17 months ago up to 1 day ago 1 days ago


Review

Field Type Description

name

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

locationId

TextString Location ID

entityType

TextString Entity type

storeCode

TextString 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 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 Category that best describes the core business this location engages in.

primaryPhone

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

additionalPhones

TextString 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 A precise, accurate address to describe your business location.

additionalCategories

TextString Additional categories to describe your business.

websiteUrl

TextString A URL for this business.

regularHours

TextString Operating hours for the business.

specialHours

TextString Special hours for the business.

serviceArea

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

locationKey

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

labels

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

adWordsLocationExtensions

TextString Additional information that is surfaced in AdWords.

latlng

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

openInfo

TextString Indicates the location other information

openInfoStatus

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

locationState

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

attributes

TextString Attributes for this location.

metadata

TextString Additional non-user-editable information.

languageCode

TextString The language of the location.

priceLists

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

profile

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

relationshipData

TextString All locations and chain related to this one.

date

CalendarDate Date represented as YYYY-MM-DD

followers

TextString Total number of followers for the location.

locationAverageRating

NumericNumeric The location's average rating

totalReviewCount

TextString The total number of reviews in a location

Insight

Field Type Description

directSearches

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

discoverySearches

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

brandedSearches

NumericInteger 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 The number of times the resource was viewed on Google Maps.

viewsOnSearch

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

websiteClicks

NumericInteger The number of times the website was clicked.

phoneClicks

NumericInteger The number of times the phone number was clicked.

requestDirection

NumericInteger The number of times driving directions were requested.

photosViewsMerchant

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

photosViewsCustomers

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

photosCountCustomers

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

photosCountMerchant

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

totalPostViewsOnSearch

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

totalPostPhoneClicks

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

Media

Field Type Description

mediaFormat

TextString The format of this media item.

mediaLocationAssociation

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

mediaGoogleUrl

TextString Google-hosted URL for this media item.

mediaThumbnailUrl

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

mediaDimensions

TextString The dimensions (width and height) in pixels.

mediaInsights

TextString Statistics for this media item.

mediaDescription

TextString Description for this media item.

Media Customer

Field Type Description

mediaCustomerMediaFormat

TextString The format of this media customer item.

mediaCustomerLocationAssociation

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

mediaCustomerGoogleUrl

TextString Google-hosted URL for media customer item.

mediaCustomerThumbnailUrl

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

mediaCustomerDimensions

TextString The dimensions (width and height) in pixels.

mediaCustomerInsights

TextString Statistics for media customer item.

mediaCustomerDescription

TextString Description for media customer item.

mediaCustomerAttribution

TextString Attribution information for customer media items.

mediaCustomerSourceUrl

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

mediaCustomerDataRef

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

Local Post

Field Type Description

postLanguageCode

TextString The language of the local post.

postSummary

TextString Description/body of the local post.

postCallToAction

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

postEventTitle

TextString Title of the post event.

postEventDetails

TextString Event information.

postState

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

postMedia

TextString The media associated with the post.

postMediaUrl

TextString The media URL associated with the post.

postSearchUrl

TextString The link to the local post in Google search.

postTopicType

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

postAlertType

TextString The type of alert the post is created for.

postOffer

TextString Additional data for offer posts.

localPostViewsOnSearch

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

localPostPhoneClicks

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

Question

Field Type Description

questionUpvoteCount

NumericInteger The number of upvotes for the question.

answerUpvoteCount

NumericInteger The number of upvotes for the answer.

questionAuthorDisplayName

TextString The author of the of question

answerAuthorDisplayName

TextString Display name of the author of the answer

answerAuthorProfilePhotoUrl

TextString Photo URL of the author of the answer

questionAuthorProfilePhotoUrl

TextString Photo URL of the author of the question

question

TextString Question

Answer

Field Type Description

topAnswers

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

totalAnswerCount

NumericNumeric The total number of answers posted for this question.

answer

TextString The answer to the question.

reviewId

TextString The encrypted unique identifier.

reviewerProfilePhotoUrl

TextString The reviewer profile photo URL

reviewerDisplayName

TextString The reviewer display name

reviewReply

TextString Reply on the review

starRating

NumericInteger The star rating of the review.

reviewComment

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

locationAverageRating - Historic data is calculated by dividing the review scores by the number of total reviews for each day. From the day the pipeline is setup and moving forward, the average rating is taken from the API. In rare cases there may be discrepancies between the calculated value of the average rating and the rating shown on the GMB location are due to the way Google can look at other factors to determine the score, as outlined in their help article here.