Run the free scan

RoutedAll guides

Source-based routing misses what it cannot match.

Free check of your Salesforce or HubSpot routing. It runs in your browser.

Routing by source sends web leads to one team and events to another. It works only when the lead holds the value the entry expects.

Where it goes wrong

Equals takes a comma-separated list. One entry can cover several spellings.

Count it yourself

SELECT LeadSource, COUNT(Id) n FROM Lead WHERE CreatedDate = LAST_N_DAYS:90 GROUP BY LeadSource ORDER BY COUNT(Id) DESC

Put the result next to your entries. Every value needs an entry, or a place in a list. Then count leads where the source is blank.

SELECT COUNT(Id) FROM Lead WHERE IsConverted = false AND CreatedDate = LAST_N_DAYS:30 AND LeadSource = null

The free scan checks your export for:

No export access? Paste your rule entries instead.

A worked example

A made-up result: Web 400, Website 60, Webinar 35, Partner 20. A blank source has 45.

The rule has three entries: Web, Webinar and Partner. So 60 leads from Website and 45 from a blank source match nothing. They reach the default owner.

Change the first entry to a list, Web and Website. Write a last entry for the blank source and name who gets it.

Steps

  1. Run the grouped count.
  2. Write each value beside the entry that takes it.
  3. Any value with no entry is a gap. Add it to a list or add an entry.
  4. Add a last entry for the blank source.
  5. Run the count again a month later. New values show up as new gaps.

See also: Route leads by score in Salesforce.

Questions

Why does my lead source rule miss some leads?

Web and Website are two values. Test whether case matters in your org. A blank source needs its own entry.

Can one entry cover several lead source values?

Yes. Equals takes a comma-separated list, so one entry can cover several spellings.

The routing health checklist17 checks, from the rules to the handoff.
Open it

Have it checked every night instead.

Routing Forensics connects as a read-only user and checks this, and the rest of your routing, against your real leads. Three design partners get a free health report on their own CRM, free for 90 days: what is leaking, where, and what it is worth. Apply for a place.

Or check it now. The free scan reads your Salesforce export in your browser. Nothing is uploaded.

Apply for a free place without leaving this page. We ask for a read-only user, a named owner and a short regular call.

We use this only to reply. Privacy notice.

More guides