Interrogating your organization's data in Sitecore CDP

Abstract

Overview of interrogating your organization's data while building segments (Sitecore CDP).

Sitecore CDP enables you to interrogate fields and values to see how much data is available, along with the exact number and percentage of your customer base. For example, it might be widely known that there is a disproportionate number of sunglasses purchased from your retail site that are designed for males. Interrogating the data can reveal that your organization has enough data on specific fields and values to build a rich segment. Interrogating the data can also reveal the audience is equally made up of females and males under 30, from a certain region, and who have purchased at least once in the past six months. 

You can create a segment to interrogate your organization’s data. The difference between creating the segment to interrogate the data versus creating a segment to use in Sitecore CDP, is that you do not have to schedule the segment to be included in your organization's nightly segment build. You do not need to schedule the segment if you are just interrogating your organization's data.

As you interrogate the data, you can see up to 500 fields or 500 values. Anything above this cardinality is not shown in the UI. 

To interrogate the data, you create a segment. As you select fields or values to include, you can hover over the chart seg_cdp_charticon.png icon, as shown in the following image:

Embedded analytics in batch segmentation.

Embedded analytics provides the following details:

  • Total Observations - the total observations of all fields in the selected entity type.

  • Nulls - the total count of null values for the selected field.

  • Unique - the distinct count of values for the selected field.

  • Data Type - the data type of the field.

Interrogating the data helps you immediately determine how much data is available and whether including a field, regardless of the value, will produce rich segment results.