Free	Data Warehouse	Type	Description
Local post search views	localPostViewsOnSearch	Integer	The number of times the local post was viewed on Google Search.
Local post call to action	localPostPhoneClicks	Integer	The number of times the call-to-action button was clicked on Google.
Local post call to action	postCallToAction	String	The URL that users are sent to when clicking through the promotion.
Store Code	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.
Date	date	Timestamp	Date represented in ISO 8601 extended format (hh:mm)
Direct searches	directSearches	Integer	The number of times resource was shown when searching for location directly
Location Name	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.
Discovery searches	discoverySearches	Integer	The number of times the resource was shown as a result of a categorical search (for example, restaurant).
Chain (Brand) searches	brandedSearches	Integer	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.
Maps views	viewsOnMap	Integer	The number of times the resource was viewed on Google Maps.
Search views	viewsOnSearch	Integer	The number of times the resource was viewed on Google Search.
Direction actions	requestDirection	Integer	The number of times driving directions were requested.
Owner photo views	photosViewsMerchant	Integer	The number of views on media items uploaded by the merchant.
Customer photo views	photosViewsCustomers	Integer	The number of views on media items uploaded by customers.
Comment	reviewcomment	String	The body of the review as plain text with markups.
Created Date	date	Integer	Date represented as (YYYY-MM-DD).
Location	locationId	String	Location ID
Reply	reviewReply	String	Reply on the review.
Review Count	totalReviewCount	Integer	The total number of reviews in a location.
Review ID	reviewId	Integer	The encrypted unique identifier.
Review Replied To	No equivalent	Boolean	Determines if a reply has been left, use the existence of reviewReply.
Reviewer Display Name	reviewerDisplayName	String	The reviewer display name.
Reviewer Photo URL	reviewerProfilePhotoUrl	String	The reviewer profile photo URL.
Star Rating	starRating	Integer	The star rating of the review.
Star Rating Value	No equivalent	String	The star rating of the review as a string.

‍

In the GBP Free connector there are some metrics that are created with calculated fields. These aggregate metrics are not part of GBP Pro but can be easily created with a formula in Data Studio.

‍

Field	Formula
Total Views	SUM(IFNULL(viewsOnSearch, 0) + IFNULL(viewsOnMap , 0))
Total Actions	SUM(IFNULL(websiteClicks, 0) + IFNULL(requestDirection, 0) + IFNULL(phoneClicks, 0))
Total Searches	SUM(IFNULL(directSearches, 0) + IFNULL(brandedSearches , 0)+ IFNULL(discoverySearches , 0))

‍

Note: Basic formulas often show 'No Data' when working with BigQuery Data Sources, so please use the above formulas as a guide to get past that issue. If you run into any issues please get in contact with support who will be happy to work through your reporting needs.

Calculated Fields in Data Studio

Within Data Studio you can choose to create a calculated field at the Data source level or chart-specific. Wherever possible we recommend to create them at the Data Source level so you can easily reuse the metric across your report without having to maintain multiple formulas. To learn more about the differences and option please see this Google article https://support.google.com/datastudio/answer/6299685

‍

Creating a chart-specific filter

Creating a data source calculated metric

‍

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.



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.

Help Center

Free Connector to Data Warehouse field comparison