Sales pipeline and lead generation compound. Build CRM systems, lead scoring models, follow-up sequences, deal tracking, and revenue dashboards for any business vertical.
Chain builds revenue systems that scale. Whether you're running a 2-person contractor crew, a SaaS startup, or an enterprise professional services firm, this compound gives you the architecture to systematize sales, prioritize leads, and forecast revenue with confidence.
1. Pipeline Architecture
Your pipeline is your business model visualized. Every deal moves through stages; your job is making those stages consistent, measurable, and automatic.
Core Lead Stages
Five stages work for 90% of businesses:
Awareness — They know you exist. They've seen content, clicked an ad, or entered your funnel. Not yet a "lead" in the sales sense.
Interest — They downloaded, watched, or responded. Explicit signal they care about your category. This is where qualification begins.
Evaluation — They're comparing options. You've had a conversation, sent a proposal, or shown them your product. Active decision-making window.
Closed — Win or loss. Document the outcome and reason. This data is revenue intelligence.
Each stage has a time expectation (velocity). A typical B2B SaaS deal: 2 weeks in Awareness, 1 week in Interest, 2 weeks in Evaluation, 1 week in Decision. Your business will differ. Track and optimize.
Stage-Specific Actions
Awareness stage:
Add to email nurture (automation)
Tag by channel (organic, paid, referral, event)
Don't contact immediately—let content do the work
Batch review weekly; decide who to activate
Interest stage:
Send structured follow-up within 48 hours (manual or automated)
Ask qualifying questions: budget window, buying process, stakeholders
Schedule a call if they fit your ICP (Ideal Customer Profile)
If no response in 5 days, move to re-engagement sequence
Evaluation stage:
Send proposal within 24 hours of call
Set explicit follow-up date ("I'll check in Thursday")
Update on calls, objections, and missing information
Create competitive summary if needed
Flag decision-maker gaps (stakeholders not yet engaged)
"Free tier user for 30+ days, zero engagement" — Archive
"Company size <$1M revenue" (if targeting enterprise) — Move to nurture list
"Role is not decision-maker" (e.g., individual contributor asking on behalf of team) — Tag and deprioritize
"No company domain email" (personal Gmail, etc.) — Lower score by 10 points
Manual vs Automatic Scoring
Automatic (do this):
Track page views, email opens, download behavior via platform (Supabase event logging, Segment, or Mixpanel)
Score immediately on form submission
Re-score weekly based on new activity
Manual (do sparingly):
Sales rep notes after call ("Budget not approved yet, revisit in Q3")
Company research (CEO change, funding round, expansion into your category)
Use manual scoring to override automatic scores with recent intel
Score Decay
Leads lose relevance fast. Decay model:
Decay 5 points per week of inactivity
After 3 months of zero engagement, move to "nurture-only" list
Reactivate if they engage again (click email, visit site)
Quarterly review: remove dead-weight leads (scored <10 for 6+ months)
4. Follow-Up Sequences
Sequence automation is the leverage that lets 1 sales rep manage 100+ leads. Build these once, run forever.
Email Sequence Templates
5-Touch Sequence (7-day span, B2B SaaS):
Day 1: Hook + problem
Day 2: Alternative approaches
Day 4: Social proof (case study)
Day 6: Scarcity/urgency (limited slots)
Day 8: Final ask + CTA
Example email 1 (hook):
Subject: [Company name], quick question
Hi [Name],
Your [Competitor/Process] looks solid, but I found most [similar companies]
struggle with [specific pain point you solve].
Is this on your radar?
[Your name]
Example email 2 (alternative):
Subject: Re: quick question
If you're open to it, most teams we work with have solved this in 3 ways:
1. [In-house solution]
2. [Competitor solution]
3. [Your solution + why it's different]
Worth exploring?
7-Touch Sequence (high-volume, cold outreach):
Day 1: Personalized intro
Day 3: One-liner value prop
Day 5: Case study / social proof
Day 7: Question ("What's blocking a conversation?")
Day 10: Pattern interrupt (different angle)
Day 14: Last chance angle
Day 21: Re-engagement ask ("We're launching X, might interest you")
Avoid 20-field forms that nobody fills out. Start minimal. Add fields only when you find yourself asking the same question repeatedly.
Integration Patterns (Supabase-Based CRM)
Use Supabase PostgreSQL as your schema foundation:
-- Enable real-time
create publication supabase_realtime for table contacts, deals, activities;
-- Triggers for auto-timestamps
create trigger set_updated_at before update on contacts
for each row execute function update_updated_at_column();
-- Index for fast lookups
create index idx_contacts_company_id on contacts(company_id);
create index idx_deals_stage on deals(stage);
create index idx_activities_contact_id on activities(contact_id);
-- Row-level security (optional, for multi-user teams)
create policy "Users can view own company's contacts" on contacts
for select using (auth.uid() = owner_id);
Connect via:
Zapier for form submissions → contacts auto-creation
Make for complex multi-step workflows (email sent → update contact score)
Custom Edge Functions for real-time notifications (deal moved to Decision stage → alert sales)
6. Revenue Dashboards
What gets measured gets managed. Build dashboards you check daily.
Key Visualizations
Pipeline Value by Stage (top metric):
X-axis: Stages (Awareness → Closed Won)
Y-axis: Total deal value in each stage
Benchmark: Pipeline value 3–4x annual revenue target
Update: Daily or weekly
Action: If pipeline < 3x target, activate lead generation
Win/Loss Analysis:
Month-to-date: Closed Won $ vs. Closed Lost $
Win rate %: Closed Won ÷ (Closed Won + Closed Lost)
Benchmark: 25–40% for B2B
Breakout: By sales rep, by industry, by competitor
Action: Why are we losing? Is it product, price, or positioning?
Breakout: By stage (which stage is the slowest bottleneck?)
Benchmark: 30–60 days for SaaS, 7–14 days for ecommerce
Action: Can you speed up the bottleneck? (e.g., faster proposals)
Lead Source Performance:
Leads generated by source (organic, cold, referral, ads)
Cost per lead (if paid)
Close rate by source
Average deal size by source
Action: Double down on sources with best conversion and deal size
Forecast (next 30/60/90 days):
Sum of (Deal amount × Probability %) for each deal in pipeline
Compare to targets
Update: Weekly
Action: Will you hit quota? Activate emergency outreach if behind
Lead Score Distribution:
Histogram: How many leads at each score level?
Healthy sign: Bell curve (some warm, some cold)
Unhealthy: All leads below 20 (not qualifying enough) or all above 70 (not enough pipeline)
Action: Adjust scoring model or lead gen strategy
Implementation (Supabase + Looker / Metabase)
-- Revenue forecast query
select
stage,
count(id) as deal_count,
sum(amount) as total_value,
sum(amount * (probability / 100)) as weighted_forecast
from deals
where stage in ('evaluation', 'decision')
and closed_at is null
and expected_close_date > now()
group by stage
order by stage;
-- Win rate query
select
trunc(closed_at, 'month') as close_month,
(count(*) filter (where final_status = 'won') * 100 / count(*))::integer as win_rate_pct
from deals
where closed_at > now() - interval '12 months'
group by close_month
order by close_month;
7. Automation Recipes
Automation removes friction. Implement these in Zapier, Make, or custom functions.
Recipe 1: New Lead Notification
Trigger: Form submission or contact created in CRM
Actions:
Add to "new_leads" email list
Assign lead score based on source
If score >50, notify sales team via Slack: "Hot lead: [Name] from [Company]"
If score <30, add to nurture sequence automatically
Benefit: Eliminates manual prospecting overhead; hot leads get immediate attention.
Recipe 2: Stage Change Triggers
Trigger: Deal moves to Evaluation stage
Actions:
Send proposal template to sales rep (Slack message with link)
Schedule calendar reminder for follow-up (3 days)
Log activity: "Moved to Evaluation"
Notify customer success if deal is >$10k (onboarding prep)
Benefit: Standardizes process; nothing falls through cracks.
Recipe 3: Stale Deal Alert
Trigger: Deal in Decision stage for >14 days without activity
Actions:
Notify sales rep: "Deal is stale. Check in today."
Suggest next action: "Send updated pricing / confirm timeline"
Log internal note with suggestion
Benefit: Prevents deals from dying from neglect.
Recipe 4: Win/Loss Post-Mortem
Trigger: Deal closed (won or lost)
Actions (if won):
Congratulations Slack notification
Prompt to log case study details
Ask for customer testimonial
Update contact as "customer"
Pass to onboarding team
Actions (if lost):
Prompt sales rep: "Why did we lose? [Dropdown: price, features, competitor, budget cut, timeline]"
Log response in deal record
Send win/loss survey to contact (email)
Archive deal after 30 days
Benefit: Builds post-mortem data that informs product and positioning.
Recipe 5: Email Sequence Automation
Trigger: Contact created with score >20 and source = "cold email"
Actions:
Add to 5-touch sequence
Send email 1 immediately
Schedule email 2 for day 3 at 10am
Schedule email 3 for day 5 at 2pm
If contact replies, pause sequence and notify sales
If sequence completes (all 5 sent), move to "nurture" status
Benefit: Scales outbound prospecting; no manual sends needed.
8. Anti-Patterns (Mistakes That Kill Revenue)
Anti-Pattern 1: Too Many Pipeline Stages
The mistake: 15-stage pipeline (Lead → Prospect → Qualified Lead → SQLs → Opportunity → Demo Scheduled → Proposal Sent → Proposal Reviewed → Negotiation → Legal Review → Contract Sent → Contract Signed → Closed Won → Onboarding → Retained)
Why it fails:
Reporting is confusing (which stages matter?)
Sales reps game the system (move deals without real progress)
Velocity metrics become meaningless
Forecasting impossible
Fix: Stick to 5–7 stages max. Anything more goes in activity notes, not deal stage.
Anti-Pattern 2: Not Tracking "Why We Lost"
The mistake: Deal closes lost, reason field is empty or generic ("customer not interested").
Why it fails:
You don't know if you're losing to price, product, or competitors
You can't improve positioning or product based on feedback
You can't distinguish between fixable and unfixable reasons
Fix: Require sales reps to select loss reason (dropdown) and add 2–3 sentence note. Analyze quarterly.
Anti-Pattern 3: Following Up Without Value
The mistake: Email sequence is pure ask. "Are you interested?" "Still interested?" "Let's talk."
Why it fails:
Reply rates collapse (<1%)
Leads ignore follow-up
Your brand becomes spam
Fix: Sequence should alternate between value (article, case study, insight) and ask. 60% value, 40% ask.
Anti-Pattern 4: Treating All Leads the Same
The mistake: Cold email to 1,000 leads with identical message. Same follow-up cadence for $1k and $100k deals.
Why it fails:
Low conversion (personalization matters)
Resource waste (sales reps follow up on unqualified leads)
Long sales cycles for low-value deals
Fix: Segment by deal size, industry, and source. Adjust cadence and messaging accordingly.
Anti-Pattern 5: No Lead-to-Customer Handoff Process
The mistake: Sales closes a deal, customer is now "someone else's problem" (support, onboarding, success).
Why it fails:
Customer feels abandoned
On-time onboarding rates suffer
Churn increases
Repeat sales rates drop
Fix: Create playbook: Deal closed → Onboarding team gets 48h notice → Kickoff call scheduled → 30-day check-in with sales + success team.
Anti-Pattern 6: Ignoring Pipeline Velocity Trends
The mistake: Deal cycle was 30 days last year, now it's 60 days. No one notices or acts.
Why it fails:
You miss early warning of product issues (harder to sell = new competitor or features broken?)
Forecasting becomes inaccurate
Team morale suffers (deals take forever)
Fix: Track cycle time monthly. If it increases >10%, investigate immediately. Common causes: product, market, or sales strategy changes.
Anti-Pattern 7: Scoring Model Never Evolves
The mistake: Built scoring model 18 months ago; never reviewed it.
Why it fails:
Your business has changed (now selling upmarket instead of SMB)
Scoring no longer predicts closes
Sales ignores scores because they don't work
Fix: Review quarterly. Check: Do high-scored leads actually convert? Adjust weights and thresholds accordingly.
Quick Start Checklist
Define your 5–7 pipeline stages (use templates above as baseline)
Set stage velocity targets (how many days in each stage?)
Build lead scoring model with demographic, behavioral, engagement factors
Create 5-touch email sequence for cold outreach
Set up 3 lead generation channels (at least 1 inbound, 1 outbound)
Document your ICP (Ideal Customer Profile) and auto-qualification rules
Build CRM schema in Supabase (contacts, companies, deals, activities tables)
Set up revenue dashboard (pipeline by stage, win rate, velocity)
Automate top 2 workflows (new lead notification, stage change trigger)