# Build safer email audience segments

Email exports often mix active subscribers, lapsed customers, and people who must not receive messages. This skill converts your own exported data into documented segments and a suppression list with clear confidence labels.

## Install

```bash
npx skillstore add aaron-he-zhu/list-segment-builder
```

## Metadata

- Status: approved
- Slug: aaron-he-zhu-list-segment-builder
- Version: 19.0.0
- Author version: 19.0.0
- Skillstore revision: r2
- Version status: valid
- Tree hash: 9197b875b097f1a571ee3c941ce2c6e8185916d0a2ce8a8fa7b07d1a5f0afc38
- Author: aaron-he-zhu
- GitHub username: aaron-he-zhu
- License: Apache-2.0
- Repository: https://github.com/aaron-he-zhu/aaron-marketing-skills/tree/main/email/setup/list-segment-builder
- Ref: 0715a6e09ea875c8e28cb705ce87cc83045e69c1
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands, network, filesystem
- Quality score: 82
- Quality tier: silver
- Public page: https://skillstore.pages.dev/skills/aaron-he-zhu-list-segment-builder
- Manifest: https://skillstore.pages.dev/api/skills/aaron-he-zhu-list-segment-builder/manifest

## Capabilities

- Identifies usable engagement, consent, and order-data columns in a provided export.
- Defines behavioral segments such as engaged, cart-abandoner, and lapsed audiences.
- Builds RFM tiers when recency, frequency, and monetary fields are available.
- Maps subscribers to reusable lifecycle stages using stated rules.
- Creates a do-not-mail rule set for unsubscribes, bounces, complaints, and withdrawn consent.
- Labels segment sizes as Measured or Estimated and flags missing data as NEEDS\_INPUT.

## Use Cases

- Prepare a retention campaign audience: Separate active, at-risk, and lapsed subscribers before planning a retention campaign.
- Create customer value tiers: Turn an ecommerce order export into RFM tiers with transparent rules and missing-data flags.
- Improve suppression hygiene: Reconcile exported unsubscribe and bounce signals with consent records before a planned send.

## Prompt Templates

### Start with an export

```
Build email segments from my attached subscriber export. My goal is retention.
```

### Create engagement audiences

```
Using this CSV, define engaged-90d, lapsed, and cart-abandoner segments. Show the rule and measured size for each.
```

### Build RFM and lifecycle tiers

```
Use my CRM and order exports to create RFM tiers and lifecycle stages. Flag any required columns that are missing.
```

### Reconcile a suppression list

```
Compare these campaign and consent exports. Build a do-not-mail rule set and identify cohorts that need consent verification.
```

## Limitations

- It needs user-provided exports or pasted column details to calculate segments.
- It does not send campaigns, write email copy, or design automation flows.
- It does not validate email authentication, reputation, or spam content.
- Live Resend changes require explicit confirmation and appropriate account access.

## Best Practices

- Provide exports with column names and date ranges, not only screenshots.
- Review suppression and consent rules before using any segment in a campaign.
- Use measured counts where possible and document every estimated rule.

## Anti Patterns

- Do not treat missing consent records as permission to email a cohort.
- Do not create RFM tiers when order recency, frequency, or value data is absent.
- Do not store or repeat raw email addresses and other personal data in summaries.

## Security Audit

- Audited at: 2026-07-26T10:29:15.294\+00:00
- Summary: Most static findings are false positives caused by Markdown code fences, inline code, and relative documentation links. One documented Resend command can perform a live suppression update when invoked with --live; it should require a clear user confirmation immediately before execution. No prompt-injection or data-exfiltration intent was found.

## Stats

- Views: 0
- Downloads: 6
- Favorites: 0
- Popularity score: 0