version: 2
models:
  - name: TEXT_ANALYTICS_BENCHMARK_BY_ACCOUNT_ARTIST_DBT
    description: Benchmarks collected from Twilio and grouped by artist only for finished campaigns.
    tests:
      - dbt_utils.unique_combination_of_columns:
          arguments:
            combination_of_columns:
              - VENDOR_ID
              - SUBACCOUNT_ID
              - GLOBAL_PARTICIPANT_ID
    columns:
      - name: GLOBAL_PARTICIPANT_ID
        description: Id representing artist(global participant)
        tests:
          - not_null
      - name: VENDOR_ID
        description: Id representing vendor
        tests:
          - not_null
      - name: SUBACCOUNT_ID
        description: Id representing subaccount
        tests:
          - not_null
      - name: AVG_DELIVERY_RATE
        description: Weighted average delivery rate
      - name: AVG_DELIVERY_FAILED_RATE
        description: Weighted average delivery failed rate
      - name: AVG_CLICK_THROUGH_RATE
        description: Weighted average click through rate