Consumption Data: Detail
This article contains the information for all of the DETAIL fact views that are available in Luminate's Data Share.
Musical Recording
Streaming & Sales
Summary
The view VW_DAILY_FACT_MR_DETAIL_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 | Description |
|---|---|---|
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 |
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 |
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 for the type of consumption record (stream or sale) |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
EQUIVALENT_QUANTITY | NUMBER | 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. |
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
Streaming & Sales
Summary
The view VW_DAILY_FACT_SONG_DETAIL_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 | Description |
|---|---|---|
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 |
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 |
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 for the type of consumption record (stream or sale) |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
EQUIVALENT_QUANTITY | NUMBER | 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. |
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
Airplay
Summary
The view VW_DAILY_FACT_SONG_AIRPLAY_DETAIL_DS provides access to the song-level airplay 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 | Description |
|---|---|---|
SONG_ID | VARCHAR | Unique Luminate ID associated to the Song |
MARKET_ID | VARCHAR | 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 |
STATION_ID | VARCHAR | Unique ID assigned to the airplay station |
METRIC_CATEGORY | VARCHAR | Indicator for the type of consumption record |
AUDIENCE | VARCHAR | Estimated number of listeners for the corresponding spins |
QUANTITY | NUMBER | The number of spins associated with the record |
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
Streaming & Sales
Summary
The view VW_DAILY_FACT_MP_DETAIL_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 | Description |
|---|---|---|
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 |
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) |
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 |
REPORTED_QUANTITY | NUMBER | 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. |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
EQUIVALENT_QUANTITY | NUMBER | 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. |
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
Streaming & Sales
Summary
The view VW_DAILY_FACT_MREL_DETAIL_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 | Description |
|---|---|---|
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 |
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 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) |
METRIC_CATEGORY | VARCHAR | Indicator of the type of consumption record (stream or sale). Streaming data is derived from the associated Musical Recordings |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
REPORTED_QUANTITY | NUMBER | 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 | NUMBER | 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. |
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
Streaming & Sales
Summary
The view VW_DAILY_FACT_MRELG_DETAIL_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 | Description |
|---|---|---|
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 |
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 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) |
METRIC_CATEGORY | VARCHAR | Indicator of the type of consumption record (stream or sale). Streaming data is derived from the associated Musical Recordings |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
REPORTED_QUANTITY | NUMBER | 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 | NUMBER | 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. |
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
Airplay
Summary
The view VW_DAILY_FACT_MRELG_AIRPLAY_DETAIL_DS provides access to the album-level radio 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 | Description |
|---|---|---|
MRELG_ID | VARCHAR | Unique Luminate ID associated to the Musical Release Group |
MARKET_ID | VARCHAR | 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 |
STATION_ID | VARCHAR | Unique ID assigned to the airplay station |
METRIC_CATEGORY | VARCHAR | Indicator for the type of consumption record |
AUDIENCE | VARCHAR | Estimated number of listeners for the corresponding spins |
QUANTITY | NUMBER | The number of spins associated with the record |
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
Streamings & Sales
Summary
The view VW_DAILY_FACT_ARTIST_DETAIL_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 | Description |
|---|---|---|
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 |
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) |
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 |
QUANTITY | NUMBER | The number of units associated with the record (10 streams, 1 sale, etc) |
REPORTED_QUANTITY | NUMBER | 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 | NUMBER | 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. |
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 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
Airplay
Summary
The view VW_DAILY_FACT_ARTIST_AIRPLAY_DETAIL_DS provides access to the artist-level airplay 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.
| Field Name | Data Type | Description |
|---|---|---|
ARTIST_ID | VARCHAR | Unique Luminate ID associated to the Artist |
MARKET_ID | VARCHAR | 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 |
STATION_ID | VARCHAR | Unique ID assigned to the airplay station |
METRIC_CATEGORY | VARCHAR | Indicator for the type of consumption record |
AUDIENCE | VARCHAR | Estimated number of listeners for the corresponding spins |
QUANTITY | NUMBER | The number of spins associated with the record |
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 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 12 days ago