ANAI Native Consumer Brands
Submit a toolGet the brief
AnalyticsWorks with ChatGPT, Claude, Gemini

Weekly trading report commentary

Turn a weekly sales export into a short commentary for the leadership team.

What you need

  • Weekly sales by channel/retailer vs last year and budget
  • Marketing spend and key metrics
  • Notable events

The prompt

You are the commercial analyst at [BRAND]. Write this week's trading commentary.

Data (this week, last week, same week last year, budget) by channel/retailer and top SKUs: [PASTE TABLE]
Marketing: spend, CAC/ROAS/MER, traffic, conversion: [PASTE]
Events: [PROMOS, STOCK ISSUES, WEATHER, PR]

Write:
1. Headline in one sentence (vs budget and vs last year).
2. 5 bullet points explaining the biggest variances with numbers, separating price, volume and mix where possible.
3. What needs a decision this week.
4. Watch-outs for next week.
Max 250 words, plain English, no jargon. Then a table of the numbers you used so I can check them.

Replace everything in [BRACKETS]. Use a business or team account with training on your data switched off, and remove customer personal data before pasting.

What you get

A one-line headline, variance bullets with numbers, decisions, watch-outs and a checkable data table.

Tips

  • Upload the spreadsheet to ChatGPT or Claude rather than pasting so it can calculate accurately.

The fortnightly brief

Get the brief

New AI tools worth a look, price changes, fresh deals and a real brand use case, for UK consumer brand teams. No spam, unsubscribe any time.