Google My Business data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: PERFORMANCE

actions_bookings
Display name Bookings
Description The number of bookings received from the business profile
Field type metric
Data type int.number.value
actions_driving_directions
Display name Directions requests
Description The number of times directions were requested
Field type metric
Data type int.number.value
actions_food_orders
Display name Food orders
Description The number of food orders received from the business profile
Field type metric
Data type int.number.value
actions_messages
Display name Messages
Description The number of message conversations received on the business profile
Field type metric
Data type int.number.value
actions_phone
Display name Phone calls
Description The number of times the business profile call button was clicked
Field type metric
Data type int.number.value
actions_website
Display name Website visits
Description The number of times the business profile website was clicked
Field type metric
Data type int.number.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
location_account_id
Display name Account ID
Description ID of the location group / business account
Field type dimension
Data type string.text.value
location_account_name
Display name Account name
Description Name of the location group / business account. For personal accounts, this is the first and last name
Field type dimension
Data type string.text.value
location_additional_categories
Display name Additional categories
Description Additional location categories
Field type dimension
Data type string.text.value
location_additional_phones
Display name Additional phones
Description Additional phone numbers at which the business can be called, in addition to the primary phone number
Field type dimension
Data type string.text.value
location_address_administrative_area
Display name Administrative area
Description Highest administrative subdivision which is used for postal addresses of a country or region
Field type dimension
Data type string.text.value
location_address_language_code
Display name Address language code
Description BCP-47 language code of the contents of the address
Field type dimension
Data type string.language.twolettercode
location_address_lines
Display name Address lines
Description Unstructured address lines describing the lower levels of the address
Field type dimension
Data type string.text.value
location_address_locality
Display name Locality
Description Generally refers to the city/town portion of the address
Field type dimension
Data type string.geo.city
location_address_organization
Display name Organization
Description The name of the organization at the address
Field type dimension
Data type string.text.value
location_address_postal_code
Display name Postal code
Description Postal code of the address
Field type dimension
Data type string.geo.zip
location_address_recipients
Display name Recipients
Description The recipient at the address
Field type dimension
Data type string.text.value
location_address_region_code
Display name Address region code
Description CLDR region code of the country/region of the address
Field type dimension
Data type string.geo.country.twolettercode
location_address_sorting_code
Display name Sorting code
Description Additional, country-specific, sorting code
Field type dimension
Data type string.text.value
location_address_sublocality
Display name Sublocality
Description Sublocality of the address
Field type dimension
Data type string.text.value
location_adwords_ad_phone
Display name Google Ads ad phone
Description Alternate phone number displayed on Google Ads location extensions
Field type dimension
Data type string.text.value
location_attributes
Display name Attributes
Description Attributes for the business location
Field type dimension
Data type string.text.json
location_category_id
Display name Category ID
Description ID of the category
Field type dimension
Data type string.text.value
location_category_name
Display name Category name
Description Name of the category
Field type dimension
Data type string.text.value
location_description
Display name Location description
Description Merchant provided description of the business
Field type dimension
Data type string.text.value
location_duplicate_access
Display name Duplicate location access
Description Indicates whether the user has access to the location it duplicates. Please note that this field will be removed on 2020-03-10
Field type dimension
Data type string.text.value
location_duplicate_id
Display name Duplicate location ID
Description The ID of the location that this duplicates. Please note that this field will be removed on 2020-03-10
Field type dimension
Data type string.text.value
location_duplicate_place_id
Display name Duplicate place ID
Description The place ID of the location that this duplicates. Please note that this field will be removed on 2020-03-10
Field type dimension
Data type string.text.value
location_id
Display name Location ID
Description ID of the business location
Field type dimension
Data type string.text.value
location_labels
Display name Labels
Description A collection of free-form strings used to tag the business
Field type dimension
Data type string.text.value
location_language_code
Display name Language code
Description The language of the business location
Field type dimension
Data type string.language.twolettercode
location_latitude
Display name Latitude
Description The latitude in degrees
Field type dimension
Data type string.geo.latitude
location_longitude
Display name Longitude
Description The longitude in degrees
Field type dimension
Data type string.geo.longitude
location_maps_url
Display name Google Maps URL
Description A link to the location on Maps
Field type dimension
Data type string.text.url
location_name
Display name Location name
Description Name of the business
Field type dimension
Data type string.text.value
location_opening_day
Display name Opening day
Description The day when the location first opened
Field type dimension
Data type string.time.dayofmonth
location_opening_month
Display name Opening month
Description The month when the location first opened
Field type dimension
Data type string.time.month
location_opening_year
Display name Opening year
Description The year when the location first opened
Field type dimension
Data type string.time.year
location_place_id
Display name Google Maps place ID
Description Google Maps place ID for the location
Field type dimension
Data type string.text.value
location_plus_page_id
Display name Google+ page ID
Description Google+ page ID for the business. Please note that this field will be removed on 2023-02-19
Field type dimension
Data type string.text.value
location_price_lists
Display name Price lists
Description Price list information for the business location
Field type dimension
Data type string.text.json
location_primary_phone
Display name Primary phone
Description A phone number that connects to the individual business location as directly as possible
Field type dimension
Data type string.text.value
location_regular_hours
Display name Regular operating hours
Description Operating hours for the business
Field type dimension
Data type string.text.json
location_service_area_business_type
Display name Business type
Description Indicates whether the business only offers services on-site at a customer location, or at both an address and on-site
Field type dimension
Data type string.text.value
location_special_hours
Display name Special operating hours
Description Special operating hours for the business. This typically includes holiday hours, and other times outside of regular operating hours
Field type dimension
Data type string.text.json
location_status
Display name Location status
Description Indicates whether or not the location is currently open for business
Field type dimension
Data type string.text.value
location_store_code
Display name Store code
Description External identifier for the business, which is unique inside a given account
Field type dimension
Data type string.text.value
location_website_url
Display name Website URL
Description A URL for the business
Field type dimension
Data type string.text.url
views_maps
Display name Views on Maps
Description Business impressions on Google Maps on combined Desktop and Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression
Field type metric
Data type int.number.value
views_maps_desktop
Display name Views on maps (Desktop)
Description 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 type metric
Data type int.number.value
views_maps_mobile
Display name Views on maps (Mobile)
Description 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 type metric
Data type int.number.value
views_search
Display name Views on Search
Description Business impressions on Google Search on combined Desktop and Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression
Field type metric
Data type int.number.value
views_search_desktop
Display name Views on Search (Desktop)
Description 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 type metric
Data type int.number.value
views_search_mobile
Display name Views on Search (Mobile)
Description 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 type metric
Data type int.number.value

Table: REVIEW

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
location_account_id
Display name Account ID
Description ID of the location group / business account
Field type dimension
Data type string.text.value
location_account_name
Display name Account name
Description Name of the location group / business account. For personal accounts, this is the first and last name
Field type dimension
Data type string.text.value
location_additional_categories
Display name Additional categories
Description Additional location categories
Field type dimension
Data type string.text.value
location_additional_phones
Display name Additional phones
Description Additional phone numbers at which the business can be called, in addition to the primary phone number
Field type dimension
Data type string.text.value
location_address_administrative_area
Display name Administrative area
Description Highest administrative subdivision which is used for postal addresses of a country or region
Field type dimension
Data type string.text.value
location_address_language_code
Display name Address language code
Description BCP-47 language code of the contents of the address
Field type dimension
Data type string.language.twolettercode
location_address_lines
Display name Address lines
Description Unstructured address lines describing the lower levels of the address
Field type dimension
Data type string.text.value
location_address_locality
Display name Locality
Description Generally refers to the city/town portion of the address
Field type dimension
Data type string.geo.city
location_address_organization
Display name Organization
Description The name of the organization at the address
Field type dimension
Data type string.text.value
location_address_postal_code
Display name Postal code
Description Postal code of the address
Field type dimension
Data type string.geo.zip
location_address_recipients
Display name Recipients
Description The recipient at the address
Field type dimension
Data type string.text.value
location_address_region_code
Display name Address region code
Description CLDR region code of the country/region of the address
Field type dimension
Data type string.geo.country.twolettercode
location_address_sorting_code
Display name Sorting code
Description Additional, country-specific, sorting code
Field type dimension
Data type string.text.value
location_address_sublocality
Display name Sublocality
Description Sublocality of the address
Field type dimension
Data type string.text.value
location_adwords_ad_phone
Display name Google Ads ad phone
Description Alternate phone number displayed on Google Ads location extensions
Field type dimension
Data type string.text.value
location_attributes
Display name Attributes
Description Attributes for the business location
Field type dimension
Data type string.text.json
location_category_id
Display name Category ID
Description ID of the category
Field type dimension
Data type string.text.value
location_category_name
Display name Category name
Description Name of the category
Field type dimension
Data type string.text.value
location_description
Display name Location description
Description Merchant provided description of the business
Field type dimension
Data type string.text.value
location_duplicate_access
Display name Duplicate location access
Description Indicates whether the user has access to the location it duplicates. Please note that this field will be removed on 2020-03-10
Field type dimension
Data type string.text.value
location_duplicate_id
Display name Duplicate location ID
Description The ID of the location that this duplicates. Please note that this field will be removed on 2020-03-10
Field type dimension
Data type string.text.value
location_duplicate_place_id
Display name Duplicate place ID
Description The place ID of the location that this duplicates. Please note that this field will be removed on 2020-03-10
Field type dimension
Data type string.text.value
location_id
Display name Location ID
Description ID of the business location
Field type dimension
Data type string.text.value
location_labels
Display name Labels
Description A collection of free-form strings used to tag the business
Field type dimension
Data type string.text.value
location_language_code
Display name Language code
Description The language of the business location
Field type dimension
Data type string.language.twolettercode
location_latitude
Display name Latitude
Description The latitude in degrees
Field type dimension
Data type string.geo.latitude
location_longitude
Display name Longitude
Description The longitude in degrees
Field type dimension
Data type string.geo.longitude
location_maps_url
Display name Google Maps URL
Description A link to the location on Maps
Field type dimension
Data type string.text.url
location_name
Display name Location name
Description Name of the business
Field type dimension
Data type string.text.value
location_opening_day
Display name Opening day
Description The day when the location first opened
Field type dimension
Data type string.time.dayofmonth
location_opening_month
Display name Opening month
Description The month when the location first opened
Field type dimension
Data type string.time.month
location_opening_year
Display name Opening year
Description The year when the location first opened
Field type dimension
Data type string.time.year
location_place_id
Display name Google Maps place ID
Description Google Maps place ID for the location
Field type dimension
Data type string.text.value
location_plus_page_id
Display name Google+ page ID
Description Google+ page ID for the business. Please note that this field will be removed on 2023-02-19
Field type dimension
Data type string.text.value
location_price_lists
Display name Price lists
Description Price list information for the business location
Field type dimension
Data type string.text.json
location_primary_phone
Display name Primary phone
Description A phone number that connects to the individual business location as directly as possible
Field type dimension
Data type string.text.value
location_regular_hours
Display name Regular operating hours
Description Operating hours for the business
Field type dimension
Data type string.text.json
location_service_area_business_type
Display name Business type
Description Indicates whether the business only offers services on-site at a customer location, or at both an address and on-site
Field type dimension
Data type string.text.value
location_special_hours
Display name Special operating hours
Description Special operating hours for the business. This typically includes holiday hours, and other times outside of regular operating hours
Field type dimension
Data type string.text.json
location_status
Display name Location status
Description Indicates whether or not the location is currently open for business
Field type dimension
Data type string.text.value
location_store_code
Display name Store code
Description External identifier for the business, which is unique inside a given account
Field type dimension
Data type string.text.value
location_website_url
Display name Website URL
Description A URL for the business
Field type dimension
Data type string.text.url
review_comment
Display name Review comment
Description The body of the review
Field type dimension
Data type string.text.value
review_id
Display name Review ID
Description ID of the review
Field type dimension
Data type string.text.value
review_reply_comment
Display name Review reply comment
Description The body of the reply to the review
Field type dimension
Data type string.text.value
review_reviewer_name
Display name Reviewer name
Description The name of the reviewer
Field type dimension
Data type string.text.value
review_star_rating
Display name Star rating
Description The star rating out of five, where five is the highest rated
Field type dimension
Data type string.text.value
review_total_count
Display name Reviews
Description The total number of reviews within the selected time frame
Field type metric
Data type int.number.value