GMB Free GMB Pro Type Description

Local post search views

localPostViewsOnSearch

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

Local post call to action

localPostPhoneClicks

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

Local post call to action

postCallToAction

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

Store Code

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.

Date

date

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

Direct searches

directSearches

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

Location Name

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.

Discovery searches

discoverySearches

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

Chain (Brand) searches

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.

Maps views

viewsOnMap

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

Search views

viewsOnSearch

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

Direction actions

requestDirection

NumericInteger The number of times driving directions were requested.

Owner photo views

photosViewsMerchant

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

Customer photo views

photosViewsCustomers

NumericInteger The number of views on media items uploaded by customers.

Comment

reviewcomment

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

Created Date

date

CalendarInteger Date represented as (YYYY-MM-DD).

Location

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.

Reply

reviewReply

TextString Reply on the review.

Review Count

totalReviewCount

NumericInteger The total number of reviews in a location.

Review ID

reviewId

NumericInteger The encrypted unique identifier.

Review Replied To

No equivalent

BooleanBoolean Determines if a reply has been left, use the existence of reviewReply.

Reviewer Display Name

reviewerDisplayName

TextString The reviewer display name.

Reviewer Photo URL

reviewerProfilePhotoUrl

TextString The reviewer profile photo URL.

Star Rating

starRating

NumericInteger The star rating of the review.

Star Rating Value

No equivalent

TextString The star rating of the review as a string.

In the GMB Free connector there are some metrics that are created with calculated fields. These aggregate metrics are not part of GMB 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