Report: Avg Sales Cycle Duration – No Altify

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

The following are covered:

What the report measures

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

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

  • Used for: Comparing sales efficiency between Altify and non Altify tracked deals, identifying potential process gaps in non Altify opportunities, and establishing benchmarks for improvement.

How the report is built

Report Type

A standard report type: 'Opportunities'.

Includes standard opportunity fields for filtering, grouping, and calculations.

Filters

  • Show Me: All Opportunities

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

  • Cross Filter: Opportunities without 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 – No Altify – Current FY'

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