Tree Guardians: Lead, Appt, and Job Funnel Analysis

Posted by: Bri Guarnieri Date Posted: November 3, 2026
Back to Case Studies

Issue

Various Tree Guardians were not hitting their goal for scheduled appointments in October, and our POCs wanted to know why (i.e. is it lead quality, marketing inefficiency, a decrease lead quantity, etc.). As an added layer to this, we only log appointment data for 2 of the brands (the other brands manually track appointment totals in a spreadsheet, so we can’t tie back people/leads).

Solution

Our main POC sent over daily, weekly, and monthly totals for each of the brands for appointments. Using that sheet & RCFX job/call/form submission data, we used Claude to run an analysis on where leads are getting lost in the funnel. We identified the number of non-spam leads vs. appointments, as well as “leads: adjusted” (which filters out unanswered calls) vs. appointments, and finally, how many appointments are turning into jobs.

We also broke down the following:

  • leads by channel per brand
  • form inquiries by brand (i.e. what service are the submitters looking for?)
  • answered calls by brand (i.e. what service are the callers looking for?)
  • form/call trend data by brand
  • uncategorized call analysis (which lead to unanswered call analysis)

As a result, between our analysis here & additional discovery conversations with our POCs, we identified some key operational constraints for a number of the brands:

  • Cross Brand Themes
    • Missed and voicemail: TWM (32%), Heartwood (29%), Caldwell (30%) and Herrington (67%) lose roughly a third or more of calls to a missed call or voicemail. AE loses about 14%.

    • Follow-ups: a large share of calls are existing customers asking about quotes or appointment times, led by AE (27%) and TWM (22%). That points to communication and scheduling gaps, not lead problems. Still we have a solution here, we’ll adjust these types of calls not to push into Google Ads as a value.

    • Budget – If we must maintain budget but operational issues significantly reduce appointment conversion, the required lead cost and volume increase substantially. We can aim for efficiency but we may need to increase spend in some situations. Keep in mind that CPC click costs rise YoY and are becoming more competitive as AI results take up more space, so the budget may need revisiting if we aren’t seeing a faster return from the below recommendations.

  • TWM: booking is running about two months out, so callers are shopping around instead of making an appointment. About 30% of calls end at a greeting or phone menu, and there is no CRM for reminders or follow-up.

  • Caldwell: calls after 5pm and on weekends often go unanswered, those callers do not call back. The $300 consultation fee on plant/tree-health visits and the handoff between front desk and office also lose bookings.

  • Burke’s: 14% of calls go unanswered, rising to 21% from 2 to 5pm and 25% on Fridays, with Google Ads calls hit hardest.

  • Arborist Enterprises: about 27% of calls are existing customers asking about quotes or job dates. Callers are frustrated with how long it takes to deliver a quote.

Achievement

Identified that although lead quantity/quality may play a part in some brands not hitting their appointment goals for the month, there are key operational constraints that are heavily impacting the lead to appointment ratio.

Snippet/Screenshot/Link

Data Analysis/Output: Link

Prompt Used/Created for TG: Link