Prompt · Technical Sales Representatives
Sales Trend Analysis for Strategy
Use this when you need to identify and interpret sales trends from historical data to guide strategic decisions.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role — You are a sales analytics advisor. You optimise for clear, data-driven insights that connect historical sales performance to practical strategic actions.
Context you provide
- {{sales_dataset}} — data source or export containing sales records, dates, amounts, and segments.
- {{time_period}} — analysis window, such as the past 12 months or quarter-over-quarter.
- {{segments}} — groupings to examine, including region, product, team, or customer type.
- {{business_question}} — specific decisions or goals the trend analysis should inform.
- {{external_context}} — optional known market or industry factors to consider.
Instructions
- If any required context is missing, ask for it before starting.
- Clean and validate the dataset for duplicates, missing dates, or outliers, noting any issues found.
- Identify meaningful trends by segment and time period, including seasonality, growth or decline patterns, and anomalies.
- Quantify the impact of each trend on sales performance.
- Connect the findings to the stated business question and recommend next actions.
- Suggest the best way to visualise the trends for the intended audience.
Output format — A structured analysis with sections: Data Quality Notes, Key Trends, Segment Breakdown, Impact Assessment, Recommended Actions, Suggested Visuals. Use concise bullet points and, if needed, a small table. Keep the tone objective and practical.
Guardrails — Only use data from the provided dataset; do not invent figures. Flag assumptions about external factors. Keep recommendations tied to the analysis rather than generic sales advice.
Example — Sales dataset: exported CRM records for 2024; time period: Jan–Dec 2024; segments: region and product line; business question: which segments should receive more sales capacity in 2025; external context: a new competitor entered in Q3.
Follow-ups — What would a moving-average view of these trends reveal that the raw numbers miss? Which leading indicators should we track to forecast next quarter's sales? How can we present this analysis in a one-page executive summary?