Skip to main contentSkip to navigationSkip to footer

CRM Pipeline Design and Visualization

8 min
2/6

Key Takeaways

  • Pipeline stages should mirror the real process with clear entry/exit criteria and defined next actions.
  • A wholesale pipeline typically has 7 stages from New Lead to Closed with 45-60 day target velocity.
  • Pipeline health metrics include stage conversion rates, value concentration, velocity, and aging.
  • Deals stalled at 2x the stage average should be reviewed and either advanced, regressed, or closed.

The pipeline is the visual representation of deals progressing from initial lead to closed transaction. A well-designed pipeline provides instant visibility into business health, identifies bottlenecks, and ensures that every opportunity receives appropriate attention. This lesson covers pipeline design principles for different real estate business models.

Process Flow

1

Pipeline Design Principles

Effective pipeline design follows four principles. Mirror the Real Process: pipeline stages should reflect the actual steps a deal goes through, not an idealized or simplified version. If the real process has 8 steps, the pipeline should have 8 stages. Artificially condensing stages hides important workflow details. Clear Stage Definitions: each stage needs an entry criteria (what must be true for a deal to enter this stage) and exit criteria (what must happen before the deal advances). Without clear definitions, team members will advance deals prematurely or inconsistently. Actionable Stages: every stage should have a defined next action. "Waiting" is not a stage—it is a symptom of unclear process definition. Replace "Waiting for Response" with "Follow-Up Scheduled" and attach a specific follow-up date and action. Measurable: each stage should have a conversion rate benchmark. If the industry average for "Offer Made to Under Contract" is 25%, and your pipeline shows 10%, there is a specific problem to diagnose.

2

Wholesale Deal Pipeline Template

A wholesale operation typically uses a 7-stage pipeline. Stage 1 — New Lead: raw lead enters the CRM from marketing (direct mail response, SMS reply, cold call connect). Entry criteria: name and phone number minimum. Required action: initial outbound call within 5 minutes (speed-to-lead is critical). Stage 2 — Contacted: two-way conversation has occurred. Entry criteria: the lead has been reached and a conversation happened. Required action: qualify the lead (motivation level, property condition, timeline, price expectations). Stage 3 — Qualified: the lead meets minimum criteria for a potential deal. Entry criteria: motivated seller with a property that fits the buying criteria. Required action: schedule a property appointment or phone offer presentation. Stage 4 — Appointment Set: an appointment is scheduled. Required action: prepare offer (pull comps, estimate rehab, calculate MAO). Stage 5 — Offer Made: a written offer has been presented. Required action: follow up within 24 hours if no response, negotiate if counteroffered. Stage 6 — Under Contract: purchase agreement is fully executed. Required action: begin disposition marketing and title coordination. Stage 7 — Closed: the deal has closed and the assignment fee has been collected.

3

Pipeline Visualization and Health Metrics

Pipeline visualization transforms deal data into actionable insights. Kanban Board View: deals displayed as cards in columns (one column per stage). Ideal for daily pipeline reviews—the team can see at a glance which deals need attention and where the pipeline is thin or congested. Pipeline Value Chart: a bar chart showing the total estimated value at each stage. This reveals revenue concentration risk—if 80% of pipeline value is in one stage, the business is vulnerable to a single deal falling through. Conversion Funnel: a funnel visualization showing the number of deals at each stage and the conversion rate between stages. This identifies bottlenecks—if 100 leads enter Stage 1 but only 5 reach Stage 3, the qualification process or lead quality needs improvement. Pipeline Velocity: the average time a deal spends in each stage. Slow stages indicate process problems—a deal that sits in "Offer Made" for 30 days suggests weak follow-up or unrealistic offers. Target pipeline velocity for wholesale: 45-60 days from New Lead to Closed. Pipeline Aging: deals that have not advanced in more than 2x the stage average should be flagged for review and either advanced, regressed, or marked as dead.

Key Takeaways

  • Pipeline stages should mirror the real process with clear entry/exit criteria and defined next actions.
  • A wholesale pipeline typically has 7 stages from New Lead to Closed with 45-60 day target velocity.
  • Pipeline health metrics include stage conversion rates, value concentration, velocity, and aging.
  • Deals stalled at 2x the stage average should be reviewed and either advanced, regressed, or closed.

Common Mistakes to Avoid

Implementing CRM and data management concepts without measuring baseline performance first.

Consequence: Without baselines, it is impossible to quantify improvement or demonstrate ROI.

Correction: Establish baseline metrics before implementing changes and track the same metrics afterward to quantify improvement.

Not documenting the rationale behind process decisions for future reference.

Consequence: Future team members repeat the same discovery process, wasting time rediscovering lessons already learned.

Correction: Document not just what the process is, but why each step exists and what alternatives were considered.

Test Your Knowledge

1.What are the three categories in value stream mapping?

2.What is the recommended documentation format for SOPs?

3.How should SOP effectiveness be measured?