I’m Brooklyn Grotte. I’ve watched hundreds of coaches drown in leads they can’t convert. They’re running lead generation ads that actually convert. Their email list is growing. Discovery calls are booked. Then nothing closes.
The problem isn’t lead quality. It’s treating every lead like they deserve equal attention. You burn hours on tire-kickers. Dream clients slip through the cracks.
Lead scoring fixes this. It’s a simple system that ranks every lead by purchase likelihood. You know exactly who to follow up with first. You don’t need a $10,000 CRM. You don’t need a sales team. You need a spreadsheet, 15 minutes of setup, and a framework that fits small businesses.
Key Takeaway: Lead scoring ranks prospects by purchase likelihood using behavior and fit signals. You prioritize follow-up without expensive software. Gleanster research found companies using lead scoring see a 77% increase in lead generation ROI compared to those that don’t. A simple spreadsheet system tracking engagement (email opens, link clicks, ad interactions) and demographic fit (budget, timeline, pain point match) converts 15-30% of scored leads into paying clients when you focus on the top 20% first.
TL;DR
- Lead scoring ranks leads by likelihood to buy — you assign points for behaviors (opened 3+ emails, clicked pricing page) and fit signals (has budget, matches ICA) so you know who to call first
- You don’t need a CRM to start — a Google Sheet with 5 columns (Name, Engagement Score, Fit Score, Total Score, Next Action) outperforms guesswork and costs $0
- Companies using lead scoring see 77% higher ROI — Gleanster research shows this happens because reps spend time on ready-to-buy leads instead of cold prospects who downloaded one freebie
- The top 20% of scored leads convert at 15-30% — when you focus follow-up on high scorers (60+ points), close rates double compared to treating every lead equally
What Is Lead Scoring and Why It Matters for Small Businesses
Lead scoring is a points-based system. It ranks every person in your pipeline by purchase readiness. You assign numerical values to two signal types: engagement and fit.
Engagement measures behavior. Did they open your emails? Click your ad? Watch your webinar?
Fit measures qualification. Do they have budget? Are they your ideal client? Do they need what you sell right now?
Add up the points. You get a score that tells you whether this lead deserves a sales call today or another nurture email next week.
Here’s why this matters for solo business owners. You don’t have time to chase every lead. InsideSales.com research found 35-50% of sales go to the vendor who responds first. But only if that vendor responds to a qualified lead. Calling a cold download who isn’t ready wastes the speed advantage. Lead scoring tells you which leads are worth that fast follow-up.
I’ve seen this with my own students. Rebecca started $10/day test ads and made 3 sales in her first 5 days, a 3.5X ROI. She didn’t have more leads than anyone else. She knew which ones to prioritize. Stephanie turned a $0.31 lead into a $1,500 client within one week for a 15X ROI. She focused on leads who’d engaged with three or more pieces of content before booking a call.
Most small business owners make one mistake. They treat lead scoring like it’s only for enterprise sales teams with Salesforce. That’s garbage. You can build a working lead scoring system in a Google Sheet in under an hour. It’ll outperform “reply to everyone in the order they came in” every single time.
Prerequisites: What You Need Before You Start Lead Scoring
Before you build your lead scoring system, make sure you have these three things:
- A lead capture mechanism — You need a way to collect leads. A lead magnet that pulls in qualified prospects, a webinar, a discovery call form, Meta ads. If you’re not generating leads yet, start there first.
- A basic tracking system — At minimum, you need to know what actions people take after they opt in. Are they opening your emails? Clicking links? Watching your content? If you’re using ConvertKit, ActiveCampaign, or Mailchimp, you already have this data. You just need to pull it.
- A clear ideal client profile — Lead scoring only works if you know what “qualified” looks like. Write down 3-5 traits your best clients share. Budget range, business stage, specific pain point, timeline to buy. If you don’t have this yet, review your last 5-10 paying clients and look for patterns.
You do NOT need:
– An expensive CRM (a spreadsheet works fine)
– A sales team (this works for solopreneurs)
– Hundreds of leads (you can score 10 leads as effectively as 1,000)
If you have those three prerequisites, you’re ready to build your system.
Ready to Take the Next Step?
Join the waitlist for ‘Out Of Office’ (the high-touch group program)
Step-by-Step: How to Build a Lead Scoring System in Google Sheets
Step 1: Set Up Your Spreadsheet Structure
Open a new Google Sheet. Create these five columns:
- Name / Email — who the lead is
- Engagement Score (0-50 points) — what they’ve done
- Fit Score (0-50 points) — how well they match your ICA
- Total Score (0-100 points) — sum of engagement + fit
- Next Action — what you’re doing with this lead (call, nurture, archive)
That’s it. Five columns. No fancy formulas yet. We’ll add those in Step 3.
Step 2: Define Your Engagement Scoring Rules
Engagement score measures behavior. What has this person actually done since they opted in? You’re assigning points for actions that signal interest. Here’s a starter framework. Adjust the point values based on what matters in your business:
- Opened 1-2 emails: 5 points
- Opened 3+ emails: 10 points
- Clicked a link in an email: 10 points
- Visited your sales page: 15 points
- Watched 50%+ of a video (webinar, VSL, training): 15 points
- Replied to an email or DM: 20 points
- Booked a discovery call: 25 points
- Attended a live training or webinar: 20 points
Notice the pattern. Passive actions (opens) score lower than active ones (clicks, replies, bookings). The more effort someone puts in, the more points they earn. Cap engagement score at 50 points so it doesn’t drown out fit score.
If you’re running Meta ads and using Facebook ad copy that attracts your ideal client, you can also track ad engagement. “Clicked ad 2+ times” = 10 points. “Watched video ad to 75%” = 10 points.
Step 3: Define Your Fit Scoring Rules
Fit score measures qualification. Does this person actually match the profile of someone who can and will buy from you? This is where you filter out tire-kickers, broke browsers, and people who love your content but will never convert.
Use the ideal client profile you wrote in the Prerequisites step. Assign points for each trait they match:
- Has stated budget or business revenue that fits your pricing: 15 points (if you sell a $2K offer and they’re making $100K/year, they score; if they’re making $12K/year, they don’t)
- Matches your target business stage: 10 points (e.g., if you serve post-launch course creators, someone who hasn’t launched yet scores 0)
- Has the specific pain point you solve: 15 points (if you teach Meta ads and they say “I need to grow my email list,” they score; if they say “I need help with SEO,” they don’t)
- Timeline to buy is within 90 days: 10 points (someone who says “I’m ready now” scores higher than “maybe next year”)
Cap fit score at 50 points. Add engagement + fit to get a total score out of 100.
Step 4: Set Your Score Thresholds and Actions
Now that every lead has a score, you need decision rules. Here’s what I use with my students. I’ve seen this work across hundreds of small businesses:
- 80-100 points (Hot Lead): Call or DM within 24 hours. These people are engaged AND qualified. They’re ready to buy if you show up with an offer.
- 60-79 points (Warm Lead): Send a personalized email with a specific next step. Book a call, watch a case study, reply with questions. Follow up twice over 7 days.
- 40-59 points (Nurture Lead): Keep them in your email sequence. They’re either engaged but not qualified, or qualified but not engaged yet. More content, more touchpoints.
- 0-39 points (Cold Lead): Archive or put in a long-term nurture sequence (monthly check-ins). Don’t waste active sales time here.
MarketingSherpa research found that 79% of marketing leads never convert into sales. But when you score leads and focus on the top 20%, conversion rates jump to 15-30%. That’s the difference between calling everyone and calling the right ones.
Step 5: Update Scores Weekly (or After Key Actions)
Lead scoring isn’t a one-time setup. Scores change as people engage (or don’t). Set a recurring calendar reminder to update your sheet once a week. Pull data from your email platform. Check who clicked what. Add points for new actions.
If someone books a discovery call, their engagement score jumps 25 points instantly. Move them to the “Hot Lead” action bucket. Prioritize that call. If someone hasn’t opened an email in 30 days, their score drops (or stays flat while others rise). They slide into “Nurture” or “Cold.”
The magic happens when you treat this like a living document. A lead who scored 35 last week might score 72 this week after watching your webinar and clicking your sales page. That’s your signal to reach out now.
Step 6: Track What Happens After You Score
Add two more columns to your sheet: Outcome (Closed-Won, Closed-Lost, Still Nurturing) and Revenue (how much they paid if they bought). After 30-60 days, you’ll see patterns:
- Which score range converts best? (For most of my students, it’s 70-85 — high enough to be serious, not so high they’re over-researched and paralyzed)
- Which engagement actions predict sales? (Email replies and sales page visits usually win)
- Which fit signals matter most? (Budget and timeline beat everything else)
Use this data to refine your scoring rules. If “attended webinar” leads close at 40% but “downloaded PDF” leads close at 2%, adjust the points. Give webinar attendance 25 points and PDF downloads 5. Your system gets smarter every month.
Step 7: Automate Scoring (Optional, for When You Scale)
Once your spreadsheet system is working, you can automate it. Use tools like Zapier or your email platform’s built-in scoring. ActiveCampaign and HubSpot have this. ConvertKit and Mailchimp don’t. But here’s the truth: most small businesses don’t need automation until they’re generating 100+ leads per month.
I ran my first six-figure year on a Google Sheet. A $0.27 click became an $8K+ client in under 90 days because I scored that lead at 82 points. I called her the same day she hit my threshold. The tool didn’t matter. The system did.
If you’re using a $5/day ad strategy and generating 50-200 leads per month, a spreadsheet is faster and cheaper than learning a new CRM. When you hit 500+ leads/month or hire a team, then automate.
Common Mistakes to Avoid When Scoring Leads
Mistake 1: Scoring Engagement Without Scoring Fit
I see this constantly. Someone builds a lead scoring system that gives 50 points for “opened 5 emails” but zero points for “has a $5K budget.” Result? Their highest-scored leads are broke superfans who love the content but will never buy.
The fix: Cap engagement at 50 points and fit at 50 points. Force yourself to evaluate both. A lead who scores 10 on engagement and 45 on fit (total: 55) is more valuable than a lead who scores 40 on engagement and 5 on fit (total: 45). The second person is more engaged. But fit predicts revenue. Engagement predicts when they’ll buy, not if.
Mistake 2: Setting Thresholds Too High
If you’re only calling leads who score 90+, you’re leaving money on the table. Most qualified buyers score 60-80. They’re not obsessively consuming every piece of content. They’re busy running their business. They’re ready to buy a solution.
The fix: Start your “Hot Lead” threshold at 60 points, not 80. You can always raise it later if you’re overwhelmed with calls. But in the early days, a 65-point lead who books a call is worth more than waiting for a 95-point lead who might never appear.
Mistake 3: Not Updating Scores After Key Actions
Your lead scored 40 points last week. You put them in “Nurture.” But yesterday they watched your entire sales video and clicked “Book a Call.” You didn’t update the sheet. You’re still sending them nurture emails instead of calling them. You just lost a sale to a competitor who responded faster.
The fix: Update scores immediately after high-value actions. Call bookings, sales page visits, webinar attendance, email replies. Set up a Slack notification or email alert if your platform supports it. Or just check your sheet every morning before you start outreach.
Mistake 4: Ignoring Negative Signals
Lead scoring isn’t just about adding points. It’s also about subtracting them when someone signals disinterest. If a lead hasn’t opened an email in 60 days, their engagement score should drop. If they unsubscribe or mark you as spam, their score goes to zero.
The fix: Add a “decay” rule. Every 30 days of inactivity, subtract 10 points from engagement score. If someone explicitly opts out or says “not interested,” move them to 0 and archive. Don’t waste time on people who’ve checked out.
Mistake 5: Treating Every Lead Source the Same
A lead who came from a $5/day Meta ad campaign targeting your exact ICA is not the same as a lead who downloaded a freebie from a Facebook group post. The ad lead already passed a qualification filter. The group lead might be a random browser.
The fix: Add a “Source Score” modifier. Leads from paid ads start at +10 points. Leads from organic social start at +5. Leads from referrals start at +15 (because someone vouched for them). Leads from cold outreach start at 0. This adjusts for source quality without overcomplicating your system.
According to Salesforce research, leads from referrals convert at 3-5x the rate of other sources. Your scoring should reflect that.
Frequently Asked Questions
What’s the difference between lead scoring and lead grading?
Lead scoring measures behavior (what they’ve done). Lead grading measures fit (who they are). Most small businesses combine both into one “score” because it’s simpler. Enterprise teams separate them because they have different teams handling each. For a solo business owner, one combined score is enough.
How many points should I assign to each action?
Start with the framework in Step 2 and Step 3. Then adjust based on your data after 30 days. If “attended webinar” leads close at 40%, give webinar attendance more points. If “downloaded PDF” leads close at 2%, give PDF downloads fewer points. Your scoring rules should reflect your actual conversion data, not generic best practices.
Can I use lead scoring if I don’t have an email list yet?
Not really. Lead scoring requires tracking behavior over time. If you’re just starting out, focus on building your list first. Use a lead magnet that pulls in qualified prospects and run $5/day ads to grow your audience. Once you have 50-100 leads, start scoring them.
What if I don’t have enough data to know what “qualified” looks like?
Review your last 5-10 paying clients. Write down what they had in common. Budget range, business stage, specific pain point, timeline to buy. If you don’t have 5 paying clients yet, use your best guess based on who you want to work with. Then refine your fit criteria as you get more sales data.
How often should I update my lead scores?
At minimum, once a week. But update immediately after high-value actions like call bookings, sales page visits, or email replies. Set a recurring calendar reminder for your weekly update. Pull data from your email platform. Add points for new actions. Subtract points for inactivity.
Do I need a CRM to do lead scoring?
No. A Google Sheet works fine until you’re generating 100+ leads per month. I ran my first six-figure year on a spreadsheet. The system matters more than the tool. When you scale to 500+ leads/month or hire a team, then invest in a CRM with built-in scoring like ActiveCampaign or HubSpot.
What’s a good conversion rate for scored leads?
If you’re focusing on leads who score 60+, expect 15-30% to convert into paying clients. If you’re calling everyone regardless of score, expect 2-5%. MarketingSherpa found that companies using lead scoring see conversion rates 3-5x higher than those that don’t. The top 20% of scored leads convert at the highest rate.
How do I score leads from different traffic sources?
Add a “Source Score” modifier. Leads from paid ads start at +10 points. Leads from organic social start at +5. Leads from referrals start at +15. Leads from cold outreach start at 0. This adjusts for source quality. Salesforce research shows referral leads convert at 3-5x the rate of other sources.
What if someone has a high engagement score but low fit score?
They’re a superfan who loves your content but won’t buy. Keep them in your email sequence. They might refer paying clients to you. But don’t waste sales time on them. Focus on leads who score high on both engagement and fit. Those are your 80-100 point “Hot Leads.”
Can I use lead scoring for B2C businesses or only B2B?
Lead scoring works for both. The principles are the same. You’re measuring behavior (engagement) and qualification (fit). For B2C, fit might be “has disposable income” and “matches target demographic.” For B2B, fit might be “has budget authority” and “matches target company size.” Adjust your fit criteria to match your business model.
Bottom Line
Lead scoring is the difference between chasing every lead and closing the right ones. You don’t need a $10,000 CRM or a sales team. You need a Google Sheet, 15 minutes of setup, and a framework that ranks leads by purchase likelihood. Companies using lead scoring see 77% higher ROI according to Gleanster research. The top 20% of scored leads convert at 15-30% when you focus follow-up on high scorers.
Start with the five-column spreadsheet. Define your engagement and fit scoring rules. Set your thresholds (60+ points = call, 40-59 = nurture, 0-39 = archive). Update scores weekly or after key actions. Track what happens. Refine your system based on actual conversion data.
Rebecca made 3 sales in her first 5 days with a 3.5X ROI. Stephanie turned a $0.31 lead into a $1,500 client in one week for a 15X ROI. They didn’t have more leads than anyone else. They knew which ones to prioritize. That’s what lead scoring does. It tells you who to call first so you stop wasting time on tire-kickers and start closing dream clients.
Brooklyn Grotte is the founder of Biz with Brooklyn and a Meta Ads strategist who’s taught thousands of students to scale their businesses using simple, low-budget ad strategies. She’s generated $79K+ from a single $5/day campaign and deployed over $1M/month in ad spend for agency clients. Brooklyn lives on a farm with her three kids, feeds goats and chickens, and believes ads should give you your life back — not steal more of your time.
Ready to Take the Next Step?
Join the waitlist for ‘Out Of Office’ (the high-touch group program)
Frequently Asked Questions
What is lead scoring and how does it work for small businesses?
Lead scoring is a points-based system that ranks prospects by their likelihood to buy, combining engagement signals (email opens, link clicks, page visits) and fit signals (budget match, ideal client profile alignment). Small businesses can implement this in a Google Sheet by assigning points for behaviors and qualifications, then prioritizing follow-up with the highest-scoring leads to maximize conversion rates.
Do I need a CRM to implement lead scoring?
No, you don’t need expensive CRM software to start lead scoring. A simple Google Sheet with five columns (Name, Engagement Score, Fit Score, Total Score, Next Action) is sufficient and often outperforms guesswork-based follow-up at zero cost. As long as you can track basic actions like email opens and clicks through your email platform, you have the data you need.
What types of actions should I assign points to in my engagement score?
Assign points based on effort level: passive actions like opening 1-2 emails earn 5-10 points, moderate actions like clicking links or visiting sales pages earn 10-15 points, and active actions like replying to emails or booking calls earn 20-25 points. Cap total engagement score at 50 points so it balances equally with your fit score, and adjust point values based on what matters most in your business.
How do I determine what traits to score in my fit assessment?
Review your last 5-10 paying clients to identify common patterns—these become your fit criteria. Look for shared traits like budget range, business stage, specific pain points, and timeline to purchase. Then assign points for leads that match these characteristics (15 points for budget fit, 10 points for business stage match, etc.), capping fit score at 50 points total to create an even weighting with engagement.
What conversion rate can I expect from lead scoring?
When you focus follow-up on high-scoring leads (60+ points), you can expect 15-30% conversion rates, roughly double the rate of treating all leads equally. Research shows companies using lead scoring see a 77% increase in lead generation ROI compared to those without it, primarily because sales time is spent on ready-to-buy prospects instead of cold leads who aren’t yet qualified.
What’s the difference between engagement score and fit score?
Engagement score measures behavior—what actions the lead has taken since opting in (opens, clicks, replies). Fit score measures qualification—whether they match your ideal client profile in terms of budget, business stage, pain points, and timeline. Together, they identify leads who are both interested AND able to buy, eliminating time wasted on disqualified prospects.
What should I do with leads that score below 30 points?
Low-scoring leads (below 30 points) aren’t yet qualified or sufficiently engaged, so they belong in a nurture sequence rather than a sales call pipeline. Continue sending valuable content to keep them warm and move them up the scoring scale, but don’t spend sales time on them until they demonstrate higher engagement or better fit with your ideal client profile.
How often should I update my lead scores?
Update scores weekly or after each new action a lead takes (email opens, link clicks, call bookings). This keeps your priority list current and ensures you’re following up with the hottest leads first. If you have fewer than 50 leads, manual weekly updates in a spreadsheet work fine; if you grow beyond that, consider automating with Zapier or a basic CRM integration.
