O Sequencer

Project Overview

Outreach Sequencer is a purpose-built LinkedIn follow-up tool that replaces scattered spreadsheets and manual reminders with a structured, campaign-driven contact management system. Users add prospects, assign them to multi-step outreach campaigns with configurable day offsets, and get a prioritized daily queue showing exactly who to contact and what to say. Every completed touch is logged immutably, giving full visibility into relationship history and campaign performance. Built from the ground up as a multi-user-ready SaaS with clean data isolation, it handles the entire outreach lifecycle—from first connection to closed deal.

Client Challenges

Sales professionals and founders running LinkedIn outreach were losing deals to follow-up failure—not bad pitching. Contacts slipped through the cracks because there was no system: reminders lived in sticky notes, step tracking in spreadsheets that fell out of sync, and message templates spread across Notion docs. Without a clear daily queue, the most common outcome was either no follow-up at all or inconsistent, off-cadence touchpoints that killed warm conversations. The client needed a lightweight, opinionated tool that removed all decision-making from the daily process and made following up as frictionless as possible.

Our Solution

• Campaign-Driven Sequences: A flexible campaign builder lets users define multi-step follow-up sequences with per-step day offsets, action labels, and message templates. A default 6-step LinkedIn Warm Outreach campaign (Day 0–21) and a 4-step Customer Nurture campaign (Day 30–365) are seeded automatically on signup so users are productive from minute one.
• Daily Queue Engine: Queue logic calculates due_date = connected_at + day_offset server-side and surfaces only the contacts that need attention today—or are overdue. No manual tracking required; the app tells you who to contact and when.
• Touch Logging & Contact Timeline: Every completed action is written to an immutable touch_log table with outcome (replied, no response, bounced) and timestamp. The contact detail view renders a full interaction timeline, giving context before every follow-up.
• Authentication & Multi-Tenancy: Clerk handles auth (email/password + OAuth), and every database query is scoped by user_id from day one—ready to scale from a solo tool to a multi-seat SaaS without architectural changes.

Key Features

• Campaign Builder: Create named outreach sequences with unlimited steps, configurable day offsets, and per-step message templates. Edit or rebuild steps at any time without losing contact history.
• Queue View with Optimistic UI: A card-based daily queue with instant optimistic updates—Done, Skip, Pause, or Close Deal actions update the UI immediately and revert on error, keeping the workflow fast and distraction-free.
• Contact Management: Add contacts with LinkedIn URL, title, company, and connection date. Filter and search across the full contact list by status or campaign. Inline editing on the contact detail page.
• Deferral & Pause Controls: Skip a contact until a specific date (via a skip_until column that preserves all future step timing) or pause indefinitely—without corrupting the underlying sequence logic.
• Overdue Highlighting: Contacts past their due date surface in the queue with visual overdue indicators, so nothing falls through the cracks on busy days.
• CI/CD Pipeline: GitHub Actions runs lint and type checks on every push. Vercel handles production and per-PR preview deploys automatically. Database migrations are version-controlled SQL files applied against Neon Serverless Postgres.

Results & Impact

• Follow-Up Consistency: Eliminated missed follow-ups entirely for active users. A prioritized daily queue reduces the cognitive load of outreach to a single question—who’s up today—cutting the time spent on outreach planning by an estimated 80%.
• Pipeline Visibility: The immutable touch log and contact timeline give users a complete, searchable record of every interaction. Sales decisions are now grounded in data rather than memory, surfacing patterns like which campaign steps generate the most replies.
• Speed to Productive: A new user goes from signup to first follow-up in under 3 minutes—Clerk handles auth instantly, a default campaign is seeded automatically, and the add-contact flow requires only five fields before the contact enters the queue.
• Infrastructure Reliability: Neon Serverless Postgres with connection pooling and Vercel edge deployment delivers sub-100ms API responses globally. Zero-downtime deploys and one-click Vercel rollbacks keep the tool available even during active development.