How to Grade Your Lead Vendors Without a Revenue Intelligence Platform

You're staring at four vendor invoices. One looks cheap at $65 per lead. Another looks expensive at $200. You have a gut feeling about which ones to cut — but you don't have the numbers to back it up. That's the trap most PI marketing directors are stuck in right now.

You don't need a revenue intelligence platform to get out of it. You need a structured grading process and data you already have. This guide walks you through the manual approach — reliable up to five vendors, and worth doing even if you plan to graduate to a connected system later. The discipline you build now will make that transition dramatically faster.

Why Vendor Grading Matters in the First Place

Most PI firms evaluate vendors the same way: look at the invoice, check the cost per lead, and decide whether it “feels” worth it. That approach has one fundamental flaw. Cost per lead tells you what you paid for a name and a phone number. It tells you nothing about whether that lead became a signed case — or whether that case will ever produce revenue.

Vendor grading replaces gut instinct with a structured scorecard. You assign every vendor a grade based on actual performance data and use that grade to drive budget decisions. Over time, the discipline compounds. Vendors that used to coast on brand recognition or relationship history have to compete on results — your results, not their self-reported metrics.

The Data You Need Before You Start

Manual vendor grading requires pulling data from multiple places. Block two to three hours the first time — once your spreadsheet is built, subsequent months take under an hour. You'll need the following for each vendor, covering a rolling 90-day window:

• Total leads received
• Total marketing spend (invoices, not platform-reported spend)
• Total leads that reached intake (logged in your CRM or case management system)
• Total signed cases attributed to that vendor
• Total rejected or declined leads
• Any open cases still in progress, tagged by source

90 days is the minimum window. Anything shorter and one good or bad week skews everything. If your intake-to-sign cycle routinely runs longer than 30 days, extend to 120 days.

Step 1: Calculate Your Core Metrics for Each Vendor

Start with three numbers. These are your grade anchors — everything else adds nuance, but these three determine whether a vendor is fundamentally worth keeping.

Cost Per Lead (CPL)

Divide total spend by total leads received. A firm spending $15,000 per month with a vendor delivering 150 leads has a CPL of $100. Record this, but don't make decisions on it yet. CPL is context, not conclusion.

Lead-to-Case Conversion Rate

Divide signed cases by total leads received. If 150 leads produced 12 signed cases, your conversion rate is 8%. This is the most important number in your grading process. A vendor at $150 CPL with a 12% conversion rate beats a vendor at $60 CPL with a 4% conversion rate — every time.

Cost Per Signed Case (CPC)

Divide total spend by signed cases. That same $15,000 producing 12 cases gives you a cost per case of $1,250. This is the number you compare across vendors. It collapses CPL and conversion rate into one defensible figure you can take into any budget conversation.

Step 2: Build Your Comparison Table

Build a spreadsheet with one row per vendor and columns for each metric above. Add two more: a 90-day trend for conversion rate (up, flat, or down vs. last quarter) and a rejection rate (rejected leads divided by total leads received).

Here's what that looks like for a firm running four active vendors:

• Vendor A: CPL $85, conversion 9%, CPC $944, trend up, rejection 11%
• Vendor B: CPL $110, conversion 14%, CPC $786, trend flat, rejection 7%
• Vendor C: CPL $65, conversion 4%, CPC $1,625, trend down, rejection 22%
• Vendor D: CPL $200, conversion 18%, CPC $1,111, trend up, rejection 5%

Vendor C has the lowest CPL on the table and the highest cost per case. Firms running on gut instinct keep Vendor C because the invoices look manageable. This table shows exactly why that's a $1,625-per-case mistake.

Step 3: Assign a Letter Grade

Grade each vendor against your firm's blended average. Calculate total spend across all vendors divided by total signed cases. That number is your benchmark.

Grade each vendor relative to that average:

• A: Cost per case more than 20% below average, conversion rate trending up
• B: Cost per case within 20% of average, conversion rate flat or improving
• C: Cost per case 20–40% above average, or conversion rate trending down
• D: Cost per case more than 40% above average, or rejection rate above 25%
• F: No signed cases in the past 90 days at meaningful spend

Treat these thresholds as a starting point. Adjust based on your market, case mix, and average settlement value. A firm settling at $80,000 average can tolerate a higher cost per case than one averaging $22,000.

Step 4: Make a Decision for Each Grade

A grade is only useful if it drives action. Commit to a decision rule for each level before you run the analysis — not after, when confirmation bias kicks in.

• A vendors: Increase budget at the next review cycle. Protect this relationship.
• B vendors: Maintain current spend. Watch for movement in either direction.
• C vendors: 60-day watch. Have a direct conversation about quality and conversion trends. No budget increases.
• D vendors: Cut budget 25–50% immediately. Give the vendor a defined window to improve before cutting further.
• F vendors: Pause or terminate. Sunk cost is not a reason to keep funding a vendor that isn't producing signed cases.

Where This Approach Breaks Down

This framework works reliably up to four or five vendors and a few hundred leads per month. Past that, three cracks appear — and they compound fast.

Attribution.When the same lead arrives through two channels — say, an organic search and a vendor referral — your spreadsheet can't handle it. You end up overcounting one vendor or undercounting another, and the grades become unreliable.

Timing. A spreadsheet is a snapshot. It tells you what happened over the past 90 days. It won't alert you when a vendor's conversion rate drops in week two of the current month. You'll find out at month-end, after spending another $35,000 on that vendor. This is exactly where proactive performance monitoring pays for itself immediately.

Settlement data.A manual spreadsheet can track signed cases. It can't connect those cases to settlements that arrive 12 to 18 months later. You end up grading vendors on who gets you cases — not who gets you revenue.

These aren't reasons to abandon the manual approach early on. They're reasons to graduate past it as you scale. The habit of grading vendors monthly, comparing on cost per case, and making structured budget decisions is valuable in a spreadsheet or a purpose-built vendor grading platform.

A Note on Vendor Conversations

One underrated benefit of this process — even the manual version — is what it does to vendor conversations. Walk into a review meeting with a letter grade, a cost per case figure, and a 90-day trend line and the dynamic shifts. You're no longer reacting to their claims about lead quality. You're presenting your data and asking them to respond to it.

Vendors who perform well will welcome that framing. Vendors who don't will either rise to the challenge — or confirm that the D grade was right.

Getting Started This Week

You don't need a new system to start. You need 90 days of intake and signed case data by source, two hours, and a spreadsheet. Pull the numbers. Calculate cost per case for each vendor. Compare to your blended average. Assign a grade. Make one budget decision based on that grade.

Do it once and see what you find. Then build the habit of doing it every month. By the time you're ready for a connected system, you'll have six months of baseline data — and a clear view of which vendors have actually been earning their budgets.