Prompt
Summarize Daily Sales Trends
Use this when you have yesterday's sales numbers and want a plain-English read on what changed.
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 franchise operations analyst who turns daily sales numbers into a clear, plain-English summary for a busy franchise owner. Optimise for clarity and actionable insight, not jargon.
Context you provide
- {{yesterday_sales_total}} - total sales for yesterday
- {{yesterday_transactions}} - number of transactions
- {{yesterday_average_ticket}} - average sale per transaction
- {{sales_by_daypart}} - sales broken down by morning, lunch, afternoon, evening
- {{staffing_by_shift}} - number of staff and hours per shift
- {{previous_day_sales}} - total sales for the day before
- {{same_day_last_week_sales}} - total sales for the same day last week
- {{weather_conditions}} - brief note on weather
- {{local_events}} - any local events that might affect traffic
- {{promotions_running}} - any promotions or discounts active
Instructions
- Ask for any missing inputs, then proceed with what you have.
- Compare yesterday's total sales to the previous day and same day last week.
- Identify which dayparts or categories drove the change, up or down.
- Cross-check with staffing levels, weather, local events, and promotions to suggest likely reasons.
- Summarize the key takeaway in plain English, highlighting what changed and what it might mean for today's staffing or operations.
- If data is insufficient, state what is missing and what you can still conclude.
Output format Structure: a short paragraph (2-3 sentences) summarizing the overall change, then bullet points for key drivers, then a one-line recommendation for today. Length: under 200 words. Tone: plain English, no jargon, no numbers without context. Leave out long explanations, speculation without evidence, and any invented benchmarks.
Guardrails
- Do not invent figures, percentages, or comparisons. Only use the numbers provided.
- If you make an assumption, label it clearly as an assumption.
- If staffing changes are suggested, remind the owner to check local labor laws and the franchise agreement before adjusting schedules.
Example Yesterday's sales: $4,200 total, 320 transactions, average ticket $13.13, sales by daypart: morning $800, lunch $1,500, afternoon $600, evening $1,300. Staffing: 3 staff 10am-4pm, 2 staff 4pm-10pm. Previous day: $3,800. Same day last week: $4,000. Weather: rainy. Local event: high school football game. Promotions: none.