Review dealer-wise sales for the month
See which dealers grew, which slipped and what to do next.
- ForBrand and distributor sales managers with a dealer network.
- HelperDealer Desk
- ModeBerri Mango 1
- AttachExcel sheet
Copy the prompt
This sheet has dealer-wise sales for [this month] and [last month]. Show the change for each dealer, flag anyone down more than [percent], and suggest one action per flagged dealer.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Dealer Desk helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Ask for a one-paragraph summary you can paste into your weekly report.
- Keep dealer names in one column and months in the next two.
Review dealer-wise sales for the monthDealer Desk
XLSdealer-sales.xlsx
This sheet has dealer-wise sales for November and October. Show the change for each dealer, flag anyone down more than 15%, and suggest one action per flagged dealer.
Reading dealer-sales.xlsx
Two dealers are down more than 15%:
| Dealer | Oct | Nov | Change |
|---|---|---|---|
| Dealer North 2 | Rs 8.2 L | Rs 6.1 L | -26% |
| Dealer West 5 | Rs 5.4 L | Rs 4.4 L | -19% |
| Dealer East 1 | Rs 6.0 L | Rs 7.3 L | +22% |
| Dealer South 3 | Rs 4.8 L | Rs 5.1 L | +6% |
North 2: visit this week, two schemes ended. West 5: check stock, three items were short.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.