How to Grade Your Lead Vendors Without a Revenue Intelligence Platform

Not every PI firm has a revenue intelligence platform. If you're managing five or more lead vendors with a spreadsheet and a lot of patience, this guide is for you. The manual approach to vendor grading isn't perfect — but it works at small scale, and it builds the habits you'll need when you do move to a connected system.

Here's how to grade your lead vendors systematically, without specialized software, using data you already have access to right now.

Why Vendor Grading Matters in the First Place

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

Vendor grading replaces gut instinct with a structured scorecard. You assign every vendor a grade based on actual performance data, and you use that grade to make budget decisions. Over time, the discipline compounds. Vendors that used to coast on brand recognition or relationship history have to compete on results.

The Data You Need Before You Start

Manual vendor grading requires pulling data from multiple places. Set aside two to three hours the first time you do this — subsequent months will be faster once your spreadsheet is built.

You'll need the following data 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. Less than that and your conversion data will be too noisy — a single good or bad week will skew the whole picture. If your intake-to-sign cycle routinely runs longer than 30 days, extend the window 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 that delivers 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, expressed as a percentage. If 150 leads produced 12 signed cases, your conversion rate is 8%. This is the most important number in your manual grading process — because a vendor with a $150 CPL and a 12% conversion rate is almost always better than a vendor with a $60 CPL and a 4% conversion rate.

Cost Per Signed Case (CPC)

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

Step 2: Build Your Comparison Table

Create a simple spreadsheet with one row per vendor and columns for each of the metrics above. Add two additional columns: a 90-day trend for conversion rate (up, flat, or down based on how this quarter compares to last quarter), and a rejection rate (rejected leads divided by total leads).

A sample table might look like this for a firm with 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. Most firms using gut instinct would keep Vendor C because the invoices look small. The comparison table shows why that's a mistake.

Step 3: Assign a Letter Grade

You need a benchmark to grade against. The easiest approach is to use your firm's blended average as the baseline. Calculate your total spend across all vendors divided by total signed cases from all vendors. That is your firm's average cost per case.

From there, grade each vendor relative to that average:

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

These thresholds are a starting point. Adjust them based on your market, your case mix, and your firm's average case value. A firm that settles high-value cases at $75,000 average can tolerate a higher cost per case than a firm averaging $20,000.

Step 4: Make a Decision for Each Grade

The grade is only useful if it drives action. Build a decision rule for each grade level and follow it consistently.

• A vendors: Increase budget at the next review cycle. Protect this relationship.
• B vendors: Maintain current spend. Monitor for movement in either direction.
• C vendors: Put them on a 60-day watch. Have a conversation about quality and conversion trends. No budget increases.
• D vendors: Cut budget by 25–50% immediately. Give the vendor a defined performance window to improve before you cut further.
• F vendors: Pause or terminate. Don't let sunk cost bias keep you funding a vendor that isn't producing.

Where This Approach Breaks Down

The manual framework described here works reliably up to four or five vendors and a few hundred leads per month. Past that, the cracks start to show.

The most common failure point is attribution. When the same lead comes in through two channels — an organic search and a vendor referral, for example — your spreadsheet has no way to handle that. You end up overcounting or undercounting vendor performance.

The second failure point is timing. Manual spreadsheets are a snapshot. They tell you what happened over the last 90 days. They don't alert you when a vendor's conversion rate drops in week two of the current month — you'll find out at the end of next month, after you've already spent another $30,000 on that vendor. This is where proactive performance monitoring pays for itself immediately.

The third failure point is settlement data. A manual spreadsheet can track signed cases, but connecting those cases to eventual settlements — which may arrive 12 to 18 months later — is practically impossible to maintain manually at scale. You end up grading vendors on who gets you cases, not who gets you revenue.

These aren't reasons to abandon the manual approach if you're just getting started. They're reasons to graduate past it as you grow. The discipline of grading vendors monthly, comparing them on cost per case, and making structured budget decisions is valuable regardless of whether you're doing it in a spreadsheet or a purpose-built vendor grading platform.

A Note on Vendor Conversations

One underrated benefit of building a vendor grading system — even a manual one — is what it does to your vendor conversations. When you can walk into a review meeting with a letter grade, a cost per case figure, and a 90-day trend, the conversation changes. You're no longer reacting to their claims about lead quality. You're presenting your data, and you're asking them to respond to it.

Vendors who perform well will welcome this framing. Vendors who are underperforming 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 grading your vendors. You need a 90-day window 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 firm's average, assign a grade, and make one budget decision based on that grade.

Do it once. See what you find. Then build the habit of doing it every month. By the time you're ready to move to a more connected system, you'll have six months of baseline data — and a much clearer picture of which vendors have actually been earning their budgets.