Skip to content
LeadsTagger

Guide for Thumbtack Pros

Free lead tracking spreadsheet for contractors

Download our free lead tracker CSV template, open it in Google Sheets, Excel, or Numbers, and log one row per lead with the source, lead cost, refund, first reply time, status, and next follow-up date. Then use the formulas below to see your hire rate and cost per hire for each lead source. Many free templates are built for B2B sales pipelines and have no columns for per-lead charges or refunds, so they can't show whether paid leads turn into profitable jobs.

Updated November 12, 2026 · Checked against the Thumbtack Help Center

The short answer

  • Download the CSV: Grab /lead-tracker-template.csv, open it in Google Sheets or Excel, and delete the three example rows.
  • Log cost and refunds: Record Lead cost and Refund on every row so bad-lead credits come out of your spend.
  • Watch two timestamps: Fill in First reply and Next follow-up so paid leads don't sit unanswered.
  • Compare cost per hire by source: Subtract refunds from lead charges and divide by Won jobs for each platform.
  • Update it weekly: Refresh statuses, send due follow-ups, and request credits inside refund windows (45 days on Thumbtack and Angi, as of November 2026).

Download the template

Download the free lead tracker (CSV)

It has 14 columns built for home-service pros plus three rows marked Example row - delete showing how entries look.

  1. Google Sheets (free): Open a blank sheet, click File → Import → Upload, and upload lead-tracker-template.csv.
  2. Excel or Numbers: Open lead-tracker-template.csv directly. In Excel, save it as .xlsx (File → Save As) to keep formulas.
  3. Clear sample rows: Delete rows 2 to 4 (Example row - delete) and keep row 1.

What each column is for

When you pay upfront for leads from Thumbtack, Google Local Services Ads, Angi, Bark, or Yelp alongside referrals and your website, contact info and deal stage aren't enough. Your lead tracking spreadsheet also needs lead fees, refunds, and reply speed.

ColHeaderWhat goes in it
ADate receivedDate the lead came in
BSourceThumbtack, Google LSA, Angi, Bark, Yelp, Referral, Website (keep spelling consistent)
CCustomerName
DPhone or emailContact
EServiceJob type
FCity or ZIPArea
GLead costWhat you paid for this lead ($0 for referrals or website)
HRefundRefund or credit received for this lead
IFirst replyDate and time you first replied
JStatusNew, Replied, Quoted, Won, Lost, or No reply
KNext follow-upDate of the next check-in
LQuoteAmount quoted
MJob revenueWhat the customer paid (Won only)
NNotesAnything else

Three platform rules explain Columns H, I, and K:

  • First reply (Column I): Thumbtack lets customers contact up to five pros in the first four hours, as of November 2026 (Quality Commitment), and its November 6, 2025 Pro Summit recap noted pros replying within 30 minutes are 25% more likely to be hired than at three hours (correlation, not proof). See how fast you should reply to Thumbtack leads.
  • Next follow-up (Column K): Thumbtack suggests following up after about 24 to 48 hours, as of November 2026 (Thumbtack Help). In a Valve+Meter marketing-agency mystery shop of 466 US home-service companies (2018/2019, updated 2021), 85% never made a second call and ~40% never replied within five days (Valve+Meter PDF).
  • Refund (Column H): Refunds arrive after the charge (Thumbtack usually decides in 24 to 48 hours, up to 4 days, per its refund policy). Keeping refunds separate helps you check disputes before deadlines close: 45 days on Thumbtack and 45 days (with a call attempt within 24 hours, excluding annual-subscription leads) on Angi, as of November 2026.

Formulas that turn the sheet into answers

Leave Column O blank, type a label in Column P and paste the matching formula next to it in Column Q (your data starts in row 2). Keep spelling in Columns B and J consistent.

  • Leads: =COUNTA(A2:A)
  • Jobs won: =COUNTIF(J2:J,"Won")
  • Hire rate: =COUNTIF(J2:J,"Won")/COUNTA(A2:A) (no platform publishes benchmark hire rates; compare with your own past months)
  • Net lead spend: =SUM(G2:G)-SUM(H2:H)
  • Cost per hire: =(SUM(G2:G)-SUM(H2:H))/COUNTIF(J2:J,"Won")
  • Cost per hire for one source: =(SUMIF(B2:B,"Thumbtack",G2:G)-SUMIF(B2:B,"Thumbtack",H2:H))/COUNTIFS(B2:B,"Thumbtack",J2:J,"Won") (swap "Thumbtack" for "Google LSA", "Angi", or "Bark"; see how to calculate your cost per hire on Thumbtack)
  • Revenue per $1 of lead spend: =SUM(M2:M)/(SUM(G2:G)-SUM(H2:H))
  • Due for follow-up (Google Sheets): =FILTER(C2:C,K2:K<>"",K2:K<=TODAY(),J2:J<>"Won",J2:J<>"Lost")

Excel note: Open-ended ranges like A2:A work in Google Sheets; in Excel, use fixed ranges such as A2:A1000. Excel 365 includes FILTER, while older Excel versions don't; use a filter on Column K instead.

Where to get the lead cost for each source

Thumbtack and Angi publish no per-lead rate cards. Here is how each source bills and where to find your numbers, as of November 2026:

SourceHow you're charged (as of November 2026)Where to get per-lead cost
ThumbtackDirect leads auto-charge at your lead price when matched (Thumbtack Help); Opportunities charge only if the customer responds; refunds go to your Thumbtack balance (Refund policy)Desktop: Performance → Download lead details (CSV up to 12 months: name, number, amount paid with taxes/discounts, refunds, per Thumbtack Help). App: Payments → Activity (Thumbtack Help)
Google Local Services AdsPay per valid lead (answered call, missed call >20s in business hours, message, voicemail, booking); automatic credits for some low-quality leads over 30 days; no credit for "job type not serviced" or "geo not serviced" (Google Help)LSA dashboard
AngiCharged when both sides show interest, whether or not you open or respond (Angi Help); credits within 45 days with conditions, not on annual-subscription leads (Angi Help, updated August 14, 2026)Angi Pro account
BarkPay credits to contact a customer at $2.35 per credit as of November 2026 (Bark Help, US standard rate updated June 10, 2026); up to five pros respond per requestCredits spent per response × credit price
Referral / own website$0 per-lead costEnter $0 in Column G

For weekly budgets and pricing models, see how much Thumbtack charges for leads. To backfill Thumbtack leads on desktop, export the CSV under Performance → Download lead details (Thumbtack Help) and paste the customer, date, amount paid, and refund into the matching columns.

A 10-minute weekly routine

This weekly habit (our suggestion) keeps the sheet accurate:

  1. Log new leads: Add any unlogged requests with Lead cost and First reply.
  2. Update statuses: Move open rows to Quoted, Won, Lost, or No reply, and enter Job revenue on wins.
  3. Send due follow-ups: Work your FILTER list (or filter Column K). For rules that protect Thumbtack's 72-hour Fair Shot refund, see how to follow up with Thumbtack leads.
  4. Check refunds within windows: Request eligible credits inside 45 days on Thumbtack and Angi or verify 30-day automatic credits on Google LSA, as of November 2026, and log them in Column H.
  5. Review monthly cost per hire: Compare each source's cost per hire against job profit after labor, materials, and travel.

When a spreadsheet stops working

You've outgrown a manual sheet when you forget to log leads on busy days, get many leads a day across sources, or share phones and updates across a team.

Field-service software or a CRM makes sense once you also want scheduling and invoicing. Thumbtack connects with partners like Jobber, Housecall Pro, Workiz, and GoSite as of November 2026 (Thumbtack Help), though integrations such as Jobber's sync new leads only, not older history; see how to track your Thumbtack leads.

If most of your leads come from Thumbtack, LeadsTagger is a free Chrome extension, not affiliated with Thumbtack, that puts tags, private notes, and follow-up dates on each lead inside your Thumbtack inbox, and reads the lead details CSV to show cost per lead and cost per hire, so you don't have to copy leads into a sheet by hand. It only reads your inbox and never sends messages.

Keep customer data safe

Your tracker holds personal customer data (names, phone numbers, emails, and job notes). Keep it locked down:

  • Don't share the sheet publicly or set Google Sheets to Anyone with the link; restrict sharing to your account and staff who need it.
  • Protect cloud accounts with two-factor authentication and lock devices with a passcode.
  • Delete old rows you no longer need for follow-up or bookkeeping.

Frequently asked questions

Is there a free lead tracker for contractors?

Yes. Download our free lead tracker CSV and open it in Google Sheets (free with a Google account), Excel, or Numbers.

What columns should a lead tracking spreadsheet have?

Track date received, source, customer, phone or email, service, city or ZIP, lead cost, refund, first reply time, status, next follow-up, quote, job revenue, and notes.

How do I calculate cost per hire in a spreadsheet?

Subtract refunds from lead costs and divide by Won jobs: =(SUM(G2:G)-SUM(H2:H))/COUNTIF(J2:J,"Won") in Google Sheets (fixed ranges in Excel). See how to calculate your cost per hire on Thumbtack for source-specific math.

Can I import my Thumbtack leads into a spreadsheet?

Yes. On desktop, go to Performance → Download lead details and export up to 12 months as a CSV, as of November 2026 (Thumbtack Help), then paste matching fields into your sheet.

Should I use Google Sheets or Excel?

Either works. Google Sheets is free and supports open ranges (A2:A) plus FILTER. In Excel, use fixed ranges like A2:A1000, and on older Excel versions without FILTER, filter Column K directly.

How often should I update my lead tracker?

Log leads and reply times as they arrive, then spend 10 minutes weekly (our suggestion) updating statuses, follow-ups, and refunds, and check cost per hire monthly.