Segment the email list

We need to split our subscribers so the right message lands with each group this week. Create a segment of active customers who opened at least one email in the past 90 days and made a purchase in the last 12 months, and a second segment of inactive subscribers who haven’t opened anything in 180 days. Name them Active Buyers and Reactivation Targets. Double-check counts and tag each record with segment name before exporting.

Before we send the next blast, make the segments work for conversion. Surface top three differences between Active Buyers and Reactivation Targets: average order value, last purchase date distribution, and preferred category. Flag any overlap where a contact appears in both segments and suggest a rule to resolve it. Recommend whether to exclude low-engagement contacts under 10% open rate.

I discovered duplicates: the same email appears in Customer List and Newsletter List with conflicting tags (VIP vs Prospect). I’m afraid we’ll send them contradictory messages and irritate VIPs. I don’t know which source of truth marketing should use. Which list should I treat as authoritative, how do I merge without losing purchase history, and what immediate rule prevents duplicate sends this week?

Every month I rebuild the same segments from scratch and we lose consistent targeting. I spend hours reconciling tags and counts before every campaign. Tell me one change to stop recreating segments, how to preserve purchase history and engagement metrics across lists, and a simple convention so the team avoids making conflicting tags.