How Salesforce CRM Analytics helped track team performance
Overview
A sales outsourcing company had limited or no visibility into its agent performance. The Sales reps were involved in high-volume prospect interaction and different goals for each customer account. After the implementation of Salesforce CRM Analytics, the customer could analyze each customer account’s health and each team’s performance and provide sales coaching based on critical metrics.
The Story of an Outsourcing Company
The company was in the business of sales outsourcing, and at a given point, more than 200 active customers relied on the company to book meetings and close deals. They had more than 125 sales reps who would be assigned to customers and were responsible for ensuring that customer goals were met.
Current State
The company used Salesforce reports and dashboards. However, these reports provided operational information only.
• The company relied on Excel reporting to generate reports.
• These reports didn’t provide insight into team performance or account performance.
“The Executive team spent hours exporting data into Excel to generate its monthly report, often referred to as the “Excel nightmare.” Salesforce CRM Analytics dashboard provided these insights in minutes.”
Business Challenges
As the company grew, monitoring every account and its performance became more difficult. The account management team spent hours exporting the data from different systems into Excel to generate reports. The customer success team had no insights into real-time data regarding how the customer’s account was performing and what sales reps were achieving. The team was only tracking calls and emails sent, but that was insufficient to grasp data insights. The key metrics they were looking for were:
• How many conversations does a sales rep need before booking a meeting?
• What are the industry trends? Are they setting customer goals based on their specific industry?
• What is the sales rep’s performance in terms of the conversion ratio?
• How many calls did it take before converting a lead into an opportunity?
• The call duration and appointment set-to-appointment held ratio
• An analysis of appointments set by emails vs. calls
• How many emails did a sales rep need to send before securing a meeting?
• An analysis of team performance
• An analysis of the customer accounts so they can staff accordingly to meet goals
• Track revenue generated by sales reps for a given account
Their current reporting provided transactional information. However, it didn’t give them insights into their sales cadences and effectiveness.
Technical Challenges
From a Salesforce implementation perspective, it was complex since record types were extensively used. In addition, the customer relied on creating unique record types for each customer to track its prospects and respective prospect activities. Hence, visibility was a complex issue that involved record types, roles, and profiles.
Record types were used to restrict visibility based on customer accounts and provide them with the account hierarchy regarding customer accounts and their corresponding prospect accounts and prospects/contacts. Initially, there was no relationship between these accounts in Salesforce. This made it challenging to display accurate data for customer accounts.
To solve this, we created a custom relationship between customer and prospect account records. We could build data sets in Tableau CRM and display the account hierarchy, its related contacts, the activities/touchpoints, and the sales rep’s goals.
Next, due to the complexity of the organizational configuration, it required the use of multiple data sets to accurately display information on each of the dashboards. This typically isn’t a best practice, but it was needed for this scenario. To ensure the data was interactive on the dashboard, we connected the datasets using a particular field — either record type ID name or owner ID name for the account and sales representative dashboards, respectively.
Why Did the customer choose Salesforce CRM Analytics/TCRM?
TCRM provided them with reporting capabilities, sales insights, and team performance metrics in one integrated platform. In addition, with TCRM, the executive team no longer had to spend hours exporting the data into Excel and generating reports.
How Did We Achieve All This?
The Salesforce implementation was complex, with extensive usage of record types and loosely connected account relationships. Pulling customer accounts, prospect accounts, contacts, and activities was challenging. Hence, we implemented custom functionality to build the object relationships, so TCRM could pull and display data. Our team used SAQL (Salesforce Analytics Query Language) to display the dynamic reference line and depict the goal met vs. the goal set.
The Results
We developed several dashboards that were used at various levels.
• Sales reps and their managers used the sales rep dashboards to understand individual performance.
• The executive dashboard was used by company executives to monitor customer accounts across the board and provide actionable insights. This dashboard also provided performance data based on the prior month, quarter, and year for a given account/sales team/sales rep.
• A sales manager dashboard was used to analyze the team’s performance based on goals met, conversion rate, and the number of appointments converted.
Sales Rep Dashboard
Sales rep dashboard
This dashboard provides insight into a sales rep’s performance against the goal set. The top left quadrant shows the number of customers to whom the sales rep is assigned and the overall stats for these accounts regarding dials, conversations, and the dial-to-conversation ratio.
Sales Rep Appointment Metrics Dashboard
Sales Rep Appointment Metrics Dashboard
Sales Rep Performance Dashboard
Sales rep performance dashboardExecutive dashboardSales team performance dashboard against goal/quota
Taking Salesforce CRM Analytics to the next level with Revenue Intelligence
Revenue intelligence uses revenue lifecycle visibility created by automation and AI to generate data-driven ways to sell.
From finance to marketing to sales, revenue intelligence gives your organization valuable insights that you can use to take action. For example, sales leaders can use revenue intelligence to keep tabs on pipeline health, while sellers can leverage it for critical information at the right time. For both, it’s key visibility into the health and vitality of your business.
With revenue intelligence, you can direct new sales reps to where they should begin and guide them to take impactful actions, so they can start competing with your best performers and optimizing your bottom line. You can set great forecasts and achieve them because you’ll be able to see the data, know that deals are at the proper stages, and take the right actions at the correct times.
Need More Info?
If you need more information, please contact us at [email protected] or click the link below.
Overview The client is a US-based marketing company that recently obtained a business in the UK. Although both entities are in the same industry, they used different Salesforce systems designed for their respective countries to house their data. Per the merger agreement, the client had a deadline of 30 days to complete the Salesforce org […]
Salesforce Sales Cloud, Pardot Pain Point Solutions Customer was dealing with duplicate Accounts in Salesforce. Developed a solution that identified and merged duplicate data as an ongoing process. Customer wanted a way to match and update Account and Contact information coming from external sources. We developed a custom reusable solution to match the external data […]
Salesforce Nonprofit Pain Point Solutions Data Quality issues, bad address data impacting patients/families’ outreach. Implemented a custom solution to clean up US and Canadian addresses using zip codes to improve data quality. Org had a lot of duplicate household data that was impacting overall campaign outreach. Developed a custom solution with combination of real example […]