Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | ||
| LOCATION GROUP / BUSINESS ACCOUNT | Account ID | location_account_id | dim | ID of the location group / business account |
| Account name | location_account_name | dim | Name of the location group / business account. For personal accounts, this is the first and last name | |
| LOCATION | Location ID | location_id | dim | ID of the business location |
| Location name | location_name | dim | Name of the business | |
| Location name & ID | location_name_id | dim | Name and ID of the business location | |
| Location description | location_description | dim | Merchant provided description of the business | |
| Language code | location_language_code | dim | The language of the business location | |
| Store code | location_store_code | dim | External identifier for the business, which is unique inside a given account | |
| Primary phone | location_primary_phone | dim | A phone number that connects to the individual business location as directly as possible | |
| Additional phones | location_additional_phones | dim | Additional phone numbers at which the business can be called, in addition to the primary phone number | |
| Regular operating hours | location_regular_hours | dim | Operating hours for the business | |
| Special operating hours | location_special_hours | dim | Special operating hours for the business. This typically includes holiday hours, and other times outside of regular operating hours | |
| Website URL | location_website_url | dim | A URL for the business | |
| Google Ads ad phone | location_adwords_ad_phone | dim | Alternate phone number displayed on Google Ads location extensions | |
| Labels | location_labels | dim | A collection of free-form strings used to tag the business | |
| Coordinates | location_coordinates | dim | Location coordinates | |
| Latitude | location_latitude | dim | The latitude in degrees | |
| Longitude | location_longitude | dim | The longitude in degrees | |
| Attributes | location_attributes | dim | Attributes for the business location | |
| Price lists | location_price_lists | dim | Price list information for the business location | |
| LOCATION OPEN INFO | Location status | location_status | dim | Indicates whether or not the location is currently open for business |
| Opening year | location_opening_year | dim | The year when the location first opened | |
| Opening month | location_opening_month | dim | The month when the location first opened | |
| Opening day | location_opening_day | dim | The day when the location first opened | |
| LOCATION POSTAL ADDRESS | Address region code | location_address_region_code | dim | CLDR region code of the country/region of the address |
| Address language code | location_address_language_code | dim | BCP-47 language code of the contents of the address | |
| Postal code | location_address_postal_code | dim | Postal code of the address | |
| Sorting code | location_address_sorting_code | dim | Additional, country-specific, sorting code | |
| Administrative area | location_address_administrative_area | dim | Highest administrative subdivision which is used for postal addresses of a country or region | |
| Locality | location_address_locality | dim | Generally refers to the city/town portion of the address | |
| Sublocality | location_address_sublocality | dim | Sublocality of the address | |
| Address lines | location_address_lines | dim | Unstructured address lines describing the lower levels of the address | |
| Recipients | location_address_recipients | dim | The recipient at the address | |
| Organization | location_address_organization | dim | The name of the organization at the address | |
| LOCATION CATEGORY | Category ID | location_category_id | dim | ID of the category |
| Category name | location_category_name | dim | Name of the category | |
| Additional categories | location_additional_categories | dim | Additional location categories | |
| LOCATION SERVICE AREA | Business type | location_service_area_business_type | dim | Indicates whether the business only offers services on-site at a customer location, or at both an address and on-site |
| GOOGLE MAPS | Google Maps place ID | location_place_id | dim | Google Maps place ID for the location |
| Google Maps URL | location_maps_url | dim | A link to the location on Maps | |
| POST | Post ID | post_id | dim | The ID of the local post |
| Post language code | post_language_code | dim | The language of the local post | |
| Post creation time | post_create_time | dim | Time of the creation of the local post | |
| Post modification time | post_update_time | dim | Time of the last modification of the local post | |
| Post summary | post_summary | dim | Description of the local post | |
| Post action type | post_call_to_action_type | dim | The type of action that will be performed | |
| Post action URL | post_call_to_action_url | dim | The URL the user will be directed to upon clicking | |
| Post state | post_state | dim | The state of the post, indicating what part of its lifecycle it is in | |
| Post URL on Google search | post_search_url | dim | The link to the local post on Google search | |
| Post topic type | post_topic_type | dim | The topic type of the local post | |
| POST MEDIA | Post media ID | post_media_id | dim | ID of the media item |
| Post media format | post_media_format | dim | The format of the media item | |
| Post media Google URL | post_media_google_url | dim | Google-hosted URL for this media item. This URL is not static and may change over time | |
| EVENT | Post event title | post_event_title | dim | Title of the event |
| Post event start time | post_event_schedule_start_time | dim | Start time of the event | |
| Post event end time | post_event_schedule_end_time | dim | End date of the event | |
| OFFER | Offer coupon code | post_offer_coupon_code | dim | Offer code that is usable in store or online |
| Offer redeem online URL | post_offer_redeem_online_url | dim | Online link to redeem offer | |
| Offer terms and conditions | post_offer_terms_conditions | dim | Offer terms and conditions | |
| REVIEWS | Review ID | review_id | dim | ID of the review |
| Star rating | review_star_rating | dim | The star rating out of five, where five is the highest rated | |
| Reviewer name | review_reviewer_name | dim | The name of the reviewer | |
| Review comment | review_comment | dim | The body of the review | |
| Review reply comment | review_reply_comment | dim | The body of the reply to the review | |
| Review creation time | review_create_time | dim | The time when review was created | |
| Review creation date | review_create_date | dim | The date when review was created | |
| Review modification time | review_update_time | dim | The time when review was updated | |
| Review modification date | review_update_date | dim | The date when review was updated | |
| Review reply time | review_reply_update_time | dim | The time when review was replied to | |
| MEDIA | Media ID | media_id | dim | ID of the media item |
| Media format | media_format | dim | The media format | |
| Media category | media_category | dim | The category that media item belongs to | |
| Location media URL | media_google_url | dim | Google-hosted URL for the location/business-uploaded media item | |
| Thumbnail URL | media_thumbnail_url | dim | URL of a thumbnail image for the media item | |
| Width (px) | media_width | dim | Width of the media item, in pixels | |
| Height (px) | media_height | dim | Height of the media item, in pixels | |
| CUSTOMER MEDIA | Media ID | customer_media_id | dim | ID of the media item |
| Media format | customer_media_format | dim | The media format | |
| Customer media URL | customer_media_google_url | dim | Google-hosted URL for the customer-uploaded media item | |
| Thumbnail URL | customer_media_thumbnail_url | dim | URL of a thumbnail image for the media item | |
| Width (px) | customer_media_width | dim | Width of the media item, in pixels | |
| Height (px) | customer_media_height | dim | Height of the media item, in pixels | |
| CUSTOMER MEDIA ATTRIBUTION | Contributor name | customer_media_attribution_profile_name | dim | The user name to attribute the media item to |
| Contributor photo URL | customer_media_attribution_profile_photo_url | dim | URL of the attributed user's profile photo thumbnail | |
| Takedown URL | customer_media_attribution_takedown_url | dim | The URL of the takedown page, where the media item can be reported if it is inappropriate | |
| Profile URL | customer_media_attribution_profile_url | dim | The URL of the attributed user's Google Maps profile page | |
| SEARCH | Search terms | search_keywords | dim | Search terms that showed your Business Profile in the search results |
| DEPRECATED | Duplicate location access | location_duplicate_access | dim | Indicates whether the user has access to the location it duplicates. Please note that this field will be removed on 2020-03-10 |
| Duplicate location ID | location_duplicate_id | dim | The ID of the location that this duplicates. Please note that this field will be removed on 2020-03-10 | |
| Followers | location_followers | dim | Total number of followers for the location. Please note that this field will be removed on 2022-04-07 | |
| Google+ page ID | location_plus_page_id | dim | Google+ page ID for the business. Please note that this field will be removed on 2023-02-19 | |
| Time of day | hour | dim | Hour of the day. Only valid for Phone calls. Please note that this field will be removed on 2023-03-29 | |
| Duplicate place ID | location_duplicate_place_id | dim | The place ID of the location that this duplicates. Please note that this field will be removed on 2020-03-10 | |
| SEARCH | Monthly search impressions | search_impressions | met | The number of monthly searches that showed your Business Profile in the search results |
| VIEWS | Total views | views_total | met | Total business impressions on both Google Maps and Google Search, on combined Desktop and Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression |
| Views on Maps | views_maps | met | 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 | |
| Views on Search | views_search | met | 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 | |
| Views on maps (Desktop) | views_maps_desktop | met | Business impressions on Google Maps on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression | |
| Views on maps (Mobile) | views_maps_mobile | met | Business impressions on Google Maps on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression | |
| Views on Search (Desktop) | views_search_desktop | met | Business impressions on Google Search on Desktop devices. Multiple impressions by a unique user within a single day are counted as a single impression | |
| Views on Search (Mobile) | views_search_mobile | met | Business impressions on Google Search on Mobile devices. Multiple impressions by a unique user within a single day are counted as a single impression | |
| ACTIONS | Total actions | actions_total | met | Business Profile interactions. Total number of times people call, message, make bookings, ask for directions and more from your Business Profile on Google |
| Website visits | actions_website | met | The number of times the business profile website was clicked | |
| Phone calls | actions_phone | met | The number of times the business profile call button was clicked | |
| Directions requests | actions_driving_directions | met | The number of times directions were requested | |
| Messages | actions_messages | met | The number of message conversations received on the business profile | |
| Bookings | actions_bookings | met | The number of bookings received from the business profile | |
| Menu clicks | actions_food_menu_clicks | met | 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 | |
| Food orders | actions_food_orders | met | The number of food orders received from the business profile | |
| POST | Posts | post_count | met | The number of local posts |
| REVIEWS | Reviews | review_total_count | met | The total number of reviews within the selected time frame |
| Avg. review star rating | review_avg_star_rating | met | Average star rating within the selected time frame | |
| Review time to respond (minutes) | review_reply_response_time | met | Number of minutes it took to reply to the review | |
| REVIEWS TOTALS | Total review count | total_review_count | met | Lifetime value for total number of reviews |
| Avg. overall star rating | total_review_star_rating | met | Lifetime value for avg. overall star rating | |
| MEDIA | Media items | media_total_count | met | The total number of media items |
| CUSTOMER MEDIA | Contributed media items | customer_media_total_count | met | The total number of customer contributed media items |
| DEPRECATED | Photo views (customers) | photo_views_customers | met | The number of views on photos uploaded by customers. Please note that this field will be removed on 2023-02-19 |
| Photos uploaded (customers) | photo_count_customers | met | The total number of photos that are currently live that have been uploaded by customers. Please note that this field will be removed on 2023-02-19 | |
| Photos uploaded (merchant) | photo_count_merchant | met | The total number of photos that are currently live that have been uploaded by the merchant. Please note that this field will be removed on 2023-02-19 | |
| Post views | post_views | met | The number of times the local post was viewed on Google Search. Please note that this field will be removed on 2023-02-19 | |
| Total photos uploaded | photo_count_total | met | The total number of photos that are currently live. Please note that this field will be removed on 2023-02-19 | |
| Total media views | media_view_count | met | The number of times the media item has been viewed. Please note that this field will be removed on 2023-02-19 | |
| Post actions | post_actions | met | The number of times the call to action button was clicked. Please note that this field will be removed on 2023-02-19 | |
| Photo views (merchant) | photo_views_merchant | met | The number of views on photos uploaded by the merchant. Please note that this field will be removed on 2023-02-19 | |
| Total customer media views | customer_media_view_count | met | The number of times the media item has been viewed. Please note that this field will be removed on 2023-02-19 | |
| Branded search impressions | queries_chain | met | The number of times a resource was shown as a result of a search for the chain it belongs to. Please note that this field will be removed on 2023-02-19 | |
| Discovery search impressions | queries_indirect | met | The number of times the resource was shown as a result of a categorical search. Please note that this field will be removed on 2023-02-19 | |
| Direct search impressions | queries_direct | met | The number of times the resource was shown when searching for the location directly. Please note that this field will be removed on 2023-02-19 | |
| Total search impressions | queries_total | met | The total number of times the resource was shown as a result of a search. Please note that this field will be removed on 2023-02-19 | |
| Total photo views | photo_views_total | met | The total number of photo views. Please note that this field will be removed on 2023-02-19 |