Reporting from Salesforce data is a great way to get insight into your sales performance. In this article, we outline top 5 reports all sales teams should have on their salesforce.com dashboard to effectively track and monitor their activities and KPIs.
1. Historical pipeline view
Track and monitor where you’re at with a report including Opportunity Pipeline information and the status of these. See the volume and value of potential opportunities in your funnel and identify where the most potential pieces of business are to create an action plan to reach your target.
2. Top selling accounts with open Opportunities
Prioritising key accounts is helpful in ensuring your resources are focused in the right area. Create a roll-up summary field on the Account page shows the value of the Opportunities associated with the account. Then use a filter to show open Opportunities only. Depending on the number of sales reps, you can narrow the list to top 10, 20 or any other number of top selling accounts.
3. Lead response times and the number of follow-ups
Get visibility into the time it takes for a lead to be followed up and how many touch points take place before a lead is converted into an Opportunity. This will inform you to optimise the number of touch points that are needed as well as the time it takes to process the leads internally.
4. Closed opportunities and their average
To quickly understand the size of deals that are being closed, run a report on closed opportunities and add the average value of these. Comparing this data to historical performance gives you visibility in the average order or piece of business.
5. Won versus lost Opportunities
Get visibility in the percentage of Opportunities that are either won or lost by running a report that shows the win/loss ratio of Opportunities. This will give you an indication to dig deeper if the rate starts declining and take any action to improve the rate if needed.
How to create Salesforce reports
All of the above reports can be build and run in Salesforce either using custom formulas or by customising the reports available under the Reports tab. However, sales managers are often limited with time and it can take a long time to learn how to run the reports so if you’re looking for a solution that can do the reports for you, why not take a look at Documill Dynamo?
A document generation App for Salesforce, such as Documill Dynamo, produces reports from Salesforce data quickly with ease. Any sales team member can build MS Excel, Word or PowerPoint based reports in seconds using Salesforce data (and external if desired) using a pre-designed report template.
Download a trial of the App for free from Salesforce AppExchange and use this ready-made Account report template to see for yourself how much time reporting from Salesforce using Documill Dynamo can save.