5 Big Ways to Maximize Your Salesforce Dashboards

December 16, 2020 by David Hecht

This was originally a guest post on the Salesforce blog.

Dashboards and reports are one of the best parts of Salesforce. In addition to being good looking, modern visualizations of your data that don’t have to be manually updated like spreadsheets, they can really maximize the impact Salesforce has on your organization.

Dashboards can improve communication on your team by allowing everyone centralized access to the latest data. They can also help you understand trends in that data more quickly and easily through charts that automatically update, so you can avoid potential problems and celebrate successes. 

Here are five high-level tips to help you make the most of your Salesforce dashboards.

 

  1. Agree on Metrics

It seems obvious, but everyone on your team (and ideally in your company) should agree on what the key metrics are that you are going to track on your dashboards. 

  • What are the metrics that define success at every level of your organization?
  • How do the metrics relate to organizational goals?
  • Over what time periods should those metrics be evaluated (monthly, quarterly, etc.)?

Agreement on what to measure is a critical first step. You don’t necessarily have to be on the same page with the types of charts (some people prefer bar charts while others like line graphs), but that also doesn’t hurt for consistency’s sake.

 

  1. Start with Existing Template

Even if your organization is new to Salesforce, you don’t need to start your dashboards from scratch. You can download a variety of free dashboards from the AppExchange in minutes, and edit them to fit your organization’s data and preferences.

Customizing existing dashboards not only saves you time, but it gives you a baseline of “best practices” of how others have designed their dashboards and created their reports. For more dashboard customization tips, see my How to Customize Salesforce Dashboards blog post.

 

  1. Have Main KPI / Executive Dashboards

Try to have one primary KPI (key performance indicator) dashboard for your organization, which consolidates key metrics from all across the organization into a single view. And even though Salesforce allows up to 20 charts per dashboard, keep this one simple – maybe 9 or 10 KPIs total, where everything fits “above the fold” (without scrolling down in your web browser).

  • One Main KPI / Executive Dashboard
  • Keep it high level, leave supporting data for other dashboards
  • Avoid information overload with a well designed, simple dashboard

You can also have a main KPI dashboard for each department or executive if you choose, but the important thing is to have one or a very small number of KPI dashboards that everyone in your organization sees as the authoritative measure of performance. Each functional area or department may have many additional dashboards that show the detail behind their different activities that roll up into those KPI dashboards, but those should only be used by those focused on each particular area of work.

 

  1. Bring other data into Salesforce

One way to really maximize the power and usage of your Salesforce dashboards is to bring in additional data that might not be in Salesforce normally. If your Sales KPIs are in Salesforce, but other operational or business metrics are in reports that haven’t been integrated into Salesforce, your dashboards are not the single source of truth that they should be. Popular data sources are external marketing systems, product usage data, and finance data such as invoices.

  • SnapLogic Integration Cloud provides hundreds of data connectors to enterprise applications
  • Zapier provides simple connections to 250+ software apps to eliminate duplicate data entry

Manually importing data into Salesforce periodically is one workaround, but then the automated updating of the dashboards with the most current data may be impaired. With tools like those above, you can make your Salesforce dashboards the authoritative source for how your organization is performing.

 

  1. Email Your Dashboards

If you have Salesforce Enterprise Edition or above, as part of scheduling the daily or weekly refresh of your dashboards, you can also set them to sent out via email. These HTML emails look identical to your dashboards in Salesforce, complete with graphics of all the charts right there in your email inbox, which you can still click on to go through to the source report in Salesforce.

  • Set dashboards to automatically refresh and be distributed via email
  • Good for team and executive communication
  • Make dashboard emails part of your daily routine to keep on top of your most critical KPIs

Emailing dashboards is a handy way to share information on a regular basis with team members, as well as with any Salesforce users who may not log in to Salesforce as frequently as they should. And for metrics that you may want to monitor as part of your daily work, such as incoming leads or registrations, starting the day with a cup of coffee and your morning dashboard emails will keep you well in the loop.

 

Want more on Salesforce Dashboards? Check out our blog post How to Customize Salesforce Dashboards.

Share this post