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 |