Tabellab
Marketing Analytics Intermediate

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.

20 lessons 20 labs Certificate

  • 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

  1. Enquiry Sources & the Conversion Funnel: Booking Rate, Close Rate and Enquiry-to-Client RateLabFree
  2. Cost per Enquiry, Cost per Consultation and Cost per New Client by ChannelLab Locked
  3. Value per Matter: Fees Billed, Fees Collected, Collection Rate and Average Fee by Practice AreaLab Locked
  4. Client Lifetime Value: Repeat Matters, Lifetime Margin and the Allowable Cost of Winning a ClientLab Locked
  5. Intake Response Time: Minutes to First Reply, Share Within Target, Average and MedianLab Locked
  6. Response Speed Bands: XLOOKUP Approximate Match, Booking Rate per Band and the Cost of WaitingLab Locked
  7. Consultation Show-Up and No-Shows: Attendance Rate, Close Rate of Attended Consultations and the Value of RemindersLab Locked
  8. Close Rate by Consultation Type: Expected Fee per Consultation, Time Cost and Net ValueLab Locked
  9. Referral Sources: Close Rate, Fees per Referral, a League Table with RANK.EQ and the Concentration of the Top ThreeLab Locked
  10. Content Leads: Enquiries per 1,000 Views, Production Cost per Client, INDEX-MATCH and a Scatter ChartLab Locked
  11. Seminar & Webinar Leads: Attendance Rate, Cost per Attendee, Cost per Client and the Zero-Client CaseLab Locked
  12. Lead Quality: Suitable and Unsuitable Enquiries, Conflicts, Suitable Rate and Cost per Suitable EnquiryLab Locked
  13. The Sales Cycle: Days from Enquiry to Instruction, Average and Longest Wait by Practice AreaLab Locked
  14. Capacity Before Campaigns: Hours Needed, Utilisation, IFS Status Bands and the Most Matters We Can TakeLab Locked
  15. Enquiry Trend and Forecast: Moving Average, SLOPE, FORECAST.LINEAR and New Clients Next QuarterLab Locked
  16. Is the Short Form Really Better? Pooled Rate, Standard Error, z Statistic and p-Value for Two Enquiry FormsLab Locked
  17. Budget What-If Grid: Mixed References, New Clients, Net Margin and the Break-Even Enquiry-to-Client RateLab Locked
  18. Source Attribution: What Clients Say vs What the System Records, Mismatch Rate and Clustered ColumnsLab Locked
  19. Marketing Review Log: Review Status, Days Live Without Review, Items at Risk and a Rule That Marks ThemLab Locked
  20. Final Project: Annual Lead Generation Scorecard with Cost per Client, Return per £1, Review Flags and a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy