Introduction

Datasources and destinations

Fields listing for Google My Business

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

31 metrics105 dimensions

136 fields

All fields
FieldDetails
(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
MetricNUMBER
(deprecated) Direct search impressions
The number of times the resource was shown when searching for the location directly.
Field IDqueries_direct
MetricNUMBER
(deprecated) Discovery search impressions
The number of times the resource was shown as a result of a categorical search.
Field IDqueries_indirect
MetricNUMBER
(deprecated) Photo views (customers)
The number of views on photos uploaded by customers.
Field IDphoto_views_customers
MetricNUMBER
(deprecated) Photo views (merchant)
TThe number of views on photos uploaded by the merchant.
Field IDphoto_views_merchant
MetricNUMBER
(deprecated) Photos uploaded (customers)
The total number of photos that are currently live that have been uploaded by customers.
Field IDphoto_count_customers
MetricNUMBER
(deprecated) Photos uploaded (merchant)
The total number of photos that are currently live that have been uploaded by the merchant.
Field IDphoto_count_merchant
MetricNUMBER
(deprecated) Post views
The number of times the local post was viewed on Google Search.
Field IDlocal_post_views
MetricNUMBER
(deprecated) Total photo views
The total number of photo views.
Field IDphoto_views_total
MetricNUMBER
(deprecated) Total photos uploaded
The total number of photos that are currently live.
Field IDphoto_count_total
MetricNUMBER
(deprecated) Total search impressions
The total number of times the resource was shown as a result of a search.
Field IDqueries_total
MetricNUMBER
Account ID
Get the Ad Account Id.
Field IDaccount/id
DimensionTEXT
Account Name
Get the Account Name.
Field IDaccount/name
DimensionTEXT
Actions
The action value for the count.
Field IDaction_value
MetricNUMBER
Actions Name
The action name for the count.
Field IDaction/actions
DimensionTEXT
Additional Categories
Additional categories to describe your business.
Field IDlocation/additional_categories
DimensionTEXT
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
DimensionTEXT
Address Language Code
BCP-47 language code of the contents of this address (if known).
Field IDlocation/address_languageCode
DimensionTEXT
Addresses Lines
Unstructured address lines describing the lower levels of the address
Field IDlocation/address_addressLines
DimensionTEXT
Administrative Area
Generally refers to the city/town portion of the address.
Field IDlocation/address_administrativeArea
DimensionTEXT
Adwords Location Extensions
Additional information that is surfaced in AdWords.
Field IDlocation/adWordsLocationExtensions
DimensionTEXT
Answer Author Is Anonymous
Indicates whether the reviewer has opted to remain anonymous.
Field IDanswer/answer_isAnonymous
DimensionTEXT
Answer Author Name
The name of the reviewer. Only populated if isAnonymous is false.
Field IDanswer/answer_displayName
DimensionTEXT
Answer Author Photo
The profile photo link of the reviewer. Only populated if isAnonymous is false.
Field IDanswer/answer_photoUrl
DimensionTEXT
Answer Created Time
The timestamp for when the review was written.
Field IDanswer/createTime
DimensionYEAR_MONTH_DAY
Answer ID
The answer ID.
Field IDanswer/answer_id
DimensionTEXT
Answer Text
The text of the answer.
Field IDanswer/text
DimensionTEXT
Answer Updated Time
The timestamp for when the review was last modified.
Field IDanswer/updateTime
DimensionYEAR_MONTH_DAY
Answer Upvote Count
The number of upvotes for the answer.
Field IDanswer/upvoteCount
DimensionNUMBER
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
MetricNUMBER
Bookings
The number of bookings received from the business profile.
Field IDbusiness_bookings
MetricNUMBER
Conversations
The number of message conversations received on the business profile.
Field IDbusiness_conversations
MetricNUMBER
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Description
Description of the location
Field IDlocation/description
DimensionTEXT
Directions requests
The number of times directions were requested.
Field IDactions_driving_directions
MetricNUMBER
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
MetricNUMBER
Food Orders
The number of food orders received from the business profile.
Field IDbusiness_food_orders
MetricNUMBER
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
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
MetricNUMBER
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
MetricNUMBER
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
MetricNUMBER
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
MetricNUMBER
Labels
A collection of free-form strings to allow you to tag your business.
Field IDlocation/labels
DimensionTEXT
Language Code
The language of the location.
Field IDlocation/languageCode
DimensionTEXT
Latitude
Latitude of the location
Field IDlocation/latitude
DimensionTEXT
Locality
Locality of the address.
Field IDlocation/address_locality
DimensionTEXT
Location ID
Google identifier for this location.
Field IDlocation/id
DimensionTEXT
Location name
Name of the business
Field IDlocation/title
DimensionTEXT
Longitude
Longitude of the location
Field IDlocation/longitude
DimensionTEXT
Maps URL
A link to the location on Maps.
Field IDlocation/mapsUri
DimensionURL
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Organization
The name of the organization at the address.
Field IDlocation/address_organization
DimensionTEXT
Phone calls
The number of times the phone number was clicked.
Field IDactions_phone
MetricNUMBER
Place ID
If this location appears on Google Maps, this field is populated with the place ID for the location.
Field IDlocation/placeId
DimensionTEXT
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
DimensionTEXT
Post Call To Action / Action Type
The type of action that will be performed.
Field IDpost/post_call_to_action_type
DimensionTEXT
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
DimensionURL
Post Create Time
Time of the creation of the post.
Field IDpost/post_create_time
DimensionYEAR_MONTH_DAY
Post Event End Time
Event End time.
Field IDpost/post_event_end_time
DimensionYEAR_MONTH_DAY
Post Event Start Time
Event start time.
Field IDpost/post_event_start_time
DimensionYEAR_MONTH_DAY
Post Event Title
Name of the event.
Field IDpost/post_event_title
DimensionTEXT
Post Height Width
Height of the media item, in pixels.
Field IDpost_media/post_media_height
DimensionTEXT
Post ID
The ID of the local post.
Field IDpost/post_id
DimensionTEXT
Post Language Code
The language of the local post.
Field IDpost/post_language_code
DimensionTEXT
Post Media Create Time
Creation time of this media item.
Field IDpost_media/post_media_create_time
DimensionYEAR_MONTH_DAY
Post Media Description
Description for this media item.
Field IDpost_media/post_media_description
DimensionTEXT
Post Media Format
The format of this media item.
Field IDpost_media/post_media_format
DimensionTEXT
Post Media Google URL
Google-hosted URL for this media item.
Field IDpost_media/post_media_google_url
DimensionURL
Post Media ID
The post media ID.
Field IDpost_media/post_media_id
DimensionTEXT
Post Media Source URL
A publicly accessible URL where the media item can be retrieved from.
Field IDpost_media/post_media_url
DimensionURL
Post Media Thumbnail URL
Where provided, the URL of a thumbnail image for this media item.
Field IDpost_media/post_media_thumbnail_url
DimensionTEXT
Post Media View Count
The number of times the media item has been viewed.
Field IDpost_media/post_media_view_count
DimensionNUMBER
Post Media Width
Width of the media item, in pixels.
Field IDpost_media/post_media_width
DimensionTEXT
Post Offer Coupon Code
Offer code that is usable in store or online.
Field IDpost/post_offer_coupon_code
DimensionTEXT
Post Offer Redeem Online URL
Online link to redeem offer.
Field IDpost/post_offer_redeem_online_url
DimensionURL
Post Offer Terms Conditions
Offer terms and conditions.
Field IDpost/post_terms_conditions
DimensionTEXT
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
DimensionURL
Post State
The state of the post, indicating what part of its lifecycle it is in.
Field IDpost/post_state
DimensionTEXT
Post Summary
Description/body of the local post.
Field IDpost/post_summary
DimensionTEXT
Post Topic Type
The topic type of the post: standard, event, offer, or alert.
Field IDpost/post_topic_type
DimensionTEXT
Post Update Time
Time of the last modification of the post made by the user.
Field IDpost/post_update_time
DimensionYEAR_MONTH_DAY
Postal Code
Postal code of the address.
Field IDlocation/address_postalCode
DimensionTEXT
Primary Category
Category that best describes the core business this location engages in.
Field IDlocation/primary_category
DimensionTEXT
Primary phone
Primary phone number of the business.
Field IDlocation/primary_phone
DimensionTEXT
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Question Author Is Anonymous
Indicates whether the reviewer has opted to remain anonymous.
Field IDquestion/question_isAnonymous
DimensionTEXT
Question Author Name
The name of the reviewer. Only populated if isAnonymous is false.
Field IDquestion/question_displayName
DimensionTEXT
Question Author Photo
The profile photo link of the reviewer. Only populated if isAnonymous is false.
Field IDquestion/question_photoUrl
DimensionTEXT
Question Created Time
The timestamp for when the review was written.
Field IDquestion/createTime
DimensionYEAR_MONTH_DAY
Question ID
Question ID
Field IDquestion/question_id
DimensionTEXT
Question Text
The text of the question.
Field IDquestion/text
DimensionTEXT
Question Updated Time
The timestamp for when the review was last modified.
Field IDquestion/updateTime
DimensionYEAR_MONTH_DAY
Question Upvote Count
The number of upvotes for the question..
Field IDquestion/upvoteCount
DimensionNUMBER
Recipients
The recipient at the address.
Field IDlocation/address_recipients
DimensionTEXT
Region Code
CLDR region code of the country/region of the address.
Field IDlocation/address_regionCode
DimensionTEXT
Regular Hours
The language of the location.
Field IDlocation/regularHoursString
DimensionTEXT
Regular Hours (JSON)
The language of the location.
Field IDlocation/regularHoursJson
DimensionTEXT
Reply Text
The body of the reply as plain text with markups. The maximum length is 4096 bytes.
Field IDreview/reply_comment
DimensionTEXT
Reply Updated Time
Output only. The timestamp for when the reply was last modified.
Field IDreview/reply_updateTime
DimensionYEAR_MONTH_DAY_SECOND
Review Created Time
The timestamp for when the review was written.
Field IDreview/createTime
DimensionYEAR_MONTH_DAY
Review ID
The review ID
Field IDreview/review_id
DimensionTEXT
Review Updated Time
The timestamp for when the review was last modified.
Field IDreview/updateTime
DimensionYEAR_MONTH_DAY
Review URI
A link to the page on Google Search where a customer can leave a review for the location.
Field IDlocation/reviewUri
DimensionURL
Reviewer Is Anonymous
Indicates whether the reviewer has opted to remain anonymous.
Field IDreview/reviewer_isAnonymous
DimensionTEXT
Reviewer Name
The name of the reviewer. Only populated if isAnonymous is false.
Field IDreview/reviewer_displayName
DimensionTEXT
Reviewer Photo
The profile photo link of the reviewer. Only populated if isAnonymous is false.
Field IDreview/reviewer_photoUrl
DimensionTEXT
Search terms
The lower-cased string that the user entered.
Field IDkeyword/keyword
DimensionTEXT
Search terms Impression
The sum of the number of unique users that used the keyword.
Field IDkeyword_impression
MetricNUMBER
Search terms Impression Estimated
The sum of the number of unique users that used the keyword including the threshold.
Field IDkeyword_impression_estimated
MetricNUMBER
Service Area Region Code
The service area region code.
Field IDlocation/serviceAreaRegionCode
DimensionTEXT
Service Arera Business Type
The service area business type.
Field IDlocation/serviceAreaBusinessType
DimensionTEXT
Sorting Code
Additional, country-specific, sorting code.
Field IDlocation/address_sortingCode
DimensionTEXT
Special Hours
The language of the location.
Field IDlocation/specialHoursString
DimensionTEXT
Special Hours (JSON)
The language of the location.
Field IDlocation/specialHoursJson
DimensionTEXT
Star Rating
The star rating of the review.
Field IDreview/starRating
DimensionNUMBER
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
DimensionTEXT
Sublocality
Sublocality of the address.
Field IDlocation/address_sublocality
DimensionTEXT
Text review
The body of the review as plain text with markups.
Field IDreview/comment
DimensionTEXT
Total actions
Total number of times customers have taken action on this listing.
Field IDactions_total
MetricNUMBER
Total Answer Count
Output only. The total number of answers posted for this question.
Field IDquestion/totalAnswerCount
DimensionNUMBER
Total Review Count
The total number of reviews for this location.
Field IDtotalReviewCount
MetricNUMBER
Total views
The total number of times the resource was viewer.
Field IDviews_total
MetricNUMBER
Views on Maps
The number of times the resource was viewed on Google Maps.
Field IDviews_maps
MetricNUMBER
Views on Search
The number of times the resource was viewed on Google Search.
Field IDviews_search
MetricNUMBER
Website URL
A URL for this business
Field IDlocation/websiteUri
DimensionURL
Website visits
The number of times the website was clicked.
Field IDactions_website
MetricNUMBER
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
AI

ChatGPT

Ask ChatGPT about your Marketing data.
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.