- Schema:
LISTING_TELEMETRY_DAILY View¶
The LISTING_TELEMETRY_DAILY view in the DATA_SHARING_USAGE schema displays daily telemetry data by data exchange and region. The view returns a row for each data exchange in your organization and each region where that data exchange is available.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
EXCHANGE_NAME |
VARCHAR |
Name of the data exchange or the Snowflake Marketplace to which the listing belongs. |
EVENT_DATE |
DATETIME |
Date of all UI interactions for a record. |
SNOWFLAKE_REGION |
VARCHAR |
Snowflake Region where the event occurred. |
LISTING_NAME |
VARCHAR |
Identifier for the listing. |
LISTING_DISPLAY_NAME |
VARCHAR |
Display name of the listing. |
LISTING_GLOBAL_NAME |
VARCHAR |
Listing global name. |
EVENT_TYPE |
VARCHAR |
Event that occurred for the listing. One of: GET, REQUEST, LISTING CLICK, or LISTING VIEW. A LISTING VIEW is recorded when a user visits the listing detail page. |
ACTION |
VARCHAR |
Action that was taken for the event. This can be one of the following: . STARTED: The consumer selected Get or Request for a listing. . COMPLETED: For an EVENT_TYPE of GET, indicates that a consumer installed a Snowflake Native App or created a database from the data product. For an EVENT_TYPE of REQUEST, indicates that the provider received a listing request from the consumer. . CLICK: For a listing click event, indicates that a consumer clicked the tile for a listing, such as from search or the Snowflake Marketplace homepage. |
EVENT_COUNT |
INTEGER |
The total number of times this event action occurred on the event date. |
CONSUMER_ACCOUNTS_DAILY |
INTEGER |
The count of distinct accounts that performed the given event action above. |
CONSUMER_ACCOUNTS_28D |
INTEGER |
The count of distinct consumer accounts that performed the given event action in the past 28 days. |
REGION_GROUP |
VARCHAR |
Region group where the event occurred. |
Usage Notes¶
Latency for the view may be up to 2 days.
The data is retained for 365 days (1 year).
The view contains data for all data products, whether your data product is a Snowflake Native App or a share.
Examples¶
To review the click-through rates for each listing, run the following:
SELECT
listing_name,
listing_display_name,
event_date,
SUM(IFF(event_type = 'LISTING CLICK', consumer_accounts_daily, 0)) AS listing_clicks,
SUM(IFF(event_type IN ('GET', 'REQUEST') and action = 'STARTED', consumer_accounts_daily, 0)) AS get_request_started,
SUM(IFF(event_type IN ('GET', 'REQUEST') and action = 'COMPLETED', consumer_accounts_daily, 0)) AS get_request_completed,
get_request_completed / NULLIFZERO(listing_clicks) AS ctr
FROM snowflake.data_sharing_usage.LISTING_TELEMETRY_DAILY
GROUP BY 1,2,3
ORDER BY 1,2,3;