Note: The agg_google_my_business_location_daily and agg_google_my_business_metrics tables contain metrics that were deprecated by Google on March 30, 2023. Yext will keep the historical data, but from March 30th onwards, all of the data for the affected metrics will return zeroes.

The schema is named legacy_listings because these are the legacy listings tables in Snowflake, not to be confused with the listings schema, which contains the new listings tables.

Activities Daily

legacy_listings.agg_activities_daily

This view contains various listings activity metrics aggregated by day.

Sample Queries

Get the average of publisher suggestions from Google per entity in the past 7 days. First, we can use the publishers view to figure out which publisher ID corresponds to Google.

select 
   publisher_id,
   resource_name
from prod_sharing.listings.publishers 
where resource_name like 'GOOGLE%'

The result of this query tells us that the publisher ID for Google is 715, so we can use that as a filter in our query on the agg_activities_daily table.

select 
   entity_id,
   date,
   avg(publisher_suggestions)
from prod_sharing.legacy_listings.agg_activities_daily 
where publisher_id = 715
and date > dateadd(day, -8, current_date)
group by 1,2 order by 2

Bing Searches

legacy_listings.agg_bing_weekly

This view contains your business's Bing search impressions by week.

Sample Query

Get Bing searches for a given week.

select
    businesses.business_id,
    name,
    entity_id,
    week,
    sum(serp_impressions) as bing_searches
from legacy_listings.agg_bing_weekly
join public.businesses using(business_id)
where week = 'yyyy-mm-dd'
  and week is not null
  and entity_id is not null
  and serp_impressions is not null
group by 1,2,3,4

Facebook Locations

legacy_listings.agg_facebook_location_daily

This view contains Facebook page impressions, views, and engagement by day, location, and additional dimensions.

Google My Business Locations

legacy_listings.agg_google_my_business_location_daily

This view contains the legacy Google My Business (GMB) metrics, dimensioned by each individual Google metric type.

Google My Business Metrics

legacy_listings.agg_google_my_business_metrics

This view contains the legacy Google My Business (GMB) metrics aggregated across all Google action types.

Sample Query

Get searches, Google map views, and Google search views dimensioned by day for the past 30 days.

select
    date,
    sum(queries) as queries,
    sum(map_views) as map_views,
    sum(search_views) as search_views
from legacy_listings.agg_google_my_business_metrics
where date > dateadd(day, -31, 'yyyy-mm-dd')
group by 1 order by 1 desc

Location Daily

legacy_listings.agg_location_daily

This view contains an aggregation of profile views and social engagement by day, at the entity level.

Sample Queries

Get profile views and SERP impressions by day for the last 30 days.

select 
    date,
    sum(profile_views) as profile_views,
    sum(serp_impressions) as serp_impressions
from legacy_listings.agg_location_daily
where date > dateadd(day, -30, current_date)
group by 1 order by 1 desc