Monitoring Usage of Your Listing¶
This topic explains how to monitor the performance of your listing in terms of usage and best practices.
Which Metrics Are Tracked?¶
Depending on whether you offer your listing privately or on the Snowflake Marketplace, you see different usage analytics. To see who is using your listings, you can use Provider Studio or the database views provided by Snowflake.
Snowflake tracks many metrics for listings, including the following:
Daily telemetry usage for your listing, such as the daily consumer query history.
Events when consumers get or request your listing.
Use of your listing, such as number of jobs run on the data product in your listing.
Access details for your listing, such as viewing the tables in your listing.
The account name and organization name for consumers accessing your listing, as well as any information consumers submit when requesting a personalized listing.
See DATA_SHARING_USAGE and ORGANIZATION_USAGE for more details about viewing this information in SQL.
For a full list of metrics tracked for listings, and details for viewing this data using SQL, see DATA_SHARING_USAGE and ORGANIZATION_USAGE.
For paid listings, you can see additional data on a per-listing basis or for all paid listings in your organization:
Earnings history for your listings.
Charges accumulated by type of charge.
Number of queries included in the charge to a consumer.
Number of consumers trialing your listing.
Number of purchases of your listing.
See Monetization Usage Views for more details about viewing this information in SQL.
Monitor Consumer Usage Metrics in Provider Studio¶
To help you manage the performance and usage of your listings, Provider Studio provides an overview on the Home tab and aggregated and detailed analytics on the Analytics tab.
Prerequisites for Viewing Usage Data in Provider Studio¶
Before you can view usage data, make sure that you meet the prerequisites.
To view Provider Studio and the data on the Home and Analytics tabs, you must use the ACCOUNTADMIN role or a custom role granted the CREATE DATA EXCHANGE LISTING privilege and IMPORTED PRIVILEGES on the SNOWFLAKE database. See Enabling Account Usage for Other Roles.
You must select a warehouse that Snowflake can use to bill your account for the queries that generate these usage analytics. You are billed at the normal rate for these queries. See Understanding Compute Cost.
View Usage Data in Provider Studio¶
To view usage data in Provider Studio, do the following:
Sign into Snowsight.
In the left navigation bar, select Data » Provider Studio.
Select a warehouse. In the upper-right corner of the page, click Select Warehouse.
Queries to show analytics data on the Home tab and Analytics tab run successfully and display results.
After you open Provider Studio and select a warehouse, you can see some usage data on the Home tab and an overview and detailed metrics on the Analytics tab.
You can see trends from the last 28 days on the Home tab, including the following:
The number of queries executed by consumers against your data products, including how those numbers are trending compared to the previous 28 day period.
The number of unique consumers that have queried your listings, including how those numbers are trending compared to the previous 28 day period.
The name of your most-queried listing.
The consumer who has run the most queries against your listings.
On the Analytics tab, you can see additional metrics, both aggregated across all your listings or a detailed view.
You can see the following overview metrics for your listings:
The reach of your listings on the Snowflake Marketplace, such as views of all of your listings, and a list of the most-viewed listings.
Engagement with your listings, based on the number of queries executed. You can see the following engagement overview metrics:
The number of queries executed across all your listings.
Your listings ordered by usage, determined by number of queries executed.
The number of consumer accounts actively using your listings per day.
A ranking of the most active consumer accounts, based on query execution.
A list of the regions in which consumers execute the most queries.
For your free listings on the Snowflake Marketplace, you can see consumer conversion from viewing, mounting the share, and querying your listings. You can only see consumer conversion over the last 28 days.
If you select More for a specific metric, or select Detailed Metrics, you can see the following details on the Analytics tab:
The number of unique consumers that have queried your data products.
The number of consumers that have requested replication of your free listings to their region or requested your personalized listings.
The number of listings that consumers have installed in their accounts.
The number of times your listings offered on the Snowflake Marketplace have been viewed.
The number of queries executed against your listings.
Using the detailed view, you can filter the metrics by time, exchange, consumer, listing name, or region.
View Usage Data using SQL¶
The overview metrics on the Analytics tab are derived from the metrics in the DATA_SHARING_USAGE schema. Some metrics, including most active consumers, conversion rate, most viewed listings, and most used listings, are derived from the metrics and might not exactly match what you can see in the schema.
The detailed metrics on the Analytics tab are obtained by querying the views in the Data Sharing Usage schema.
If you want, you can query the views directly. See Data Sharing Usage.
Because the views are part of the SNOWFLAKE database, only account administrators (users with the ACCOUNTADMIN role) can perform queries on the data sharing usage for the listings published from that account. Privileges can be granted to other roles in your account to allow other users access. For more details, see Enabling Account Usage for Other Roles.
The DATA_SHARING_USAGE schema is not updated immediately. There can be up to two days of latency between an event occurring and updates to the DATA_SHARING_USAGE schema.
Improve Listing Performance in the Marketplace¶
If you publish your listing on the Snowflake Marketplace and want to improve the listing performance with consumers, review the Snowflake Marketplace Provider Best Practices.