Introduction

Datasources and destinations

Fields listing for Google My Business

Account ID
Get the Ad Account Id.
Field IDaccount/id
TypeTEXT
Data Typedimension
Account Name
Get the Account Name.
Field IDaccount/name
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Location ID
Google identifier for this location.
Field IDlocation/id
TypeTEXT
Data Typedimension
Language Code
The language of the location.
Field IDlocation/languageCode
TypeTEXT
Data Typedimension
Store Code
External identifier for this location, which must be unique within a given account. This is a means of associating the location with your own records.
Field IDlocation/storeCode
TypeTEXT
Data Typedimension
Location name
Name of the business
Field IDlocation/title
TypeTEXT
Data Typedimension
Primary phone
Primary phone number of the business.
Field IDlocation/primary_phone
TypeTEXT
Data Typedimension
Additional Phones Number
Up to two phone numbers (mobile or landline, no fax) at which your business can be called, in addition to your primary phone number.
Field IDlocation/additional_phone_number
TypeTEXT
Data Typedimension
Primary Category
Category that best describes the core business this location engages in.
Field IDlocation/primary_category
TypeTEXT
Data Typedimension
Additional Categories
Additional categories to describe your business.
Field IDlocation/additional_categories
TypeTEXT
Data Typedimension
Region Code
CLDR region code of the country/region of the address.
Field IDlocation/address_regionCode
TypeTEXT
Data Typedimension
Address Language Code
BCP-47 language code of the contents of this address (if known).
Field IDlocation/address_languageCode
TypeTEXT
Data Typedimension
Postal Code
Postal code of the address.
Field IDlocation/address_postalCode
TypeTEXT
Data Typedimension
Sorting Code
Additional, country-specific, sorting code.
Field IDlocation/address_sortingCode
TypeTEXT
Data Typedimension
Administrative Area
Generally refers to the city/town portion of the address.
Field IDlocation/address_administrativeArea
TypeTEXT
Data Typedimension
Sublocality
Sublocality of the address.
Field IDlocation/address_sublocality
TypeTEXT
Data Typedimension
Locality
Locality of the address.
Field IDlocation/address_locality
TypeTEXT
Data Typedimension
Addresses Lines
Unstructured address lines describing the lower levels of the address
Field IDlocation/address_addressLines
TypeTEXT
Data Typedimension
Recipients
The recipient at the address.
Field IDlocation/address_recipients
TypeTEXT
Data Typedimension
Organization
The name of the organization at the address.
Field IDlocation/address_organization
TypeTEXT
Data Typedimension
Website URL
A URL for this business
Field IDlocation/websiteUri
TypeURL
Data Typedimension
Labels
A collection of free-form strings to allow you to tag your business.
Field IDlocation/labels
TypeTEXT
Data Typedimension
Adwords Location Extensions
Additional information that is surfaced in AdWords.
Field IDlocation/adWordsLocationExtensions
TypeTEXT
Data Typedimension
Latitude
Latitude of the location
Field IDlocation/latitude
TypeTEXT
Data Typedimension
Longitude
Longitude of the location
Field IDlocation/longitude
TypeTEXT
Data Typedimension
Description
Description of the location
Field IDlocation/description
TypeTEXT
Data Typedimension
Place ID
If this location appears on Google Maps, this field is populated with the place ID for the location.
Field IDlocation/placeId
TypeTEXT
Data Typedimension
Maps URL
A link to the location on Maps.
Field IDlocation/mapsUri
TypeURL
Data Typedimension
Review URI
A link to the page on Google Search where a customer can leave a review for the location.
Field IDlocation/reviewUri
TypeURL
Data Typedimension
Post ID
The ID of the local post.
Field IDpost/post_id
TypeTEXT
Data Typedimension
Post Language Code
The language of the local post.
Field IDpost/post_language_code
TypeTEXT
Data Typedimension
Post Summary
Description/body of the local post.
Field IDpost/post_summary
TypeTEXT
Data Typedimension
Post Call To Action / Action Type
The type of action that will be performed.
Field IDpost/post_call_to_action_type
TypeTEXT
Data Typedimension
Post Call To Action / URL
The URL the user will be directed to upon clicking. This field should be left unset for Call CTA.
Field IDpost/post_call_to_action_url
TypeURL
Data Typedimension
Post Create Time
Time of the creation of the post.
Field IDpost/post_create_time
TypeYEAR_MONTH_DAY
Data Typedimension
Post Update Time
Time of the last modification of the post made by the user.
Field IDpost/post_update_time
TypeYEAR_MONTH_DAY
Data Typedimension
Post Event Title
Name of the event.
Field IDpost/post_event_title
TypeTEXT
Data Typedimension
Post Event Start Time
Event start time.
Field IDpost/post_event_start_time
TypeYEAR_MONTH_DAY
Data Typedimension
Post Event End Time
Event End time.
Field IDpost/post_event_end_time
TypeYEAR_MONTH_DAY
Data Typedimension
Post State
The state of the post, indicating what part of its lifecycle it is in.
Field IDpost/post_state
TypeTEXT
Data Typedimension
Post Search URL
The link to the local post in Google search. This link can be used to share the post via social media, email, text, etc.
Field IDpost/post_search_url
TypeURL
Data Typedimension
Post Topic Type
The topic type of the post: standard, event, offer, or alert.
Field IDpost/post_topic_type
TypeTEXT
Data Typedimension
Post Alert Type
The type of alert the post is created for. This field is only applicable for posts of topicType Alert, and behaves as a sub-type of Alerts.
Field IDpost/post_alert_type
TypeTEXT
Data Typedimension
Post Offer Coupon Code
Offer code that is usable in store or online.
Field IDpost/post_offer_coupon_code
TypeTEXT
Data Typedimension
Post Offer Redeem Online URL
Online link to redeem offer.
Field IDpost/post_offer_redeem_online_url
TypeURL
Data Typedimension
Post Offer Terms Conditions
Offer terms and conditions.
Field IDpost/post_terms_conditions
TypeTEXT
Data Typedimension
Post Media ID
The post media ID.
Field IDpost_media/post_media_id
TypeTEXT
Data Typedimension
Post Media Format
The format of this media item.
Field IDpost_media/post_media_format
TypeTEXT
Data Typedimension
Post Media Google URL
Google-hosted URL for this media item.
Field IDpost_media/post_media_google_url
TypeURL
Data Typedimension
Post Media Thumbnail URL
Where provided, the URL of a thumbnail image for this media item.
Field IDpost_media/post_media_thumbnail_url
TypeTEXT
Data Typedimension
Post Media Create Time
Creation time of this media item.
Field IDpost_media/post_media_create_time
TypeYEAR_MONTH_DAY
Data Typedimension
Post Media Width
Width of the media item, in pixels.
Field IDpost_media/post_media_width
TypeTEXT
Data Typedimension
Post Height Width
Height of the media item, in pixels.
Field IDpost_media/post_media_height
TypeTEXT
Data Typedimension
Post Media View Count
The number of times the media item has been viewed.
Field IDpost_media/post_media_view_count
TypeNUMBER
Data Typedimension
Post Media Description
Description for this media item.
Field IDpost_media/post_media_description
TypeTEXT
Data Typedimension
Post Media Source URL
A publicly accessible URL where the media item can be retrieved from.
Field IDpost_media/post_media_url
TypeURL
Data Typedimension
Review ID
The review ID
Field IDreview/review_id
TypeTEXT
Data Typedimension
Reviewer Photo
The profile photo link of the reviewer. Only populated if isAnonymous is false.
Field IDreview/reviewer_photoUrl
TypeTEXT
Data Typedimension
Reviewer Name
The name of the reviewer. Only populated if isAnonymous is false.
Field IDreview/reviewer_displayName
TypeTEXT
Data Typedimension
Reviewer Is Anonymous
Indicates whether the reviewer has opted to remain anonymous.
Field IDreview/reviewer_isAnonymous
TypeTEXT
Data Typedimension
Star Rating
The star rating of the review.
Field IDreview/starRating
TypeNUMBER
Data Typedimension
Text review
The body of the review as plain text with markups.
Field IDreview/comment
TypeTEXT
Data Typedimension
Review Created Time
The timestamp for when the review was written.
Field IDreview/createTime
TypeYEAR_MONTH_DAY
Data Typedimension
Review Updated Time
The timestamp for when the review was last modified.
Field IDreview/updateTime
TypeYEAR_MONTH_DAY
Data Typedimension
Reply Text
The body of the reply as plain text with markups. The maximum length is 4096 bytes.
Field IDreview/reply_comment
TypeTEXT
Data Typedimension
Reply Updated Time
Output only. The timestamp for when the reply was last modified.
Field IDreview/reply_updateTime
TypeYEAR_MONTH_DAY
Data Typedimension
Average Rating Review
The average star rating of all reviews for this location on a scale of 1 to 5, where 5 is the highest rating.
Field IDaverageRating
TypeNUMBER
Data Typemetric
Total Review Count
The total number of reviews for this location.
Field IDtotalReviewCount
TypeNUMBER
Data Typemetric
(deprecated) Total search impressions
The total number of times the resource was shown as a result of a search.
Field IDqueries_total
TypeNUMBER
Data Typemetric
(deprecated) Direct search impressions
The number of times the resource was shown when searching for the location directly.
Field IDqueries_direct
TypeNUMBER
Data Typemetric
(deprecated) Discovery search impressions
The number of times the resource was shown as a result of a categorical search.
Field IDqueries_indirect
TypeNUMBER
Data Typemetric
(deprecated) Branded search impressions
The number of times a resource was shown as a result of a search for the chain it belongs to.
Field IDqueries_chain
TypeNUMBER
Data Typemetric
Total views
The total number of times the resource was viewer.
Field IDviews_total
TypeNUMBER
Data Typemetric
Views on Maps
The number of times the resource was viewed on Google Maps.
Field IDviews_maps
TypeNUMBER
Data Typemetric
Views on Search
The number of times the resource was viewed on Google Search.
Field IDviews_search
TypeNUMBER
Data Typemetric
Total actions
Total number of times customers have taken action on this listing.
Field IDactions_total
TypeNUMBER
Data Typemetric
Website visits
The number of times the website was clicked.
Field IDactions_website
TypeNUMBER
Data Typemetric
Phone calls
The number of times the phone number was clicked.
Field IDactions_phone
TypeNUMBER
Data Typemetric
Directions requests
The number of times directions were requested.
Field IDactions_driving_directions
TypeNUMBER
Data Typemetric
(deprecated) Photo views (merchant)
TThe number of views on photos uploaded by the merchant.
Field IDphoto_views_merchant
TypeNUMBER
Data Typemetric
(deprecated) Photo views (customers)
The number of views on photos uploaded by customers.
Field IDphoto_views_customers
TypeNUMBER
Data Typemetric
(deprecated) Total photo views
The total number of photo views.
Field IDphoto_views_total
TypeNUMBER
Data Typemetric
(deprecated) Photos uploaded (merchant)
The total number of photos that are currently live that have been uploaded by the merchant.
Field IDphoto_count_merchant
TypeNUMBER
Data Typemetric
(deprecated) Photos uploaded (customers)
The total number of photos that are currently live that have been uploaded by customers.
Field IDphoto_count_customers
TypeNUMBER
Data Typemetric
(deprecated) Total photos uploaded
The total number of photos that are currently live.
Field IDphoto_count_total
TypeNUMBER
Data Typemetric
(deprecated) Post views
The number of times the local post was viewed on Google Search.
Field IDlocal_post_views
TypeNUMBER
Data Typemetric
Post actions
The number of times the call to action button was clicked.
Field IDlocal_post_actions
TypeNUMBER
Data Typemetric
Question ID
Question ID
Field IDquestion/question_id
TypeTEXT
Data Typedimension
Question Author Photo
The profile photo link of the reviewer. Only populated if isAnonymous is false.
Field IDquestion/question_photoUrl
TypeTEXT
Data Typedimension
Question Author Name
The name of the reviewer. Only populated if isAnonymous is false.
Field IDquestion/question_displayName
TypeTEXT
Data Typedimension
Question Author Is Anonymous
Indicates whether the reviewer has opted to remain anonymous.
Field IDquestion/question_isAnonymous
TypeTEXT
Data Typedimension
Question Upvote Count
The number of upvotes for the question..
Field IDquestion/upvoteCount
TypeNUMBER
Data Typedimension
Question Text
The text of the question.
Field IDquestion/text
TypeTEXT
Data Typedimension
Question Created Time
The timestamp for when the review was written.
Field IDquestion/createTime
TypeYEAR_MONTH_DAY
Data Typedimension
Question Updated Time
The timestamp for when the review was last modified.
Field IDquestion/updateTime
TypeYEAR_MONTH_DAY
Data Typedimension
Total Answer Count
Output only. The total number of answers posted for this question.
Field IDquestion/totalAnswerCount
TypeNUMBER
Data Typedimension
Answer ID
The answer ID.
Field IDanswer/answer_id
TypeTEXT
Data Typedimension
Answer Author Photo
The profile photo link of the reviewer. Only populated if isAnonymous is false.
Field IDanswer/answer_photoUrl
TypeTEXT
Data Typedimension
Answer Author Name
The name of the reviewer. Only populated if isAnonymous is false.
Field IDanswer/answer_displayName
TypeTEXT
Data Typedimension
Answer Author Is Anonymous
Indicates whether the reviewer has opted to remain anonymous.
Field IDanswer/answer_isAnonymous
TypeTEXT
Data Typedimension
Answer Upvote Count
The number of upvotes for the answer.
Field IDanswer/upvoteCount
TypeNUMBER
Data Typedimension
Answer Text
The text of the answer.
Field IDanswer/text
TypeTEXT
Data Typedimension
Answer Created Time
The timestamp for when the review was written.
Field IDanswer/createTime
TypeYEAR_MONTH_DAY
Data Typedimension
Answer Updated Time
The timestamp for when the review was last modified.
Field IDanswer/updateTime
TypeYEAR_MONTH_DAY
Data Typedimension
Impression on Google Search on Desktop
Business impressions on Google Search on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression.
Field IDbusiness_impressions_desktop_search
TypeNUMBER
Data Typemetric
Impression on Google Search on Mobile
Business impressions on Google Search on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression.
Field IDbusiness_impressions_mobile_search
TypeNUMBER
Data Typemetric
Impression on Google Maps on Desktop
Business impressions on Google Maps on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression.
Field IDbusiness_impressions_desktop_maps
TypeNUMBER
Data Typemetric
Impression on Google Maps on Mobile
Business impressions on Google Maps on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression.
Field IDbusiness_impressions_mobile_maps
TypeNUMBER
Data Typemetric
Conversations
The number of message conversations received on the business profile.
Field IDbusiness_conversations
TypeNUMBER
Data Typemetric
Bookings
The number of bookings received from the business profile.
Field IDbusiness_bookings
TypeNUMBER
Data Typemetric
Food Orders
The number of food orders received from the business profile.
Field IDbusiness_food_orders
TypeNUMBER
Data Typemetric
Food Menu Clicks
The number of clicks to view or interact with the menu content on the business profile. Multiple clicks by a unique user within a single day are counted as 1.
Field IDbusiness_food_menu_clicks
TypeNUMBER
Data Typemetric
Search terms
The lower-cased string that the user entered.
Field IDkeyword/keyword
TypeTEXT
Data Typedimension
Search terms Impression
The sum of the number of unique users that used the keyword.
Field IDkeyword_impression
TypeNUMBER
Data Typemetric
Actions Name
The action name for the count.
Field IDaction/actions
TypeTEXT
Data Typedimension
Actions
The action value for the count.
Field IDaction_value
TypeNUMBER
Data Typemetric
Search terms Impression Estimated
The sum of the number of unique users that used the keyword including the threshold.
Field IDkeyword_impression_estimated
TypeNUMBER
Data Typemetric
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Regular Hours
The language of the location.
Field IDlocation/regularHoursString
TypeTEXT
Data Typedimension
Regular Hours (JSON)
The language of the location.
Field IDlocation/regularHoursJson
TypeTEXT
Data Typedimension
Special Hours
The language of the location.
Field IDlocation/specialHoursString
TypeTEXT
Data Typedimension
Special Hours (JSON)
The language of the location.
Field IDlocation/specialHoursJson
TypeTEXT
Data Typedimension
Service Arera Business Type
The service area business type.
Field IDlocation/serviceAreaBusinessType
TypeTEXT
Data Typedimension
Service Area Region Code
The service area region code.
Field IDlocation/serviceAreaRegionCode
TypeTEXT
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension