DATABASE_NAME = "DELPHI_CRM_DATA" SCHEMA_NAME = "RAW_SALESFORCE_SALES_CLOUD" FORMS = "form_c" FORM_RESPONSES = "form_response_c" MAILING_LISTS = "mailing_list_c" SUBSCRIPTIONS = "subscription_c" PROMOTIONS = "promotion_c" FANS = "fan_c" TLAS = "tla_c" TLS = "tl_c" LABELS = "label_c" TERRITORIES = "territory_c" ARTISTS = "artist_c" APPROVAL_STAGE = "EXPORT_APPROVALS" # columns selected for form response or mailing list export selection_columns = { "form_name_column_key": "FORM.FORM_NAME_C AS FORM_NAME", "mailing_list_name_column_key": "ML.MAILING_LIST_NAME_C AS MAILING_LIST_NAME", "ml_created_date_column_key": "SUB.CREATED_DATE", "ml_promo_id_column_key": "PROMO.NAME", "ml_instagram_handle_column_key": "FAN.INSTAGRAM_HANDLE_C AS INSTAGRAM_HANDLE", "ml_active_column_key": "SUB.ACTIVE_C", "ml_promo_description_column_key": "PROMO.PROMO_DESCRIPTION_C", "email_column_key": "RESP.EMAIL_C AS EMAIL", "ml_email_column_key": "FAN.EMAIL_C AS EMAIL", "last_name_column_key": "RESP.LAST_NAME_C AS LAST_NAME", "ml_last_name_column_key": "FAN.LAST_NAME_C AS LAST_NAME", "gender_column_key": "RESP.GENDER_C AS GENDER", "ml_gender_column_key": "FAN.GENDER_C AS GENDER", "birthday_mm_dd_column_key": "RESP.BIRTHDAY_MM_DD_C AS BIRTHDAY_MM_DD", "ml_birthday_mm_dd_column_key": "FAN.BIRTHDAY_MM_DD_C AS BIRTHDAY_MM_DD", "city_column_key": "RESP.CITY_C AS CITY", "ml_city_column_key": "FAN.CITY_C AS CITY", "country_name_column_key": "RESP.COUNTRY_REGION_C AS COUNTRY", "ml_country_name_column_key": "FAN.COUNTRY_REGION_C AS COUNTRY", "mobile_phone_column_key": "RESP.MOBILE_PHONE_C AS MOBILE_PHONE", "ml_mobile_phone_column_key": "FAN.MOBILE_PHONE_C AS MOBILE_PHONE", "language_column_key": "RESP.PREFERRED_LANGUAGE_C AS LANGUAGE", "ml_language_column_key": "FAN.PREFERRED_LANGUAGE_C AS LANGUAGE", "preferred_genre_column_key": "RESP.PRIMARY_GENRE_C AS PREFERRED_GENRE", "ml_preferred_genre_column_key": "FAN.PRIMARY_GENRE_C AS PREFERRED_GENRE", "created_date_column_key": "RESP.CREATED_DATE AS CREATED_DATE", "first_name_column_key": "RESP.FIRST_NAME_C AS FIRST_NAME", "ml_first_name_column_key": "FAN.FIRST_NAME_C AS FIRST_NAME", "age_range_column_key": "RESP.AGE_RANGE_C AS AGE_RANGE", "ml_age_range_column_key": "FAN.AGE_RANGE_C AS AGE_RANGE", "address_column_key": "RESP.ADDRESS_1_C AS ADDRESS1", "address_column_key2": "RESP.ADDRESS_2_C AS ADDRESS2", "ml_address_column_key": "FAN.ADDRESS_1_C AS ADDRESS1", "ml_address_column_key2": "FAN.ADDRESS_2_C AS ADDRESS2", "birthdate_mm_dd_yyy_column_key": "RESP.BIRTHDAY_C AS BIRTHDATE", "ml_birthdate_mm_dd_yyy_column_key": "FAN.BIRTHDATE_C AS BIRTHDATE", "state_column_key": "RESP.STATE_C AS STATE", "ml_state_column_key": "FAN.STATE_C AS STATE", "postal_code_column_key": "RESP.POSTAL_CODE_C AS POSTAL_CODE", "ml_postal_code_column_key": "FAN.POSTAL_CODE_C AS POSTAL_CODE", "twitter_handle_column_key": "RESP.TWITTER_HANDLE_C AS TWITTER_HANDLE", "ml_twitter_handle_column_key": "FAN.TWITTER_HANDLE_C AS TWITTER_HANDLE", "dsp_column_key": "RESP.DSP_C AS DSP", "ml_dsp_column_key": "FAN.DSP_C AS DSP", } # columns selected for specific fans related export fan_export_selection_columns = { "email_column_key_2": "EMAIL_C", "mobile_phone_column_key_2": "MOBILE_PHONE_C", "first_name_column_key_2": "FIRST_NAME_C", "last_name_column_key_2": "LAST_NAME_C", "gender_column_key_2": "GENDER_C", "age_range_column_key_2": "AGE_RANGE_C", "birthday_mm_dd_column_key_2": "BIRTHDAY_MM_DD_C", "birthdate_mm_dd_yyy_column_key_2": "BIRTHDATE_C", "language_column_key_2": "PREFERRED_LANGUAGE_C", "country_name_column_key_2": "COUNTRY_REGION_C", "city_column_key_2": "CITY_C", "state_column_key_2": "STATE_C", "address_column_key_2": "ADDRESS_1_C", "postal_code_column_key_2": "POSTAL_CODE_C", "twitter_handle_column_key_2": "TWITTER_HANDLE_C", "dsp_column_key_2": "DSP_C", "created_date_column_key_2": "CREATED_DATE", } # mapping for renaming columns fan_export_column_mappings = { "EMAIL_C": "EMAIL", "MOBILE_PHONE_C": "MOBILE_PHONE", "FIRST_NAME_C": "FIRST_NAME", "LAST_NAME_C": "LAST_NAME", "GENDER_C": "GENDER", "AGE_RANGE_C": "AGE_RANGE", "BIRTHDAY_MM_DD_C": "BIRTHDAY_MM_DD", "BIRTHDATE_C": "BIRTHDATE", "PREFERRED_LANGUAGE_C": "PREFERRED_LANGUAGE", "COUNTRY_REGION_C": "COUNTRY_REGION", "CITY_C": "CITY", "STATE_C": "STATE", "ADDRESS_1_C": "ADDRESS_1", "ADDRESS_2_C": "ADDRESS_2", "POSTAL_CODE_C": "POSTAL_CODE", "TWITTER_HANDLE_C": "TWITTER_HANDLE", "DSP_C": "DSP", "CREATED_DATE": "CREATED_DATE", } main_filter_columns = [ "report_type", "approver", "requester", "justification", "detailed_justification", "recepient_name", "recepient_co", "recepient_email", "recepient_phone", "territory_key", "label_key", "artist_key", "mailing_list_status_key", ] # columns used for filtering export filter_columns_dict = { "start_date_key": {"operator": ">=", "column": "RESP.CREATED_DATE"}, "end_date_key": {"operator": "<=", "column": "RESP.CREATED_DATE"}, "form_id_keys": {"operator": "=", "column": "FORM.ID"}, "ccpa_do_not_sell_selection_key": {"operator": "=", "column": "CCPA_DO_NOT_SELL_C"}, "mailing_list_status_key": {"operator": "=", "column": "ML.ACTIVE_C"}, "mailing_list_keys": {"operator": "=", "column": "ML.MAILING_LIST_NAME_C"}, "mailing_list_form_id_key": {"operator": "=", "column": "SUB.FORM_ID_C"}, } # advanced_columns_used for filtering advanced_filter_columns_dict = { "fan_city_selection_key": {"column": "FAN.CITY_C", "key_value": "fan_city_value_key"}, "fan_state_selection_key": {"column": "FAN.STATE_C", "key_value": "fan_state_value_key"}, "fan_postal_code_selection_key": { "column": "FAN.POSTAL_CODE_C", "key_value": "fan_postal_code_value_key", }, "fan_country_selection_key": { "column": "FAN.COUNTRY_REGION_C", "key_value": "fan_country_value_key", }, } advanced_filter_operators_dict = { "Equal to": "=", "Not Equal to": "!=", } justifications_list = [ "Contest winner selection", "Label/Artist gifts to fans", "Event RSVP list", "Artist website use", "Partner collaboration", "Retargeting", "Send to artist manager", "Internal Analysis", "Other", ] custom_columns = [ "CUSTOM_FORM_FIELD_1_C", "CUSTOM_FORM_FIELD_2_C", "CUSTOM_FORM_FIELD_3_C", "CUSTOM_FORM_FIELD_4_C", "CUSTOM_FORM_FIELD_5_C", "CUSTOM_FORM_FIELD_6_C", "CUSTOM_FORM_FIELD_7_C", "CUSTOM_FORM_FIELD_8_C", "CUSTOM_FORM_FIELD_9_C", "CUSTOM_FORM_FIELD_10_C", "CUSTOM_FORM_FIELD_11_C", "CUSTOM_FORM_FIELD_12_C", "CUSTOM_FORM_FIELD_13_C", "CUSTOM_FORM_FIELD_14_C", "CUSTOM_FORM_FIELD_15_C", "CUSTOM_FORM_FIELD_16_C", "CUSTOM_FORM_FIELD_17_C", "CUSTOM_FORM_FIELD_18_C", "CUSTOM_FORM_FIELD_19_C", "CUSTOM_FORM_FIELD_20_C", ] desired_column_order = [ "FORM_NAME", "MAILING_LIST_NAME", "FAN_ID", "EMAIL", "MOBILE_PHONE", "NAME", "FIRST_NAME", "LAST_NAME", "LANGUAGE", "GENDER", "AGE_RANGE", "PREFERRED_LANGUAGE", "BIRTHDATE", "BIRTHDAY_MM_DD", "ADDRESS", "ADDRESS_2_C", "CITY", "STATE", "COUNTRY", "COUNTRY_REGION", "POSTAL_CODE", "CREATED_DATE", "ACTIVE_C", "PROMO_DESCRIPTION_C", "PREFERRED_GENRE", "TWITTER_HANDLE", "INSTAGRAM_HANDLE", "DSP", ] fan_id_sources = ["I want to use contest winner drawer", "I have list of fan ids in CSV file"]