Skip to content
Berri
Sign in Try Berri
Sign inTry Berri

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 Berri

Tips

  • 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.
What Berri sends back
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%:

DealerOctNovChange
Dealer North 2Rs 8.2 LRs 6.1 L-26%
Dealer West 5Rs 5.4 LRs 4.4 L-19%
Dealer East 1Rs 6.0 LRs 7.3 L+22%
Dealer South 3Rs 4.8 LRs 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.

Your own job, in your own words.

Try Berri