GuidesLead Funnel

Inquiry-to-Application Lead Funnel

Track and merge leads as they progress from initial inquiry to full application. This feature prevents duplicates when the same prospect submits partial information first, then completes a full application later.

Features

  • Lead Merging: Automatically merge inquiry leads with their application counterparts
  • Smart Matching: Match on phone AND email within a configurable time window
  • Attribution Preservation: Original inquiry vendor keeps attribution credit
  • Funnel Analytics: Track conversion rates, time-to-convert, and drop-offs
  • Audit Trail: Complete history of all merge events

How It Works

When a prospect first shows interest (inquiry), they often provide minimal information. Later, they may complete a full application with more details. Without funnel tracking, this creates duplicates.

Day 1: Inquiry Lead                    Day 2: Application Lead
┌──────────────────────┐               ┌──────────────────────┐
│ email: [email protected] │               │ email: [email protected]
│ phone: 555-123-4567  │               │ phone: 555-123-4567  │
│ first_name: Jane     │               │ first_name: Jane     │
│ last_name: (empty)   │               │ last_name: Smith     │
│ program: (empty)     │               │ program: MBA         │
│ start_date: (empty)  │               │ start_date: Fall2025 │
└──────────────────────┘               └──────────────────────┘
           │                                      │
           │           ┌───────────────┐          │
           └──────────▶│  MERGE EVENT  │◀─────────┘
                       │               │
                       │ Phone + Email │
                       │    Match!     │
                       └───────────────┘


                 ┌──────────────────────┐
                 │   Merged Lead        │
                 │ email: [email protected]
                 │ phone: 555-123-4567  │
                 │ first_name: Jane     │
                 │ last_name: Smith     │ ← From application
                 │ program: MBA         │ ← From application
                 │ start_date: Fall2025 │ ← From application
                 │ vendor: InquiryVendor│ ← Attribution preserved
                 └──────────────────────┘

Match Criteria

For a merge to occur, both of these must match:

  • Phone number (normalized, digits only)
  • Email address (case-insensitive)

The match must occur within the configured time window (default: 24 hours).

Merge Behavior

Field TypeMerge Rule
Data fields (name, address, etc.)Application data wins if non-empty
Attribution (vendor, UTM, etc.)Inquiry data preserved
TimestampsInquiry created_at preserved
Custom fieldsApplication data wins if non-empty

Configuration

Step 1: Set Vendor Lead Types

First, configure which vendors collect inquiries vs. applications.

  1. Navigate to Settings > Vendors
  2. Click on a vendor to edit
  3. Set the Lead Type:
Lead TypeDescription
StandardNormal lead processing (default)
InquiryCollects initial interest/partial info
ApplicationCollects full application data
  1. Click Save

Connect your application vendors to their inquiry sources.

  1. Navigate to Settings > Vendors
  2. Edit an Application vendor
  3. Click the Funnel Links tab
  4. Click Add Funnel Link
  5. Select the Inquiry Vendor to match against
  6. Set the Time Window (how far back to look for matches)
  7. Click Save

Time Window Options

WindowUse Case
1 hourFast-moving, same-session conversions
6 hoursShort consideration cycle
12 hoursHalf-day campaigns
24 hoursStandard (recommended default)
48 hoursLonger consideration cycle
7 daysExtended campaigns

Tip: Shorter windows reduce false matches but may miss legitimate conversions. Start with 24 hours and adjust based on your data.

Example Setup

Scenario: You have a “Request Info” form (inquiry) and a “Full Application” form (application).

VendorTypeLinks To
Facebook Lead AdsInquiry-
Google Lead FormsInquiry-
Website Info RequestInquiry-
Full Application FormApplicationFacebook Lead Ads, Google Lead Forms, Website Info Request

Funnel Analytics Dashboard

Once at least one funnel link is configured, the Funnel Analytics section appears in your Analytics menu.

Dashboard Overview

MetricDescription
Total InquiriesAll inquiry leads in the period
Total ApplicationsAll application leads in the period
Matched ApplicationsApplications that merged with inquiries
Conversion RateMatched applications / Total inquiries
Avg Time to ConvertAverage time from inquiry to application

Time-to-Convert Distribution

See how quickly inquiries convert to applications:

BucketDescription
0-1 hourSame-session conversions
1-6 hoursQuick follow-ups
6-12 hoursHalf-day conversions
12-24 hoursNext-day conversions
24+ hoursExtended consideration

Per-Vendor Analysis

Break down metrics by vendor pair:

Inquiry VendorApp VendorInquiriesConversionsRateAvg Time
Facebook AdsApp Form50012525%4.2 hrs
Google AdsApp Form35010530%3.8 hrs
Website FormApp Form2008040%2.1 hrs

Drop-off Analysis

Identify unconverted inquiries to understand funnel leakage:

  • Total unconverted inquiries in the window
  • Breakdown by inquiry vendor
  • Age distribution of unconverted leads

API Endpoints

EndpointMethodDescription
/api/vendor-funnel-linksGETList all funnel links
/api/vendor-funnel-linksPOSTCreate a funnel link
/api/vendor-funnel-links/:idDELETEDelete a funnel link
/api/vendor-funnel-links/has-linksGETCheck if any links exist

Funnel Analytics

EndpointMethodDescription
/api/analytics/funnel/overviewGETSummary metrics
/api/analytics/funnel/time-to-convertGETConversion time breakdown
/api/analytics/funnel/drop-offsGETUnconverted inquiry analysis
/api/analytics/funnel/by-vendorGETPer-vendor pair metrics
/api/analytics/funnel/dailyGETDaily trend data

See the Funnel API Reference for detailed endpoint documentation.


Best Practices

Vendor Organization

  • Name vendors clearly: “Facebook - Request Info” vs “Facebook - Full App”
  • Use consistent naming for inquiry/application pairs
  • Document which forms map to which vendors

Time Window Selection

ScenarioRecommended Window
High-intent, fast funnel1-6 hours
Standard web funnel24 hours
Multi-day campaigns48-72 hours
Re-engagement campaigns7 days

Monitoring

  • Check conversion rates weekly
  • Investigate unusually low rates
  • Review drop-offs for re-engagement opportunities
  • Watch for false matches (very rare with phone+email)

Attribution Best Practices

  • The inquiry vendor always keeps attribution
  • This accurately reflects initial touchpoint
  • ROI calculations credit the first vendor
  • Consider this when evaluating vendor performance

Troubleshooting

Leads Not Merging

  1. Check vendor types: Verify vendors are set to “Inquiry” and “Application”
  2. Check funnel links: Confirm the link exists between vendors
  3. Check time window: Lead may be outside the configured window
  4. Check match fields: Both phone AND email must match
  5. Check normalization: Phone formats should normalize (555-123-4567 = 5551234567)

Too Many False Matches

False matches are rare because both phone AND email must match. If occurring:

  1. Reduce time window to limit match scope
  2. Review the matching leads - are they actually the same person?
  3. Check for shared phone numbers (call centers, households)

Analytics Not Showing

The Funnel Analytics dashboard only appears when:

  1. At least one funnel link is configured
  2. The current user has analytics permissions

Integration with Other Features

Deduplication

Funnel merging is different from deduplication:

FeatureDeduplicationFunnel Merging
PurposeBlock duplicate leadsCombine partial + complete leads
MatchConfigurable (email, phone, etc.)Phone AND email required
ResultReject the duplicateMerge into one lead
VendorAny vendorSpecific inquiry/application pairs

Both can be enabled simultaneously. Deduplication runs first; funnel merging only applies to non-duplicate leads.

Attribution

Funnel merging preserves the original inquiry vendor for attribution:

  • Inquiry vendor gets credit for the conversion
  • ROI calculations use inquiry vendor costs
  • Analytics show inquiry vendor as the source

Webhooks

When a merge occurs:

  • The merged lead is delivered via webhooks
  • The original inquiry lead is NOT re-delivered
  • Webhook payload includes merge metadata