Schema:

DATA_SHARING_USAGE

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;
Copy
Language: English