Yext data warehouse table groups

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

Table: PROFILE_VIEW_SEARCH

analytics__account_ids
Display name Account ID
Description Identify events by sub-account
Field type dimension
Data type string.text.value
analytics__date
Display name Date
Field type dimension
Data type string.time.date
analytics__location_ids
Display name Location ID
Description Identify events by store ID of the corresponding location
Field type dimension
Data type string.text.value
analytics__location_names
Display name Location name
Description Identify events by name of the corresponding location
Field type dimension
Data type string.text.value
analytics__profile_views
Display name Profile views
Description The number of times your listings were viewed. Does not include listings on Yelp, Bing, or Google
Field type metric
Data type int.number.value
analytics__searches
Display name Searches
Description The number of times your listings were included in search results. Does not include search results on Yelp, Facebook, Bing, or Google
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

Table: CUST_ACTION

analytics__account_ids
Display name Account ID
Description Identify events by sub-account
Field type dimension
Data type string.text.value
analytics__customer_action_type
Display name Customer action type
Description 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
Field type dimension
Data type string.text.value
analytics__date
Display name Date
Field type dimension
Data type string.time.date
analytics__google_customer_actions
Display name Google customer actions
Description 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
Field type metric
Data type int.number.value
analytics__location_ids
Display name Location ID
Description Identify events by store ID of the corresponding location
Field type dimension
Data type string.text.value
analytics__location_names
Display name Location name
Description Identify events by name of the corresponding location
Field type dimension
Data type string.text.value
analytics__yelp_customer_actions
Display name Yelp customer actions
Description 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
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

Table: FACEBOOK_YELP

analytics__account_ids
Display name Account ID
Description Identify events by sub-account
Field type dimension
Data type string.text.value
analytics__date
Display name Date
Field type dimension
Data type string.time.date
analytics__facebook_impressions
Display name Facebook impressions
Description The total number of impressions seen of any content associated with your Page
Field type metric
Data type int.number.value
analytics__facebook_likes
Display name Facebook likes
Description The number of consumers who have liked your Page
Field type metric
Data type int.number.value
analytics__facebook_page_views
Display name Facebook page views
Description The total number of times your Page has been viewed
Field type metric
Data type int.number.value
analytics__location_ids
Display name Location ID
Description Identify events by store ID of the corresponding location
Field type dimension
Data type string.text.value
analytics__location_names
Display name Location name
Description Identify events by name of the corresponding location
Field type dimension
Data type string.text.value
analytics__yelp_page_views
Display name Yelp page views
Description The number of times your listings on Yelp pages were viewed
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

Table: FOURSQUARE_GOOGLE

analytics__account_ids
Display name Account ID
Description Identify events by sub-account
Field type dimension
Data type string.text.value
analytics__date
Display name Date
Field type dimension
Data type string.time.date
analytics__foursquare_daily_checkins
Display name Foursquare daily checkins
Description The number of consumers who checked into your business on Foursquare on a given date
Field type metric
Data type int.number.value
analytics__google_map_views
Display name Google map views
Description The number of times your listings were viewed on Google Maps
Field type metric
Data type int.number.value
analytics__google_search_queries
Display name Google search queries
Description The number of times your listings appeared in search results on either Google Search or Google Maps
Field type metric
Data type int.number.value
analytics__google_search_views
Display name Google search views
Description The number of times your listings were viewed on Google Search
Field type metric
Data type int.number.value
analytics__location_ids
Display name Location ID
Description Identify events by store ID of the corresponding location
Field type dimension
Data type string.text.value
analytics__location_names
Display name Location name
Description Identify events by name of the corresponding location
Field type dimension
Data type string.text.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