All topics
English

Build KPIs and dashboards in Analytics · 3 min read

Create funnels and rankings for team follow-up

Arrange opportunities by stage and rank results by an explicitly defined owner.

In this guide
  1. Recipe: opportunities by stage
  2. Separate distribution from a historical journey
  3. Keep pipeline context coherent
  4. Recipe: yearly applications by owner
  5. Explain what owner means
  6. Combine models in a team dashboard
  7. Keep learning

For: CRMDAY One users with the Insurance profile.

Recipe: opportunities by stage

  1. Create a Funnel KPI.
  2. Choose Deals and Number of records.
  3. Choose Stage as the funnel grouping.
  4. Check period and filters. Without a date restriction this is the current distribution of included records; filter to open opportunities if needed.
  5. Name it Opportunities by stage and create.
  6. Open a stage to inspect its Deals.
Opportunity funnel grouped by stage.
Opportunity funnel grouped by stage. Open the image to enlarge it.

Separate distribution from a historical journey

The ratio against the preceding stage compares group values in this query. It does not prove the same clients passed through every phase or establish historical conversion.

The example has four opportunities in each of three stages. Use the appropriate Sales cohort or stage-passage view for that different analysis.

Keep pipeline context coherent

With several pipelines, ensure the included records and stages belong to the process being analyzed. Similar stage names do not make different workflows equivalent.

Filtering to Open excludes won opportunities. Choosing value rather than count makes widths represent the selected numeric calculation.

Recipe: yearly applications by owner

  1. Create a Ranking KPI.
  2. Choose Policies and Number of records.
  3. Rank by Owner and select Top 5.
  4. Choose Application date and This year.
  5. Name it Applications by Owner — year and create.
  6. Open a position to inspect its records.
Applications ranked by the record’s responsible owner.
Applications ranked by the record’s responsible owner. Open the image to enlarge it.

Explain what owner means

Owner is the record’s responsible user. It is not automatically the credited Producer, NPN holder or commission recipient. Confirm fields and data quality before using a different business interpretation.

Ties are possible. Top 5 may omit part of the team. Compare the same metric, period and criteria.

Combine models in a team dashboard

A dashboard can combine funnel, ranking and portfolio share. Their placement together does not make their filters identical.

The agency-management example presents them as independent cards. Validate underlying records before using them in a meeting.

Share, funnel and ranking in the demonstration dashboard.
Share, funnel and ranking in the demonstration dashboard. Open the image to enlarge it.

Keep learning

Updated October 25, 2026.