Loading
Connect in real time with the Trailblazer Community in Slack Open BetaRead More
Account Insights - Agreement Performance

Account Insights - Agreement Performance

Use the Account Insights - Agreement Performance dashboard to evaluate how an account is performing against its revenue commitments over time, compare current prorated revenue against the same period from the previous year, and project whether the account is on track to meet its full-year targets. This dashboard helps key account managers move beyond point-in-time snapshots to understand performance trends and anticipate shortfalls before they become material.

Required Editions

Available in: Lightning Experience

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

Filter by time period and agreement to focus on specific performance windows or individual contracts within the account.

  • The Prorated Actual Amount section calculates revenue earned based on actual daily amounts multiplied by active schedule days up to the selected date, enabling fair like-for-like comparisons across periods of different lengths.

  • The Previous Year Revenue Variance section compares the current prorated actual revenue against the exact same prorated period from the prior year, helping key account managers distinguish genuine performance decline from seasonal variation.

  • The Revenue Projection section combines prorated actuals with planned amounts for remaining valid schedules to project the expected full-year revenue, giving key account managers an early warning of potential shortfalls.

  • The Revenue Realization Rate section shows the efficiency of actual revenue generated versus planned revenue allocations, expressed as a percentage, providing a consistent benchmark for account health.

  • The Actual vs. Planned Variance section shows the net dollar discrepancy between prorated actual and planned amounts, making it clear whether an account is overperforming or underperforming against its schedule at any point in the year.

Next Best Actions: Monitor Previous Year Revenue Variance monthly to detect whether account performance is trending up or down relative to the prior year. Use Revenue Projection at the start of each quarter to identify accounts at risk of missing full-year targets and initiate recovery conversations before the shortfall becomes material.

Example
Example For Rayler Parts, the dashboard shows a Prorated Actual Amount of $1.82M against a Prorated Planned Amount of $2.0M — a Revenue Realization Rate of 91%. Previous Year Revenue Variance shows -8% compared to the same period last year, indicating the account is not just underperforming against plan but also declining year-over-year. Revenue Projection for the full year is $2.1M against $2.4M planned, flagging an expected $300K shortfall. The key account manager uses this data to prepare a mid-year recovery discussion with the account focused on closing the gap in the second half.

Key Metrics

Metric Description Calculation
Prorated Actual Amount Calculates the revenue earned based on daily actual amounts multiplied by active schedule days up to today or the selection date.

[Actual Daily Amount] * [Actual Prorated Days]

Where Actual Daily Amount = [Derived Actual Amount] / [Total Schedule Days]

Previous Year Revenue Variance (%) Compares the current prorated actual revenue against the exact same prorated period from the previous year. IF [Prorated Actual Amount] > 0 THEN (([Previous Year Actual Amount] - [Prorated Actual Amount]) / [Prorated Actual Amount]) ELSE 0 END
Revenue Projection Projects the expected total revenue by combining the prorated actual amount with planned amounts for valid schedules.

[Prorated Actual Amount] + [Planned Amount]

Where Planned Amount = [Planned Daily Amount] * [Planned Prorated Days]

Revenue Realization Rate The percentage efficiency of actual revenue generated versus planned revenue allocations. SUM([Prorated Actual Amount]) / SUM([Prorated Planned Amount])
Actual vs Planned Variance The net dollar discrepancy showing whether an account is overperforming or underperforming against its schedule. [Prorated Actual Amount] - [Prorated Planned Amount]
 
Loading
Salesforce Help | Article