Consumption Data: Summary
This article contains the details for all of the SUMMARY fact views that are available in Luminate's Data Share. These views exclude certain dimensions (market-level data, transaction information) and are reported at a national level. Due to these factors, the performance for these views is higher than those of the DETAIL fact views.
Musical Recording
Streaming & Sales
Summary
The view VW_DAILY_FACT_MR_SUMMARY_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 |
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 |
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_SUMMARY_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 |
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 |
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_SUMMARY_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 |
COUNTRY_CODE | VARCHAR | 2-digit country code using the ISO 3166-1 alpha-2 format |
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_SUMMARY_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 |
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) |
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 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_SUMMARY_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 |
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) |
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_SUMMARY_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 |
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) |
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_SUMMARY_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 |
COUNTRY_CODE | VARCHAR | 2-digit country code using the ISO 3166-1 alpha-2 format |
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
Streaming & Sales
Summary
The view VW_DAILY_FACT_ARTIST_SUMMARY_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 |
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) |
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_SUMMARY_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.
Details
| Field Name | Data Type | Description |
|---|---|---|
ARTIST_ID | VARCHAR | Unique Luminate ID associated to the Artist |
COUNTRY_CODE | VARCHAR | 2-digit country code using the ISO 3166-1 alpha-2 format |
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