Explore recipe: Average revenue per sales rep this year

Note: Sell customers who also have a Suite Professional plan or higher may also create this report.

In this Explore recipe, you’ll learn how to you’ll learn how to report on the amount of business that each of your sales reps has brought in for the current year. This information helps you evaluate the effectiveness of your sales team.

This article contains the following topics:

• What you’ll need
• Creating the report

What you’ll need

Skill level: Beginner

Time required: 10 minutes

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Giving agents access to Explore)
• Sales data in Zendesk Sell

Creating the report

1. In Explore, click the reports () icon.
2. In the Reports library, click New report.
3. On the Select a dataset page, click Sell > Sell - Sales, then click Start report. The report builder opens.
4. In the Metrics panel, click Add.
5. From the list, select Won deal value, change the aggregator to AVG, and then click Apply.
6. In the Columns panel, click Add.
7. From the list, select Deal owner, and then click Apply.
8. To change the report to a column chart, click Visualization type () and select Column.
9. To filter the report to just this year, click Add next to Filters (to the right of the Metrics panel), select Time - Deal closed - Year and set it to the current year. For help with filtering, see Working with report filters.
10. To adjust the date labels so that you can see them more clearly, click Chart configuration () and select X axis, then change Label rotation to 45.
11. To show the total for each column, click Chart configuration () and select Displayed values.
    Next to Show value, select Show.
12. To sort the columns from most revenue to least, go to Result manipulation (), click Sort, and select Value descending.

Tip: You can format the Won deal value metric to include currency symbols and decimal places. Go to Chart configuration () and select Display format. Next to SUM(Won deal value), select $, €, Finance, or Custom, depending on how you want to format the values above each column.