How to Build and Manage Your Email List in DenchClaw

Build and manage your email list in DenchClaw—import subscribers, segment by tag, track engagement, and integrate with sending tools. All data stays local.

Mark Rachapoom

March 26, 2026·6 min read

Managing an email list in a spreadsheet works until it doesn't. Once you're past a few hundred subscribers, you need segmentation, engagement tracking, and the ability to query your list intelligently. DenchClaw gives you a proper email list management layer—relational, queryable, AI-assisted—that runs entirely on your machine.

This is not a replacement for your email sending tool (Mailchimp, ConvertKit, Resend, etc.). It's the layer that sits between your audience and your sender—where you manage the data, segment your list, and maintain the source of truth.

Step 1: Create Your Subscribers Object#

"Create a subscribers object with these fields: 
Full Name (text), Email (email), Status (enum: Active, Unsubscribed, Bounced), 
Source (enum: Organic, Referral, Lead Magnet, Social, Import), 
Subscribed At (date), Tags (tags), Engagement Level (enum: Hot, Warm, Cold), 
Last Email Opened (date), Notes (richtext)."

Set the default view to table with Email as the primary sort field. The enum fields give you your segments; the tags field gives you flexible categorization beyond those enums.

Step 2: Import Your Existing List#

Export your current list from your email provider as CSV, then import:

"Import email subscribers from ~/Downloads/mailchimp-export.csv into my 
subscribers object. Map: Email Address → Email, First Name + Last Name → Full Name, 
Status → Status, OPTIN_TIME → Subscribed At."

For larger lists, the agent batches the inserts. DuckDB handles hundreds of thousands of rows without breaking a sweat.

Step 3: Set Up Source Tracking#

Every new subscriber should have a source. Create a simple intake process: when someone subscribes via your website, a webhook or Zapier trigger can hit a DenchClaw endpoint that creates a new subscriber entry.

Or do it manually for high-value additions: "Add john@example.com to my subscribers, source: referral from Sarah Chen, subscribed today."

Track sources religiously from the start. In six months, you'll be able to answer: "Which subscriber sources have the highest engagement rate?" That's the kind of question that changes how you allocate marketing effort.

Step 4: Segment Your List with Tags#

Tags are your primary segmentation tool. Unlike status enums (one value per subscriber), tags are multi-value. One subscriber can have developer, enterprise, and newsletter-only tags simultaneously.

Common tagging patterns:

Interest area: ai-tools, saas, developer, founder
Content type: newsletter, product-updates, tutorials
Lead status: trial, paid, churned, prospect
Event-based: webinar-jan-2026, conference-2026, early-access

Apply tags in bulk: "Tag all subscribers who signed up via the 'Developer Toolkit' lead magnet with the tag 'developer-tools'."

Query by tag: "How many subscribers have the tag 'enterprise'?"

Step 5: Track Engagement#

Most email platforms export engagement data—open rates, click rates, last open date. Import this periodically to keep your DenchClaw list in sync:

"Import the engagement data from ~/Downloads/mailchimp-engagement.csv. 
Update each subscriber's Last Email Opened date and set Engagement Level 
based on this rule: opened in last 30 days = Hot, 30-90 days = Warm, 90+ days or never = Cold."

This gives you a clean segmentation for re-engagement campaigns: "Show me all subscribers with Engagement Level = Cold who have been on my list for more than 6 months."

Step 6: Build List Segments as Views#

Create saved views for your most-used segments:

Active engaged subscribers:

"Create a view called 'Hot List' filtering: Status = Active, 
Engagement Level = Hot or Warm."

Win-back candidates:

"Create a view called 'Re-engagement' filtering: Status = Active, 
Engagement Level = Cold, Subscribed At more than 90 days ago."

Recent subscribers:

"Create a view called 'New Subscribers' filtering: Subscribed At in last 30 days."

Each view becomes a segment you can export to your email platform for targeted campaigns.

Step 7: Export Segments for Sending#

When you're ready to send a campaign, export the relevant segment:

"Export my 'Hot List' view as a CSV with columns: Full Name, Email. 
Save it to ~/Downloads/campaign-july-hot-list.csv."

Upload that CSV to your email provider. The separation is intentional: DenchClaw manages the data and segmentation logic; your email platform handles deliverability and sending infrastructure.

Step 8: Handle Unsubscribes and Bounces#

Keep your suppression list in sync. After each campaign, export unsubscribes and bounces from your email platform and update DenchClaw:

"Import unsubscribes from ~/Downloads/unsubs.csv and update those 
subscribers' Status to 'Unsubscribed' in my subscribers object."

Never manually manage suppression lists. Do a clean import-update cycle after every campaign send.

Step 9: Analyze List Growth#

Track your list over time:

"Show me new subscriber count by month for the last 12 months as a line chart."

"Show me subscriber sources—what percentage came from each source?"

"Show me unsubscribe rate by month."

These queries give you a list health view that most email platforms charge extra for in their analytics tier. In DenchClaw, it's a SQL query against your local data.

Take it one step further by linking subscribers to entries in your people or leads object. If someone on your email list is also a sales lead, you want to know:

"Create a relation field in my subscribers object called 'CRM Contact' 
that links to my people object. Find matches by email address and link them automatically."

Now you can see: does this subscriber have an open deal? Have they ever talked to sales? Are they already a customer? This cross-object view gives you context that pure email tools can't provide.

Frequently Asked Questions#

Is DenchClaw a replacement for Mailchimp or ConvertKit?#

No—DenchClaw doesn't send emails at scale. It's the data layer: import, segment, tag, analyze. Your email platform handles sending, deliverability, and templates. The two work in tandem.

DenchClaw stores everything locally, which simplifies GDPR significantly (you're the data controller and processor). Track consent source and date in your subscribers object. For right-to-erasure requests, ask: "Delete all data for subscriber email@example.com."