Call Center Abandon Rate Staffing Analysis Builder

You are a contact center analytics lead investigating high abandon rates and staffing gaps. Build an analysis plan for:

Contact center type: [customer support, sales, healthcare scheduling, public services, collections, technical support]
Channels in scope: [phone, chat, callback, SMS, email, blended agents]
Data available: [ACD logs, IVR events, agent schedules, handle time, queue time, abandon time, dispositions, call reasons]
Time grain: [15-minute intervals, 30-minute intervals, hourly, daily, weekly]
Current pain points: [high abandon rate, long average speed of answer, uneven staffing, lunch coverage, call spikes, callback failure]
Service goals: [abandon rate target, service level, ASA, occupancy, CSAT, revenue, regulatory SLA]
Segmentation needs: [queue, language, product, customer tier, call reason, region, weekday, campaign]
Staffing model: [fixed shifts, WFM tool, manual schedules, outsourced team, remote agents, skill-based routing]
Known constraints: [training time, shrinkage, PTO, breaks, overtime limits, union rules, budget, hiring freeze]
Data quality concerns: [short abandons, duplicate calls, transfers, IVR containment, callback attempts, bot deflection]
Decision audience: [operations manager, workforce management, finance, executives, vendor partner]

Create:
1. Data inventory with fields, joins, filters, and cleaning rules.
2. Metric definitions for abandon rate, short abandon, ASA, service level, occupancy, shrinkage, handle time, and repeat calls.
3. Interval-level analysis design that separates demand spikes, understaffing, handle-time drift, and routing issues.
4. Queue and segment comparison table for where abandonment is concentrated.
5. Staffing gap analysis using forecasted calls, actual calls, required agents, scheduled agents, and shrinkage.
6. Customer impact analysis for wait time, callback success, repeat contact, CSAT, and revenue or appointment loss.
7. Dashboard specification with heatmaps, interval charts, Pareto views, and exception tables.
8. Recommendation matrix for schedule changes, callbacks, IVR updates, cross-training, overtime, hiring, or deflection.
9. Before-and-after experiment plan for one queue or shift change.
10. Executive summary template with findings, confidence level, tradeoffs, and next data needs.

Do not treat every abandoned call as lost demand without checking short abandons, repeat calls, callbacks, and IVR containment.