Distributor Ranking (Advanced Reports)

This report is designed to allow you to compare distribution among multiple distributor markets.

Written By Chris Louis ()

Updated at May 13th, 2020


This report is designed to allow you to compare distribution among multiple distributor markets.

**NOTE: Requires sales data 


  • Select the time frame for which you’d like to pull the report
  • Choose the distributors you would like included
  • If you’d like, you can filter the report down to include only specific brands and SKUs
  • You can also filter by on or off premise and independent or chain accounts
  • Click the blue “Submit” button

**NOTE: If you’d like to save these parameters to pull this report more efficiently in the future you can do so by clicking the Saved Filters button in the top right corner of the Filters area. You’d then click on the “Create New From Current Filters” and add a bookmark name and click “Save.” You’ll then be able to automatically pull this report with these pre-set filters at anytime in the future.

  • In the report that populates, you’ll find the following information:
    1. Top 10 Distributors by CEs: the x-axis of this graph will show your top 10 performing distributors, while the y-axis shows benchmark CE numbers. If you hover over any bar on the graph you’ll be able to view the total number of CEs and PODs reported by that distributor for the selected time frame.
    2. Activities Completed: shows the total number of activities logged under your distributor’s territories during the chosen time frame. This will also show you the total number of activities completed under your distributor’s territories during the same period of the previous year.
    3. Top Distributor – Activities Completed: this will show the distributor under which the most activities were logged during the selected time frame.
    4. Accounts – On Premise vs Off Premise: this will show the total number of accounts split by on premise (green) vs. off premise (yellow) classification.
    5. Sales – On Premise vs Off Premise: this will show the total distribution split between on premise (green) and off premise (yellow) accounts.
    6. Distributor Ranking: This table will show the following information:
      • Distributor – name of each distributor
      • # of Brands – total number of brands each distributor sold during the selected time frame
      • Column showing selected time frame for previous year: Sales (CEs) – total number of CEs sold during the period of time shown, Sales (Units) – total number of units sold during the period of time shown, PODs – total points of distribution reported during the period of time shown.
      • Column showing selected time frame for current year: Sales (CEs) – total number of CEs sold during the period of time shown, Sales (Units) – total number of units sold during the period of time shown, PODs – total points of distribution reported during the period of time shown.
      • Growth: shows the percentage by which a distributor’s sales have either increased or declined by based on the time period selected in comparison with the previous year.
      • Top SKU: Shows the top selling SKU within each distributor’s territory during the selected time frame.

Was this article helpful?