This article contains the information for the industry-level data that is available in Luminate's Data Share.

Summary

The view VW_WEEKLY_FACT_ANALYSIS_DS provides access to data that is grouped at the market and country level. Unlike in the other fact views, the data is stored at a weekly level and every record is assigned a WEEK_ID.

Details

Field Name	Data Type	Description
`MARKET_ID`	`NUMBER`	Unique ID associated with a US or Canadian market. For all other territories, the only supported markets are National or Global
`MARKET_NAME`	`VARCHAR`	Market name corresponding to the Market ID
`COUNTRY_CODE`	`VARCHAR`	2-digit country code using the ISO 3166-1 alpha-2 format
`SERVICE_TYPE`	`VARCHAR`	Streaming breakout that describes whether the stream was played on-demand or programmed
`CONTENT_TYPE`	`VARCHAR`	Streaming breakout that describes whether the stream was in audio or video format. Available only in US, CA, or AA (Worldwide)
`COMMERCIAL_MODEL`	`VARCHAR`	Streaming breakout that describes whether the stream was played on a premium or ad-supported platform
`STORE_STRATA`	`VARCHAR`	The strata attribute represents the category of retailer that reported the sale
`DISTRIBUTION_CHANNEL`	`VARCHAR`	The distribution channel attribute represents the channel by which the product was distributed to the market
`PURCHASE_METHOD`	`VARCHAR`	The purchase method attribute represents the way in which the consumer purchased the product
`PRODUCT_FORMAT`	`VARCHAR`	The medium used in the creation of the Musical Product (CD, Vinyl, etc)
`RELEASE_TYPE`	`VARCHAR`	Specifies the nature of the associated release (album, single, video, etc)
`RELEASE_AGE`	`NUMBER`	Indicator for Current (0-36), Catalog (36-72), or Deep Catalog (72+) music. Release age is measured in ranges of months, with the range being identified by the lower bound.
`GENRE_ID`	`VARCHAR`	Unique ID assigned to the genre
`GENRE_CLIENT_DOMAIN`	`VARCHAR`	Genre definition according to Luminate or Billboard
`METRIC_CATEGORY`	`VARCHAR`	Indicator for the type of consumption record
`QUANTITY`	`NUMBER`	The number of units associated with the record
`REPORTED_QUANTITY`	`FLOAT`	The number of units reported by the provider without the application of modeling. This field is most relevant to the ProductSales metric category. For all other metrics, the quantity and reported quantity values will be the same.
`EQUIVALENT_QUANTITY`	`FLOAT`	In the US and Canada, this field converts streaming and sales data into album sales. For all other territories, this field converts streaming and sales data into premium streams.
`WEEK_ID`	`NUMBER`	ID of chart week in YYYYWW format
`MODIFIED_AT`	`TIMESTAMP_NTZ`	A timestamp that indicates when the record was last modified within the Luminate database

Performance

The following cluster keys are available to optimize the query performance for this view:

COUNTRY_CODE
WEEK_ID
MARKET_ID

Operations

This view is updated daily, but the updates are limited to the current quarter and the last complete quarter.