Lead Management and Conversion Data Model

Core Entity Model

Lead Object

Representation: Potential customers who have shown interest but haven’t been qualified or converted

Implementation:

Key Standard Fields:

Account Object (Post-Conversion)

Representation: Business accounts created from lead conversion

Implementation:

Contact Object (Post-Conversion)

Representation: Individual contacts created from lead conversion

Implementation:

Opportunity Object (Post-Conversion)

Representation: Sales opportunities created from qualified lead conversion

Implementation:

Lead Conversion Model

Conversion Process Overview

Process Flow:

  1. Lead is created and assigned
  2. Lead is qualified (status changes to “Qualified”)
  3. Lead is converted (creates Account, Contact, and optionally Opportunity)
  4. Lead record becomes read-only (IsConverted = true)
  5. Related records (Account, Contact, Opportunity) become active

Field Mapping During Conversion

Lead to Contact Mapping:

Lead to Account Mapping:

Lead to Opportunity Mapping:

Account Matching During Conversion

Matching Logic:

Person Account Considerations:

Conversion Settings and Automation

Standard Conversion Settings:

Automated Conversion Patterns:

Nonprofit/Education Conversion Patterns:

Conversion Error Handling:

Duplicate Rules and Matching Rules

Duplicate Rule Configuration

Purpose: Prevent duplicate leads from being created or identify duplicates during lead creation/update

Implementation:

Lead Duplicate Rule Patterns:

Matching Rule Configuration:

Common Matching Rule Patterns:

Duplicate Rule Actions

Block Action:

Allow Action:

Alert Action:

Duplicate Management Best Practices

Data Quality:

Matching Strategy:

Performance Considerations:

Lead Assignment Rules

Assignment Rule Configuration

Purpose: Automatically assign leads to sales representatives or queues based on criteria

Implementation:

Assignment Criteria Patterns

Geographic Assignment:

Industry-Based Assignment:

Company Size Assignment:

Lead Source Assignment:

Product Interest Assignment:

Composite Criteria:

Round-Robin Assignment

Purpose: Distribute leads evenly across sales representatives

Implementation:

Round-Robin Best Practices:

Assignment Rule Order

Rule Evaluation:

Example Rule Order:

  1. Enterprise Healthcare (Country = “US” AND Industry = “Healthcare” AND AnnualRevenue > 10000000)
  2. Healthcare (Industry = “Healthcare”)
  3. Enterprise (AnnualRevenue > 10000000)
  4. Default (all other leads)

Assignment Rule Triggers

On Create:

On Manual Assignment:

Both:

Lead Status Management

Standard Lead Status Values

Common Status Values:

Status Progression Patterns

Linear Progression:

Branching Progression:

Status-Based Automation:

Status Validation

Status Transition Rules:

Status-Based Field Requirements:

Lead Scoring

Scoring Model Design

Demographic Scoring:

Behavioral Scoring:

Engagement Scoring:

Scoring Implementation

Manual Scoring:

Automated Scoring:

Einstein Lead Scoring:

Score Thresholds

Qualification Thresholds:

Conversion Thresholds:

Record Type Strategy

Lead Record Types

Types: Different lead types by source, product, or qualification stage

Implementation: Use Record Types to support different lead workflows and processes

Account Record Types (Post-Conversion)

Types: Different account types based on business model

Implementation: Use Record Types to distinguish between different account types created from conversion

Contact Record Types (Post-Conversion)

Types: Different contact types based on role or relationship

Implementation: Use Record Types to distinguish between different contact types created from conversion

Opportunity Record Types (Post-Conversion)

Types: Different opportunity types by product or sales process

Implementation: Use Record Types to support different opportunity workflows and processes

Field Design Patterns

Source System Fields

Pattern: Lead Source field - should be picklist with controlled values

Implementation: Use standard LeadSource picklist or create custom picklist. Standardize source values (Web, Phone, Email, Trade Show, Partner, etc.). Add custom sources as needed (Webinar, Social Media, Referral, etc.). Use for reporting and assignment rules.

Campaign Tracking Fields

Pattern: Campaign fields for marketing attribution

Implementation: Use standard Campaign field (lookup to Campaign object). Track first touch and last touch campaigns. Link leads to Campaigns for ROI measurement. Support multi-touch attribution.

Qualification Fields

Pattern: Qualification fields to track BANT or similar criteria

Implementation: Budget field (picklist or currency). Authority field (picklist: Decision Maker, Influencer, User). Need field (picklist or text area). Timeline field (date or picklist). Use for qualification scoring and automation.

Custom Status Fields

Pattern: Custom status fields for detailed tracking

Implementation: MQL (Marketing Qualified Lead) checkbox. SQL (Sales Qualified Lead) checkbox. Qualification Score (number). Last Contact Date (date). Next Follow-up Date (date).

Data Quality Patterns

Field Description Quality

Standards:

Help Text

Pattern: Add help text for user-facing fields

Implementation: Provide guidance to users on field purpose and expected values. Include examples for complex fields. Document business rules and validation criteria. Help users understand data quality requirements.

Data Standardization

Pattern: Standardize data formats for consistency

Implementation: Phone numbers: Strip formatting, standardize format. Email addresses: Lowercase, trim whitespace. Company names: Title case, remove extra spaces. Use Flow or Apex to standardize on create/update.

Data Enrichment

Pattern: Enrich lead data with external sources

Implementation: Integrate with data enrichment services (ZoomInfo, Clearbit, etc.). Auto-populate missing fields (industry, company size, revenue). Validate and update existing data. Use callouts in Flow or Apex for real-time enrichment.

Picklist Conversions

Pattern: Convert Text fields with limited values to Picklists

Implementation: Improve data quality by using picklists for fields with limited valid values. Use for LeadSource, Industry, Rating, and other fields with controlled vocabularies.

Integration Patterns

Web-to-Lead Integration

Pattern: Capture leads from website forms

Implementation:

Marketing Automation Integration

Pattern: Sync leads with marketing automation platforms

Implementation:

API-Based Lead Creation

Pattern: Create leads via REST/SOAP API

Implementation:

Best Practices

Lead Object Design

Conversion Process Design

Duplicate Management

Assignment Rules

Data Quality

Tradeoffs

Advantages

Challenges

When to Use This Model

Use this lead management model when:

When Not to Use This Model

Avoid this model when:

Q&A

Q: What is the Lead object and when should I use it?

A: The Lead object represents potential customers who have shown interest but haven’t been qualified or converted. Use Leads when: (1) Tracking unqualified prospects (before qualification), (2) Marketing attribution (tracking lead sources, campaigns), (3) Lead qualification process (qualifying leads before conversion), (4) Multiple lead sources (web, phone, email, events), (5) Integration with marketing automation (marketing platforms create leads).

Q: How does lead conversion work in Salesforce?

A: Lead conversion creates: (1) Contact (from Lead name/email), (2) Account (from Lead Company, or matched to existing), (3) Opportunity (optional, for qualified leads), (4) Links converted records (ConvertedAccountId, ConvertedContactId, ConvertedOpportunityId). Conversion can be manual or automated. Once converted, Lead.IsConverted = true and Lead cannot be edited.

Q: How do I prevent duplicate leads?

A: Prevent duplicates by: (1) Configuring duplicate rules for Lead object (matching on Email, Name, Company), (2) Using matching rules to define match criteria, (3) Setting blocking vs. alerting rules (block duplicates or alert users), (4) Using external IDs for integration-based leads, (5) Implementing data quality checks at entry. Duplicate rules are essential for lead data quality.

Q: What is lead scoring and how do I implement it?

A: Lead scoring assigns scores to leads based on criteria (demographics, behavior, engagement). Implement by: (1) Creating score fields (Lead Score, Behavioral Score), (2) Using automation (Flow, Process Builder) to calculate scores, (3) Defining scoring criteria (what increases/decreases score), (4) Updating scores based on lead activity, (5) Using scores for routing (route high-scoring leads to sales). Lead scoring helps prioritize leads for sales teams.

Q: How do I route leads to the right sales rep?

A: Route leads by: (1) Assignment rules (automated routing based on criteria), (2) Lead source routing (route by LeadSource), (3) Territory routing (route by geography, industry), (4) Round-robin routing (distribute leads evenly), (5) Manual assignment (users assign leads). Assignment rules can be based on Lead fields (Source, Industry, State, etc.).

Q: What is the difference between Lead Status and Lead Rating?

A: Lead Status tracks lead progression (Open - Not Contacted, Working - Contacted, Qualified, Nurturing, Unqualified). Lead Rating indicates lead quality (Hot, Warm, Cold). Status tracks process stage, Rating tracks quality. Both are picklist fields on Lead object. Use Status for workflow, Rating for prioritization.

Q: How do I track marketing attribution for leads?

A: Track attribution by: (1) LeadSource field (source of lead - Web, Phone, Email, Trade Show), (2) Campaign association (link Leads to Campaigns via CampaignMember), (3) External system IDs (correlate with marketing automation platforms), (4) First Touch/Last Touch (track first and last touchpoints), (5) Multi-touch attribution (track all touchpoints). Marketing attribution helps measure marketing effectiveness.

Q: What happens to converted leads?

A: After conversion: (1) Lead.IsConverted = true (Lead marked as converted), (2) Lead becomes read-only (cannot edit converted leads), (3) Converted records created (Contact, Account, Opportunity), (4) Links maintained (ConvertedAccountId, ConvertedContactId, ConvertedOpportunityId), (5) Lead data preserved (for historical tracking). Converted leads remain in system for reporting and historical tracking.

Q: How do I handle lead assignment to queues vs. users?

A: Assign leads to: (1) Users - individual sales reps (direct assignment), (2) Queues - team assignment (round-robin, manual assignment from queue). Use queues for: team-based routing, workload distribution, shared lead pools. Use user assignment for: direct ownership, individual accountability. Assignment rules can route to users or queues.

Q: What are best practices for lead management?

A: Best practices include: (1) Prevent duplicates (duplicate rules, matching rules), (2) Implement lead scoring (prioritize high-quality leads), (3) Automate routing (assignment rules for efficiency), (4) Track marketing attribution (LeadSource, Campaigns), (5) Maintain data quality (validation rules, data quality checks), (6) Convert qualified leads (convert when ready), (7) Monitor lead metrics (conversion rates, source performance).

Edge Cases and Limitations

Edge Case 1: Lead Conversion with Existing Accounts/Contacts

Scenario: Converting a lead when Account or Contact already exists, causing duplicate creation or conversion conflicts.

Consideration:

Edge Case 2: High-Volume Lead Import

Scenario: Importing thousands of leads from external systems, causing duplicate creation or assignment rule performance issues.

Consideration:

Edge Case 3: Lead Assignment Rule Conflicts

Scenario: Multiple assignment rules matching the same lead, causing assignment conflicts or unexpected routing.

Consideration:

Edge Case 4: Lead Scoring with Incomplete Data

Scenario: Lead scoring formulas failing or producing incorrect scores when required fields are missing.

Consideration:

Edge Case 5: Lead Conversion with Complex Opportunity Creation

Scenario: Converting leads with complex Opportunity creation requirements (multiple products, custom fields, relationships).

Consideration:

Limitations