Loading
Connect in real time with the Trailblazer Community in Slack Open BetaRead More
Account Insights- Product Sales & Pricing

Account Insights- Product Sales & Pricing

Use the Account Insights - Product Sales & Pricing dashboard to get a product-level breakdown of sales realization and pricing structures for a specific account, and to identify which products are driving performance and which are contributing to revenue shortfall. By surfacing the top and bottom five accounts by contract adherence, this dashboard helps key account managers take targeted action on the products and accounts that matter most.

Required Editions

Available in: Lightning Experience

Available in: Enterprise, Unlimited, and Developer Editions with Manufacturing and Data 360 enabled

Filter by product, account, and time period to focus analysis on specific product lines or segments of the account's purchase history.

  • The Derived Actual Amount section computes the true financial realization of each product schedule after factoring in negotiated contract discounts, giving a more accurate picture of realized revenue than invoice totals alone.

  • The Actual vs. Planned Ratio section measures account efficiency per product line, making it straightforward to compare performance across multiple products and identify where demand is falling short of targets.

  • The Top 5 Accounts component visualizes the five highest-performing accounts for the selected product based on contract adherence, helping key account managers understand what strong performance looks like and replicate it elsewhere.

  • The Bottom 5 Accounts component flags the five accounts with the lowest Actual vs. Planned Ratio, identifying where revenue leakage is most concentrated and where intervention is most urgent.

Next Best Actions: Review the Bottom 5 Accounts component regularly to identify which accounts have the lowest adherence for key products and prioritize them for outreach. Compare Derived Actual Amount against planned values for underperforming products to determine whether the root cause is volume, pricing, or both before engaging the account on a recovery plan.

Example
Example For Rayler Parts, Engine Brackets appear in the Bottom 5 with an Actual vs. Planned Ratio of 0.64 — only 64% of planned demand realized. The Derived Actual Amount shows a 12% discount was applied, further reducing realized value below plan. The key account manager identifies this as both a volume and pricing issue, escalates the pricing deviation to the pricing team, and initiates a product-specific recovery plan with the account focused on increasing Engine Bracket order volumes in the next quarter.

Key Metrics

Metric Description Calculation
Derived Actual Amount Computes the true financial realization of a product schedule after factoring in negotiated contract discounts. [Sales Agreement Product Schedule].[Actual Quantity] * [Sales Agreement Product Schedule].[Sales Price] * ((100 - [Sales Agreement Product].[Discount Percentage]) / 100)
Actual vs Planned Ratio Determines account efficiency per product line to identify high and low performers. SUM(IF [Sales Agreement Product Schedule].[Planned Amount] > 0 THEN [Derived Actual Amount] / [Sales Agreement Product Schedule].[Planned Amount] ELSE 0 END)
Top 5 Accounts Component Visualizes the top 5 highest-performing accounts based on contract adherence. Filtered by Top 5 based on descending [Actual Vs Planned Ratio].
Bottom 5 Accounts Component Flags the top 5 revenue-leaking or underperforming accounts requiring intervention. Filtered by Bottom 5 based on ascending [Actual Vs Planned Ratio].
 
Loading
Salesforce Help | Article