version: 2
seeds:
  - name: FACEBOOK_ADS__OBJECTIVE_MAPPING_DBT
    description: |
      A mapping between old and new Facebook Ads Campaign Objectives.
      Source: https://developers.facebook.com/docs/marketing-api/reference/ad-campaign-group/
    config:
      column_types:
        OLD_OBJECTIVE: VARCHAR(16777216)
        NEW_OBJECTIVE: VARCHAR(16777216)
    columns:
      - name: OLD_OBJECTIVE
      - name: NEW_OBJECTIVE
  - name: FACEBOOK_ADS__ACCOUNT_CAMPAIGN_NAMING_DBT
    description: |
      A mapping between an Account and its campaign naming convention to help extract Artist names and map them to Global Participants
    config:
      column_types:
        VENDOR_ID: NUMBER(32)
        SUBACCOUNT_ID: NUMBER(32)
        DELIMITERS: VARCHAR(16777216)
        ARTIST_NAME_PART_NUMBER: NUMBER(32)
        JW_SIMILARITY_THRESHOLD: NUMBER(32)
        LOOKUP_ARTISTS_FROM_BRAND:  VARCHAR(16777216)
    columns:
      - name: VENDOR_ID
      - name: SUBACCOUNT_ID
      - name: DELIMITERS
      - name: ARTIST_NAME_PART_NUMBER
      - name: JW_SIMILARITY_THRESHOLD
      - name: LOOKUP_ARTISTS_FROM_BRAND
  - name: TIKTOK_ADS__OBJECTIVE_MAPPING_DBT
    description: |
      A mapping to convert Deprecated TikTok Advertising Objective to new ones.
      Source: https://business-api.tiktok.com/gateway/docs/index?identify_key=c0138ffadd90a955c1f0670a56fe348d1d40680b3c89461e09f78ed26785164b&language=ENGLISH&doc_id=1737174886619138#item-link-Advertising%20Objective%20(objective_type)
    config:
      column_types:
        OLD_OBJECTIVE: VARCHAR(16777216)
        NEW_OBJECTIVE: VARCHAR(16777216)
    columns:
      - name: OLD_OBJECTIVE
      - name: NEW_OBJECTIVE
  - name: TIKTOK_ADS__ACCOUNT_CAMPAIGN_NAMING_DBT
    description: |
      A mapping between an Account and its campaign naming convention to help extract Artist names and map them to Global Participants
    config:
      column_types:
        VENDOR_ID: NUMBER(32)
        SUBACCOUNT_ID: NUMBER(32)
        DELIMITERS: VARCHAR(16777216)
        ARTIST_NAME_PART_NUMBER: NUMBER(32)
        JW_SIMILARITY_THRESHOLD: NUMBER(32)
        LOOKUP_ARTISTS_FROM_BRAND:  VARCHAR(16777216)
    columns:
      - name: VENDOR_ID
      - name: SUBACCOUNT_ID
      - name: DELIMITERS
      - name: ARTIST_NAME_PART_NUMBER
      - name: JW_SIMILARITY_THRESHOLD
      - name: LOOKUP_ARTISTS_FROM_BRAND
  - name: GLOBAL_PARTICIPANT_ADVERTISING_ROSTER_DBT
    description: |
      List of Global Participants that an Account is running advertising for. Used for Campaign-Artist matching by name
    config:
      column_types:
        ID: VARCHAR(16777216)
        VENDOR_ID: NUMBER(32)
        SUBACCOUNT_ID: NUMBER(32)
    columns:
      - name: ID
      - name: VENDOR_ID
      - name: SUBACCOUNT_ID