Transferring your Google Business Profile 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 18 months ago up to 4 days ago | 4 days ago |
Local Post |
From 18 months ago up to 1 day ago | 1 day ago |
Media |
From 18 months ago up to 1 day ago | 1 day ago |
Media Customer |
From 18 months ago up to 1 day ago | 1 day ago |
Question |
From 18 months ago up to 1 day ago | 1 day ago |
Answer |
From 18 months ago up to 1 day ago | 1 days ago |
Location
Field | Type | Description |
---|---|---|
name |
|
Google identifier for this location in the form: accounts/{accountId}/locations/{locationId} |
locationId |
|
Location ID |
entityType |
|
Entity type |
storeCode |
|
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 |
|
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 |
|
Category that best describes the core business this location engages in. |
primaryPhone |
|
A phone number that connects to your individual business location as directly as possible. |
additionalPhones |
|
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 |
|
A precise, accurate address to describe your business location. |
additionalCategories |
|
Additional categories to describe your business. |
websiteUrl |
|
A URL for this business. |
regularHours |
|
Operating hours for the business. |
specialHours |
|
Special hours for the business. |
serviceArea |
|
Service area businesses provide their service at the customer's location. |
locationKey |
|
A collection of keys that link this business to other Google properties, such as a Google+ page and Google Maps Places. |
labels |
|
A collection of free-form strings to allow you to tag your business. |
adWordsLocationExtensions |
|
Additional information that is surfaced in AdWords. |
latlng |
|
User-provided latitude and longitude. When creating a location, this field is ignored if the provided address geocodes successfully. |
openInfo |
|
Indicates the location other information |
openInfoStatus |
|
A flag that indicates whether the location is currently open for business. |
locationState |
|
A set of booleans that reflects the state of a location. |
attributes |
|
Attributes for this location. |
metadata |
|
Additional non-user-editable information. |
languageCode |
|
The language of the location. |
priceLists |
|
Describes your business in your own voice and shares with users the unique story of your business and offerings. |
profile |
|
Describes your business in your own voice and shares with users the unique story of your business and offerings. |
relationshipData |
|
All locations and chain related to this one. |
date |
|
Date represented as YYYY-MM-DD |
dateTime |
|
Date represented in ISO 8601 extended format (hh:mm) |
followers |
|
Total number of followers for the location. |
locationAverageRating |
|
The location's average rating |
totalReviewCount |
|
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 |
|
For Jepto Use only |
directSearches |
|
The number of times resource was shown when searching for location directly |
discoverySearches |
|
The number of times the resource was shown as a result of a categorical search (for example, restaurant). |
brandedSearches |
|
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 |
|
The number of times the resource was viewed on Google Maps. |
viewsOnSearch |
|
The number of times the resource was viewed on Google Search. |
websiteClicks |
|
The number of times the website was clicked. |
phoneClicks |
|
The number of times the phone number was clicked. |
requestDirection |
|
The number of times driving directions were requested. |
photosViewsMerchant |
|
The number of views on media items uploaded by the merchant. |
photosViewsCustomers |
|
The number of views on media items uploaded by customers. |
photosCountCustomers |
|
The total number of media items that are currently live that have been uploaded by customers. |
photosCountMerchant |
|
The total number of media items that are currently live that have been uploaded by the merchant. |
totalPostViewsOnSearch |
|
The number of times all local posts were viewed on Google Search |
totalPostPhoneClicks |
|
The total number of times the call to action button was clicked on Google. |
Insight
Field | Type | Description |
---|---|---|
directSearches |
|
The number of times resource was shown when searching for location directly |
discoverySearches |
|
The number of times the resource was shown as a result of a categorical search (for example, restaurant). |
brandedSearches |
|
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 |
|
The number of times the resource was viewed on Google Maps. |
viewsOnSearch |
|
The number of times the resource was viewed on Google Search. |
websiteClicks |
|
The number of times the website was clicked. |
phoneClicks |
|
The number of times the phone number was clicked. |
requestDirection |
|
The number of times driving directions were requested. |
photosViewsMerchant |
|
The number of views on media items uploaded by the merchant. |
photosViewsCustomers |
|
The number of views on media items uploaded by the merchant. |
photosCountCustomers |
|
The total number of media items that are currently live that have been uploaded by customers. |
photosCountMerchant |
|
The total number of media items that are currently live that have been uploaded by the merchant. |
totalPostViewsOnSearch |
|
The number of times all local posts were viewed on Google Search |
totalPostPhoneClicks |
|
The total number of times the call to action button was clicked on Google. |
Reviews
Field | Type | Description |
---|---|---|
reviewId |
|
The encrypted unique identifier. |
reviewerProfilePhotoUrl |
|
The reviewer profile photo URL |
reviewerDisplayName |
|
The reviewer display name |
reviewReply |
|
Reply on the review |
starRating |
|
The star rating of the review. |
reviewComment |
|
The body of the review as plain text with markups. |
Media
Field | Type | Description |
---|---|---|
mediaFormat |
|
The format of this media item. |
mediaLocationAssociation |
|
Describes how this media item is connected to its location. |
mediaGoogleUrl |
|
Google-hosted URL for this media item. |
mediaThumbnailUrl |
|
Where provided, the URL of a thumbnail image for this media item. |
mediaDimensions |
|
The dimensions (width and height) in pixels. |
mediaInsights |
|
Statistics for this media item. |
mediaDescription |
|
Description for this media item. |
Media Customer
Field | Type | Description |
---|---|---|
mediaCustomerMediaFormat |
|
The format of this media customer item. |
mediaCustomerLocationAssociation |
|
Describes how this media item is connected to its location. |
mediaCustomerGoogleUrl |
|
Google-hosted URL for media customer item. |
mediaCustomerThumbnailUrl |
|
Where provided, the URL of a thumbnail image for media customer item. |
mediaCustomerDimensions |
|
The dimensions (width and height) in pixels. |
mediaCustomerInsights |
|
Statistics for media customer item. |
mediaCustomerDescription |
|
Description for media customer item. |
mediaCustomerAttribution |
|
Attribution information for customer media items. |
mediaCustomerSourceUrl |
|
A publicly accessible URL where the media item can be retrieved from. |
mediaCustomerDataRef |
|
A reference to media item binary data as obtained by the media. |
Local Post
Field | Type | Description |
---|---|---|
postId |
|
Google identifier for this post in the form: accounts/{accountId}/locations/{locationId}/localPosts/{postId} |
postLanguageCode |
|
The language of the local post. |
postSummary |
|
Description/body of the local post. |
postCallToAction |
|
The URL that users are sent to when clicking through the promotion. |
postEventTitle |
|
Title of the post event. |
postEventDetails |
|
Event information. |
postState |
|
The state of the post, indicating what part of its lifecycle it is in. |
postMedia |
|
The media associated with the post. |
postMediaUrl |
|
The media URL associated with the post. |
postSearchUrl |
|
The link to the local post in Google search. |
postTopicType |
|
The topic type of the post: standard, event, offer, or alert. |
postAlertType |
|
The type of alert the post is created for. |
postOffer |
|
Additional data for offer posts. |
postPublishDate |
|
Time of the creation of the post. |
Question
Field | Type | Description |
---|---|---|
questionUpvoteCount |
|
The number of upvotes for the question. |
answerUpvoteCount |
|
The number of upvotes for the answer. |
questionAuthorProfilePhotoUrl |
|
Photo URL of the author of the question |
question |
|
The content of the question. |
questionAuthorDisplayName |
|
The author of the of question. |
Answer
Field | Type | Description |
---|---|---|
answerAuthorDisplayName |
|
Display name of the author of the answer |
answerAuthorProfilePhotoUrl |
|
Photo URL of the author of the answer |
topAnswers |
|
A list of answers to the question, sorted by upvotes. |
totalAnswerCount |
|
The total number of answers posted for this question. |
answer |
|
The answer to the question. |
Review
Field | Type | Description |
---|---|---|
reviewId |
|
The encrypted unique identifier. |
reviewerProfilePhotoUrl |
|
The reviewer profile photo URL |
reviewerDisplayName |
|
The reviewer display name |
reviewReply |
|
Reply on the review |
reviewReplyDate |
|
Date represented in ISO 8601 extended format (hh:mm) |
starRating |
|
The star rating of the review. |
reviewComment |
|
The body of the review as plain text with markups. |
Notes
- 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 Google Business Profile location are due to the way Google can look at other factors to determine the score, as outlined in their help article here.
Comments
Comments | Slack