Professional Services Lead Generation: Enquiry Sources, Booking & Close Rates, Value per Matter, Content & Seminar Leads, Response Time & Capacity
Win the right clients for a law, accounting or consulting practice by measuring the whole path from enquiry to engagement in 20 labs of spreadsheet practice. You will total an enquiry funnel by source, calculate booking, close and enquiry-to-client rates, cost per enquiry and per new client, collection rate and value per matter, lifetime value and the allowable cost of winning a client, then measure intake response time, speed bands and booking rate, show-up and no-shows, and close rate and net value by consultation type. You rank referral sources, compare content, seminar and webinar leads, separate suitable from unsuitable enquiries, study the sales cycle and capacity, forecast enquiries, test two enquiry forms, build a budget what-if grid, compare told and recorded sources, keep a marketing review log and finish with an annual scorecard. Professional advertising rules vary by country and profession, and nothing here is advice. 20 hands-on labs, fictional firm data, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
Professional Services Lead Generation follows the path from first enquiry to signed engagement at Ardenvale Partners, a fictional firm with employment law, property law, tax and consulting teams. In 20 hands-on spreadsheet labs you total the funnel by enquiry source, calculate booking, close and enquiry-to-client rates, cost per client, collection rate, value per matter and the allowable cost of winning a client. You measure intake response time and its effect on bookings, show-up and no-shows, referral sources, content, seminar and webinar leads, lead quality, the sales cycle and capacity, then forecast enquiries, test two enquiry forms, build a budget what-if grid, compare told and recorded sources, keep a marketing review log and finish with an annual scorecard. Professional advertising rules vary by country and profession, and nothing here is legal or regulatory advice. All firms, people and numbers are fictional.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- Enquiry Sources & the Conversion Funnel: Booking Rate, Close Rate and Enquiry-to-Client RateFree
- Cost per Enquiry, Cost per Consultation and Cost per New Client by Channel Locked
- Value per Matter: Fees Billed, Fees Collected, Collection Rate and Average Fee by Practice Area Locked
- Client Lifetime Value: Repeat Matters, Lifetime Margin and the Allowable Cost of Winning a Client Locked
- Intake Response Time: Minutes to First Reply, Share Within Target, Average and Median Locked
- Response Speed Bands: XLOOKUP Approximate Match, Booking Rate per Band and the Cost of Waiting Locked
- Consultation Show-Up and No-Shows: Attendance Rate, Close Rate of Attended Consultations and the Value of Reminders Locked
- Close Rate by Consultation Type: Expected Fee per Consultation, Time Cost and Net Value Locked
- Referral Sources: Close Rate, Fees per Referral, a League Table with RANK.EQ and the Concentration of the Top Three Locked
- Content Leads: Enquiries per 1,000 Views, Production Cost per Client, INDEX-MATCH and a Scatter Chart Locked
- Seminar & Webinar Leads: Attendance Rate, Cost per Attendee, Cost per Client and the Zero-Client Case Locked
- Lead Quality: Suitable and Unsuitable Enquiries, Conflicts, Suitable Rate and Cost per Suitable Enquiry Locked
- The Sales Cycle: Days from Enquiry to Instruction, Average and Longest Wait by Practice Area Locked
- Capacity Before Campaigns: Hours Needed, Utilisation, IFS Status Bands and the Most Matters We Can Take Locked
- Enquiry Trend and Forecast: Moving Average, SLOPE, FORECAST.LINEAR and New Clients Next Quarter Locked
- Is the Short Form Really Better? Pooled Rate, Standard Error, z Statistic and p-Value for Two Enquiry Forms Locked
- Budget What-If Grid: Mixed References, New Clients, Net Margin and the Break-Even Enquiry-to-Client Rate Locked
- Source Attribution: What Clients Say vs What the System Records, Mismatch Rate and Clustered Columns Locked
- Marketing Review Log: Review Status, Days Live Without Review, Items at Risk and a Rule That Marks Them Locked
- Final Project: Annual Lead Generation Scorecard with Cost per Client, Return per £1, Review Flags and a Combo Chart Locked
Learner reviews
Be the first to review this course.