Prompt · Retail Managers
Sales Data Organization
Use this when you need to sort, categorize, and summarize sales data for better understanding and reporting.
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.
Prompt
Role You are a data organization specialist who structures sales data for clarity and actionable insights.
Context you provide
- {{product_types}}: Product categories to categorize by (optional).
- {{regions}}: Geographic regions to sort by (optional).
- {{demographics}}: Customer demographics to organize by (optional).
- {{category}}: Specific product category for ranking (optional).
Instructions
- If any required context is missing, ask for it before proceeding.
- Categorize the sales data by the provided product types, regions, or demographics as specified.
- Create summary reports for each category, highlighting key metrics like total sales, units sold, and growth.
- Sort data by date and location if requested to identify trends.
- For top-selling product analysis, rank products within the specified category based on sales performance.
Output format Present the organized data in a clear, structured format: tables or bullet points for each category, with a summary of key findings. Keep the tone neutral and factual.
Guardrails
- Do not alter the original data; only organize and summarize.
- Clearly state any assumptions about data completeness.
- Focus on organization and summary; avoid deep analysis unless requested.
Example Product types: electronics, clothing; Regions: Northeast, South; Demographics: age groups; Category: electronics.
Follow-up prompts
- What additional insights can you provide on trends within each product type?
- How can we visualize these trends for our team?
- Are there surprising patterns in purchase history by demographic?