fostergn/drip-campaign.csv

## drip-campaign.csv

          
            Shop ID
            Campaign Name
            Segment Name
            User Filters
            Campaigns in Drip

            
              372
              VDAY Promo: 2+ Purchase Old Subscriber
              Total Spend $70-$7000 - US
              (total_spent_cents ge 10000 OR num_of_orders gt 1 OR subscriber_clicked_campaign_id in 331264 OR subscriber_keywords in 90417 OR subscriber_has_received_automation in 210872) AND (country_code,eq,US)
              3

            
              372
              70-7000 Purchase Old Subscriber (copy)
              Total Spend $70-$7000 - US
              (total_spent_cents ge 10000 OR num_of_orders gt 1 OR subscriber_clicked_campaign_id in 331264 OR subscriber_keywords in 90417 OR subscriber_has_received_automation in 210872) AND (country_code,eq,US)
              3

            
              372
              new campaign
              Total Spend $70-$7000 - US
              (total_spent_cents ge 10000 OR num_of_orders gt 1 OR subscriber_clicked_campaign_id in 331264 OR subscriber_keywords in 90417 OR subscriber_has_received_automation in 210872) AND (country_code,eq,US)
              3

            
              374
              VALENTINES DAY SALES '22 SECOND
              ENGAGED 2021
              (subscriber_clicked_campaign_id in 97873 OR subscriber_clicked_campaign_id in 89359 OR subscriber_clicked_campaign_id in 84737 OR subscriber_clicked_campaign_id in 81677 OR subscriber_clicked_campaign_id in 47447 OR subscriber_clicked_campaign_id in 58033 OR subscriber_clicked_campaign_id in 73383 OR subscriber_clicked_campaign_id in 19496)
              2

            
              374
              Presidents’ Day sale 
              ENGAGED 2021
              (subscriber_clicked_campaign_id in 97873 OR subscriber_clicked_campaign_id in 89359 OR subscriber_clicked_campaign_id in 84737 OR subscriber_clicked_campaign_id in 81677 OR subscriber_clicked_campaign_id in 47447 OR subscriber_clicked_campaign_id in 58033 OR subscriber_clicked_campaign_id in 73383 OR subscriber_clicked_campaign_id in 19496)
              2

            
              783
              received VDAY sale text - did not order yet 
              received VDAY sale text - did not order yet 
              (subscriber_received_campaign_id in 332080) AND (last_order_date lt 2022-02-11)
              5

            
              783
              VDAY SALE - FINAL CALL
              received VDAY text - did not order today yet
              (subscriber_received_campaign_id in 334404) AND (last_order_date lt 2022-02-14)
              5

            
              783
              BDAY BOGO - text 2
              clicked bday text did not order
              (subscriber_clicked_campaign_id in 344499) AND (last_order_date lt 2022-02-27)
              5

            
              783
              TRUE CRIME & WIENER DOGS DROP #2 (copy)
              Clicked TCWD text 
              (subscriber_clicked_campaign_id in 348874)
              5

            
              783
              NEW CUSTOM SHIRT 2
              clicked new custom tee text - didn't order yet
              (subscriber_clicked_campaign_id in 352379) AND (last_order_date le 2022-03-09)
              5

            
              1977
              Valentine's Day Sale 25% 021122 Retarget
              Valentine's Sale Retarget no open/orders 021122
              (subscriber_received_campaign_id in 331377 OR subscriber_received_campaign_id in 331374 OR subscriber_received_campaign_id in 329862 OR subscriber_received_campaign_id in 330540) AND (subscriber_clicked_campaign_id ni 331377 OR subscriber_clicked_campaign_id ni 331374 OR subscriber_clicked_campaign_id ni 329862 OR subscriber_clicked_campaign_id ni 330540) AND (last_order_date wl 90) AND (subscriber_is_international ne true)
              2

            
              1977
              Valentine's Day Sale 25% 021122 Total Spend $100-500
              Total Spend $100-$500 US
              (total_spent_cents,lt,50000) AND (total_spent_cents,ge,10000) AND (subscriber_is_international ne true) AND (subscriber_received_campaign_id in 231026) AND (subscriber_clicked_campaign_id ni 231026)
              2

            
              2579
              02.27.22 - Scorch Restock Sale is Closing | exclu Scorch Buyers
              02.27.2022 - Scorch Segment Non Scorch Buyers
              (subscriber_received_campaign_id in 337467) AND (subscriber_clicked_campaign_id in 337498) AND (subscriber_is_in_klaviyo_list ni TkXDkf)
              2

            
              2579
              03.04.22_POM#12 Is Selling Fast UPDATE
              03.04.22 - POM 12 Selling Fast
              (subscriber_clicked_campaign_id in 347247 OR subscriber_clicked_campaign_id in 347264 OR subscriber_received_campaign_id in 347261 OR subscriber_received_campaign_id in 347228) AND (subscriber_is_in_klaviyo_list ni YzyfU4)
              2

            
              2619
              Bling Clicked - No Purchase Last 7 Days
              Bling Clicked - Early, At Risk, High Spenders- No Purchase Last 7 Days
              (subscriber_clicked_campaign_id in 342749 OR subscriber_clicked_campaign_id in 342765 OR subscriber_clicked_campaign_id in 342821) AND (last_order_date bl 7)
              2

            
              2619
              Clicked Curiouser - $10 Offer
              Curiouser Clicked - $10 offer
              (last_order_date bl 5) AND (subscriber_clicked_campaign_id in 345531 OR subscriber_clicked_campaign_id in 345534)
              2

            
              3640
              021822 NPB Choc Coll PM (3142) - Prev PM click / no buy / choc buy
              021822 Clicked PM didn't buy, choc buy (a)
              (country_code eq US) AND (num_of_orders ge 1) AND (subscriber_clicked_campaign_id in 322536 OR subscriber_clicked_campaign_id in 322532 OR subscriber_clicked_campaign_id in 320775 OR subscriber_clicked_campaign_id in 321030 OR subscriber_clicked_campaign_id in 321046 OR subscriber_clicked_campaign_id in 321685 OR subscriber_clicked_campaign_id in 321580 OR subscriber_clicked_campaign_id in 321704 OR subscriber_clicked_campaign_id in 321705) AND (product_id ni 6608659841161) AND (product_id ni 6608660529289) AND (product_id in 6608657907849) AND (product_id ni 6651962458249) AND (product_id ni 6805027291273) AND (product_id ni 6808095096969) AND (product_id ni 6805027160201) AND (product_id ni 6807926014089) AND (product_id ni 6807926079625) AND (product_id ni 6807943250057) AND (product_id ni 6808095228041)
              4

            
              3640
              021822 NPB Choc Coll PM (3142) - Prev PM click / no buy (b)
              021822 Clicked PM didn't buy (b)
              (country_code eq US) AND (num_of_orders ge 1) AND (subscriber_clicked_campaign_id in 322536 OR subscriber_clicked_campaign_id in 322532 OR subscriber_clicked_campaign_id in 320775 OR subscriber_clicked_campaign_id in 321030 OR subscriber_clicked_campaign_id in 321046 OR subscriber_clicked_campaign_id in 321685 OR subscriber_clicked_campaign_id in 321580 OR subscriber_clicked_campaign_id in 321704 OR subscriber_clicked_campaign_id in 321705) AND (product_id ni 6608659841161) AND (product_id ni 6608660529289)
              4

            
              3640
              021922 NPB Choc Coll PM (3142) - Prev PM click / no buy / choc buy (a)
              021922 Clicked PM didn't buy, choc buy (a)
              (country_code eq US) AND (num_of_orders ge 1) AND (subscriber_clicked_campaign_id in 322536 OR subscriber_clicked_campaign_id in 322532 OR subscriber_clicked_campaign_id in 320775 OR subscriber_clicked_campaign_id in 321030 OR subscriber_clicked_campaign_id in 321046 OR subscriber_clicked_campaign_id in 321685 OR subscriber_clicked_campaign_id in 321580 OR subscriber_clicked_campaign_id in 321704 OR subscriber_clicked_campaign_id in 321705) AND (product_id ni 6608659841161) AND (product_id ni 6608660529289) AND (product_id in 6608657907849) AND (product_id ni 6651962458249) AND (product_id ni 6805027291273) AND (product_id ni 6808095096969) AND (product_id ni 6805027160201) AND (product_id ni 6807926014089) AND (product_id ni 6807926079625) AND (product_id ni 6807943250057) AND (product_id ni 6808095228041) AND (subscriber_clicked_campaign_id ni 338149)
              4

            
              3640
              021922 NPB Choc Coll PM (3142) - Prev PM click / no buy (b)
              021922 Clicked PM didn't buy (b)
              (country_code eq US) AND (num_of_orders ge 1) AND (subscriber_clicked_campaign_id in 322536 OR subscriber_clicked_campaign_id in 322532 OR subscriber_clicked_campaign_id in 320775 OR subscriber_clicked_campaign_id in 321030 OR subscriber_clicked_campaign_id in 321046 OR subscriber_clicked_campaign_id in 321685 OR subscriber_clicked_campaign_id in 321580 OR subscriber_clicked_campaign_id in 321704 OR subscriber_clicked_campaign_id in 321705) AND (product_id ni 6608659841161) AND (product_id ni 6608660529289) AND (subscriber_clicked_campaign_id ni 338159)
              4

            
              3758
              5DC Circle Love Bird - 2/10/22
              5dc campaign 2/10/22
              (is_active_recharge_customer eq true) AND (subscriber_received_campaign_id in 311053 OR subscriber_received_campaign_id in 214425 OR subscriber_has_received_automation in 114818 OR subscriber_received_campaign_id in 326086 OR subscriber_received_campaign_id in 337071)
              11

            
              3758
              2DT Wine Theme + 3D Butterfly - 2/15/22 - 11:30am
              2DT Campaign - 2/15/22
              (product_id ni 7162408304829 OR product_id ni 7162387923133 OR product_id ni 7162395361469 OR product_id ni 7162413318333) AND (subscriber_has_received_automation in 17787 OR subscriber_has_received_automation in 15429 OR subscriber_received_campaign_id in 329732 OR subscriber_received_campaign_id in 319469) AND (subscriber_last_click_date wl 120)
              11

            
              3758
              5DC You and Me + $15 App Credit - 2/17/22 - 11:30am
              5dc campaign 2/10/22
              (is_active_recharge_customer eq true) AND (subscriber_received_campaign_id in 311053 OR subscriber_received_campaign_id in 214425 OR subscriber_has_received_automation in 114818 OR subscriber_received_campaign_id in 326086 OR subscriber_received_campaign_id in 337071)
              11

            
              3758
              Free Cross over $40 + Custom Wallet Sign 2/18/22 - 7pm
              10 Days of Christmas (Non 5DC) 
              (subscriber_has_received_automation in 168636 OR subscriber_received_campaign_id in 248767) AND (is_active_recharge_customer ne true)
              11

            
              3758
              2DT Subs 2/22/22 - 11am
              $2 Tuesday(MASTER LIST)
              (subscriber_keyword_id eq 11524 OR subscriber_keyword_id eq 10199 OR subscriber_opt_in_source eq Manual Upload OR subscriber_has_received_automation in 17787 OR subscriber_has_received_automation in 15429 OR subscriber_received_campaign_id in 14332 OR subscriber_received_campaign_id in 13942 OR subscriber_received_campaign_id in 13544 OR subscriber_received_campaign_id in 13172 OR subscriber_has_received_automation in 29000 OR subscriber_keyword_id eq 19332 OR subscriber_has_received_automation in 33369 OR subscriber_keyword_id eq 19423 OR subscriber_has_received_automation in 33543 OR subscriber_keyword_id eq 26481 OR subscriber_keywords in 79165)
              11

            
              3758
              2DT Subs No-Purchase Last Chance - 2/22/22 6pm
              2DT Ultimate Last Chance List 2/22/22
              (subscriber_last_click_date wl 60) AND (last_order_date le 2022-02-22) AND (subscriber_received_campaign_id in 340778)
              11

            
              3758
              5DC Mason Jar + 3D Mystical Moon Fairy Deal - 2/24/22 - 5:30pm
              5dc campaign 2/10/22
              (is_active_recharge_customer eq true) AND (subscriber_received_campaign_id in 311053 OR subscriber_received_campaign_id in 214425 OR subscriber_has_received_automation in 114818 OR subscriber_received_campaign_id in 326086 OR subscriber_received_campaign_id in 337071)
              11

            
              3758
              $2 Tuesday (Cross + Faith Fish Shirt) 3/1/22
              $2 Tuesday List
              (subscriber_keyword_id eq 10199 OR subscriber_received_campaign_id in 8846 OR subscriber_received_campaign_id in 8861 OR subscriber_has_received_automation in 15429 OR subscriber_received_campaign_id in 9780 OR subscriber_received_campaign_id in 9217 OR subscriber_keyword_id eq 11524 OR subscriber_has_received_automation in 17787 OR subscriber_received_campaign_id in 11540 OR subscriber_opt_in_source eq Manual Upload OR subscriber_received_campaign_id in 12808 OR subscriber_has_received_automation in 29000 OR subscriber_keyword_id eq 19332 OR subscriber_has_received_automation in 33369 OR subscriber_keyword_id eq 19423 OR subscriber_has_received_automation in 33543 OR subscriber_received_campaign_id in 37870 OR subscriber_received_campaign_id in 36524 OR subscriber_received_campaign_id in 35239 OR subscriber_keyword_id eq 26481 OR subscriber_keywords in 79165) AND (num_of_orders ge 1 OR subscriber_created_at wl 30) AND (last_order_date bl 1)
              11

            
              3758
              5DC Mason Jar + 3D Mystical Moon Fairy Deal - 2/24/22 - 5:30pm (copy)
              5dc campaign 2/10/22
              (is_active_recharge_customer eq true) AND (subscriber_received_campaign_id in 311053 OR subscriber_received_campaign_id in 214425 OR subscriber_has_received_automation in 114818 OR subscriber_received_campaign_id in 326086 OR subscriber_received_campaign_id in 337071)
              11

            
              3758
              $2 Tuesday (Cross + Faith Fish Shirt) 3/1/22 (copy)
              2DT Campaign - 2/15/22
              (product_id ni 7162408304829 OR product_id ni 7162387923133 OR product_id ni 7162395361469 OR product_id ni 7162413318333) AND (subscriber_has_received_automation in 17787 OR subscriber_has_received_automation in 15429 OR subscriber_received_campaign_id in 329732 OR subscriber_received_campaign_id in 319469) AND (subscriber_last_click_date wl 120)
              11

            
              3758
              5DC Lucky Dog + Allegiance Flag 3/10/22
              5dc campaign 2/10/22
              (is_active_recharge_customer eq true) AND (subscriber_received_campaign_id in 311053 OR subscriber_received_campaign_id in 214425 OR subscriber_has_received_automation in 114818 OR subscriber_received_campaign_id in 326086 OR subscriber_received_campaign_id in 337071)
              11

            
              4427
              Retail - Stoneware Candle Restock (2.10)
              Retail - Stoneware Candle Past Purchasers
              (customer_tag ni wholesale) AND (customer_tag ni wholesale1) AND (subscriber_keyword_id ne 13507) AND (subscriber_keyword_id ne 41175) AND (customer_tag ni faire) AND (customer_tag ni Handshake) AND (product_id in 6827390042285 OR product_id in 6827379490989 OR product_id in 6827402723501 OR product_id in 6827333517485 OR product_id in 6827395055789 OR product_id in 6827398987949 OR product_id in 6827386175661 OR product_id in 6827401773229 OR product_id in 6827404132525 OR subscriber_clicked_campaign_id in 199059 OR subscriber_clicked_campaign_id in 199141) AND (last_order_date bl 12 OR num_of_orders eq 0)
              2

            
              4427
              Retail - Love Your Pet Day (2.20)
              Retail - Interest: Pets
              (customer_tag ni wholesale) AND (customer_tag ni wholesale1) AND (subscriber_keyword_id ne 13507) AND (subscriber_keyword_id ne 41175) AND (customer_tag ni faire) AND (customer_tag ni Handshake) AND (last_order_date bl 12 OR num_of_orders eq 0) AND (product_id in 4512044384369 OR product_id in 6848756252845 OR product_id in 6122897211565 OR product_id in 4512039272561 OR subscriber_clicked_campaign_id in 217214)
              2

            
              4475
              Podcast Launch
              DropList
              (subscriber_keywords in 103719 OR subscriber_clicked_campaign_id in 316902 OR last_order_date ge 2021-01-01)
              3

            
              4475
              Dizon-Drop2
              DropList
              (subscriber_keywords in 103719 OR subscriber_clicked_campaign_id in 316902 OR last_order_date ge 2021-01-01)
              3

            
              4475
              Gun Stand Launch
              DropList
              (subscriber_keywords in 103719 OR subscriber_clicked_campaign_id in 316902 OR last_order_date ge 2021-01-01)
              3

            
              5109
              Pet Studs
              Enamel Buy 3 Get 1 
              (product_tag in enamel OR product_tag in signature enamel earrings OR subscriber_received_campaign_id in 85870 OR product_tag in enamel studs OR product_type in PET TOY OR product_type in PET TOYS OR product_tag in pet enamel OR product_tag in pet studs) AND (last_order_date wl 365 OR subscriber_last_click_date wl 30)
              4

            
              5109
              insider Michelle McDowell (copy) (copy) (copy)
              Ave/Clothing + Denim (CORRECTED) (Black Friday)
              (product_tag in ave OR product_tag in tops OR product_tag in bottoms OR product_tag in judy blues OR product_tag in Tops OR product_tag in Bottoms OR product_type in CLOTHES OR product_type in BASIC DENIM OR product_tag in denim OR product_tag in jeans OR product_type in PULL ON SHORTS OR subscriber_is_in_klaviyo_list in Yvp67x OR subscriber_is_in_klaviyo_list in XNWHwJ OR product_type in TOPS UNDER $30 OR product_type in TOPS OVER $30 OR num_of_orders ge 1 OR subscriber_created_at wl 30 OR product_tag in jeggings OR product_tag in leggings OR subscriber_received_campaign_id in 320557 OR last_order_date wl 365) AND (subscriber_last_click_date wl 365 OR last_order_date wl 180)
              4

            
              5109
              Ave 3/3 (copy)
              Ave/Clothing + Denim (CORRECTED) (Black Friday)
              (product_tag in ave OR product_tag in tops OR product_tag in bottoms OR product_tag in judy blues OR product_tag in Tops OR product_tag in Bottoms OR product_type in CLOTHES OR product_type in BASIC DENIM OR product_tag in denim OR product_tag in jeans OR product_type in PULL ON SHORTS OR subscriber_is_in_klaviyo_list in Yvp67x OR subscriber_is_in_klaviyo_list in XNWHwJ OR product_type in TOPS UNDER $30 OR product_type in TOPS OVER $30 OR num_of_orders ge 1 OR subscriber_created_at wl 30 OR product_tag in jeggings OR product_tag in leggings OR subscriber_received_campaign_id in 320557 OR last_order_date wl 365) AND (subscriber_last_click_date wl 365 OR last_order_date wl 180)
              4

            
              5109
              Ave 3/10 (copy)
              Ave/Clothing + Denim (CORRECTED) (Black Friday)
              (product_tag in ave OR product_tag in tops OR product_tag in bottoms OR product_tag in judy blues OR product_tag in Tops OR product_tag in Bottoms OR product_type in CLOTHES OR product_type in BASIC DENIM OR product_tag in denim OR product_tag in jeans OR product_type in PULL ON SHORTS OR subscriber_is_in_klaviyo_list in Yvp67x OR subscriber_is_in_klaviyo_list in XNWHwJ OR product_type in TOPS UNDER $30 OR product_type in TOPS OVER $30 OR num_of_orders ge 1 OR subscriber_created_at wl 30 OR product_tag in jeggings OR product_tag in leggings OR subscriber_received_campaign_id in 320557 OR last_order_date wl 365) AND (subscriber_last_click_date wl 365 OR last_order_date wl 180)
              4

            
              5470
              Addison Rae Alani
              Clicked Witchs Brew Text
              (subscriber_clicked_campaign_id in 226841 OR product_id in 6678545793212)
              5

            
              5470
              Last Chance Free Shipping - Feb
              Clicked Free Shipping Over $25 But Didnt Order
              (subscriber_clicked_campaign_id in 333688) AND (last_order_date le 2022-02-11)
              5

            
              5470
              Phame energy
              Clicked Beta Tester
              (subscriber_clicked_campaign_id in 233343)
              5

            
              5470
              Second text Scorch
              Clicked Scorch 
              (subscriber_clicked_campaign_id in 342242)
              5

            
              5470
              Last Chance Deal Wheel
              Last Chance Deal Wheel
              (subscriber_received_campaign_id in 349377) AND (last_order_date le 2022-03-01)
              5

            
              6651
              M6: Bernhardt Sale_Engaged (02/11/22)
              M6: Bernhardt Engaged (01/22)
              (subscriber_clicked_campaign_id in 327357) AND (last_order_date bl 7 OR num_of_orders eq 0)
              2

            
              6651
              M6: Four Hands Sale (03/03/22) (copy)
              M6: Four Hands Sale Engaged (03/05/22)
              (subscriber_clicked_campaign_id in 347882 OR subscriber_clicked_klaviyo_email in M6: Four Hands Sale Launch (03/02/22) OR subscriber_received_klaviyo_email in M6: Four Hands Sale_Outdoor (03/03/22))
              2

            
              7329
              PM Flash Sale Friday: Seed Starting Bundle
              Flash Sale PM
              (subscriber_clicked_campaign_id in 346651 OR subscriber_last_click_date wl 30 OR subscriber_num_replies ge 1 OR subscriber_clicked_klaviyo_email in Seeds 2022 OR subscriber_clicked_klaviyo_email in Seeds Remail 2022 OR subscriber_clicked_klaviyo_email in Seed Starting Mix, Pots and Seeds OR subscriber_clicked_klaviyo_email in Seed Starting Mix, Pots and Seeds Remail) AND (num_of_orders eq 0 OR last_order_date bl 30) AND (subscriber_created_at bl 14)
              2

            
              7329
              PM Flash Sale Friday: Organic Beginners Garden 10-Pack
              Flash Sale PM
              (subscriber_clicked_campaign_id in 346651 OR subscriber_last_click_date wl 30 OR subscriber_num_replies ge 1 OR subscriber_clicked_klaviyo_email in Seeds 2022 OR subscriber_clicked_klaviyo_email in Seeds Remail 2022 OR subscriber_clicked_klaviyo_email in Seed Starting Mix, Pots and Seeds OR subscriber_clicked_klaviyo_email in Seed Starting Mix, Pots and Seeds Remail) AND (num_of_orders eq 0 OR last_order_date bl 30) AND (subscriber_created_at bl 14)
              2

            
              8589
              FISH OIL MAILOUT - 2022
              2022 - Free Gift / Protein
              (subscriber_received_campaign_id in 329097) AND (subscriber_clicked_campaign_id ni 329097)
              4

            
              8589
              sweetheart sale / no click -- 
              *** sweetheart sale /// no click -- 2022
              (subscriber_received_campaign_id in 333335) AND (subscriber_clicked_campaign_id ni 333335)
              4

            
              8589
              [Resend] President's Day Flash Sale: Cinnamon Cereal Protein
              Didn't Purchase President's Day Sale
              (subscriber_received_campaign_id in 339724) AND (subscriber_clicked_campaign_id ni 339724) AND (num_of_orders eq 0)
              4

            
              8589
              Bundle / 2.0
              Bundle Offer 2.0
              (subscriber_received_campaign_id in 349145) AND (subscriber_clicked_campaign_id ni 349145)
              4

            
              8660
              022222RESTOCK
              ACTIVE BY DATE 
              (subscriber_last_click_date ge 2021-02-25 OR subscriber_clicked_campaign_id in 128430 OR subscriber_created_at ge 2021-04-01 OR subscriber_clicked_campaign_id in 337413 OR subscriber_clicked_campaign_id in 337410 OR subscriber_clicked_campaign_id in 337667 OR subscriber_clicked_campaign_id in 326579 OR subscriber_clicked_campaign_id in 301960)
              3

            
              8660
              NEW022422
              ACTIVE BY DATE 
              (subscriber_last_click_date ge 2021-02-25 OR subscriber_clicked_campaign_id in 128430 OR subscriber_created_at ge 2021-04-01 OR subscriber_clicked_campaign_id in 337413 OR subscriber_clicked_campaign_id in 337410 OR subscriber_clicked_campaign_id in 337667 OR subscriber_clicked_campaign_id in 326579 OR subscriber_clicked_campaign_id in 301960)
              3

            
              8660
              NEW022422 (copy)
              ACTIVE BY DATE 
              (subscriber_last_click_date ge 2021-02-25 OR subscriber_clicked_campaign_id in 128430 OR subscriber_created_at ge 2021-04-01 OR subscriber_clicked_campaign_id in 337413 OR subscriber_clicked_campaign_id in 337410 OR subscriber_clicked_campaign_id in 337667 OR subscriber_clicked_campaign_id in 326579 OR subscriber_clicked_campaign_id in 301960)
              3

            
              8918
              Vday reminder
              clicked vday sale
              (subscriber_clicked_campaign_id in 332314 OR last_order_date le 2022-02-04 OR num_of_orders eq 0)
              5

            
              8918
              Vday sale last chance 
              2/14 vday sale clicked not purch
              (subscriber_clicked_campaign_id in 332314 OR subscriber_clicked_campaign_id in 333589) AND (num_of_orders eq 0 OR last_order_date le 2022-02-07)
              5

            
              8918
              New Denim
              2/23 Wardrobe purchased or clicked
              (product_type in PANTS OR product_type in COATS & JACKETS OR product_type in DRESSES OR product_type in PANTS OR product_type in SHIRTS & TOPS OR product_type in SHORTS OR subscriber_clicked_campaign_id in 158515 OR subscriber_clicked_campaign_id in 256529 OR subscriber_clicked_campaign_id in 311035 OR subscriber_clicked_campaign_id in 211370)
              5

            
              8918
              VIP $10 reminder
              2/28 - VIP campaign clicked not purch
              (subscriber_clicked_campaign_id in 345425) AND (last_order_date le 2022-02-25)
              5

            
              8918
              VIP $10 reminder (copy)
              2/28 - VIP campaign clicked not purch
              (subscriber_clicked_campaign_id in 345425) AND (last_order_date le 2022-02-25)
              5

            
              9020
              Bars Close-out (copy)
              Bars Close-out (clicks, but no purchase)
              (subscriber_clicked_campaign_id in 345831) AND (last_order_date le 2022-02-28)
              3

            
              9020
              Bars Close-out (final)
              [BFCM 21] No Clicks
              (subscriber_received_campaign_id in 259414 OR subscriber_received_campaign_id in 265895 OR subscriber_received_campaign_id in 267207 OR subscriber_received_campaign_id in 268697 OR subscriber_received_campaign_id in 269036 OR subscriber_received_campaign_id in 269016 OR subscriber_received_campaign_id in 269072 OR subscriber_received_campaign_id in 268990 OR subscriber_received_campaign_id in 268957 OR subscriber_received_campaign_id in 268679) AND (subscriber_clicked_campaign_id ni 259414 OR subscriber_clicked_campaign_id ni 265895 OR subscriber_clicked_campaign_id ni 267207 OR subscriber_clicked_campaign_id ni 268697 OR subscriber_clicked_campaign_id ni 269036 OR subscriber_clicked_campaign_id ni 269016 OR subscriber_clicked_campaign_id ni 269072 OR subscriber_clicked_campaign_id ni 268990 OR subscriber_clicked_campaign_id ni 268957 OR subscriber_clicked_campaign_id ni 268679)
              3

            
              9020
              Bars Close-out (final) (copy)
              Bars Close-out (clicks, but no purchase)
              (subscriber_clicked_campaign_id in 345831) AND (last_order_date le 2022-02-28)
              3

            
              9101
              Herstory - Pivot
              Herstory Campaign (Didn't Convert)
              (subscriber_clicked_campaign_id in 330056) AND (subscriber_clicked_campaign_id ni 336812)
              2

            
              9101
              It Was All A Dream - Pivot 
              All A Dream (Didn't Convert) 
              (subscriber_clicked_campaign_id in 336812) AND (last_order_date ne 2022-02-17 OR last_order_date ne 2022-02-18 OR last_order_date ne 2022-02-19)
              2

            
              9996
              Feb 14 | VDAY45 
              Campaign Clickers No BF Orders (ex FL)
              (subscriber_clicked_campaign_id in 70453 OR subscriber_clicked_campaign_id in 70495 OR subscriber_clicked_campaign_id in 70518 OR subscriber_clicked_campaign_id in 70522 OR subscriber_clicked_campaign_id in 73696 OR subscriber_clicked_campaign_id in 73697 OR subscriber_clicked_campaign_id in 72106 OR subscriber_clicked_campaign_id in 72109 OR subscriber_clicked_campaign_id in 243012 OR subscriber_clicked_campaign_id in 246625 OR subscriber_clicked_campaign_id in 258303 OR subscriber_clicked_campaign_id in 262917 OR subscriber_clicked_campaign_id in 274749 OR subscriber_clicked_campaign_id in 264977 OR subscriber_clicked_campaign_id in 273509 OR subscriber_clicked_campaign_id in 268534 OR subscriber_clicked_campaign_id in 271284 OR subscriber_clicked_campaign_id in 271277) AND (customer_state ne florida) AND (last_order_date lt 2021-11-23 OR num_of_orders eq 0)
              4

            
              9996
              Feb 18 | MJB45
              Campaign Clickers No BF Orders (ex FL)
              (subscriber_clicked_campaign_id in 70453 OR subscriber_clicked_campaign_id in 70495 OR subscriber_clicked_campaign_id in 70518 OR subscriber_clicked_campaign_id in 70522 OR subscriber_clicked_campaign_id in 73696 OR subscriber_clicked_campaign_id in 73697 OR subscriber_clicked_campaign_id in 72106 OR subscriber_clicked_campaign_id in 72109 OR subscriber_clicked_campaign_id in 243012 OR subscriber_clicked_campaign_id in 246625 OR subscriber_clicked_campaign_id in 258303 OR subscriber_clicked_campaign_id in 262917 OR subscriber_clicked_campaign_id in 274749 OR subscriber_clicked_campaign_id in 264977 OR subscriber_clicked_campaign_id in 273509 OR subscriber_clicked_campaign_id in 268534 OR subscriber_clicked_campaign_id in 271284 OR subscriber_clicked_campaign_id in 271277) AND (customer_state ne florida) AND (last_order_date lt 2021-11-23 OR num_of_orders eq 0)
              4

            
              9996
              Mar 3 | Exclnt | BLKWM40
              Campaign Clickers No BF Orders (ex FL)
              (subscriber_clicked_campaign_id in 70453 OR subscriber_clicked_campaign_id in 70495 OR subscriber_clicked_campaign_id in 70518 OR subscriber_clicked_campaign_id in 70522 OR subscriber_clicked_campaign_id in 73696 OR subscriber_clicked_campaign_id in 73697 OR subscriber_clicked_campaign_id in 72106 OR subscriber_clicked_campaign_id in 72109 OR subscriber_clicked_campaign_id in 243012 OR subscriber_clicked_campaign_id in 246625 OR subscriber_clicked_campaign_id in 258303 OR subscriber_clicked_campaign_id in 262917 OR subscriber_clicked_campaign_id in 274749 OR subscriber_clicked_campaign_id in 264977 OR subscriber_clicked_campaign_id in 273509 OR subscriber_clicked_campaign_id in 268534 OR subscriber_clicked_campaign_id in 271284 OR subscriber_clicked_campaign_id in 271277) AND (customer_state ne florida) AND (last_order_date lt 2021-11-23 OR num_of_orders eq 0)
              4

            
              9996
              Mar 5 | Dreaming | BLKWM40
              Campaign Clickers No BF Orders (ex FL)
              (subscriber_clicked_campaign_id in 70453 OR subscriber_clicked_campaign_id in 70495 OR subscriber_clicked_campaign_id in 70518 OR subscriber_clicked_campaign_id in 70522 OR subscriber_clicked_campaign_id in 73696 OR subscriber_clicked_campaign_id in 73697 OR subscriber_clicked_campaign_id in 72106 OR subscriber_clicked_campaign_id in 72109 OR subscriber_clicked_campaign_id in 243012 OR subscriber_clicked_campaign_id in 246625 OR subscriber_clicked_campaign_id in 258303 OR subscriber_clicked_campaign_id in 262917 OR subscriber_clicked_campaign_id in 274749 OR subscriber_clicked_campaign_id in 264977 OR subscriber_clicked_campaign_id in 273509 OR subscriber_clicked_campaign_id in 268534 OR subscriber_clicked_campaign_id in 271284 OR subscriber_clicked_campaign_id in 271277) AND (customer_state ne florida) AND (last_order_date lt 2021-11-23 OR num_of_orders eq 0)
              4

            
              10475
              Clicked on self care weekend txt but have not shopped 
              clicked on self care weekend msg but did not shop 
              (subscriber_clicked_campaign_id in 338501 OR subscriber_clicked_campaign_id in 338527) AND (last_order_date bl 3)
              3

            
              10475
              30% off REMINDER for re-engagement group 
              clicked on re-engagement campaign, didn't shop 
              (subscriber_received_campaign_id in 331251) AND (num_of_orders eq 0) AND (subscriber_last_click_date wl 365)
              3

            
              10475
              THE BYE BYE WINTER SALE REMINDER
              clicked on bye bye winter sale, but have not shopped
              (subscriber_clicked_campaign_id in 349360) AND (last_order_date bl 7) AND (subscriber_keywords ni 29690) AND (average_order_value_cents le 4000)
              3

            
              11246
              Clearance 20% or 30% off
              Clearance Lovers
              (subscriber_clicked_campaign_id in 87356)
              2

            
              11246
              LC for Head in the Clouds Dress Sale
              Head in the Clouds
              (subscriber_clicked_campaign_id in 346452)
              2

            
              11712
              2.13 White Fringe skirt
              Pink nash girl
              (product_id in 6709946482775 OR subscriber_clicked_campaign_id in 326944 OR subscriber_clicked_campaign_id in 302828 OR subscriber_clicked_campaign_id in 307068 OR product_id in 6710000025687)
              2

            
              11712
              2.27 Fringe dress
              Pink nash girl
              (product_id in 6709946482775 OR subscriber_clicked_campaign_id in 326944 OR subscriber_clicked_campaign_id in 302828 OR subscriber_clicked_campaign_id in 307068 OR product_id in 6710000025687)
              2

            
              13118
              30% VINTAGE
              ENGAGED + NOBUY
              (num_of_orders eq 0) AND (subscriber_clicked_campaign_id in 201614 OR subscriber_clicked_campaign_id in 198015)
              2

            
              13118
              RED  PROMO(copy)
              ENGAGED + NOBUY
              (num_of_orders eq 0) AND (subscriber_clicked_campaign_id in 201614 OR subscriber_clicked_campaign_id in 198015)
              2

            
              14724
              Vday 30 (copy)
              Never Purchased 2/14
              (num_of_orders eq 0) AND (subscriber_received_campaign_id in 334245) AND (subscriber_clicked_campaign_id ni 334245)
              4

            
              14724
              Vday 30 (copy) (copy)
              Did not Click 2/14
              (subscriber_received_campaign_id in 334245) AND (subscriber_clicked_campaign_id ni 334245)
              4

            
              14724
              Vday 30 (copy) (copy) (copy)
              Valentines Day Extended
              (subscriber_received_campaign_id in 335274) AND (subscriber_clicked_campaign_id ni 335274 OR num_of_orders eq 0)
              4

            
              14724
              Vday 30 (copy) (copy) (copy) (copy)
              Valentine's Day Extended (2)
              (subscriber_received_campaign_id in 335572) AND (subscriber_clicked_campaign_id ni 335572) AND (num_of_orders eq 0)
              4

            
              15314
              livw 2/14
              Jessica Live Texts
              (subscriber_clicked_campaign_id in 289256 OR subscriber_keywords in 97135)
              6

            
              15314
              Tik Tok 
              Jessica Live Texts
              (subscriber_clicked_campaign_id in 289256 OR subscriber_keywords in 97135)
              6

            
              15314
              live 2/21
              Jessica Live Texts
              (subscriber_clicked_campaign_id in 289256 OR subscriber_keywords in 97135)
              6

            
              15314
              live 2/28
              Jessica Live Texts
              (subscriber_clicked_campaign_id in 289256 OR subscriber_keywords in 97135)
              6

            
              15314
              Live Tutorial 3/1 (copy)
              Jessica Live Texts
              (subscriber_clicked_campaign_id in 289256 OR subscriber_keywords in 97135)
              6

            
              15314
              morning live 2/7
              Jessica Live Texts
              (subscriber_clicked_campaign_id in 289256 OR subscriber_keywords in 97135)
              6

            
              16375
              2-22 flash
              Engaged
              (subscriber_clicked_campaign_id in 144782 OR subscriber_clicked_campaign_id in 147531)
              2

            
              16375
              style 
              Engaged
              (subscriber_clicked_campaign_id in 144782 OR subscriber_clicked_campaign_id in 147531)
              2

            
              16381
              I Love Truckers (Truck Yeah Non-Buyers) - 2/10/22
              Truck Yeah Received No Buy
              (subscriber_is_international ne true) AND (product_id ni 7409368006825) AND (subscriber_received_campaign_id in 330946)
              8

            
              16381
              Saturday App Push 2/12/22
              App Launch Clickers - Last Chance 2/2/22
              (subscriber_is_international ne true) AND (subscriber_clicked_campaign_id in 284971 OR subscriber_clicked_campaign_id in 286579 OR subscriber_clicked_campaign_id in 295917 OR subscriber_clicked_campaign_id in 282595 OR subscriber_clicked_campaign_id in 296618 OR subscriber_clicked_campaign_id in 297984 OR subscriber_clicked_campaign_id in 324786) AND (subscriber_last_click_date wl 180 OR last_order_date wl 90)
              8

            
              16381
              Sunday I Love Truckers Send
              Truck Yeah Received No Buy
              (subscriber_is_international ne true) AND (product_id ni 7409368006825) AND (subscriber_received_campaign_id in 330946)
              8

            
              16381
              Free S&H App Push 2/23/22
              App Launch Clickers - Last Chance 2/2/22
              (subscriber_is_international ne true) AND (subscriber_clicked_campaign_id in 284971 OR subscriber_clicked_campaign_id in 286579 OR subscriber_clicked_campaign_id in 295917 OR subscriber_clicked_campaign_id in 282595 OR subscriber_clicked_campaign_id in 296618 OR subscriber_clicked_campaign_id in 297984 OR subscriber_clicked_campaign_id in 324786) AND (subscriber_last_click_date wl 180 OR last_order_date wl 90)
              8

            
              16381
              Free S&H App Push 2/26/22
              App Launch Clickers - Last Chance 2/2/22
              (subscriber_is_international ne true) AND (subscriber_clicked_campaign_id in 284971 OR subscriber_clicked_campaign_id in 286579 OR subscriber_clicked_campaign_id in 295917 OR subscriber_clicked_campaign_id in 282595 OR subscriber_clicked_campaign_id in 296618 OR subscriber_clicked_campaign_id in 297984 OR subscriber_clicked_campaign_id in 324786) AND (subscriber_last_click_date wl 180 OR last_order_date wl 90)
              8

            
              16381
              Free S&H App Push 2/27/22
              App Launch Clickers - Last Chance 2/2/22
              (subscriber_is_international ne true) AND (subscriber_clicked_campaign_id in 284971 OR subscriber_clicked_campaign_id in 286579 OR subscriber_clicked_campaign_id in 295917 OR subscriber_clicked_campaign_id in 282595 OR subscriber_clicked_campaign_id in 296618 OR subscriber_clicked_campaign_id in 297984 OR subscriber_clicked_campaign_id in 324786) AND (subscriber_last_click_date wl 180 OR last_order_date wl 90)
              8

            
              16381
              Free S&H App Push 3/05/22
              App Launch Clickers - Last Chance 2/2/22
              (subscriber_is_international ne true) AND (subscriber_clicked_campaign_id in 284971 OR subscriber_clicked_campaign_id in 286579 OR subscriber_clicked_campaign_id in 295917 OR subscriber_clicked_campaign_id in 282595 OR subscriber_clicked_campaign_id in 296618 OR subscriber_clicked_campaign_id in 297984 OR subscriber_clicked_campaign_id in 324786) AND (subscriber_last_click_date wl 180 OR last_order_date wl 90)
              8

            
              16381
              Free S&H App Push 3/06/22
              App Launch Clickers - Last Chance 2/2/22
              (subscriber_is_international ne true) AND (subscriber_clicked_campaign_id in 284971 OR subscriber_clicked_campaign_id in 286579 OR subscriber_clicked_campaign_id in 295917 OR subscriber_clicked_campaign_id in 282595 OR subscriber_clicked_campaign_id in 296618 OR subscriber_clicked_campaign_id in 297984 OR subscriber_clicked_campaign_id in 324786) AND (subscriber_last_click_date wl 180 OR last_order_date wl 90)
              8

            
              16669
              LIVE TONIGHT - 2.16
              Live Customers
              (subscriber_clicked_campaign_id in 113243 OR subscriber_clicked_campaign_id in 112271 OR subscriber_clicked_campaign_id in 107704 OR subscriber_clicked_campaign_id in 103496 OR subscriber_clicked_campaign_id in 103498 OR subscriber_clicked_campaign_id in 103495 OR subscriber_clicked_campaign_id in 100102 OR subscriber_clicked_campaign_id in 131223 OR subscriber_clicked_campaign_id in 132299 OR subscriber_clicked_campaign_id in 113243 OR subscriber_clicked_campaign_id in 112271 OR subscriber_clicked_campaign_id in 109294 OR subscriber_clicked_campaign_id in 107704 OR subscriber_clicked_campaign_id in 103496 OR subscriber_clicked_campaign_id in 103498 OR subscriber_clicked_campaign_id in 103495 OR subscriber_clicked_campaign_id in 100102 OR subscriber_clicked_campaign_id in 135831 OR subscriber_clicked_campaign_id in 135220 OR subscriber_clicked_campaign_id in 138294 OR subscriber_clicked_campaign_id in 142268 OR subscriber_clicked_campaign_id in 143207 OR subscriber_clicked_campaign_id in 144329 OR subscriber_clicked_campaign_id in 144336 OR subscriber_clicked_campaign_id in 148815 OR subscriber_clicked_campaign_id in 150219 OR subscriber_clicked_campaign_id in 154217 OR subscriber_clicked_campaign_id in 154794 OR subscriber_clicked_campaign_id in 157102 OR subscriber_clicked_campaign_id in 158163 OR subscriber_clicked_campaign_id in 160772 OR subscriber_clicked_campaign_id in 161962 OR subscriber_clicked_campaign_id in 164958 OR subscriber_clicked_campaign_id in 166103 OR subscriber_clicked_campaign_id in 168685 OR subscriber_clicked_campaign_id in 169980 OR subscriber_clicked_campaign_id in 173000 OR subscriber_clicked_campaign_id in 174271 OR subscriber_clicked_campaign_id in 176652 OR subscriber_clicked_campaign_id in 177456 OR subscriber_clicked_campaign_id in 180240 OR subscriber_clicked_campaign_id in 181333 OR subscriber_clicked_campaign_id in 183756 OR subscriber_clicked_campaign_id in 184818 OR subscriber_clicked_campaign_id in 188003 OR subscriber_clicked_campaign_id in 189179 OR subscriber_clicked_campaign_id in 191657 OR subscriber_clicked_campaign_id in 192352 OR subscriber_clicked_campaign_id in 195615 OR subscriber_clicked_campaign_id in 196576 OR subscriber_clicked_campaign_id in 203524 OR subscriber_clicked_campaign_id in 205246 OR subscriber_clicked_campaign_id in 209138 OR subscriber_clicked_campaign_id in 210062 OR subscriber_clicked_campaign_id in 212732 OR subscriber_clicked_campaign_id in 214089 OR subscriber_clicked_campaign_id in 216654 OR subscriber_clicked_campaign_id in 220832 OR subscriber_clicked_campaign_id in 217151 OR subscriber_clicked_campaign_id in 222831 OR subscriber_clicked_campaign_id in 225852 OR subscriber_clicked_campaign_id in 227366 OR subscriber_clicked_campaign_id in 237632 OR subscriber_clicked_campaign_id in 249116 OR subscriber_clicked_campaign_id in 247486 OR subscriber_clicked_campaign_id in 230454 OR subscriber_clicked_campaign_id in 254528 OR subscriber_clicked_campaign_id in 231909 OR subscriber_clicked_campaign_id in 292287 OR subscriber_clicked_campaign_id in 244364 OR subscriber_clicked_campaign_id in 265205 OR subscriber_clicked_campaign_id in 281176 OR subscriber_clicked_campaign_id in 313572 OR subscriber_clicked_campaign_id in 309307 OR subscriber_clicked_campaign_id in 295603 OR subscriber_clicked_campaign_id in 289947 OR subscriber_clicked_campaign_id in 297433 OR subscriber_clicked_campaign_id in 286055) AND (subscriber_last_click_date wl 45)
              2

            
              16669
              HAUTE SHORE - 3.3
              Clicked sale texts
              (subscriber_clicked_campaign_id in 138700 OR subscriber_clicked_campaign_id in 138696 OR subscriber_clicked_campaign_id in 135002 OR subscriber_clicked_campaign_id in 132651 OR subscriber_clicked_campaign_id in 140927 OR subscriber_clicked_campaign_id in 122004 OR subscriber_clicked_campaign_id in 120373 OR subscriber_clicked_campaign_id in 119027 OR subscriber_clicked_campaign_id in 117276 OR subscriber_clicked_campaign_id in 116225 OR subscriber_clicked_campaign_id in 108403 OR subscriber_clicked_campaign_id in 144211 OR subscriber_clicked_campaign_id in 142529 OR subscriber_clicked_campaign_id in 144248 OR subscriber_clicked_campaign_id in 149281 OR subscriber_clicked_campaign_id in 150152 OR subscriber_clicked_campaign_id in 150856 OR subscriber_clicked_campaign_id in 150924 OR subscriber_clicked_campaign_id in 150927 OR subscriber_clicked_campaign_id in 154086 OR subscriber_clicked_campaign_id in 157569 OR subscriber_clicked_campaign_id in 161115 OR subscriber_clicked_campaign_id in 161347 OR subscriber_clicked_campaign_id in 163235 OR subscriber_clicked_campaign_id in 163802 OR subscriber_clicked_campaign_id in 165220 OR subscriber_clicked_campaign_id in 166036 OR subscriber_clicked_campaign_id in 160778 OR subscriber_clicked_campaign_id in 160592 OR subscriber_clicked_campaign_id in 161115 OR subscriber_clicked_campaign_id in 161347 OR subscriber_clicked_campaign_id in 163235 OR subscriber_clicked_campaign_id in 163802 OR subscriber_clicked_campaign_id in 166408 OR subscriber_clicked_campaign_id in 169095 OR subscriber_clicked_campaign_id in 171052 OR subscriber_clicked_campaign_id in 171179 OR subscriber_clicked_campaign_id in 171708 OR subscriber_clicked_campaign_id in 172356 OR subscriber_clicked_campaign_id in 171710 OR subscriber_clicked_campaign_id in 172995 OR subscriber_clicked_campaign_id in 176661 OR subscriber_clicked_campaign_id in 176912 OR subscriber_clicked_campaign_id in 209269 OR subscriber_clicked_campaign_id in 191920 OR subscriber_clicked_campaign_id in 184330 OR subscriber_clicked_campaign_id in 188218 OR subscriber_clicked_campaign_id in 195747 OR subscriber_clicked_campaign_id in 199089 OR subscriber_clicked_campaign_id in 203858 OR subscriber_clicked_campaign_id in 213021 OR subscriber_clicked_campaign_id in 217044 OR subscriber_clicked_campaign_id in 221412 OR subscriber_clicked_campaign_id in 226398 OR subscriber_clicked_campaign_id in 230829 OR subscriber_clicked_campaign_id in 236537 OR subscriber_received_campaign_id in 241323 OR subscriber_clicked_campaign_id in 247882 OR subscriber_clicked_campaign_id in 253181 OR subscriber_clicked_campaign_id in 266298 OR subscriber_clicked_campaign_id in 284839 OR subscriber_clicked_campaign_id in 279819 OR subscriber_clicked_campaign_id in 296226 OR subscriber_clicked_campaign_id in 309417 OR subscriber_clicked_campaign_id in 318998 OR subscriber_clicked_campaign_id in 313577 OR subscriber_clicked_campaign_id in 335447 OR subscriber_clicked_campaign_id in 323713 OR subscriber_clicked_campaign_id in 346251 OR subscriber_clicked_campaign_id in 329168) AND (subscriber_last_click_date wl 45)
              2

            
              16947
              PB Sale
              Manual Lists Combination
              (subscriber_received_campaign_id in 334937 OR subscriber_received_campaign_id in 276308)
              2

            
              16947
              PB Sale - Final Chance
              Popup + Manual Uploads
              (subscriber_explicit_opt_in eq true OR subscriber_received_campaign_id in 341261 OR subscriber_received_campaign_id in 334937 OR subscriber_is_in_klaviyo_list in TJEmjr)
              2

            
              18749
              Sale FEB 11 Retarget FEB 12
              subscriber did click this campaign but not order since it was sent
              (subscriber_clicked_campaign_id in 332415) AND (last_order_date ne 2022-02-11 OR last_order_date ne 2022-02-12)
              3

            
              18749
              3rd Anniversary (did not click)
              3rd Anniversary Not Clicked
              (subscriber_received_campaign_id in 346370) AND (subscriber_clicked_campaign_id ni 346370)
              3

            
              18749
              3rd Anniversary clicked
              3rd Anniversary Clicked
              (subscriber_clicked_campaign_id in 346370) AND (last_order_date bl 3)
              3

            
              20709
              Don't Forget
              Hasn't purchased in 36 hours
              (num_of_orders eq 0) AND (subscriber_received_campaign_id in 338336)
              2

            
              20709
              VIP Reminder
              VIP Clicked Campaign (but didn't purchase)
              (subscriber_clicked_campaign_id in 348061) AND (customer_tag ni active_subscriber)
              2

            
              20820
              Zelle Checkout
              Active Customers
              (subscriber_clicked_campaign_id in 268829 OR subscriber_clicked_campaign_id in 262607 OR num_of_orders eq 1 OR subscriber_clicked_campaign_id in 243315 OR subscriber_clicked_campaign_id in 267146 OR subscriber_clicked_campaign_id in 237730 OR subscriber_clicked_campaign_id in 320017)
              3

            
              20820
              End of szn
              Active Customers
              (subscriber_clicked_campaign_id in 268829 OR subscriber_clicked_campaign_id in 262607 OR num_of_orders eq 1 OR subscriber_clicked_campaign_id in 243315 OR subscriber_clicked_campaign_id in 267146 OR subscriber_clicked_campaign_id in 237730 OR subscriber_clicked_campaign_id in 320017)
              3

            
              20820
              End of szn (copy)
              Active Customers
              (subscriber_clicked_campaign_id in 268829 OR subscriber_clicked_campaign_id in 262607 OR num_of_orders eq 1 OR subscriber_clicked_campaign_id in 243315 OR subscriber_clicked_campaign_id in 267146 OR subscriber_clicked_campaign_id in 237730 OR subscriber_clicked_campaign_id in 320017)
              3

            
              22990
              LBF sold
              BA code
              (subscriber_received_campaign_id in 329622 OR subscriber_received_campaign_id in 329246 OR subscriber_received_campaign_id in 342843 OR subscriber_received_campaign_id in 332490 OR subscriber_received_campaign_id in 326190 OR subscriber_received_campaign_id in 326240) AND (num_of_orders eq 0) AND (total_texts_count lt 4) AND (subscriber_is_international ne true)
              4

            
              22990
              LBF sold (copy)
              LBF sold 22
              (subscriber_is_international ne true) AND (subscriber_received_campaign_id in 326240 OR subscriber_received_campaign_id in 329622 OR subscriber_received_campaign_id in 342843 OR subscriber_received_campaign_id in 326240 OR subscriber_received_campaign_id in 332490 OR subscriber_received_campaign_id in 326190) AND (subscriber_opt_in_source eq Manual Upload) AND (total_texts_count gt 4) AND (num_of_orders eq 0) AND (subscriber_received_campaign_id ni 344166)
              4

            
              22990
              Brand Amb upd (copy)
              ambas but not upd
              (subscriber_received_campaign_id in 329622 OR subscriber_received_campaign_id in 329246 OR subscriber_received_campaign_id in 342843 OR subscriber_received_campaign_id in 332490) AND (num_of_orders eq 0) AND (subscriber_is_international ne true) AND (subscriber_is_a_customer ne true) AND (subscriber_received_campaign_id ni 326240)
              4

            
              22990
              Brand Amb upd (copy) (copy)
              here retarget
              (subscriber_received_campaign_id in 350706) AND (num_of_orders eq 0) AND (subscriber_num_replies eq 0) AND (subscriber_is_international ne true) AND (subscriber_is_a_customer ne true)
              4

            
              24865
              Trust Me! Meme (PS+)
              Mr melville follow up ab1
              (subscriber_received_campaign_id in 346672) AND (num_of_orders ge 2) AND (last_order_date bl 12) AND (ab_segment eq 1_of_2)
              2

            
              24865
              In A World Highlight (PS+)
              Mr melville follow up ab2
              (subscriber_received_campaign_id in 346672) AND (num_of_orders ge 2) AND (last_order_date bl 12) AND (ab_segment eq 2_of_2)
              2

            
              25066
              RCG V-day (winter scoop engaged)
              PS KARA: Winter Scoop Engaged
              (subscriber_clicked_campaign_id in 319119 OR subscriber_clicked_campaign_id in 320885) AND (product_id ni 7198622482610) AND (product_id ni 7198622777522)
              2

            
              25066
              RCG V-day (loyal customers)
              PS KARA: Winter Scoop Engaged
              (subscriber_clicked_campaign_id in 319119 OR subscriber_clicked_campaign_id in 320885) AND (product_id ni 7198622482610) AND (product_id ni 7198622777522)
              2

            
              30541
              2/10/22 Extra 20% off Clearance (copy)
              Vday Follow Up
              (subscriber_clicked_campaign_id in 329952) AND (num_of_orders eq 0)
              2

            
              30541
              2/26 Cloud 5 Launch
              On Running 2
              (product_tag in On Running OR subscriber_keywords in 102481 OR subscriber_keywords in 103596 OR subscriber_clicked_campaign_id in 235925)
              2

            
              31072
              Kickstarter Sign Up link Preview
              KICKSTARTER
              (subscriber_keywords in 113323 OR subscriber_clicked_campaign_id in 339979)
              3

            
              31072
              Kickstarter Monday Last Chance
              KICKSTARTER
              (subscriber_keywords in 113323 OR subscriber_clicked_campaign_id in 339979)
              3

            
              31072
              Kickstarter Sign Up Expectations
              kickstarter sign up
              (subscriber_clicked_campaign_id in 342692 OR subscriber_clicked_campaign_id in 339979 OR subscriber_clicked_campaign_id in 341989)
              3

            
              51724
              Valentine's Day - Last Chanced (Clicked)
              Clicked on Valentine's Day 2
              (subscriber_clicked_campaign_id in 329283 OR subscriber_clicked_campaign_id in 329288)
              3

            
              51724
              Miss Shields - Has not purchased - Stock Update
              Have Not Purchased Miss Shields - Received first text
              (product_id ni 5776536305821) AND (subscriber_received_campaign_id in 337421)
              3

            
              51724
              03/07/22 Red Ryder Bundle / Affirm Follow Up
              Follow Up - ACS Movie Sequel Celebration Offer 
              (subscriber_clicked_campaign_id in 342225 OR subscriber_clicked_campaign_id in 342229 OR subscriber_clicked_campaign_id in 342972 OR subscriber_clicked_campaign_id in 342244) AND (product_id ni 7160981946525)
              3