Consumption Data
This article contains the details for the streaming & sales fact views that are available in Luminate's Data Share.
Musical Recording
Summary
The view VW_DAILY_FACT_MR_DS provides access to the track-level consumption data. In the majority of cases, these tracks have an associated ISRC. Due to delivery nuances with data providers, it is possible an ISRC is not attached to a Musical Recording.
Unlike the metadata views, the fact views contain data that is specific to a territory, which is indicated by the country code and country name fields.
Details
| Field Name | Data Type | Details |
|---|---|---|
MR_ID | VARCHAR | Unique Luminate ID associated to the Musical Recording |
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 |
TRANSACTION_TYPE | VARCHAR | Indicator of the type of sales transaction. Possible values are R (return), S (sale), and CMA (complete my album) |
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 |
METRIC_CATEGORY | VARCHAR | Indicator for the type of consumption record (stream or sale) |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
REPORT_DATE | DATE | The date of the record as reported by the data provider |
MODIFIED_AT | TIMESTAMP_NTZ | A timestamp that indicates when the consumption record for the Musical Recording was last modified within the Luminate database |
Performance
The following cluster keys are available to optimize the query performance for this view:
COUNTRY_CODEMR_IDREPORT_DATE
Song
Summary
The view VW_DAILY_FACT_SONG_DS provides access to the song-level consumption data.
Unlike the metadata views, the fact views contain data that is specific to a territory, which is indicated by the country code and country name fields.
Details
| Field Name | Data Type | Details |
|---|---|---|
SONG_ID | VARCHAR | Unique Luminate ID associated to the Song |
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 |
TRANSACTION_TYPE | VARCHAR | Indicator of the type of sales transaction. Possible values are R (return), S (sale), and CMA (complete my album) |
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 |
METRIC_CATEGORY | VARCHAR | Indicator for the type of consumption record (stream or sale) |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
REPORT_DATE | DATE | The date of the record as reported by the data provider |
MODIFIED_AT | TIMESTAMP_NTZ | A timestamp that indicates when the consumption record for the Song was last modified within the Luminate database |
Performance
The following cluster keys are available to optimize the query performance for this view:
COUNTRY_CODESONG_IDREPORT_DATE
Musical Product
Summary
The view VW_DAILY_FACT_MP_DS provides access to the barcode-level consumption data.
Unlike the metadata views, the fact views contain data that is specific to a territory, which is indicated by the country code and country name fields.
Details
| Field Name | Data Type | Details |
|---|---|---|
MP_ID | VARCHAR | Unique Luminate ID associated to the Musical Product |
ICPN | VARCHAR | Barcode associated to the Musical Product |
MARKET_ID | NUMBER | Unique ID associated with the 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 |
PRODUCT_FORMAT | VARCHAR | The medium used in the creation of the Musical Product (CD, Vinyl, etc) |
TRANSACTION_TYPE | VARCHAR | Indicator of the type of sales transaction. Possible values are R (return), S (sale), and CMA (complete my album) |
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 |
SERVICE_TYPE | VARCHAR | Streaming breakout that describes whether the stream was played on-demand or programmed |
METRIC_CATEGORY | VARCHAR | Indicator of the type of consumption record (stream or sale). Streaming data is derived from the associated Musical Recordings |
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 |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
REPORT_DATE | DATE | The date of the record as reported by the data provider |
MODIFIED_AT | TIMESTAMP_NTZ | A timestamp that indicates when the consumption record for the Musical Product was last modified within the Luminate database |
Performance
The following cluster keys are available to optimize the query performance for this view:
COUNTRY_CODEMP_IDREPORT_DATE
Musical Release
Summary
The view VW_DAILY_FACT_MREL_DS provides access to the release-level consumption data.
Unlike the metadata views, the fact views contain data that is specific to a territory, which is indicated by the country code and country name fields.
Details
| Field Name | Data Type | Details |
|---|---|---|
MREL_ID | VARCHAR | Unique Luminate ID associated to the Musical Release |
MARKET_ID | NUMBER | Unique ID associated with the 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 |
PRODUCT_FORMAT | VARCHAR | The medium used in the creation of the Musical Release (CD, Vinyl, etc) |
TRANSACTION_TYPE | VARCHAR | Indicator of the type of sales transaction. Possible values are R (return), S (sale), and CMA (complete my album) |
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 |
SERVICE_TYPE | VARCHAR | Streaming breakout that describes whether the stream was played on-demand or programmed |
METRIC_CATEGORY | VARCHAR | Indicator of the type of consumption record (stream or sale). Streaming data is derived from the associated Musical Recordings |
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 |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
REPORT_DATE | DATE | The date of the record as reported by the data provider |
MODIFIED_AT | TIMESTAMP_NTZ | A timestamp that indicates when the consumption record for the Musical Release was last modified within the Luminate database |
Performance
The following cluster keys are available to optimize the query performance for this view:
COUNTRY_CODEMREL_IDREPORT_DATE
Musical Release Group
Summary
The view VW_DAILY_FACT_MRELG_DS provides access to the album-level consumption data.
Unlike the metadata views, the fact views contain data that is specific to a territory, which is indicated by the country code and country name fields.
Details
| Field Name | Data Type | Details |
|---|---|---|
MRELG_ID | VARCHAR | Unique Luminate ID associated to the Musical Release Group |
MARKET_ID | NUMBER | Unique ID associated with the 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 |
PRODUCT_FORMAT | VARCHAR | The medium used in the creation of the Musical Release Group (CD, Vinyl, etc) |
TRANSACTION_TYPE | VARCHAR | Indicator of the type of sales transaction. Possible values are R (return), S (sale), and CMA (complete my album) |
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 |
SERVICE_TYPE | VARCHAR | Streaming breakout that describes whether the stream was played on-demand or programmed |
METRIC_CATEGORY | VARCHAR | Indicator of the type of consumption record (stream or sale). Streaming data is derived from the associated Musical Recordings |
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 |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
REPORT_DATE | DATE | The date of the record as reported by the data provider |
MODIFIED_AT | TIMESTAMP_NTZ | A timestamp that indicates when the consumption record for the Musical Release Group was last modified within the Luminate database |
Performance
The following cluster keys are available to optimize the query performance for this view:
COUNTRY_CODEMRELG_IDREPORT_DATE
Artist
Summary
The view VW_DAILY_FACT_ARTIST_DS provides access to the artist-level consumption data.
Unlike the metadata views, the fact views contain data that is specific to a territory, which is indicated by the country code and country name fields.
Details
| Field Name | Data Type | Details |
|---|---|---|
ARTIST_ID | VARCHAR | Unique Luminate ID associated to the Artist |
MARKET_ID | NUMBER | Unique ID associated with the 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 |
PRODUCT_FORMAT | VARCHAR | The medium used in the creation of the Musical Product (CD, Vinyl, etc) |
TRANSACTION_TYPE | VARCHAR | Indicator of the type of sales transaction. Possible values are R (return), S (sale), and CMA (complete my album) |
METRIC_CATEGORY | VARCHAR | Indicator of the type of consumption record (stream or sale). Streaming data is derived from the associated Musical Recordings |
REPORT_DATE | DATE | The date of the record as reported by the data provider |
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 |
SERVICE_TYPE | VARCHAR | Streaming breakout that describes whether the stream was played on-demand or programmed |
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 |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
MODIFIED_AT | TIMESTAMP_NTZ | A timestamp that indicates when the consumption record for the Artist was last modified within the Luminate database |
Performance
The following cluster keys are available to optimize the query performance for this view:
COUNTRY_CODEARTIST_IDREPORT_DATE
Updated 2 days ago