Skip to main content

Get a High-Level View of Your Accounts

Learning Objectives

After completing this unit, you’ll be able to:

  • Check the performance of your accounts.
  • Analyze data on the Accounts’ Health dashboard.

For Starters…

To make the most of this module, make sure you complete Sales Agreements and Forecasting in Manufacturing Cloud and CRM Analytics Administration for Manufacturing Cloud. This module builds on the steps and concepts covered in the two modules.

Get Hands-on with CRM Analytics for Manufacturing Cloud

In this module, we walk you through the different out-of-the-box CRM Analytics dashboards for Manufacturing Cloud. We don’t have any hands-on challenges in this module, but if you want to view the dashboards for yourself and try out the steps, you need a special Developer Edition org that contains CRM Analytics, Manufacturing Cloud, and our sample data. A regular Trailhead Playground doesn’t have Manufacturing Cloud or our sample data. Here’s how to get the free Developer Edition now.

Note

To see data-rich dashboards, you’ll need to create records in bulk. Don’t worry, we’ve given you a headstart. We have sample records in the special org which will get you started with the dashboard analysis. The examples and screenshots you see in this module may differ from what you see in your org, but you'll see the same dashboards so you can follow along and analyze them.

  1. Sign up for a free CRM Analytics–enabled Manufacturing Cloud Developer Edition org.
  2. Fill out the form.
    1. For Email, enter an active email address.
    2. For Username, enter a username that looks like an email address and is unique, but it doesn't need to be a valid email account (for example, yourname@test.com).
  3. After you fill out the form, click Sign me up. A confirmation message appears.
  4. When you receive the activation email (this might take a few minutes), open it, and click Verify Account.
  5. Complete your registration by setting your password and challenge question. Tip: Write down your username, password, and login URL for easy access later.
  6. You are logged in to your Developer Edition.

Gain Insights with CRM Analytics Dashboards

Do you remember Cindy Jones, the admin at Rayler Parts from CRM Analytics Administration for Manufacturing Cloud? She has set up CRM Analytics for Manufacturing Cloud in Rayler Parts’ org and added easy-to-access dashboards, which account managers can use to analyze different facets of the business. 

In this module, we’ll follow Elliott Drake, Head of Sales, AMER, as he explores the dashboards and gains actionable insights into his business. He has already met Cindy to understand how to use the analytics app. Here are a few questions Elliott is seeking answers to.

  • Which accounts and products contribute to low sales?
  • What are the areas for growth in revenue and profit?
  • What are the competitive prices at which certain products can be sold?
  • What’s the difference between planned, forecasted, and actual revenue and quantity?
  • How accurate are forecasts for accounts and products?
  • Which accounts and products can be sold more?

Elliott logs into the Manufacturing application and finds the Key Account Manager Home dashboard embedded on the landing page. He starts exploring one dashboard at a time.The Key Account Manager Home dashboard on the home page of the Manufacturing app.
When you log in to your special org the first time or add dashboards to a record page, you may not see any dashboard data. It can take some time for CRM Analytics to sync data and fill the dashboards. Click Refresh icon after about 10 minutes to view dashboard data.

Check the Health of Your Accounts

Elliott starts with the Accounts’ Health card and opens it from the Manufacturing app home page.

Note

To see data-rich dashboards in your org, change the global filters for time period and forecast period to Previous Fiscal Year, and accounts to Haven Enterprises, Meridian Partners, or Acme Partners.

The Accounts’ Health dashboard gives you a glimpse of the overall business. Elliott wants to look at how his trusted key account manager, Vance, is performing. You may be familiar with Vance and his account, Acme Partners, from the Sales Agreements and Forecasting in Manufacturing Cloud module. Vance has also been dealing with Meridian Partners, a distributor of Rayler Parts’ attachments to industrial sectors. Elliott clicks the global filter Account Owner and selects Vance. This returns dashboards specific to Vance and his accounts.

Elliott starts with the Overview tab on the Accounts’ Health dashboard, where he can check the performance of accounts in two different ways. 

  1. On the Planned Business card, he can compare actual revenue and quantity with planned revenue and quantity, so he understands how his business is performing against the plan.
  2. On the Sales Forecast card, he can compare the actuals with forecasted revenue and quantity, so he understands how his business is performing against forecast.

He can click View Dashboard on either card to switch between the two analytics views.

Elliott notes that for accounts Acme Partners and Meridian Partners, the difference between planned and actual revenue for the current fiscal year is $6.5 million. While Acme Partners has a revenue realization of around 110% against the business plan, Meridian Partners has a revenue realization below 50%. The revenue trend over the current fiscal year and the month of June shows that the actual revenue is more than the planned revenue.

The Planned Business view on the Overview tab of the Accounts’ Health dashboard.

Elliott also observes that for the two accounts, the difference between forecasted and actual revenue in the current fiscal year is $2.7 million. While Acme Partners has an attainment of around 150%, Meridian Partners has an attainment rate of over 50%. Attainment is the actual revenue displayed as a percentage of forecasted revenue. From the trend chart, Elliott notes that the planned revenue has been higher than the forecasted and actual revenue throughout the current fiscal year.

The Sales Forecast view on the Overview tab of the Accounts’ Health dashboard.

Based on his analysis, Elliott concludes that for the next year, his team should plan numbers similar to the forecasted revenue. Maybe it’s time to estimate better?

Elliott digs deeper into Vance’s accounts to find out more about them.

Check Which Accounts Need Your Attention

Elliott switches to the Accounts in Focus tab. He still has the global filter set to Vance’s accounts. On this tab, Elliott can see how much revenue is outstanding for Vance’s accounts and their actual versus planned revenue. These values are derived from the active sales agreements of an account. Elliott toggles between month, quarter, and year to check how much revenue is flowing in from sales agreements that are expiring soon.

For sales agreements expiring this year, Elliott observes that Acme Partners is well-placed and won’t have any outstanding revenue, while Meridian Partners has an outstanding revenue of $5.7 million. The difference between planned and actual revenue is significant for Meridian Partners and it’s negatively impacting Vance’s overall sales, even though Acme Partners is performing well.

The Accounts in Focus tab of the Accounts’ Health dashboard, showing the accounts that need a follow-up.

Elliott also notices that, based on past schedules of all active sales agreements, Acme Partners has been a consistent customer and their order inflow equals the planned quantity. Meridian Partners accounts for almost 90% of actual-versus-planned revenue difference and is one of the worst-performing accounts at Rayler Parts. Vance must follow up with Meridian Partners and get more orders flowing in.

The Accounts in Focus tab of the Accounts’ Health dashboard, showing the best and worst performing accounts.

Elliott is curious to know how much these accounts contribute to the overall lifetime value of Rayler Parts. 

Strengthen Customer Relationships

Customer Lifetime Value (CLV) is the sum of revenue generated to date and the revenue anticipated from an account. To calculate anticipated revenue, multiply planned revenue with the historical performance of the account (past realization). Elliott clicks the My Account Relationships tab to find out more.

This tab shows the duration of sales agreements for Vance’s accounts. 

  • Meridian Partners has sales agreements of 5 years with Rayler Parts and has completed over 2.8 years.
  • Acme Partners has sales agreements spanning over 4 years and is almost in its third year.

Based on the duration, the tab calculates planned revenue starting the next day and the actual revenue till date. It also shows the place of each account in the overall customer lifetime value chart. Elliott notices that while Meridian Partners is below the average customer lifetime value, Acme Partners is above it.

The My Account Relationships tab of the Accounts’ Health dashboard.

All the more proof to concentrate on Meridian Partners for the remaining 2 years. Elliott is glad that he could gather so much information with just a few clicks! 

Elliott shares his observations with Vance and suggests gathering more details about Meridian Partners.

Resources

Keep learning for
free!
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities