You are here:
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.
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] |
