Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
Category | Field | Code | Type | Description |
---|---|---|---|---|
Time | Year | analytics_year | dim | |
Year of week (Sun-Sat) | analytics_year_of_week | dim | ||
Year of week (Mon-Sun) | analytics_year_of_week_iso | dim | ||
Year & month | analytics_year_month | dim | ||
Month | analytics_month | dim | ||
Year & week (Sun-Sat) | analytics_year_week | dim | ||
Year & week (Mon-Sun) | analytics_year_week_iso | dim | ||
Week (Sun-Sat) | analytics_week | dim | ||
Week (Mon-Sun) | analytics_week_iso | dim | ||
Day of month | analytics_day_of_month | dim | ||
Day of week (Sun-Sat) | analytics_day_of_week_name | dim | ||
Day of week (Mon-Sun) | analytics_day_of_week_name_iso | dim | ||
Date | analytics_date | dim | ||
Datetime | analytics_atom | dim | ||
General | Account ID | analytics_account_ids | dim | Identify events by sub-account |
Location ID | analytics_location_ids | dim | Identify events by store ID of the corresponding location | |
Location name | analytics_location_names | dim | Identify events by name of the corresponding location | |
Medium ID | analytics_medium_id | dim | Identify the source of click this conversion is attributed to. Can only be used with Conversion Tracking metrics | |
Medium type | analytics_medium_type | dim | Identify the type of source of click this conversion is attributed to. Can only be used with Conversion Tracking metrics | |
Partners | analytics_partners | dim | The sites your reviews appear on. Can only be used with Reviews metrics | |
Platform | analytics_platform | dim | Groups data by the platform on which the action measured in metrics was conducted (e.g., Desktop, Mobile) | |
Product | analytics_product | dim | Identify conversion analytics by the product in which they occurred. Can only be used with Conversion Tracking metrics | |
Publisher | analytics_publishers | dim | Groups data about the site-interaction events listed in metrics by the sites on which they occurred | |
Publisher suggestion type | analytics_publisher_suggestion_type | dim | The type of the publisher suggestion (can only be used with the Publisher suggestions metric) | |
Rating | analytics_ratings | dim | Can only be used with Reviews metrics except Cumulative rating | |
Review keywords | analytics_review_keywords | dim | The keywords used in your reviews | |
Review labels | analytics_review_labels | dim | Identify reviews by their label | |
Search query | analytics_search_query | dim | Groups searches according to the search criteria used. Can only be used with the SEARCHES metric | |
Search term | analytics_search_term | dim | Raw Search Term entered by user for Search | |
Sentiment collection | analytics_sentiment_collection | dim | Identify reviews by their sentiment collection of keywords | |
Traffic source | analytics_traffic_source | dim | Identify conversion analytics by the source of the traffic | |
Visitor email | analytics_visitor_email | dim | Email of Unique Visitor who triggered event | |
Visitor ID | analytics_visitor_id | dim | ID of Unique Visitor who triggered event | |
Visitor ID method | analytics_visitor_id_method | dim | Method used to identify Visitor | |
Visitor name | analytics_visitor_name | dim | Name of Unique Visitor who triggered event | |
Click type | analytics_click_type | dim | Identify the type of click that a conversion is attributed to. Can only be used with Conversion Tracking metrics | |
Conversion action ID | analytics_conversion_action_id | dim | Can only be used with Conversion Tracking metrics | |
Conversion type | analytics_conversion_type | dim | Type of conversion action (Customer Support, Lead, Page View, Purchase, etc) | |
Customer action type | analytics_customer_action_type | dim | The type of action consumers took through your Google or Yelp listings (Phone Calls, Get Directions, or Website Clicks). Can only be used with the Google customer actions and Yelp customer actions metrics | |
Entity group | analytics_entity_groups | dim | Identify events by the type group of the corresponding entity | |
Entity ID | analytics_entity_ids | dim | Identify events by the corresponding entity | |
Entity type | analytics_entity_types | dim | Identify events by the type of the corresponding entity | |
Event | analytics_events | dim | Identify events by the corresponding event | |
Event | analytics_event_search_condition | dim | Identify Search Tracker for Events metrics by the event search schedule condition. Can be used with Search Tracker Event metrics | |
Field name | analytics_field_name | dim | The name of the field being updated in your profile (can only be used with the Profile updates metric) | |
Folder ID | analytics_folder_ids | dim | Identify events by folder ID of the corresponding entity | |
Folder name | analytics_folder_names | dim | Identify events by folder name of the corresponding entity | |
Frequent words | analytics_frequent_words | dim | The words that most frequently appear in your reviews | |
Live listings type | analytics_listings_live_type | dim | The type of of listings live, either be Claimed or Created (can only be used with Live listings metric) | |
Value proposition | analytics_value_proposition | dim | ||
Vertical config ID | analytics_vertical_config_id | dim | ||
Intelligent search tracker | Competitor | analytics_ist_competitor | dim | Competitors monitored by the Intelligent Search Tracker. Can be used with Intelligent Search Tracker metrics and the Cumulative Rating metric |
Keyword | analytics_ist_keyword | dim | The keyword used to create search requests. Can only be used with Intelligent Search Tracker metrics | |
Local pack competitor | analytics_ist_local_pack_competitor | dim | Local pack competitors monitored by the Intelligent Search Tracker. Can be used with Matches per search and Total matches metrics | |
Match position | analytics_ist_match_position | dim | The local pack or organic position of the search result. Can only be used with Intelligent Search Tracker metrics | |
Match type | analytics_ist_match_type | dim | One of Local Map Pack, Listings, Pages and Corporate Website. Can only be used with Intelligent Search Tracker metrics | |
Query template | analytics_ist_query_template | dim | The query template used to create search requests. Can only be used with Intelligent Search Tracker metrics | |
Search engine | analytics_ist_search_engine | dim | The search engine used for the Intelligent Search Tracker. Can only be used with Intelligent Search Tracker metrics | |
Search result type | analytics_ist_search_result_type | dim | One of Organic, Local Pack or Knowledge Card. Can only be used with Intelligent Search Tracker metrics | |
Store pages | Store page directory | analytics_storepages_directory | dim | The directories of your Store Pages. Can only be used with Store Pages metrics |
Store page type | analytics_storepages_page_type | dim | The page types for your Store Pages. Can only be used with Store Pages metrics | |
Store page URL | analytics_storepages_page_url | dim | he urls people visited on your Store Pages. Can only be used with Store Pages metrics | |
Age | analytics_age | dim | The age range of a Facebook user. Can be used with metrics Facebook likes, Facebook talking about, Facebook check-ins, Facebook impressions, and Facebook page views | |
Gender | analytics_gender | dim | The gender of a Facebook user. Can be used with metrics Facebook likes, Facebook talking about, Facebook check-ins, Facebook impressions, and Facebook page views | |
Facebook impression type | analytics_facebook_impression_type | dim | Indicates whether your Facebook Impressions came from Organic, Paid, or Viral content. Can only be used with the Facebook impressions and Facebook post impressions metrics | |
Facebook RSVP type | analytics_facebook_rsvp_type | dim | Identify Facebook Events by RSVP type. Can be used with the Facebook event new RSVPs metric | |
Facebook story type | analytics_facebook_story_type | dim | How people are talking about your Page (e.g., posts, likes, comments). Can only be used with the Facebook talking about metric | |
Google phone call hours | analytics_google_phone_call_hours | dim | Can only be used with the Google phone calls metric | |
Google query type | analytics_google_query_type | dim | Groups search criteria based on whether they contained your brand name (branded) or not (unbranded). Can only be used with the Google search queries metric. Groupings are DIRECT, DISCOVERY and BRANDED | |
Foursquare | Foursquare age | analytics_foursquare_age | dim | Groups checkins by the users' ages (13-17, 18-24, 25-34, 35-44, 45-54, 55+). Can only be used with the Foursquare daily checkins metric |
Foursquare gender | analytics_foursquare_gender | dim | Groups checkins by users' sexes (male or female). Can only be used with the Foursquare daily checkins metric | |
Foursquare time | analytics_foursquare_time | dim | Groups checkins by their times (morning: 7 AM - 10:59 AM, noon: 11 AM - 1:59 PM, afternoon: 2 PM - 5:59 PM, evening: 6 PM - 8:59 PM, night: 9 PM - 6:59 AM). Can only be used with the Foursquare daily checkins metric | |
Clicks | analytics_clicks | met | The number of times consumers clicked on your online properties | |
Conversions | analytics_conversions | met | The number of conversions based on the methodology you selected | |
Conversion rate | analytics_conversion_rate | met | Conversion rate. Conversions / Clicks | |
Conversion searches | analytics_conversion_searches | met | The number of Answers Searches with a Click | |
Conversion value | analytics_conversion_value | met | The monetary impact of your conversions | |
Value per conversion | analytics_value_per_conversion | met | Value per conversion. Conversion value / Conversions | |
Cumulative rating | analytics_cumulative_rating | met | Average review rating of Competitors | |
Duplicates detected | analytics_duplicates_detected | met | Count of all duplicates detected | |
Duplicates suppressed | analytics_duplicates_suppressed | met | Count of all duplicates suppressed | |
Profile views (Event) | analytics_event_profileviews | met | The number of times a consumer has seen your full event listing profile on a publisher site, either by clicking on your event listing from a search on the publisher site or from another search engine | |
Searches (Event) | analytics_event_searches | met | The number of times a consumer has run a search and seen your event listing in the search result on a Yext Listings Publisher site | |
Featured message clicks | analytics_featured_message_clicks | met | The number of times consumers clicked on your Featured Message. Does not include Featured Messages on Yelp, Facebook, Bing, or Google | |
Keyword mentions | analytics_keyword_mentions | met | The number of times a review keyword is mentioned | |
Keyword sentiment score | analytics_keyword_sentiment | met | The sentiment score of review keywords | |
Live listings | analytics_listings_live | met | Count of new listings live | |
New reviews | analytics_new_reviews | met | The number of new reviews your business has received | |
Active listings live | analytics_powerlistings_live | met | The total number of your listings that were live | |
Profile updates | analytics_profile_updates | met | Count of updates to your Yext profile | |
Profile views | analytics_profile_views | met | The number of times your listings were viewed. Does not include listings on Yelp, Bing, or Google | |
Publisher suggestions | analytics_publisher_suggestions | met | Count of all publisher suggestions | |
Response count | analytics_response_count | met | The number of reviews with responses on publishers that support in-platform response | |
Response rate | analytics_response_rate | met | The percentage of reviews with responses on publishers that support in-platform response | |
Response time | analytics_response_time | met | The average time in hours between the review date and the response date of all reviews with responses that can be responded to in the platform | |
Searches | analytics_searches | met | The number of times your listings were included in search results. Does not include search results on Yelp, Facebook, Bing, or Google | |
Sessions | analytics_sessions | met | The number of Answers Sessions with a Click | |
Social activities | analytics_social_activities | met | Count of all new social posts | |
Ticket clicks | analytics_ticket_clicks | met | Clicks to a button that allows users to get tickets | |
Total listing impressions | analytics_total_listings_impressions | met | The number of times your listing appeared in search results across Google Maps, Google Search, Bing, Facebook, and the broader network | |
Widget review views | analytics_widgets_reviews_views | met | The number of views of embedded widgets containing reviews | |
Matches per search | analytics_st_event_matches_per_search | met | Matches per Search for Events | |
Event rich result presence | analytics_st_event_rich_result_presence | met | The percentage of time your event appeared in an event rich result when one was shown | |
Event share of intelligent search | analytics_st_event_share_of_intelligent_search | met | Share of Intelligent Search for your Events | |
Average rating | analytics_average_rating | met | The cumulative average of the ratings your business has received. | |
Ad matches | analytics_ist_ad_matches | met | The total number of ads matched to the location or one of its competitors | |
Ad presence | analytics_ist_ad_presence | met | The percentage of searches in which at least one ad appeared for the location or one of its competitors | |
Average first local pack match position | analytics_ist_average_first_local_pack_match_position | met | The average position of the first match in the local pack in the search engine results page if one exists | |
Average first match position | analytics_ist_average_first_match_position | met | The average position of the first match in either the local pack or organic results in the search engine results page if one exists | |
Average first organic match position | analytics_ist_average_first_organic_match_position | met | The average position of the first match in the organic results in the search engine results page if one exists | |
Average local pack number of results | analytics_ist_average_local_pack_number_of_results | met | The average number of results in the local pack when it appears in a search engine results page | |
Average local pack position | analytics_ist_average_local_pack_position | met | The average position of the local pack when it appears in a search engine results page | |
Knowledge card existed | analytics_ist_knowledge_card_existed | met | The percentage of times a knowledge card showed up in search results | |
Local pack existed | analytics_ist_local_pack_existed | met | The percentage of times a local pack showed up in search results | |
Local pack presence | analytics_ist_local_pack_presence | met | The percentage of times your business appears in a local pack when one was shown | |
Local pack share of search | analytics_ist_local_pack_share_of_search | met | The share of search for all local pack matches in the search engine results page | |
Matches per search | analytics_ist_matches_per_search | met | The total number of matches on the first page of the search engine results | |
Organic share of search | analytics_ist_organic_share_of_search | met | The share of search for all organic matches in the search engine results page | |
Search requests | analytics_ist_search_requests | met | The number of search requests that were successfully analyzed | |
Share of intelligent search | analytics_ist_share_of_intelligent_search | met | The share of search for all matches in the search engine results page | |
Total matches | analytics_ist_total_matches | met | The total number of matches on the first page of the search engine results | |
Store pages call-to-action clicks | analytics_store_pages_call_to_action_clicks | met | The number of times someone clicked a call to action on your Store Pages | |
Store pages clicks to website | analytics_store_pages_clicks_to_website | met | The number of times someone clicked to go to your website from your Store Pages | |
Store pages driving directions | analytics_store_pages_driving_directions | met | The number of times someone clicked for directions on your Store Page | |
Store pages page views | analytics_store_pages_page_views | met | The number of page views on your Store Pages | |
Store pages phone calls | analytics_store_pages_phone_calls | met | The number of times someone clicked to make a phone call from your Store Pages | |
Store pages sessions | analytics_store_pages_sessions | met | The number of unique visitors (sessions) to your Store Pages | |
Facebook check-ins | analytics_facebook_checkins | met | The total number of consumers who have checked into your business, along with the people tagged as being with them when checking in | |
Facebook CTA clicks | analytics_facebook_cta_clicks | met | The total number of clicks on your Page CTA button by people who are logged in to Facebook | |
Facebook event new RSVPs | analytics_facebook_event_new_rsvps | met | The number of new RSVPs to your Facebook event | |
Facebook impressions | analytics_facebook_impressions | met | The total number of impressions seen of any content associated with your Page | |
Facebook likes | analytics_facebook_likes | met | The number of consumers who have liked your Page | |
Facebook page views | analytics_facebook_page_views | met | The total number of times your Page has been viewed | |
Facebook post impressions | analytics_facebook_post_impressions | met | The number of impressions for your Page post | |
Facebook talking about | analytics_facebook_talking_about | met | The number of unique consumers who had an interaction with your Page. For an interaction to be included in this total, it must result in a story being posted to the newsfeeds of those consumers' friends. Examples of these interactions include, but are not limited to, sharing a post on your Page, liking your Page, or tagging your location in a photo | |
Facebook were here | analytics_facebook_were_here | met | The total number of consumers who have checked into your business on Facebook, along with the people tagged as being with them when checking in | |
Google customer actions | analytics_google_customer_actions | met | The number of times consumers called your business, got driving directions to your business, or visited your website via the links in your Google listings | |
Google map views | analytics_google_map_views | met | The number of times your listings were viewed on Google Maps | |
Google phone calls | analytics_google_phone_calls | met | The number of times consumers called your business by clicking your phone number in your Google listings during the past 90 days. You must use the Google phone call hours dimension with this metric | |
Google search queries | analytics_google_search_queries | met | The number of times your listings appeared in search results on either Google Search or Google Maps | |
Google search views | analytics_google_search_views | met | The number of times your listings were viewed on Google Search | |
Google user photos | analytics_google_user_photos | met | The number of photos uploaded by Google users (consumers) to your Google listing | |
Google search console clicks | analytics_gsc_clicks | met | The number of times a user clicked through to your Pages from anywhere on the Google Search results page | |
Google search console impressions | analytics_gsc_impressions | met | The number of times a link to your Pages has appeared anywhere on a Google Search result page | |
Google search console CTR | analytics_gsc_ctr | met | The percentage of time users clicked on links to your Pages when they appeared in search results on Google. Google search console clicks / Google search console impressions | |
Google search console average position | analytics_gsc_position | met | The average position of your highest ranking Pages result when they appeared in search results on Google | |
Yelp customer actions | analytics_yelp_customer_actions | met | The number of times consumers called your business, got driving directions to your business, or visited your website via the links in your Yelp listings | |
Yelp page views | analytics_yelp_page_views | met | The number of times your listings on Yelp pages were viewed | |
Foursquare daily checkins | analytics_foursquare_daily_checkins | met | The number of consumers who checked into your business on Foursquare on a given date |