Sample made from invented data
Sample: missed-call follow-up list for Bluebird Plumbing & Heating (invented business and data)
Every missed call and unanswered website inquiry in one list, most urgent first, with a draft reply for each.
Everything in this sample is invented: the business, the people, the numbers and the contact details. It was produced by the same code a pilot uses, then checked by the quality checks listed at the end. In a pilot, a person reviews the output before it goes to you.
What went in (all invented)
- 32 calls in the call log, 12 of them missed, and 4 website inquiries, Fri 2 Oct to Thu 8 Oct
- 8 follow-ups (calls, texts and emails) from the business's own records
- Business hours: Mon to Sat, 7:00am to 6:00pm
- Services: plumbing repairs, water heaters, drain cleaning, heating
The sample output
Summary
Missed calls: 12 from 10 callers (out of 32 calls in the log).
Website inquiries: 4.
Open leads with no recorded reply: 7 (3 urgent, 1 to call back by a person now, 3 first came in after hours).
Already followed up: 7. Median time to first reply: 40 minutes (2 within 15 minutes, 4 in 16 to 60 minutes, 1 later).
Waiting times are counted to 7:00am on Fri 9 Oct, your opening time.
Open leads, most urgent first
| Lead | First contact | Attempts | Channel | Request | Urgency | Hours waiting |
|---|---|---|---|---|---|---|
| Ellen Foster, (512) 555-0129 | Thu 8 Oct, 4:45pm | 1 call | Phone, voicemail left | I smell gas near the furnace in the hall closet. Please call me back. | Safety: call back by a person now ("smell gas") | 14 |
| Marcus Webb, (512) 555-0118 | Wed 7 Oct, 7:40pm (after hours) | 1 call | Phone, voicemail left | Kitchen sink is backed up and the dishwasher won't drain. Please call me back. | Urgent: "backed up" | 35 |
| Daniel Ortiz, (512) 555-0163 | Thu 8 Oct, 11:30am | 1 web form | Website form | Drain cleaning: Basement floor drain is overflowing after last night's rain. | Urgent: "overflowing" | 19 |
| Rachel Dunn, (512) 555-0142 | Thu 8 Oct, 5:52pm | 3 calls | Phone, voicemail left | Hi, it's Rachel on Maple Court. The water heater is leaking all over the garage floor. | Urgent: "leaking" | 13 |
| Unknown caller, (512) 555-0177 | Sun 4 Oct, 10:15am (after hours) | 1 call | Phone, no voicemail | No voicemail left | Normal | 116 |
| Priya Shah, priya.shah@example.com | Tue 6 Oct, 9:12pm (after hours) | 1 web form | Website form | Water heater: Looking for a quote to replace a 12-year-old water heater. No rush, sometime this month. | Normal | 57 |
| Jake Turner, (512) 555-0147 | Thu 8 Oct, 1:10pm | 1 call | Phone, voicemail left | Calling about the bathroom repipe we talked about in the spring. Still interested. | Normal | 17 |
Urgent means the message mentions a leak, flooding, a burst, no heat, no hot water, no power, sewage, a backup or an overflow.
Already followed up
| Lead | First contact | Attempts | First reply | Minutes to first reply |
|---|---|---|---|---|
| Brian Walsh, (512) 555-0134 | Fri 2 Oct, 9:10am | 1 call | Fri 2 Oct, 9:22am by text | 12 |
| Unknown caller, (512) 555-0102 | Sat 3 Oct, 6:40am (after hours) | 1 call | Sat 3 Oct, 7:20am by call | 40 |
| Hector Ruiz, (512) 555-0172 | Sat 3 Oct, 9:30am | 1 web form | Sat 3 Oct, 10:01am by text | 31 |
| Olivia Grant, olivia.grant@example.org | Mon 5 Oct, 8:05am | 1 web form | Mon 5 Oct, 10:50am by email | 165 |
| Unknown caller, (512) 555-0156 | Mon 5 Oct, 12:40pm | 1 call | Mon 5 Oct, 1:25pm by call | 45 |
| Nathan Brooks, (512) 555-0191 | Tue 6 Oct, 3:30pm | 1 call | Tue 6 Oct, 3:41pm by text | 11 |
| Carmen Diaz, (512) 555-0108 | Wed 7 Oct, 7:15am | 1 call | Wed 7 Oct, 8:00am by call | 45 |
Missed calls by time of day
| Time of day | Missed calls | Outside your hours |
|---|---|---|
| Before 9am | 2 | 1 |
| 9am to noon | 2 | 1 |
| Noon to 3pm | 2 | 0 |
| 3pm to 6pm | 3 | 0 |
| 6pm or later | 3 | 3 |
| Total | 12 | 5 |
Draft replies for open leads
Drafts for you to review, edit and send yourself. Amber does not send messages.
To: (512) 555-0118 · As: text message
Hi Marcus, this is Bluebird Plumbing & Heating. Sorry we missed your call on Wed 7 Oct. It sounded urgent, so we're getting back to you first. When is a good time to call? Reply here or call us back. Dana, Bluebird Plumbing & Heating
First contact Wed 7 Oct, 7:40pm (after hours); 1 call; urgent: "backed up".
To: (512) 555-0163 · As: text message
Hi Daniel, this is Bluebird Plumbing & Heating. Thanks for your drain cleaning request through our website on Thu 8 Oct. It sounded urgent, so we're getting back to you first. When is a good time to call? Reply here or call us back. Dana, Bluebird Plumbing & Heating
First contact Thu 8 Oct, 11:30am; 1 web form; urgent: "overflowing".
To: (512) 555-0142 · As: text message
Hi Rachel, this is Bluebird Plumbing & Heating. Sorry we missed your 3 calls on Thu 8 Oct. It sounded urgent, so we're getting back to you first. When is a good time to call? Reply here or call us back. Dana, Bluebird Plumbing & Heating
First contact Thu 8 Oct, 5:52pm; 3 calls; urgent: "leaking".
To: (512) 555-0177 · As: text message
Hi, this is Bluebird Plumbing & Heating. Sorry we missed your call on Sun 4 Oct. How can we help? Reply here or call us back. Dana, Bluebird Plumbing & Heating
First contact Sun 4 Oct, 10:15am (after hours); 1 call.
To: priya.shah@example.com · As: email
Subject: Your water heater request with Bluebird Plumbing & Heating
Hi Priya, Thanks for your water heater request through the Bluebird Plumbing & Heating website on Tue 6 Oct. Sorry for the slow reply. What is a good time to call you, and what number is best? You can also reply here with any details or photos that would help. Dana, Bluebird Plumbing & Heating
First contact Tue 6 Oct, 9:12pm (after hours); 1 web form.
To: (512) 555-0147 · As: text message
Hi Jake, this is Bluebird Plumbing & Heating. Sorry we missed your call on Thu 8 Oct, and thanks for the message. When is a good time to call? Reply here or call us back. Dana, Bluebird Plumbing & Heating
First contact Thu 8 Oct, 1:10pm; 1 call.
Call back by a person now (no written draft)
- Ellen Foster, (512) 555-0129 (first contact Thu 8 Oct, 4:45pm, 1 call): "I smell gas near the furnace in the hall closet. Please call me back."
These messages mention a possible safety issue. Call them back yourself now; Amber does not write a reply for them.
Quality checks run on this sample
17 of 17 QA checks passed. Direct cost of producing it: $0.00 (no paid service was used).
- Passed: Every open lead appears exactly once in the open-leads table
- Passed: No draft for a lead already replied to or on the call-back-now list
- Passed: Each open lead not on the call-back list has exactly one draft
- Passed: Urgent and safety rows list the words that matched
- Passed: Text message drafts are 320 characters or fewer
- Passed: Every draft names the business
- Passed: No draft quotes a price or promises a discount, refund, credit or arrival time
- Passed: Text drafts go to a phone number; email drafts go to an email address and have a subject
- Passed: Summary counts equal the tables' row counts
- Passed: Attempt counts and the time-of-day table add up to the missed calls
- Passed: Every safety lead is on the call-back-now list once and marked in the table
- Passed: Hours waiting are counted from the as-of time
- Passed: No claims of guarantees, certification, compliance, affiliation or unmeasured results
- Passed: Nothing says a message was sent (Amber drafts; a person sends)
- Passed: Every section of messages is labelled as drafts
- Passed: No empty section without a note saying why
- Passed: Every stage of the demo completed
Ask about the Missed-Call and Web-Inquiry Follow-Up List pilot · All ten pilot services