version: 2 models: - name: business_review_monthly_accounting_non_release_level description: "Accounting Model for Business Reviews at the monthly non-release level grain" data_tests: - has_data columns: - name: label_id description: "The Label Id" - name: accounting_month description: "The accounting month" - name: activity_month description: "The activity month" - name: transaction_country_name description: "The transaction country" - name: transaction_country_code description: "The transaction country code" - name: store_id description: "The store unique identifier" - name: store_name description: "The store name" - name: transaction_group description: "The transaction group, calculated from the activity date" - name: payout_currency_name description: "The payout currenct name" - name: payout_currency_code description: "The payout currency code" - name: label_name description: "The label nae" - name: digital_v_physical description: "Flag to indicate if the sale was physical or digital" - name: units description: "The number of sales" - name: gross_revenue_payout_currency description: "The gross revenue in the payout currency" - name: net_revenue_payout_currency description: "The new revenue in the payout currency" - name: gross_revenue_usd description: "The gross revenue in USD" - name: new_revenue_usd description: "The new revenue in USD " config: access: public - name: business_review_monthly_accounting_release_level description: "Business review accounting model at the release level. Includes subaccount" columns: - name: label_id description: "The label unique identifier" - name: label_name description: "The label name" - name: accounting_month description: "The accounting month" - name: activity_month description: "The actvity month" - name: transaction_country_name description: "The transaction country name" - name: transaction_country_code description: "The transaction country code" - name: artist_name description: "The artist name" - name: upc description: "The UPC" - name: release_name description: "The release name" - name: display_configuration description: "The display config e.g. CD, Vinyl..." - name: digital_v_physical description: "Flag to show if the sale was digital or physical" - name: catalog_type description: "The Catalog Type calculated from activity date" - name: release_date description: "The release date" - name: sale_start_date description: "The sale start date" - name: transaction_group description: "The transaction group" - name: units description: "The number of units sold" - name: gross_revenue_usd description: "Gross sales in USD" - name: net_revenue_usd description: "Net sales in USD" - name: payout_currency_name description: "Payout currency name" - name: payout_currency_code description: "Payout currency code" - name: gross_revenue_payout_currency description: "Gross sales in payout currency" - name: net_revenue_payout_currency description: "Net sales in payout currency" - name: subaccount_id description: "The subaccount id" - name: subaccount_name description: "The subaccount name" - name: store_id description: "The store unique identifier" - name: store_name description: "The store name" config: access: public - name: business_review_monthly_physical description: "Business review accounting deck for non-release level physical only" columns: - name: label_id description: "The label unique identifier" - name: accounting_month description: "The accounting month" - name: activity_month description: "The accounting month" - name: upc description: "The UPC" - name: sale_start_date description: "The sale start date" - name: release_date description: "The release date" - name: release_name description: "The release name" - name: artist_name description: "The artist name" - name: store_name description: "The store name" - name: transaction_country_name description: "The transaction country name" - name: transaction_country_code description: "The trasaction country code" - name: payout_currency_name description: "The payout currency name" - name: payout_currency_code description: "The payout currency code" - name: units description: "The phyiscal units sold" - name: gross_revenue_payout_currency description: "Gross physical sales in payout currency" - name: net_revenue_payout_currency description: "Net physical sales in payout currency" - name: gross_revenue_usd description: "Gross physical sales in USD" - name: new_revenue_usd description: "Net physcial sales in USD" config: access: public - name: business_review_monthly_analytics_all_stores description: "Weekly grain dataset for all stores for business reviews" columns: - name: download_activity_month description: "The download month" - name: label_id description: "The label id" - name: label_name description: "The Label Name" - name: store description: "The Store Name" - name: sub_store description: "The Sub Store name" - name: catalog_type description: "The catalog type" - name: subscription_type description: "The subscription type" - name: source_of_stream_buckets description: "The source of stream bucket" - name: subaccount_id description: "Subaccount ID" - name: subaccount_name description: "The subaccount name" - name: artist_id description: "The artist unique identifier" - name: artist_name description: "The artist name" - name: sale_start_date description: "The release date for each individual release" - name: streams description: "The number of streams" - name: business_review_weekly_analytics_all_stores description: "Weekly grain dataset for all stores for business reviews" columns: - name: download_activity_month description: "The download month" - name: label_id description: "The label id" - name: label_name description: "The Label Name" - name: store description: "The Store Name" - name: sub_store description: "The Sub Store name" - name: catalog_type description: "The catalog type" - name: subscription_type description: "The subscription type" - name: source_of_stream_buckets description: "The source of stream bucket" - name: subaccount_id description: "Subaccount ID" - name: subaccount_name description: "The subaccount name" - name: artist_id description: "The artist unique identifier" - name: artist_name description: "The artist name" - name: sale_start_date description: "The release date for each individual release" - name: streams description: "The number of streams"