UpdateOctober 9, 2025

Distinct Count Aggregate Property in Segments

Distinct Count Aggregate Property in Segments

The new Distinct count aggregation enables you to filter users based on the number of distinct values of a property, which is ideal for use cases that require a broad range of engagement.

Why it’s useful

  • Distinct count answers: “How many different X did the user have/do?”

  • Regular count answers: “How many times did the user do X (total)?”

Example:

Create a segment of users who performed “Order Place” in the last 90 days. Apply Distinct count on the attribute product_category ≥ 5.

This returns users who purchased from 5 or more different categories recently.

If you used a regular count ≥ 5 instead, you’d include anyone with 5 purchases total, even if all were from a single category.

What you can count distinctly

You can apply distinct count to attributes or time:

Attributes

  • Any event attribute (e.g., product_categorybrandstore_id)

Time

  • Date: Unique calendar dates. Example: Distinct count = 3 → purchases on 21-07-202524-08-202521-10-2025.

  • Day: Unique day numbers 1–30/31 (useful for patterns across months). Example: Distinct count = 3 → purchases on days 212425 (any months).

  • Month: Unique months. Example: Distinct count = 3 → purchases in JanuaryMarchAugust (any years).

How to set it up

To use this feature, create a new segment. Add an event and optionally an attribute (if required). Next, click the dropdown under the ‘Where’ option and select ‘Aggregation’. From the subsequent dropdown, choose ‘Distinct Count of Property’. Then, select the attribute or time-based property you want to count and define the desired number of distinct counts.

Image

Tips

  • Use Distinct count when you care about variety/uniqueness (e.g., category breadth, store diversity, unique purchase dates).

  • Use Regular count when you care about volume/frequency (e.g., total purchases, total sessions).

Share this post

Was this page useful?