Build an Email List Segmentation and Tagging Plan from Your Real Data

Get 5-7 email segments built from the data you already collect, each with a trigger, a tag name, the email it receives and setup steps for your tool.

You getSegment table, overlap and priority rules and setup steps in my tool

Prompt

Prompt
Act as an email marketing strategist who sets up lists for small businesses.

Your job: design a segmentation and tagging plan I can build in my current email tool this week.

First, ask me these questions in one message and wait for my answers:
1. What do you sell, and what is your main email goal for the next 3 months?
2. Which email tool do you use, and what feeds into it (online store, booking system, forms)?
3. Which data fields do you actually collect today? Paste the field list if you can.
4. Roughly how many subscribers do you have, and how many have bought?

Rules:
- Use only the fields and tools I name. If a segment needs data I don't have, say so and give the simplest way to start collecting it.
- Create 5 to 7 segments, no more. Every subscriber must land in at least one.
- Each segment gets one clear trigger and one lowercase-kebab tag with a prefix: status-, interest- or source-.
- Each segment gets one specific email with a subject line and send timing.
- State which segment wins when subscribers overlap.

Output format:
1. Segment table: Segment | Trigger | Tag name | Email it receives | Timing
2. Overlap and priority rules (3-5 bullets)
3. Setup steps in my tool (numbered, max 8)
4. Data gaps to fix

End with one line on assumptions you made and what could break the plan.

Example output

At a glanceSix email segments: trigger and tagCandle shop on Shopify + Klaviyo, 2,400 subscribers
ItemTriggerTag name
New leadsPopup signup, 0 ordersstatus-new-lead
First-time buyersOrder count = 1status-first-buyer
Repeat buyersOrder count ≥ 2status-repeat
Lapsed buyersLast order > 120 days agostatus-lapsed
Gift buyersGift note checkedinterest-gifting
Market signupsPaper sheet importsource-market

Example for: a two-person candle shop on Shopify with Klaviyo, 2,400 subscribers, 610 buyers, goal of more repeat orders.

1. Segment Table

SegmentTriggerTag nameEmail it receivesTiming
New leadsSigned up via site popup, 0 ordersstatus-new-lead"The 3 scents customers reorder most"Day 3 after signup
First-time buyersPlaced order count = 1status-first-buyer"Get 50+ hours from your candle" (care tips + review ask)7 days after fulfillment
Repeat buyersPlaced order count ≥ 2status-repeat"Your early access: autumn scents"48 hours before each launch
Lapsed buyersLast order > 120 days agostatus-lapsed"Still burning? Your favorite is back in stock"Day 121
Gift buyersGift note box checked at checkoutinterest-gifting"Gift guide: done in 5 minutes"Nov 10 and Dec 1
Market signupsImported from paper sign-up sheetsource-market"Nice meeting you at the market" + 10% codeWithin 2 days of import

2. Overlap and Priority Rules

  • status- tags are exclusive: a subscriber holds only one, and Shopify order count decides which.
  • status-lapsed overrides status-repeat until a new order arrives.
  • interest-gifting and source-market stack with any status tag.
  • If someone qualifies for two emails in the same week, send the status email and skip the other.

3. Setup Steps in Klaviyo

  1. Confirm the Shopify integration syncs "Placed Order" and order count.
  2. Create four segments using order count and last-order date.
  3. Add a flow on segment entry that adds the matching status- tag and removes the old one.
  4. Map the Shopify gift-note field to a profile property, then tag interest-gifting.
  5. Create a list for market imports and tag source-market on upload.
  6. Build one flow per segment with the email above.
  7. Exclude status-lapsed from the weekly newsletter for 14 days after the win-back email.
  8. Check segment counts after 7 days; all should add up to at least 2,400.

4. Data Gaps to Fix

  • No scent preference field: add a one-question quiz to the popup ("Fresh, warm or floral?").
  • Market sheets lack dates: add a date column so source-market timing works.

Assumes Shopify order data syncs reliably; a broken integration would put every buyer in status-new-lead.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • It asks for your real fields and tool first, so every segment can actually be built today.
  • The 5-7 cap stops the model from inventing 15 segments a small team can't maintain.
  • Prefixed tag names and priority rules prevent subscribers getting conflicting emails.

Use when your list is one big blob and every email goes to everyone. Have your email tool's field list open. Works in ChatGPT, Claude or Gemini; paste the exported column names for the best result.

Common edits

  • Add a question about your sending frequency so timing fits your current newsletter schedule.
  • Ask for the email copy for each segment instead of just the subject line.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Marketing