This prompt analyzes support ticket volume to identify trends and forecast future volume.
Analyze this export of support ticket volume by week for the past 12 months. Identify seasonality trends and forecast volume for the next quarter. Visualize the trend and provide commentary for capacity planning.
Co-founder of Prompt Magic and ThinkingDeeply.ai Career Chief Marketing Officer
Build your personal prompt library, save your favorites, and access curated AI prompts created by the community
Access a vast library of high-quality AI prompts for every use case
Save prompts to your personal library and organize them your way
Get started with full access to our core features at no cost
No credit card required • Free forever • Join 10,000+ users
Projects the expected lead volume for the next quarter based on historical data.
This prompt calculates the average deal velocity per quarter from a CRM export and displays the trend in a simple chart.
ChatGPT interprets operational and financial datasets to surface trends, diagnose issues, forecast outcomes, and optimize initiatives.
Visualization Success Brief Context: what this dataset represents in plain English Audience: who will see the chart (exec, analyst, customer, team) Decision: what decision this chart should drive Time window: what time period matters Definitions: metrics, units, and any business logic Constraints: styling, number of charts, layout, labeling rules Validation: checks to confirm correctness before finalizing Output format: chart + insights + (optional) code
Examines support ticket data to identify recurring issues and their root causes.
Now you can upload Excel files to Claude and it can do complex analysis on the files. (You need the Max version of Claude for this advanced function but its really good!) You can upload CSVs to ChatGPT with the prompt below to have it do stronger analysis as well. Most people throw a CSV at AI and get vague summaries. Pros use great prompts like the one below that guide the AI through statistical best practices. Use this prompt to get better results.