Calculate segment audience size in Sitecore CDP
It is best practice to calculate the audience size of a segment when you create it or add a new rule in the segment builder. This is particularly useful when working with multiple rules, as it ensures you are using the intended comparators. Additionally, calculating the audience size allows you to view a sample guest_ref records included in the segment.
In advanced mode, you can also calculate the audience size within the SQL editor.
Calculate the audience size in the segment builder
To calculate the audience size in the segment builder:
-
After you create and add rules to a segment, click Validate to make sure the segment query contains no errors.
-
After validation succeeds, click Calculate Audience. When finished calculating, the audience size displays as:
-
An integer under Guests in segment.
-
A percentage of the total guests under Segment VS total guests.
-
-
Click View sample. The View Execution Sample dialog displays a maximum of 10
guest_refsthat are included in the segment results. -
Click
icon to open the guest profile in a separate browser window.
Calculate the audience size in the SQL editor
To calculate the audience size in the SQL editor when in advanced mode:
-
After you create a segment by writing an SQL query, on the Calculate audience tab, click Validate to make sure the segment query contains no errors.
-
After validation succeeds, click Calculate Audience. When finished calculating, the audience size displays as an integer and a percentage of the total guests.
-
Click View sample. The View Execution Sample dialog displays a maximum of 10
guest_refsthat are included in the segment results. -
Click
icon to open the guest profile in a separate browser window.