Marketing is sending a campaign. A customer in promo_customers (customer_id, country, signup_date, marketing_opt_in, lifetime_spend, last_order_at, deleted_at) is eligible when all of these hold:
1. The account isn't deleted (deleted_at is empty). 2. country is 'GB' or 'IE'. 3. They've agreed to marketing: marketing_opt_in is true. Customers who signed up before 2018-05-25 were never asked, so their marketing_opt_in is empty and counts as agreed; anyone else with an empty answer has not agreed. 4. They're not a *lapsed low-value* customer: lifetime spend under 100 (an empty spend counts as 0) and no order on or after 2024-01-02 00:00:00 (or no order at all). Either half alone is fine. 5. They're not on the suppression list, promo_suppressions (customer_id, reason).
Columns: customer_id. Sort by customer_id.