Report: Avg Sales Cycle Duration – with Altify

This topic explains the report/widget 'Avg Sales Cycle Duration – with Altify' in the Opportunity Manager ROI dashboard.

The following are covered:

• What the report measures

• How the report is built

• Dashboard widget setup

What the report measures

This report measures the average number of days it takes to close opportunities tracked in Altify within the current fiscal year. It calculates the duration from the opportunity’s creation date to its close date, providing insight into the speed and efficiency of the sales process.

• Metric displayed: Average Sales Cycle Duration = (Sum of individual sales cycle durations ÷ Number of opportunities).

• Used for: Identifying bottlenecks in the sales cycle, benchmarking sales efficiency across teams or regions, and tracking improvements over time as processes are optimized.

How the report is built

Report Type

A custom report type: 'Opportunities with Altify Opportunities'.

Includes standard opportunity fields plus Altify-specific fields for filtering and grouping.

Filters

• Show Me: All Opportunities

• Close Date: Current FY (e.g. Jan 1, 2025 – Dec 31, 2025)

• Opportunities: With Altify Opportunities

Grouping (Outline)

The following rows are grouped:

• Opportunity Owner: Full Name

• Optionally; Region, Segment, or Opportunity Type for deeper analysis

Columns Added (& Summary Formulas)

• Sales Cycle Duration → AVG(Sales Cycle Duration)

• Opportunity Amount → SUM(Amount)

• Additional columns: Stage, Fiscal Period, Lead Source, Type (for context)

Dashboard widget setup

• Visualization: Metric Chart or Gauge

• Metric: Summary Formula (Average Sales Cycle Duration in days)

• Label: 'Avg Sales Cycle Duration – Current FY'

• Filters: None by default; owner, region or opportunity type for deeper analysis.