Calculate a clinic's lead funnel
calculate_lead_funnelWorks out a health clinic's lead follow-up metrics from its own weekly counts, per source (all, Meta, Google, website, phone, other): contacted ÷ leads, booked ÷ leads, attended ÷ booked and lead → patient, the median time to first response and, with ad spend, the cost per lead, per booking and per new patient. A metric without its counts comes back as pending with the count it needs; nothing is filled with averages. Counts only: never send names, phone numbers or other lead data.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"rows": "<rows>"
},
"name": "calculate_lead_funnel"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | One week of the clinic's own counts, one row per source (each source once; all for every source together): the leads that arrived that week, and how many of them have replied, booked and come so far. Leave out any count the clinic does not have: it is never estimated. | |
| currency | No | Currency of ad_spend: EUR, GBP, USD or AUD. Without it, money is written as a plain number. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | Yes | ||
| rows | Yes | ||
| footer | Yes | ||
| currency | Yes | ||
| reference | Yes | The lead follow-up skill's published reference (Spain, chiropractic): not a target |