version: 2 models: - name: FANS_BY_ARTIST_ACCOUNT_ACQUISITION_CHANNEL_DAILY_DBT description: '{{ doc("FANS_BY_ARTIST_ACCOUNT_ACQUISITION_CHANNEL_DAILY_DBT") }}' data_tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: - GLOBAL_PARTICIPANT_ID - VENDOR_ID - SUBACCOUNT_ID - ACQUISITION_CHANNEL - ACQUIRED_AT_DATE - dbt_expectations.expect_table_row_count_to_be_between: min_value: 1 - dbt_utils.expression_is_true: expression: "DAILY_RUNNING_TOTAL_EMAIL_ELIGIBLE_FANS_COUNT <= DAILY_RUNNING_TOTAL_FANS_COUNT" columns: - name: VENDOR_ID description: Vendor ID from Orchard data_tests: - not_null - name: SUBACCOUNT_ID description: Subaccount ID from Orchard data_tests: - not_null - name: GLOBAL_PARTICIPANT_ID description: Global participant ID from Orchard data_tests: - not_null - name: ACQUISITION_CHANNEL description: channel data_tests: - not_null - accepted_values: values: [ 'WYNG', 'FILE_UPLOAD_TOOL', 'SMF_BESPOKE_ACTIVATION', 'SMF_UNCATEGORIZED', 'SMF_PLAYLIST_GENERATOR_SPOTIFY_LIBRARY_SCAN', 'SMF_PLAYLIST_GENERATOR_QUIZ', 'SMF_SOCIAL_SIGNUP_FORM_COMBO', 'SMF_NEWSLETTER_SIGNUP', 'SMF_FAN_CARD_ACTIVATION', 'SMF_GENERAL_PRESAVE', 'SMF_GIVEAWAY', 'MAKE_THE_LINK', 'TUNESPEAK', 'SHOPIFY', 'MIGRATION', 'APPRECIATION_ENGINE', 'TICKETING', 'FEATURE_FM', 'SPOTIFY_SONY_MUSIC_NOW', 'PREVIOUS_MAILING_LIST', 'SMS_CAMPAIGNS', 'SEATED_LIST', 'BANDSINTOWN_LIST', 'LINKFIRE', 'MAESTRO_LIST', 'WEBSITE', 'PAST_PURCHASERS', 'SQWAD', 'INTERNAL_SONY_LIST_TRANSFER', 'LEVELLR', 'EVENT_SHOP', 'SONGWHIP_PRE_SAVE', 'SONGWHIP_EXCLUSIVE_CONTENT'] where: "ACQUISITION_CHANNEL NOT LIKE 'ROSALIA_%'" - name: ACQUIRED_AT_DATE description: Date representing fan acquisition data_tests: - not_null - name: DAILY_RUNNING_TOTAL_FANS_COUNT description: Cumulative count of fans per day data_tests: - not_null - fans_count_equal_to_source_daily: value_column: "ACQUISITION_CHANNEL" date_column: "ACQUIRED_AT_DATE" - name: DAILY_RUNNING_TOTAL_EMAIL_ELIGIBLE_FANS_COUNT description: Cumulative count of email eligible fans per day (forward-filled) data_tests: - not_null - name: FANS_BY_ARTIST_ACCOUNT_ACQUISITION_CHANNEL_COUNTRY_DAILY_DBT description: '{{ doc("FANS_BY_ARTIST_ACCOUNT_ACQUISITION_CHANNEL_COUNTRY_DAILY_DBT") }}' data_tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: - GLOBAL_PARTICIPANT_ID - VENDOR_ID - SUBACCOUNT_ID - COUNTRY_ISO2 - ACQUISITION_CHANNEL - ACQUIRED_AT_DATE - dbt_expectations.expect_table_row_count_to_be_between: min_value: 1 - dbt_utils.expression_is_true: expression: "DAILY_RUNNING_TOTAL_EMAIL_ELIGIBLE_FANS_COUNT <= DAILY_RUNNING_TOTAL_FANS_COUNT" columns: - name: VENDOR_ID description: Vendor ID from Orchard data_tests: - not_null - name: SUBACCOUNT_ID description: Subaccount ID from Orchard data_tests: - not_null - name: GLOBAL_PARTICIPANT_ID description: Global participant ID from Orchard data_tests: - not_null - name: COUNTRY_ISO2 description: Country code in ISO2 format data_tests: - not_null - name: ACQUISITION_CHANNEL description: channel data_tests: - not_null - accepted_values: values: [ 'WYNG', 'FILE_UPLOAD_TOOL', 'SMF_BESPOKE_ACTIVATION', 'SMF_UNCATEGORIZED', 'SMF_PLAYLIST_GENERATOR_SPOTIFY_LIBRARY_SCAN', 'SMF_PLAYLIST_GENERATOR_QUIZ', 'SMF_SOCIAL_SIGNUP_FORM_COMBO', 'SMF_NEWSLETTER_SIGNUP', 'SMF_FAN_CARD_ACTIVATION', 'SMF_GENERAL_PRESAVE', 'SMF_GIVEAWAY', 'MAKE_THE_LINK', 'TUNESPEAK', 'SHOPIFY', 'MIGRATION', 'APPRECIATION_ENGINE', 'TICKETING', 'FEATURE_FM', 'SPOTIFY_SONY_MUSIC_NOW', 'PREVIOUS_MAILING_LIST', 'SMS_CAMPAIGNS', 'SEATED_LIST', 'BANDSINTOWN_LIST', 'LINKFIRE', 'MAESTRO_LIST', 'WEBSITE', 'PAST_PURCHASERS', 'SQWAD', 'INTERNAL_SONY_LIST_TRANSFER', 'LEVELLR', 'EVENT_SHOP', 'SONGWHIP_PRE_SAVE', 'SONGWHIP_EXCLUSIVE_CONTENT'] where: "ACQUISITION_CHANNEL NOT LIKE 'ROSALIA_%'" - name: ACQUIRED_AT_DATE description: Date representing fan acquisition data_tests: - not_null - name: DAILY_RUNNING_TOTAL_FANS_COUNT description: Cumulative count of fans per day data_tests: - not_null - fans_count_equal_to_source_country_daily: value_column: "ACQUISITION_CHANNEL" date_column: "ACQUIRED_AT_DATE" - name: DAILY_RUNNING_TOTAL_EMAIL_ELIGIBLE_FANS_COUNT description: Cumulative count of email eligible fans per day (forward-filled) data_tests: - not_null - name: FANS_BY_ARTIST_ACCOUNT_ACQUISITION_CHANNEL_DBT description: '{{ doc("FANS_BY_ARTIST_ACCOUNT_ACQUISITION_CHANNEL_DBT") }}' data_tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: - GLOBAL_PARTICIPANT_ID - VENDOR_ID - SUBACCOUNT_ID - ACQUISITION_CHANNEL - dbt_expectations.expect_table_row_count_to_be_between: min_value: 1 - dbt_utils.expression_is_true: expression: "EMAIL_ELIGIBLE_FANS_COUNT <= FANS_COUNT" columns: - name: VENDOR_ID description: Vendor ID from Orchard data_tests: - not_null - name: SUBACCOUNT_ID description: Subaccount ID from Orchard data_tests: - not_null - name: GLOBAL_PARTICIPANT_ID description: Global participant ID from Orchard data_tests: - not_null - name: ACQUISITION_CHANNEL description: channel data_tests: - not_null - accepted_values: values: [ 'WYNG', 'FILE_UPLOAD_TOOL', 'SMF_BESPOKE_ACTIVATION', 'SMF_UNCATEGORIZED', 'SMF_PLAYLIST_GENERATOR_SPOTIFY_LIBRARY_SCAN', 'SMF_PLAYLIST_GENERATOR_QUIZ', 'SMF_SOCIAL_SIGNUP_FORM_COMBO', 'SMF_NEWSLETTER_SIGNUP', 'SMF_FAN_CARD_ACTIVATION', 'SMF_GENERAL_PRESAVE', 'SMF_GIVEAWAY', 'MAKE_THE_LINK', 'TUNESPEAK', 'SHOPIFY', 'MIGRATION', 'APPRECIATION_ENGINE', 'TICKETING', 'FEATURE_FM', 'SPOTIFY_SONY_MUSIC_NOW', 'PREVIOUS_MAILING_LIST', 'SMS_CAMPAIGNS', 'SEATED_LIST', 'BANDSINTOWN_LIST', 'LINKFIRE', 'MAESTRO_LIST', 'WEBSITE', 'PAST_PURCHASERS', 'SQWAD', 'INTERNAL_SONY_LIST_TRANSFER', 'LEVELLR', 'EVENT_SHOP', 'SONGWHIP_PRE_SAVE', 'SONGWHIP_EXCLUSIVE_CONTENT'] where: "ACQUISITION_CHANNEL NOT LIKE 'ROSALIA_%'" - name: FANS_COUNT description: Total fans count data_tests: - not_null - fans_count_equal_to_source - name: EMAIL_ELIGIBLE_FANS_COUNT description: Count of fans with email marketing consent data_tests: - not_null - name: FANS_BY_ARTIST_ACCOUNT_ACQUISITION_CHANNEL_COUNTRY_DBT description: '{{ doc("FANS_BY_ARTIST_ACCOUNT_ACQUISITION_CHANNEL_COUNTRY_DBT") }}' data_tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: - GLOBAL_PARTICIPANT_ID - VENDOR_ID - SUBACCOUNT_ID - COUNTRY_ISO2 - ACQUISITION_CHANNEL - dbt_expectations.expect_table_row_count_to_be_between: min_value: 1 - dbt_utils.expression_is_true: expression: "EMAIL_ELIGIBLE_FANS_COUNT <= FANS_COUNT" columns: - name: VENDOR_ID description: Vendor ID from Orchard data_tests: - not_null - name: SUBACCOUNT_ID description: Subaccount ID from Orchard data_tests: - not_null - name: GLOBAL_PARTICIPANT_ID description: Global participant ID from Orchard data_tests: - not_null - name: COUNTRY_ISO2 description: Country code in ISO2 format data_tests: - not_null - name: ACQUISITION_CHANNEL description: channel data_tests: - not_null - accepted_values: values: [ 'WYNG', 'FILE_UPLOAD_TOOL', 'SMF_BESPOKE_ACTIVATION', 'SMF_UNCATEGORIZED', 'SMF_PLAYLIST_GENERATOR_SPOTIFY_LIBRARY_SCAN', 'SMF_PLAYLIST_GENERATOR_QUIZ', 'SMF_SOCIAL_SIGNUP_FORM_COMBO', 'SMF_NEWSLETTER_SIGNUP', 'SMF_FAN_CARD_ACTIVATION', 'SMF_GENERAL_PRESAVE', 'SMF_GIVEAWAY', 'MAKE_THE_LINK', 'TUNESPEAK', 'SHOPIFY', 'MIGRATION', 'APPRECIATION_ENGINE', 'TICKETING', 'FEATURE_FM', 'SPOTIFY_SONY_MUSIC_NOW', 'PREVIOUS_MAILING_LIST', 'SMS_CAMPAIGNS', 'SEATED_LIST', 'BANDSINTOWN_LIST', 'LINKFIRE', 'MAESTRO_LIST', 'WEBSITE', 'PAST_PURCHASERS', 'SQWAD', 'INTERNAL_SONY_LIST_TRANSFER', 'LEVELLR', 'EVENT_SHOP', 'SONGWHIP_PRE_SAVE', 'SONGWHIP_EXCLUSIVE_CONTENT'] where: "ACQUISITION_CHANNEL NOT LIKE 'ROSALIA_%'" - name: FANS_COUNT description: Total fans count data_tests: - not_null - fans_count_equal_to_source_country - name: EMAIL_ELIGIBLE_FANS_COUNT description: Count of fans with email marketing consent data_tests: - not_null - name: GLOBAL_FANS_BY_ARTIST_ACQUISITION_CHANNEL_DAILY_DBT description: '{{ doc("GLOBAL_FANS_BY_ARTIST_ACQUISITION_CHANNEL_DAILY_DBT") }}' data_tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: - GLOBAL_PARTICIPANT_ID - ACQUISITION_CHANNEL - ACQUIRED_AT_DATE - dbt_expectations.expect_table_row_count_to_be_between: min_value: 1 - dbt_utils.expression_is_true: expression: "DAILY_RUNNING_TOTAL_EMAIL_ELIGIBLE_FANS_COUNT <= DAILY_RUNNING_TOTAL_FANS_COUNT" columns: - name: GLOBAL_PARTICIPANT_ID description: Global participant ID from Orchard data_tests: - not_null - name: ACQUISITION_CHANNEL description: channel data_tests: - not_null - accepted_values: values: [ 'WYNG', 'FILE_UPLOAD_TOOL', 'SMF_BESPOKE_ACTIVATION', 'SMF_UNCATEGORIZED', 'SMF_PLAYLIST_GENERATOR_SPOTIFY_LIBRARY_SCAN', 'SMF_PLAYLIST_GENERATOR_QUIZ', 'SMF_SOCIAL_SIGNUP_FORM_COMBO', 'SMF_NEWSLETTER_SIGNUP', 'SMF_FAN_CARD_ACTIVATION', 'SMF_GENERAL_PRESAVE', 'SMF_GIVEAWAY', 'MAKE_THE_LINK', 'TUNESPEAK', 'SHOPIFY', 'MIGRATION', 'APPRECIATION_ENGINE', 'TICKETING', 'FEATURE_FM', 'SPOTIFY_SONY_MUSIC_NOW', 'PREVIOUS_MAILING_LIST', 'SMS_CAMPAIGNS', 'SEATED_LIST', 'BANDSINTOWN_LIST', 'LINKFIRE', 'MAESTRO_LIST', 'WEBSITE', 'PAST_PURCHASERS', 'SQWAD', 'INTERNAL_SONY_LIST_TRANSFER', 'LEVELLR', 'EVENT_SHOP', 'SONGWHIP_PRE_SAVE', 'SONGWHIP_EXCLUSIVE_CONTENT'] where: "ACQUISITION_CHANNEL NOT LIKE 'ROSALIA_%'" - name: ACQUIRED_AT_DATE description: Date representing fan acquisition data_tests: - not_null - name: DAILY_RUNNING_TOTAL_FANS_COUNT description: Cumulative count of fans per day data_tests: - not_null - global_fans_count_equal_to_source_daily: value_column: "ACQUISITION_CHANNEL" date_column: "ACQUIRED_AT_DATE" - name: DAILY_RUNNING_TOTAL_EMAIL_ELIGIBLE_FANS_COUNT description: Cumulative count of email eligible fans per day (forward-filled) data_tests: - not_null - name: GLOBAL_FANS_BY_ARTIST_ACQUISITION_CHANNEL_COUNTRY_DAILY_DBT description: '{{ doc("GLOBAL_FANS_BY_ARTIST_ACQUISITION_CHANNEL_COUNTRY_DAILY_DBT") }}' data_tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: - GLOBAL_PARTICIPANT_ID - COUNTRY_ISO2 - ACQUISITION_CHANNEL - ACQUIRED_AT_DATE - dbt_expectations.expect_table_row_count_to_be_between: min_value: 1 - dbt_utils.expression_is_true: expression: "DAILY_RUNNING_TOTAL_EMAIL_ELIGIBLE_FANS_COUNT <= DAILY_RUNNING_TOTAL_FANS_COUNT" columns: - name: GLOBAL_PARTICIPANT_ID description: Global participant ID from Orchard data_tests: - not_null - name: COUNTRY_ISO2 description: Country code in ISO2 format data_tests: - not_null - name: ACQUISITION_CHANNEL description: channel data_tests: - not_null - accepted_values: values: [ 'WYNG', 'FILE_UPLOAD_TOOL', 'SMF_BESPOKE_ACTIVATION', 'SMF_UNCATEGORIZED', 'SMF_PLAYLIST_GENERATOR_SPOTIFY_LIBRARY_SCAN', 'SMF_PLAYLIST_GENERATOR_QUIZ', 'SMF_SOCIAL_SIGNUP_FORM_COMBO', 'SMF_NEWSLETTER_SIGNUP', 'SMF_FAN_CARD_ACTIVATION', 'SMF_GENERAL_PRESAVE', 'SMF_GIVEAWAY', 'MAKE_THE_LINK', 'TUNESPEAK', 'SHOPIFY', 'MIGRATION', 'APPRECIATION_ENGINE', 'TICKETING', 'FEATURE_FM', 'SPOTIFY_SONY_MUSIC_NOW', 'PREVIOUS_MAILING_LIST', 'SMS_CAMPAIGNS', 'SEATED_LIST', 'BANDSINTOWN_LIST', 'LINKFIRE', 'MAESTRO_LIST', 'WEBSITE', 'PAST_PURCHASERS', 'SQWAD', 'INTERNAL_SONY_LIST_TRANSFER', 'LEVELLR', 'EVENT_SHOP', 'SONGWHIP_PRE_SAVE', 'SONGWHIP_EXCLUSIVE_CONTENT'] where: "ACQUISITION_CHANNEL NOT LIKE 'ROSALIA_%'" - name: ACQUIRED_AT_DATE description: Date representing fan acquisition data_tests: - not_null - name: DAILY_RUNNING_TOTAL_FANS_COUNT description: Cumulative count of fans per day data_tests: - not_null - global_fans_count_equal_to_source_country_daily: value_column: "ACQUISITION_CHANNEL" date_column: "ACQUIRED_AT_DATE" - name: DAILY_RUNNING_TOTAL_EMAIL_ELIGIBLE_FANS_COUNT description: Cumulative count of email eligible fans per day (forward-filled) data_tests: - not_null - name: GLOBAL_FANS_BY_ARTIST_ACQUISITION_CHANNEL_DBT description: '{{ doc("GLOBAL_FANS_BY_ARTIST_ACQUISITION_CHANNEL_DBT") }}' data_tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: - GLOBAL_PARTICIPANT_ID - ACQUISITION_CHANNEL - dbt_expectations.expect_table_row_count_to_be_between: min_value: 1 - dbt_utils.expression_is_true: expression: "EMAIL_ELIGIBLE_FANS_COUNT <= FANS_COUNT" columns: - name: GLOBAL_PARTICIPANT_ID description: Global participant ID from Orchard data_tests: - not_null - name: ACQUISITION_CHANNEL description: channel data_tests: - not_null - accepted_values: values: [ 'WYNG', 'FILE_UPLOAD_TOOL', 'SMF_BESPOKE_ACTIVATION', 'SMF_UNCATEGORIZED', 'SMF_PLAYLIST_GENERATOR_SPOTIFY_LIBRARY_SCAN', 'SMF_PLAYLIST_GENERATOR_QUIZ', 'SMF_SOCIAL_SIGNUP_FORM_COMBO', 'SMF_NEWSLETTER_SIGNUP', 'SMF_FAN_CARD_ACTIVATION', 'SMF_GENERAL_PRESAVE', 'SMF_GIVEAWAY', 'MAKE_THE_LINK', 'TUNESPEAK', 'SHOPIFY', 'MIGRATION', 'APPRECIATION_ENGINE', 'TICKETING', 'FEATURE_FM', 'SPOTIFY_SONY_MUSIC_NOW', 'PREVIOUS_MAILING_LIST', 'SMS_CAMPAIGNS', 'SEATED_LIST', 'BANDSINTOWN_LIST', 'LINKFIRE', 'MAESTRO_LIST', 'WEBSITE', 'PAST_PURCHASERS', 'SQWAD', 'INTERNAL_SONY_LIST_TRANSFER', 'LEVELLR', 'EVENT_SHOP', 'SONGWHIP_PRE_SAVE', 'SONGWHIP_EXCLUSIVE_CONTENT'] where: "ACQUISITION_CHANNEL NOT LIKE 'ROSALIA_%'" - name: FANS_COUNT description: Total fans count data_tests: - not_null - global_fans_count_equal_to_source - name: EMAIL_ELIGIBLE_FANS_COUNT description: Count of fans with email marketing consent data_tests: - not_null - name: GLOBAL_FANS_BY_ARTIST_ACQUISITION_CHANNEL_COUNTRY_DBT description: '{{ doc("GLOBAL_FANS_BY_ARTIST_ACQUISITION_CHANNEL_COUNTRY_DBT") }}' data_tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: - GLOBAL_PARTICIPANT_ID - COUNTRY_ISO2 - ACQUISITION_CHANNEL - dbt_expectations.expect_table_row_count_to_be_between: min_value: 1 - dbt_utils.expression_is_true: expression: "EMAIL_ELIGIBLE_FANS_COUNT <= FANS_COUNT" columns: - name: GLOBAL_PARTICIPANT_ID description: Global participant ID from Orchard data_tests: - not_null - name: COUNTRY_ISO2 description: Country code in ISO2 format data_tests: - not_null - name: ACQUISITION_CHANNEL description: channel data_tests: - not_null - accepted_values: values: [ 'WYNG', 'FILE_UPLOAD_TOOL', 'SMF_BESPOKE_ACTIVATION', 'SMF_UNCATEGORIZED', 'SMF_PLAYLIST_GENERATOR_SPOTIFY_LIBRARY_SCAN', 'SMF_PLAYLIST_GENERATOR_QUIZ', 'SMF_SOCIAL_SIGNUP_FORM_COMBO', 'SMF_NEWSLETTER_SIGNUP', 'SMF_FAN_CARD_ACTIVATION', 'SMF_GENERAL_PRESAVE', 'SMF_GIVEAWAY', 'MAKE_THE_LINK', 'TUNESPEAK', 'SHOPIFY', 'MIGRATION', 'APPRECIATION_ENGINE', 'TICKETING', 'FEATURE_FM', 'SPOTIFY_SONY_MUSIC_NOW', 'PREVIOUS_MAILING_LIST', 'SMS_CAMPAIGNS', 'SEATED_LIST', 'BANDSINTOWN_LIST', 'LINKFIRE', 'MAESTRO_LIST', 'WEBSITE', 'PAST_PURCHASERS', 'SQWAD', 'INTERNAL_SONY_LIST_TRANSFER', 'LEVELLR', 'EVENT_SHOP', 'SONGWHIP_PRE_SAVE', 'SONGWHIP_EXCLUSIVE_CONTENT'] where: "ACQUISITION_CHANNEL NOT LIKE 'ROSALIA_%'" - name: FANS_COUNT description: Total fans count data_tests: - not_null - global_fans_count_equal_to_source_country - name: EMAIL_ELIGIBLE_FANS_COUNT description: Count of fans with email marketing consent data_tests: - not_null