Hours spent
Estimates total hours invested in a customer across meetings and emails over the last 6 months
One of 51 free, open-source prompts from Sonora — copy-paste-ready AI prompts for customer success and account management, organized by customer lifecycle stage. Copy this into any AI assistant, or run it on autopilot inside Sonora.
Estimate the total hours spent on [Customer] over the last 6 months across meetings and email.
Step 1: Meeting hours
Retrieve all meetings involving [Customer] over the last 6 months. For each meeting, use its recorded duration. Sum meeting hours by calendar month.
Step 2: Email hours
Retrieve all email threads with [Customer] over the last 6 months. Estimate 5 minutes per email. Aggregate estimated email time by calendar month.
Step 3: Monthly totals
For each of the last 6 months, sum meeting hours and estimated email hours into a combined total. Round each monthly total to one decimal place.
Output
Return the combined hours total for the most recent month as a single number (e.g., 4.5). If no data is available, return 0.
In the reason field, include a breakdown table for all 6 months with columns: Month, Meeting Hours, Email Hours, Total Hours. List each month on its own row, oldest first, with the most recent month last. Round all values to one decimal place. Note the email estimate assumption (5 min/email) at the end of the reason field.
Data sources required
The catch
A prompt is only as good as the data you feed it.
Run this well and you'll be stitching together 2 disconnected systems by hand, for one account at a time — and the answer is only ever as fresh as your last copy-paste. Sonora already has the context, live:
- Meeting transcripts — connected and continuously synced
- Customer communications — connected and continuously synced
Inside Sonora this prompt runs grounded in your real customer data, on a schedule, across every account at once — and flags what needs you, before you have to ask.
More Monitor prompts
Bad call
Detects customers with poor eCSAT scores (less than 4) in the last 2 weeks
Build VoC report
Synthesizes themes from calls, tickets, and sentiment data into a Voice of Customer artifact for product teams
Call count (90d)
Tallies the total number of meetings held in the last 90 days
Competitor mentions
Identifies customers who have mentioned competitors in recent communications
Customer health brief
Synthesizes health signals, risks, and opportunities into a 1-page executive brief with three prioritized next steps
Diagnose account issues
Surfaces and prioritizes everything going wrong at an account with root cause analysis and a recovery plan