All topics
English

Build KPIs and dashboards in Analytics · 3 min read

Create numeric indicators and production goals

Count applications, sum book premium and follow a monthly target with the right definition.

In this guide
  1. Recipe 1: monthly applications
  2. Check comparison and saving
  3. Recipe 2: active-book net premium
  4. Use average, minimum and maximum appropriately
  5. Recipe 3: ten monthly applications
  6. Keep target unit and period explicit
  7. Keep learning

For: CRMDAY One users with the Insurance profile.

Recipe 1: monthly applications

  1. Choose New KPI → Indicator.
  2. Select Policies and Number of records.
  3. Choose Application date and This month in Period and filters.
  4. Leave additional filters empty for all monthly applications, or add the intended product/owner criteria.
  5. Enable comparison with the previous period when applicable.
  6. Name it Monthly applications, describe the criteria, set visibility and create.
Indicator: Policies module and record count.
Indicator: Policies module and record count. Open the image to enlarge it.
Monthly applications: event date, range and comparison.
Monthly applications: event date, range and comparison. Open the image to enlarge it.

Check comparison and saving

The fictitious example has six applications this month and six in the compared previous-period portion: 0% change. An ongoing period can compare the equivalent portion of the previous one rather than its entire month.

Choose Only me while validating. After creation, find the KPI in the library and reopen its actions menu. A correct preview does not replace checking the saved definition.

Name, description, visibility and appearance of the new KPI.
Name, description, visibility and appearance of the new KPI. Open the image to enlarge it.
Reusable definitions in the fictitious agency’s library.
Reusable definitions in the fictitious agency’s library. Open the image to enlarge it.

Recipe 2: active-book net premium

  1. Create another Indicator using Policies.
  2. Select Value of a field → Sum → Net premium.
  3. Choose no date restriction to measure the book rather than only recent applications.
  4. Apply Status equals Active.
  5. Name it Active-book net premium, verify currency and create.

The example totals $2,020.00 across 12 active policies. This is the recorded field, not confirmed commission or payment collection.

Net premium sum: US$2,020 across 12 fictitious active policies.
Net premium sum: US$2,020 across 12 fictitious active policies. Open the image to enlarge it.

Use average, minimum and maximum appropriately

Average examines the value per record; Minimum and Maximum show extremes. Use a compatible numeric field and explicit filters.

Policy count differs from covered lives; premium sum differs from policy count. Rename and revalidate when changing the calculation.

Recipe 3: ten monthly applications

  1. Choose New KPI → Goal.
  2. Select Policies and Number of records.
  3. Choose Application date and This month.
  4. Set Goal for the period to 10. For an individual goal, also filter its owner.
  5. Name it Monthly applications goal and create.
  6. Open the indicator to check the applications behind actual performance.

Six of ten is 60%, with four remaining. This KPI target does not automatically update administrative goals in Sales.

Demonstration target of ten applications, with six this month.
Demonstration target of ten applications, with six this month. Open the image to enlarge it.

Keep target unit and period explicit

For a monetary goal, select a monetary sum and enter the target in the displayed currency unit. For quantity, use count. The target must exceed zero; ten is an instructional example, not a production recommendation.

If actual performance looks wrong, check filters, date, access and calculation before changing the target.

Keep learning

Updated October 25, 2026.