How to Find Your Top 100 Customers in Your CRM
20% of customers drive 50-70% of revenue in most home service shops. Here's how to find your top 100 customers in your Jobber, HCP, or ServiceTitan CRM and run the playbook around them.
Key takeaways
- 20% of customers drive 50-70% of revenue in a typical home service shop, with the top 100 often delivering an outsized share
- Repeat customers close at 60-70% versus 5% for cold prospects per Pete & Gabi reactivation research
- Retaining a top customer is 5-25x cheaper than acquiring a new one per widely cited Bain & Company customer retention research
A landscaper with 1,800 customers in his Jobber CRM ran the math one night. 63% of his last three years of revenue came from 142 households. Most of those 142 lived in three zip codes. He had been spending Google Ads dollars on the other 1,658.
That is the Pareto distribution every $1M-$10M home service shop has. The top 100-200 customers drive 50-70% of revenue. Most owners cannot name 30 of them by memory.
This is how you find your top 100 customers in your CRM, what to do with the list, and why running the playbook around it is one of the highest-ROI weeks you will spend this year.
Why the Top 100 Matters
Bain & Company's customer retention research is the standard reference: a 5% increase in customer retention can lift profits 25-95%. The math is dramatic because acquisition is expensive and repeat work has near-zero CAC.
Pete & Gabi's 2026 reactivation research shows existing customers close at 60-70% versus 5% for cold prospects. That 12-14x gap means every dollar spent talking to your top 100 is worth 12-14x more than a Google Ads dollar chasing a stranger.
The roofer in the customer LTV math post found that real customer lifetime value was $12K, not the $8K per job he had been pricing. The top tier of his customer list was worth far more than he assumed because he had only counted the first job.
The landscaper in the three-zip-code analysis found that 62% of repeat revenue lived in three postal codes. That single fact reshaped where he advertised, where he routed crews, and which customers got proactive outreach.
These owners stopped buying more leads and started running playbooks around the customers they already had. The first move was finding the top 100.
Text Clint: "rank customers by total revenue last 36 months"
What "Top" Should Mean
Most contractors default to total revenue. That is a fine starting point and a bad finishing point.
The five dimensions that actually matter:
Lifetime revenue. Total dollars across every job and invoice. The simplest cut.
Recency. Last job within the last 18 months. A customer who spent $40K in 2019 and disappeared is a different segment than one who spent $40K and returned six months ago.
Frequency. Number of distinct jobs or service visits. A homeowner with 8 jobs over 5 years has different LTV than one big install and silence.
Margin. Gross profit, not gross revenue. A $30K install at 12% margin is worth less than a $20K maintenance customer at 35% margin compounded.
Referral influence. Customers who have referred others. Often invisible in the CRM unless you tag it explicitly. Worth more per dollar of revenue than a non-referrer.
A real top-100 list weights all five. The simple version takes lifetime revenue and filters to recent activity. The full version adds margin, frequency, and referral flag.
Text Clint: "list customers with 3+ completed jobs in last 36 months ranked by total revenue"
Find Them With These Queries
The query shape works in Jobber, Housecall Pro, ServiceTitan, Workiz, and GoHighLevel. Field names vary. The logic does not.
Query 1: Lifetime revenue ranked. Sum invoice totals by customer across all time. Sort descending. Cap at top 200 for a working list.
Text Clint: "show top 200 customers by lifetime revenue"
Query 2: Last 36 months revenue. Same sum, but filter invoices to the last 36 months. Removes long-dormant customers from the top of the list.
Text Clint: "rank customers by total revenue last 36 months"
Query 3: Top 100 by job count. Count distinct jobs or service visits per customer. Sort descending. Surfaces the maintenance-loyal customers who might not show up at the top of revenue rankings.
Text Clint: "find customers with most service visits in last 24 months"
Query 4: Top 100 by margin. Sum (invoice_total - job_cost) per customer. Sort descending. Requires job-cost data, which not every CRM has clean. Worth the effort for shops over $3M revenue. The roofer in the housecall pro reports miss profit post ran this and found his real top tier was different from his revenue top tier.
Text Clint: "rank customers by gross profit last 36 months"
Query 5: Top 100 with referral flag. Pull customers tagged as referrers, or trace inbound leads back to the referring customer. Cross-reference with revenue. Surfaces the high-influence customers whose loyalty is structurally important.
Query 6: Top 100 by zip code. Group customers by postal code. Identify the top 5-10 zip codes by total revenue. Then pull the top 20 customers within each. The landscaping playbook from the three-zip-code post starts here.
Text Clint: "show top zip codes by total customer revenue with customer counts"
These cross-cuts are the kind of analysis most CRM dashboards cannot do natively without a CSV export and a pivot table. The full home service KPI playbook treats customer concentration as a Tier 1 metric for a reason.
What to Do With the List
A top-100 list with no playbook attached is just a CSV. The point is the actions you run against it.
Action 1: Personal outreach from the owner. A handwritten card or a phone call from the owner to every top-100 customer once a year. Costs an afternoon. Generates referrals, reviews, and a moat against price-shopping competitors. Tommy Mello has talked about this discipline on every Owned and Operated podcast appearance.
Action 2: Proactive maintenance reminders. Top-100 customers get the white-glove version of your seasonal reminders. Not a generic blast. A specific message that references their last job, system, and address.
Action 3: First call on emergency capacity. When demand spikes, top customers get a slot before the queue. Communicating this builds loyalty far more than a generic discount.
Action 4: Membership upsell. If you have a maintenance plan, the top 100 are the highest-conversion target. Most are already buying frequent service. Formalizing it locks revenue in advance. The full motion is in squeeze 2x lifetime value out of customers in your CRM.
Action 5: Review and referral asks. Top-100 customers are the highest-conversion source of reviews and referrals. A targeted ask after a successful job converts at 30-50%, versus 5-10% on a generic blast.
Action 6: Geographic expansion intelligence. The top 100 by zip code tells you where to advertise next. Buying Google Ads in zip codes where you already have 8 top customers is far more efficient than buying in cold zip codes.
A landscaper or pest control operator can layer all six actions on top of normal operations. The cost is one person's attention. The return is double-digit revenue lift in 12 months, exactly the triple revenue per lead without more ads discipline applied at the top tier.
The Tommy Mello Framework
Tommy Mello built A1 Garage Door to $220M+ on database discipline. His framing in The Home Service Millionaire and across Owned and Operated podcast appearances with John Wilson and Jack Carr:
The average garage door shop has 18-24 months of pipeline already in the CRM. The difference between $1M and $5M is whether the owner has a system to work it. The top 100 is the lowest-effort, highest-yield slice of that pipeline.
Peterman Brothers, the Indiana plumbing and HVAC operator, hit $100M+ on the same discipline. Customer-list segmentation, proactive outreach to the top tier, and a defined cadence around dormant customers.
Nexstar Network member shops, which include some of the largest privately-held HVAC and plumbing businesses in the US, run quarterly top-customer reviews as standard practice. The owners know their top 100 by name. The CSRs treat top customers differently in the call queue.
The framing is consistent across the Mello, Wilson, Carr, and Peterman versions: the customers you already have are worth more than the customers you are buying. The first job is to know who they are.
The Pareto Math by Trade
The 80-20 distribution holds across trades, with shape variations that matter for outreach.
Roofing. Top 100 customers often drive 70-85% of revenue because the work is high-ticket and infrequent. The top tier is who refers neighbors after a hailstorm. Roofer LTV is typically $12K-$20K when you count repeat work and referrals.
HVAC. Top 100 customers drive 50-65% of revenue. More even distribution because of maintenance plan customers and recurring tune-ups. The top tier is heavy in maintenance plan members.
Plumbing. Top 100 customers drive 45-60% of revenue. Smallest concentration of the major trades because most plumbing work is reactive and one-off, but the top is heavy in property managers and commercial accounts.
Landscaping. Top 100 customers drive 60-75% of revenue. Heavily geographic, as the three-zip-code analysis shows. Maintenance contracts compound recurring revenue.
Garage door. Top 100 customers drive 50-65% of revenue, lower than other trades because most work is one-off, but the top tier is heavy in HOA contracts and property managers.
Pest control. Top 100 customers drive 70-80% of revenue because the model is recurring quarterly service. Top tier is your most loyal annual contracts.
Knowing the shape of your distribution before running the playbook lets you set realistic targets and prioritize the right segments.
Why AI Changes the Practice
A disciplined office manager can pull these queries, sort the list, and run the playbook. The reason most shops do not is that the analysis takes a day, the playbook takes a week, and it never beats inbound calls for priority.
AI removes the labor bottleneck. An agent connected to your CRM can run the queries every Monday, surface changes (new top-100 entrants, top-100 customers who have not booked in 90 days, top-100 customers in markets where you are about to spend ad money), and trigger the relevant playbook automatically.
The patterns from AI customer reactivation and AI lead qualification agents apply to top-100 management directly. The agent tracks the list, runs the maintenance reminder cadence, books the seasonal tune-ups, surfaces the customers who need a personal call from the owner, and pushes the review-and-referral asks at the right moments.
Clint runs this from your texting line, against your real CRM data, on a daily cadence. The owner gets a Monday morning text: "Five top-100 customers haven't booked in 90 days. Three are in your top 20. Want me to send them the seasonal reminder?"
That is the difference between knowing your top customers exist and actually doing something about them every week.
A First-Week Plan
Day 1. Run the six queries above. Save as one spreadsheet with tabs.
Day 2. Cross-reference. Find the customers who appear in multiple queries (top 100 by revenue AND top 100 by job count AND in a top zip code). The intersection is your real top tier.
Day 3. Tag the top 100 in your CRM with a single label like "VIP" or "Top100." Future segmentation depends on this tag existing.
Day 4. Pull the customers in the top 100 who have not booked in the last 12 months. Personal outreach from the owner this week.
Day 5. Pull the customers in the top 100 who do not have a maintenance plan. Membership upsell campaign next week.
Days 6-7. Plan the seasonal reminder cadence for the rest of the top 100. Different message than the regular customer reminder. Reference last job, system, address.
That gives you the list, the tag, two campaigns, and a working cadence. Most owners discover at least one $20K+ customer they had not realized they were ignoring, and a top-tier customer who has been quietly transitioning to a competitor.
Sources
Frequently Asked Questions
6 questions home service owners actually ask about this.
01Should I weight by revenue, margin, or job count?
Start with revenue for simplicity. Add margin for the second pass if your CRM has clean cost data. Add job count to surface maintenance loyalty separately from one-time big-ticket customers.
02How often should I refresh the top 100 list?
Quarterly at minimum. Monthly is better for shops doing $3M+. Customers move in and out of the top tier as their household systems age, their needs change, or your competitors approach them.
03What if my CRM has dirty data?
Run a one-weekend cleanup first. Top-100 analysis on duplicate-laden, half-tagged data produces a misleading list. Dedupe customers, fix the obvious phone and email problems, and tag your customers consistently.
04Can I run this in Jobber, Housecall Pro, and ServiceTitan?
Yes. Each platform exports invoices and customer records with totals and dates. The query logic is identical. The report names differ. ServiceTitan's Customer List by Revenue, Housecall Pro's Customers list with sorting, and Jobber's Customer Statements report each surface the same data.
05How do I track referrals if I do not have a tag?
Add the tag now. Going forward, ask every new customer in the intake script how they heard about you. Backfill what you can from email and SMS history. The referral signal is the highest-value field most contractors do not capture.
06What about commercial customers and property managers?
Treat them as a separate top-100 list. Their cadence is different (RFP cycles, multi-property management, contract renewals) and the playbook around them is different. Mixing residential and commercial top customers usually obscures both.
See Clint in action
Clint is the pre-built AI for home service shops. Connect your CRM, email, and phone system in minutes and the agents run on your real data.