121: Benedikt Deicke - Building Userlist.io

What It Covers

Benedikt Deicke explains building Userlist.io, a SaaS-focused email automation platform, covering technical architecture choices including Rails backend, Ember frontend, server-side integration strategy, dynamic SQL query generation from abstract syntax trees, and workflow engine implementation.

Key Questions Answered

• •Server-side integration strategy: Userlist requires server-side API calls instead of JavaScript snippets to ensure reliable tracking without ad blockers, browser limitations, or third party cookie restrictions affecting data collection and automation triggers for customer onboarding sequences.
• •Dynamic segmentation architecture: User segments compile from abstract syntax trees stored as hashes in the database, using Rails AREL to generate SQL queries dynamically. This allows complex nested conditions like email filters combined with event frequency tracking across custom time periods.
• •Workflow execution model: Campaign automations execute as background jobs that process one node at a time, scheduling the next step only after completion. This just-in-time approach allows campaign modifications to affect users mid-sequence without re-queuing all future emails.
• •Email deliverability preparation: SparkPost integration separates customer accounts into subaccounts to prevent one bad actor from damaging deliverability for all users. Custom domain authentication with DKIM is optional but recommended, defaulting to userlistmail.com sending addresses for immediate functionality.