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.

Entity date ranges for syncing
Performance
Location
Media
Media (Customer)
Local Posts
Questions
Answers
Google Reviews
Search Keywords
Deprecated Fields
Notes

‍

Data Studio Report Template - Need some inspiration for reporting? 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 day ago
Search Keyword	From last month up to 36 months ago	1st day of the month for the previous month
Metric Performance	From 18 months ago up to 4 days ago	4 days ago

‍

Performance

Field	Type	Description
mapsImpressionsDesktop	Integer	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	Integer	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	Integer	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	Integer	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	Integer	The number of message conversations received on the business profile.
directionRequests	Integer	The number of times a direction request was requested to the business location.
callClicks	Integer	The number of times the business profile call button was clicked.
webClicks	Integer	The number of times the business profile website was clicked.
bookings	Integer	The number of bookings received from the business profile.
foodOrders	Integer	The number of food orders received from the business profile.
desktopImpressions	Integer	Impressions on Google Search and Maps on Desktop devices. Multiple impressions by a unique user within a single day are counted once.
mobileImpressions	Integer	Impressions on Google Search and Maps on Mobile devices. Multiple impressions by a unique user within a single day are counted once.
searchImpressions	Integer	Impressions on Google Search on Mobile and Desktop devices. Multiple impressions by a unique user within a single day are counted once.
mapsImpressions	Integer	Impressions on Google Maps on Mobile and Desktop devices. Multiple impressions by a unique user within a single day are counted once.

‍

Location

Field	Type	Description
name	String	Google identifier for this location in the form: accounts/{accountId}/locations/{locationId}
locationId	String	Location ID
entityType	String	Entity type
storeCode	String	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	String	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	String	Category that best describes the core business this location engages in.
primaryPhone	String	A phone number that connects to your individual business location as directly as possible.
additionalPhones	String	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	String	A precise, accurate address to describe your business location.
additionalCategories	String	Additional categories to describe your business.
websiteUrl	String	A URL for this business.
regularHours	String	Operating hours for the business.
specialHours	String	Special hours for the business.
serviceArea	String	Service area businesses provide their service at the customer's location.
labels	String	A collection of free-form strings to allow you to tag your business.
adWordsLocationExtensions	String	Additional information that is surfaced in AdWords.
latlng	String	User-provided latitude and longitude. When creating a location, this field is ignored if the provided address geocodes successfully.
openInfo	String	Indicates the location other information
openInfoStatus	String	A flag that indicates whether the location is currently open for business.
attributes	String	Attributes for this location.
metadata	String	Additional non-user-editable information.
languageCode	String	The language of the location.
priceLists	String	Describes your business in your own voice and shares with users the unique story of your business and offerings.
profile	String	Describes your business in your own voice and shares with users the unique story of your business and offerings.
relationshipData	String	All locations and chain related to this one.
date	Date	Date represented as YYYY-MM-DD
dateTime	Timestamp	Date represented in ISO 8601 extended format (hh:mm)
followers	String	Total number of followers for the location.
locationAverageRating	Numeric	The location's average rating
totalReviewCount	String	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	String	For Jepto Use only

‍

Media

Field	Type	Description
mediaFormat	String	The format of this media item.
mediaLocationAssociation	String	Describes how this media item is connected to its location.
mediaGoogleUrl	String	Google-hosted URL for this media item.
mediaThumbnailUrl	String	Where provided, the URL of a thumbnail image for this media item.
mediaDimensions	String	The dimensions (width and height) in pixels.
mediaDescription	String	Description for this media item.

‍

Media Customer

Field	Type	Description
mediaCustomerMediaFormat	String	The format of this media customer item.
mediaCustomerLocationAssociation	String	Describes how this media item is connected to its location.
mediaCustomerGoogleUrl	String	Google-hosted URL for media customer item.
mediaCustomerThumbnailUrl	String	Where provided, the URL of a thumbnail image for media customer item.
mediaCustomerDimensions	String	The dimensions (width and height) in pixels.
mediaCustomerDescription	String	Description for media customer item.
mediaCustomerAttribution	String	Attribution information for customer media items.
mediaCustomerSourceUrl	String	A publicly accessible URL where the media item can be retrieved from.
mediaCustomerDataRef	String	A reference to media item binary data as obtained by the media.

‍

Local Post

Field	Type	Description
postId	String	Google identifier for this post in the form: accounts/{accountId}/locations/{locationId}/localPosts/{postId}
postLanguageCode	String	The language of the local post.
postSummary	String	Description/body of the local post.
postCallToAction	String	The URL that users are sent to when clicking through the promotion.
postEventTitle	String	Title of the post event.
postEventDetails	String	Event information.
postState	String	The state of the post, indicating what part of its lifecycle it is in.
postMedia	String	The media associated with the post.
postMediaUrl	String	The media URL associated with the post.
postSearchUrl	String	The link to the local post in Google search.
postTopicType	String	The topic type of the post: standard, event, offer, or alert.
postAlertType	String	The type of alert the post is created for.
postOffer	String	Additional data for offer posts.
postPublishDate	Timestamp	Time of the creation of the post.

‍

Question

Field	Type	Description
questionUpvoteCount	Integer	The number of upvotes for the question.
answerUpvoteCount	Integer	The number of upvotes for the answer.
questionAuthorProfilePhotoUrl	String	Photo URL of the author of the question
question	String	The content of the question.
questionAuthorDisplayName	String	The author of the of question.

‍

Answer

Field	Type	Description
answerAuthorDisplayName	String	Display name of the author of the answer
answerAuthorProfilePhotoUrl	String	Photo URL of the author of the answer
topAnswers	String	A list of answers to the question, sorted by upvotes.
totalAnswerCount	Numeric	The total number of answers posted for this question.
answer	String	The answer to the question.

‍

Review

Field	Type	Description
reviewId	String	The encrypted unique identifier.
reviewerProfilePhotoUrl	String	The reviewer profile photo URL
reviewerDisplayName	String	The reviewer display name
reviewReply	String	Reply on the review
reviewReplyDate	Timestamp	Date represented in ISO 8601 extended format (hh:mm)
starRating	Integer	The star rating of the review.
reviewComment	String	The body of the review as plain text with markups.
updateTime	Timestamp	Date represented in ISO 8601 extended format (hh:mm)

‍

Search Keyword

Note: This data is only available at the monthly level. If you are using Google Data Studio to display this data please ensure that the date range of your chart covers the first day of the month you wish to show data for.

Field	Type	Description
searchKeyword	String	The lower-cased string that the user entered.
searchThreshold	Integer	A threshold that indicates that the actual value is below this threshold.
searchVolume	Integer	The sum of the number of unique users that used the keyword in a month, aggregated for each month requested.

‍

Deprecated Fields

These fields have been removed from the data source so they are no longer supported, although they may be available in your Data Warehouse it is not recommended that they be used for reporting as we cannot verify their accuracy.

Field	Replacement Field	Discontinuation Date
directSearches	none	Feb 2023
discoverySearches	none	Feb 2023
brandedSearches	none	Feb 2023
viewsOnMap	mapsImpressionsDesktop mapsImpressionsMobile	Feb 2023
viewsOnSearch	searchImpressionsDesktop searchImpressionsMobile	Feb 2023
websiteClicks	webClicks	Feb 2023
phoneClicks	callClicks	Feb 2023
requestDirection	directionRequests	Feb 2023
photosViewsMerchant	none	Feb 2023
photosViewsCustomers	none	Feb 2023
photosCountCustomers	none	Feb 2023
photosCountMerchant	none	Feb 2023
totalPostViewsOnSearch	none	Feb 2023
totalPostPhoneClicks	none	Feb 2023
locationState	metadata	Feb 2023
locationKey	metadata	Feb 2023
priceLists	FoodMenus ServiceLists	Feb 2023
mediaInsights	none	Feb 2023
mediaCustomerInsights	none	Feb 2023

‍

Data Source 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.

‍

Was this article helpful?



Nice one!

Thanks a lot for your feedback! If you’d like a member of our support team to respond to you, please send a message here



Please try again

Oops! Something went wrong while submitting the form.

