Lead ROI

How each number is computed

Every figure comes from your file and the spend you enter. Nothing is estimated or benchmarked.

Scorecard

  • Leads: rows with that vendor (vendor names are matched ignoring case and spacing).
  • Contact %: leads whose disposition you marked reached, sold or didn't-request, or that are marked sold, ÷ leads.
  • Close %: leads marked sold (sold column says Y, Yes, True, 1, X, Sold, Won, Closed, Issued or Placed, or the disposition is marked sold) ÷ leads.
  • Cost per lead and cost per sale: the spend you entered ÷ leads, ÷ sales.
  • Premium : cost: the premium column summed over sold leads ÷ spend. Use whatever premium your file carries (annual or monthly); it's summed as is.
  • At cost per lead: refund-eligible leads × cost per lead, what those leads cost you on average.

Refund list

  • Duplicate: the same phone number delivered again, by the same vendor or another. The earliest delivery (by delivered date, then file order) is the original; every later one is flagged with who delivered it first. For subscribers, earlier uploads count as earlier deliveries.
  • Invalid phone: not 10 digits after an optional leading 1; an area code that isn't a US geographic area code in service in the NANPA NPA report (file of 11/15/2026, 390 codes), including Canadian, Caribbean and toll-free codes; an exchange starting with 0 or 1 or ending in 11; 555-0100 to 555-0199, which NANPA reserves for fictional use; seven repeated digits; or a disposition you marked bad number.
  • Stale: a disposition you marked didn't-request or old, or, if your file has a lead generated date, delivered more than the number of days you set after it was generated (30 unless you change it).

Month over month

Leads are grouped by the month they were delivered. When two uploads cover the same vendor and month, the newest upload's figures are used. An upload's spend is spread over its months in proportion to each month's leads.