Segmentation Rule Builder

Email marketing performance lives and dies by segmentation precision. Broadcasting the same message to an entire list tanks open rates, accelerates subscriber unsubscribes, and triggers deliverability penalties from mailbox providers like Google and Yahoo. Yet building granular segments in platforms like Klaviyo, HubSpot, Mailchimp, or ActiveCampaign usually requires tedious manual schema mapping and wrestling with incompatible filter syntax. This free tool parses your CSV headers or sample data, automatically classifies column attributes into Recency, Frequency, Monetary, and Persona dimensions, scores your list's segmentation readiness out of 100, and generates ready-to-paste filter definitions and SQL queries in seconds. Everything runs 100% locally in your browser — your customer data is never uploaded, tracked, or saved.

/* Paste CSV headers above to generate your segmentation rule */

What is a segmentation rule builder?

A segmentation rule builder is an email marketing and CRM utility that translates raw customer data schemas — specifically CSV column headers and attribute fields — into executable logical filter queries. When you export customer lists from e-commerce platforms like Shopify, billing engines like Stripe, or databases like PostgreSQL, your data arrives with raw column headers such as total_spend, last_order_date, orders_count, or is_active. To turn those raw attributes into targeted marketing campaigns, you must define segment criteria inside an Email Service Provider (ESP) like Klaviyo, HubSpot, Mailchimp, or ActiveCampaign.

Translating column schemas into production segments is frequently fraught with errors. Different platforms use incompatible syntax, idiosyncratic property naming rules, and distinct handling for dates, numbers, and strings. A filter that checks whether a customer spent over $500 requires a numeric property evaluation in Klaviyo (Properties about someone → total_spend is greater than 500), an active contact property list filter in HubSpot (Contact property | total_spend is greater than 500), a conditional merge tag check in Mailchimp (*|TOTAL_SPEND|* is greater than 500), or a standard SQL clause (WHERE total_spend > 500). This tool automates that translation process while evaluating your schema against modern list hygiene and RFM (Recency, Frequency, Monetary) best practices.

Why CSV header quality determines segmentation capability

You cannot build segments on data points that your list does not capture. Many marketing teams attempt advanced behavioral workflows — such as churn prevention win-backs, VIP tiered rewards, or cart abandonment sequences — only to discover their customer CSV contains nothing more than an email address and a signup timestamp. Without transactional, temporal, or firmographic attributes, your campaigns are trapped in generic broadcast territory.

This tool evaluates CSV headers across four essential dimensions to calculate a comprehensive Segmentation Readiness Score (0–100):

The RFM segmentation framework for email marketers

The gold standard for database segmentation is the RFM model: Recency, Frequency, and Monetary value. Originally pioneered in direct-mail catalog marketing, RFM provides an objective, mathematical framework to divide subscribers based on actual commercial behavior rather than guesswork:

1. Recency: When did the customer last interact or purchase? Subscribers who purchased within the last 30 days are up to five times more receptive to new cross-sell offers than subscribers whose last transaction was 12 months ago. Headers like last_order_date or last_active_at power these time-decay filters.
2. Frequency: How often do they buy or log in? High-frequency repeat buyers have demonstrated trust in your fulfillment and customer service. Headers like orders_count, sessions_count, or total_purchases allow you to separate one-time buyers from repeat brand champions.
3. Monetary: How much capital have they spent over their relationship with your brand? A customer who has spent $3,000 across four orders warrants dedicated VIP treatment, exclusive previews, and higher-touch concierge support compared to someone who bought a $15 accessory. Headers like total_spend, lifetime_value, or clv define these value thresholds.

How segmentation syntax differs across email platforms

Every major marketing platform formats logical queries differently. Confusing string equality with numeric comparisons or relative date filters is one of the most common causes of misdirected email broadcasts:

Klaviyo

Klaviyo separates contact traits into Properties about someone (profile attributes) and Metrics (event tracking). Profile properties generated from CSV imports require exact type mapping. If you import total_spend as a text string instead of a number, Klaviyo will disable mathematical operators like “is greater than” and force alphabetical sorting where “50” is evaluated as greater than “400”. This builder generates native profile property definitions with appropriate types.

HubSpot

HubSpot categorizes segmentation through Active Lists (which dynamically add and remove contacts as criteria change) and Static Lists (snapshots). HubSpot's filtering engine uses property-specific operators like “is equal to any of” for dropdown properties and “is less than X days ago” for date properties. Relative date handling in HubSpot is calculated backwards from the current execution date.

Mailchimp

Mailchimp operates on audience tags, groups, and merge tags. When filtering on merge fields, Mailchimp requires exact bracket notation (*|MERGE_TAG|*) and limits conditional segment logic to a maximum of five nested criteria on standard plans. Conjunctions must be uniformly set to match ALL (AND) or match ANY (OR) conditions.

ActiveCampaign

ActiveCampaign provides an intuitive condition builder for lists and automations. Custom contact fields are queried using strict case-sensitive comparisons. Date queries support both absolute calendar dates and dynamic offsets (such as “Current date minus 30 days”).

Universal SQL

For growth engineers and data analysts managing raw customer data warehouses in PostgreSQL, MySQL, BigQuery, or Snowflake, SQL offers the ultimate flexibility. The SQL output mode generates clean, ANSI-compliant WHERE clauses that handle string escaping, NULL checks, and date interval arithmetic.

6 essential segmentation rules every email brand needs

1. High-Value VIP Customers: Filter for customers where total_spend > 500 AND orders_count >= 3 AND email_opt_in = true. Send this segment VIP-exclusive early access to new product drops and surprise thank-you perks.
2. The 90-Day Sunset Policy: Filter for subscribers where last_order_date is older than 90 days AND email_open_count = 0. Route these contacts into an automated 3-part re-engagement sequence. If they fail to engage, suppress or unsubscribe them to protect your domain reputation.
3. New Subscriber Welcome Nurture: Filter for contacts where created_at is within the past 30 days AND orders_count = 0. Focus your copy on introducing brand values, addressing common first-time objections, and delivering a welcome incentive.
4. B2B Corporate vs. Consumer Accounts: In B2B lead generation, personal webmail addresses (such as Gmail, Yahoo, or Outlook) convert at vastly lower rates than corporate company domains. Filter for email does not contain @gmail.com AND company is set to prioritize high-value sales demos.
5. Regional & Geographic Segmentation: Filter by country = 'US' or timezone = 'America/New_York' to prevent sending morning marketing alerts in the middle of the recipient’s night, and to tailor local holiday promotions.
6. Cart & Browse Abandonment Recovery: Filter for customers where cart_abandoned = true AND last_cart_date is within past 3 days to trigger timely, automated recovery reminders before purchase intent cools.

Worked examples: From raw headers to production rules

Limitations and operational caveats

• Schema evaluation vs. row validation: This tool inspects column headers and optional data samples to infer data types and scoring. It does not audit the completeness or null-rate of millions of rows in your database. A column named total_spend will be detected as a monetary attribute, but if 95% of your records contain blank values for that field, your segment size will be smaller than expected.
• ESP data type formatting: When importing a CSV file into your ESP, ensure that your import wizard explicitly casts columns to the correct data type (e.g., Number, Date, or Boolean). If an ESP defaults a numeric column to Text during upload, mathematical greater-than operators will fail.
• Date timezone offsets: Relative date filters (e.g. “within the last 30 days”) depend on your ESP’s configured account timezone. A segment evaluated at midnight UTC may include or exclude contacts based on local billing time differences.
• Browser-only processing: For security and confidentiality, all file parsing and rule synthesis occurs entirely within your browser’s JavaScript engine. No contact data or column schemas are ever sent to an external server.

Frequently asked questions

What is the difference between a list and a segment?

A list is a static collection of email addresses that contacts join through a form or import and leave by unsubscribing. A segment is a dynamic, rule-based filter that continuously evaluates your entire audience. Contacts automatically enter a segment when they meet its criteria (such as placing a second order) and automatically exit when they no longer qualify (such as going 90 days without an interaction).

Why did my CSV headers receive a low Segmentability Score?

A low score indicates that your dataset contains few behavioral, monetary, or temporal attributes. If your CSV only has email and first_name, it receives points for basic contactability but zero points for Recency (dates) or Monetary value (spend). To increase your segmentability, configure your e-commerce platform or CRM to export transactional totals and timestamp fields.

How does Klaviyo distinguish profile properties from event metrics?

In Klaviyo, profile properties represent current static attributes about a person (e.g. country, total_spend, first_name), whereas event metrics track historical actions (e.g. Placed Order, Started Checkout). CSV imports populate profile properties. If you want to segment by behavioral events in Klaviyo, you must use their native integrations (such as Shopify or WooCommerce) rather than CSV uploads.

Can I segment by both AND and OR conditions simultaneously?

Yes. In professional ESPs and SQL queries, you can group criteria using Boolean logic. For example, you can require that a subscriber matches (total_spend > 500 OR orders_count > 5) AND country = 'US'. This tool allows you to select the primary conjunction mode and incorporates secondary criteria into preset recipes.

Why does my ESP reject numeric queries like “greater than”?

This almost always indicates a data type mismatch during CSV import. When uploading your CSV, your ESP asked you to map each column. If total_spend was mistakenly mapped as a “Text” field instead of a “Number” or “Currency” field, the platform disables mathematical operators. To fix this, update the property type in your platform’s settings or re-import the file with correct column mapping.

Will segmenting my list hurt my overall reach?

No — it increases your effective reach and engagement. While sending to a targeted segment reaches fewer inboxes than blasting your whole list, segmented campaigns consistently achieve 2× to 3× higher open rates and substantially fewer spam complaints. Mailbox providers reward this high engagement by delivering your emails directly to the primary inbox rather than the promotions or spam folders.

Related email marketing tools

• Campaign Link Checker — Test all destination links and redirects before broadcast
• UTM Bulk Builder — Generate consistent campaign tracking tags for your email links
• Unsubscribe Compliance Checker — Audit one-click unsubscribe headers and compliance
• CAN-SPAM / GDPR Email Checker — Verify mandatory legal disclosure requirements
• List Hygiene Planner — Build automated sunset policies to purge unengaged contacts
• Cold Email Subject Line Grader — Score subject lines for open rates and deliverability

Next step

Need help configuring advanced multi-tier segmentation, lifecycle automation flows, or deliverability repair for your brand? Explore our dedicated Email Marketing & Deliverability Consulting services to turn customer data into revenue.