Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Description |
|---|---|---|---|
| TIME | Year | year | |
| Year of week (Sun-Sat) | yearOfWeek | ||
| Year of week (Mon-Sun) | yearOfWeekIso | ||
| Year & month | yearMonth | ||
| Month | month | ||
| Year & week (Sun-Sat) | yearWeek | ||
| Year & week (Mon-Sun) | yearWeekIso | ||
| Week (Sun-Sat) | week | ||
| Week (Mon-Sun) | weekIso | ||
| Day of month | dayOfMonth | ||
| Day of week (Sun-Sat) | dayOfWeekName | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | ||
| Date | date | ||
| LOCATION GROUP / BUSINESS ACCOUNT | Account ID | location_account_id | ID of the location group / business account |
| Account name | location_account_name | Name of the location group / business account. For personal accounts, this is the first and last name | |
| LOCATION | Location ID | location_id | ID of the business location |
| Location name | location_name | Name of the business | |
| Location name & ID | location_name_id | Name and ID of the business location | |
| Location description | location_description | Merchant provided description of the business | |
| Language code | location_language_code | The language of the business location | |
| Store code | location_store_code | External identifier for the business, which is unique inside a given account | |
| Primary phone | location_primary_phone | A phone number that connects to the individual business location as directly as possible | |
| Additional phones | location_additional_phones | Additional phone numbers at which the business can be called, in addition to the primary phone number | |
| Regular operating hours | location_regular_hours | Operating hours for the business | |
| Special operating hours | location_special_hours | Special operating hours for the business. This typically includes holiday hours, and other times outside of regular operating hours | |
| Website URL | location_website_url | A URL for the business | |
| Google Ads ad phone | location_adwords_ad_phone | Alternate phone number displayed on Google Ads location extensions | |
| Labels | location_labels | A collection of free-form strings used to tag the business | |
| Coordinates | location_coordinates | Location coordinates | |
| Latitude | location_latitude | The latitude in degrees | |
| Longitude | location_longitude | The longitude in degrees | |
| Attributes | location_attributes | Attributes for the business location | |
| Price lists | location_price_lists | Price list information for the business location | |
| LOCATION OPEN INFO | Location status | location_status | Indicates whether or not the location is currently open for business |
| Opening year | location_opening_year | The year when the location first opened | |
| Opening month | location_opening_month | The month when the location first opened | |
| Opening day | location_opening_day | The day when the location first opened | |
| LOCATION POSTAL ADDRESS | Address region code | location_address_region_code | CLDR region code of the country/region of the address |
| Address language code | location_address_language_code | BCP-47 language code of the contents of the address | |
| Postal code | location_address_postal_code | Postal code of the address | |
| Sorting code | location_address_sorting_code | Additional, country-specific, sorting code | |
| Administrative area | location_address_administrative_area | Highest administrative subdivision which is used for postal addresses of a country or region | |
| Locality | location_address_locality | Generally refers to the city/town portion of the address | |
| Sublocality | location_address_sublocality | Sublocality of the address | |
| Address lines | location_address_lines | Unstructured address lines describing the lower levels of the address | |
| Recipients | location_address_recipients | The recipient at the address | |
| Organization | location_address_organization | The name of the organization at the address | |
| LOCATION CATEGORY | Category ID | location_category_id | ID of the category |
| Category name | location_category_name | Name of the category | |
| Additional categories | location_additional_categories | Additional location categories | |
| LOCATION SERVICE AREA | Business type | location_service_area_business_type | 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 | Google Maps place ID for the location |
| Google Maps URL | location_maps_url | A link to the location on Maps | |
| POST | Post ID | post_id | The ID of the local post |
| Post language code | post_language_code | The language of the local post | |
| Post creation time | post_create_time | Time of the creation of the local post | |
| Post modification time | post_update_time | Time of the last modification of the local post | |
| Post summary | post_summary | Description of the local post | |
| Post action type | post_call_to_action_type | The type of action that will be performed | |
| Post action URL | post_call_to_action_url | The URL the user will be directed to upon clicking | |
| Post state | post_state | The state of the post, indicating what part of its lifecycle it is in | |
| Post URL on Google search | post_search_url | The link to the local post on Google search | |
| Post topic type | post_topic_type | The topic type of the local post | |
| POST MEDIA | Post media ID | post_media_id | ID of the media item |
| Post media format | post_media_format | The format of the media item | |
| Post media Google URL | post_media_google_url | Google-hosted URL for this media item. This URL is not static and may change over time | |
| EVENT | Post event title | post_event_title | Title of the event |
| Post event start time | post_event_schedule_start_time | Start time of the event | |
| Post event end time | post_event_schedule_end_time | End date of the event | |
| OFFER | Offer coupon code | post_offer_coupon_code | Offer code that is usable in store or online |
| Offer redeem online URL | post_offer_redeem_online_url | Online link to redeem offer | |
| Offer terms and conditions | post_offer_terms_conditions | Offer terms and conditions | |
| REVIEWS | Review ID | review_id | ID of the review |
| Star rating | review_star_rating | The star rating out of five, where five is the highest rated | |
| Reviewer name | review_reviewer_name | The name of the reviewer | |
| Review comment | review_comment | The body of the review | |
| Review reply comment | review_reply_comment | The body of the reply to the review | |
| Review creation time | review_create_time | The time when review was created | |
| Review creation date | review_create_date | The date when review was created | |
| Review modification time | review_update_time | The time when review was updated | |
| Review modification date | review_update_date | The date when review was updated | |
| Review reply time | review_reply_update_time | The time when review was replied to | |
| MEDIA | Media ID | media_id | ID of the media item |
| Media format | media_format | The media format | |
| Media category | media_category | The category that media item belongs to | |
| Location media URL | media_google_url | Google-hosted URL for the location/business-uploaded media item | |
| Thumbnail URL | media_thumbnail_url | URL of a thumbnail image for the media item | |
| Width (px) | media_width | Width of the media item, in pixels | |
| Height (px) | media_height | Height of the media item, in pixels | |
| CUSTOMER MEDIA | Media ID | customer_media_id | ID of the media item |
| Media format | customer_media_format | The media format | |
| Customer media URL | customer_media_google_url | Google-hosted URL for the customer-uploaded media item | |
| Thumbnail URL | customer_media_thumbnail_url | URL of a thumbnail image for the media item | |
| Width (px) | customer_media_width | Width of the media item, in pixels | |
| Height (px) | customer_media_height | Height of the media item, in pixels | |
| CUSTOMER MEDIA ATTRIBUTION | Contributor name | customer_media_attribution_profile_name | The user name to attribute the media item to |
| Contributor photo URL | customer_media_attribution_profile_photo_url | URL of the attributed user's profile photo thumbnail | |
| Takedown URL | customer_media_attribution_takedown_url | The URL of the takedown page, where the media item can be reported if it is inappropriate | |
| Profile URL | customer_media_attribution_profile_url | The URL of the attributed user's Google Maps profile page | |
| SEARCH | Search terms | search_keywords | Search terms that showed your Business Profile in the search results |
| DEPRECATED | Duplicate location access | location_duplicate_access | 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 | The ID of the location that this duplicates. Please note that this field will be removed on 2020-03-10 | |
| Followers | location_followers | 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 | Google+ page ID for the business. Please note that this field will be removed on 2023-02-19 | |
| Time of day | hour | 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 | The place ID of the location that this duplicates. Please note that this field will be removed on 2020-03-10 | |
| Query | Start date | system_metadata.query_date_range_start | The start date of the requested query |
| End date | system_metadata.query_date_range_end | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | All filters used in the query | |
| Start | system_metadata.query_date_start | When the query was started | |
| End | system_metadata.query_date_end | When the query completed | |
| Duration | system_metadata.query_duration | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | The Supermetrics users that created the data source login connections |