version: 2

models:
  - name: fct_orchard_insights_top_streams_metrics_tiktok_by_label
    description: |
      A mart table that recreates a view in Orchard Insights, that generates top level streaming metrics for labels across all DSPs and seperately for TikTok. Adapted from [this query](https://github.com/theorchard/ows-analytics/blob/master/analytics/models/queries/top_metrics_tiktok/top_metrics_and_total_results_by_country.sql).
    columns:
      - name: isrc
        description: "The unique identifier for the music track."
      - name: label_id
        description: "The identifier for the label of the music track."
      - name: release_date
        description: "The release date of the music track."
      - name: streams_1_day
        description: "The number of streams the music track has received in the past 24 hours."
      - name: growth_percentage_1_day
        description: "The percentage change in streams for the music track in the past 24 hours compared to the previous day."
      - name: streams_7_days
        description: "The number of streams the music track has received in the past 7 days."
      - name: growth_percentage_7_days
        description: "The percentage change in streams for the music track in the past 7 days compared to the previous 7 days."
      - name: streams_28_days
        description: "The number of streams the music track has received in the past 28 days."
      - name: growth_percentage_28_days
        description: "The percentage change in streams for the music track in the past 28 days compared to the previous 28 days."
      - name: streams_183_days
        description: "The number of streams the music track has received in the past 183 days."
      - name: growth_percentage_183_days
        description: "The percentage change in streams for the music track in the past 183 days compared to the previous 183 days."
      - name: streams_365_days
        description: "The number of streams the music track has received in the past 365 days."
      - name: growth_percentage_365_days
        description: "The percentage change in streams for the music track in the past 365 days compared to the previous 365 days."
      - name: streams_all_time
        description: "The total number of streams the music track has received since its release."
      - name: views_1_day
        description: "The number of views the music track has received on social media in the past 24 hours."
      - name: views_growth_percentage_1_day
        description: "The percentage change in views for the music track on social media in the past 24 hours compared to the previous day."
      - name: views_7_days
        description: "The number of views the music track has received on social media in the past 7 days."
      - name: views_growth_percentage_7_days
        description: "The percentage change in views for the music track on social media in the past 7 days compared to the previous 7 days."
      - name: views_28_days
        description: "The number of views the music track has received on social media in the past 28 days."
      - name: views_growth_percentage_28_days
        description: "The percentage change in views for the music track on social media in the past 28 days compared to the previous 28 days."
      - name: views_all_time
        description: "The total number of views the music track has received on social media since its release."
      - name: creations_1_day
        description: "The number of user creations (e.g. videos) on social media that use the music track in the past 24 hours."