Definition
Age in Salesforce is a calculated value representing the number of days a record has been open or in a particular state. It is commonly used in reports and dashboards to track how long Cases, Opportunities, or Leads have been active, helping teams identify stale records and prioritize their workload.
Real-World Example
A sales director at Forge Dynamics runs a report showing the Age of all open Opportunities. She notices that 15 deals have been sitting in the "Negotiation" stage for over 60 days. She flags these as at-risk and schedules pipeline review meetings with the responsible reps to either advance or disqualify them.
Why Age Matters
Age in Salesforce is a critical metric for identifying records that require immediate attention or action. Unlike static fields, Age dynamically calculates the number of days a record has existed in its current state—whether that's an open Case, stalled Opportunity, or aging Lead. This real-time calculation is essential because it surfaces stale records that might otherwise fall through the cracks, directly impacting sales velocity, customer satisfaction, and team accountability. When you build reports or dashboards with Age, you're creating visibility into workflow bottlenecks and helping teams prioritize their efforts on records that have been languishing.
As organizations grow, without Age-based visibility, records naturally accumulate in early stages without triggering urgency. A 120-day-old Lead rarely converts; a 90-day Case without closure damages customer trust and increases escalation risk. Without Age, managers lack the data-driven trigger to coach reps or reassign work, leading to forecast inaccuracy and missed revenue. Age empowers teams to establish SLAs (Service Level Agreements), escalation protocols, and pipeline health checks that scale across hundreds or thousands of records, turning passive record tracking into an active management discipline.
How Organizations Use Age
- TriplePoint Insurance — TriplePoint's customer service team configured an Age formula on their Case object to track days elapsed since a Case was opened. They created a dashboard showing Cases grouped by Age brackets (0-7 days, 8-14 days, 15-30 days, 30+ days) and set an automated workflow to escalate any Case older than 45 days to a supervisor. Within two months, their average Case resolution time dropped from 38 days to 22 days, directly improving their CSAT scores from 72% to 86%.
- Velocity Sales Solutions — Velocity's sales directors built an Opportunity Age report to identify deals stuck in early stages. They discovered 23 Opportunities had been in 'Prospecting' for over 100 days—either stale or misqualified. Using Age as a filter, they created a quarterly 'pipeline hygiene' process where reps must either advance opportunities or mark them as lost. This resulted in a 34% reduction in dead-weight pipeline and improved forecast accuracy by eliminating phantom deals from projections.
- Nexus Staffing Services — Nexus uses Age on their Lead object to trigger nurture campaigns and lead scoring rules. Leads older than 60 days but never contacted are automatically flagged in a custom field and re-routed to a 'warm lead' team rather than languishing in the original rep's queue. They also use Age in a report combined with a COUNTIF formula to identify reps whose average Lead Age exceeds company benchmarks, enabling targeted coaching conversations. This approach increased lead-to-conversion velocity by 28% and reduced lead decay.