Hello @Michael_Soprano,   To locate the membership of an audience you can use the following SQL statement.   select * from profile_snapshot_export_XXXXX where segmentmembership['ups']['<<segmentID>>'].status IN ('realized'). -- this is for profiles which qualify for the segment.   The segment object...

When exporting segment membership to a batch destination you will need to enter the following text:   segmentMembership.seg_namespace.seg_id.statussegmentMembership.seg_namespace.seg_id.lastQualificationTime Please refer to the following article https://experienceleague.adobe.com/en/docs/experience-...

Hello @Pradeep-Jaiswal    Data Distiller can create a new dataset based upon a conditional statement.  It does not allow for the deletion of records from the profile store and or datalake.     If you are looking to remove records from a the Adobe Experience Platform profile store an option to consid...

Hello @Prabhakar_The_Analyst    Please refer to the following article on how estimates are calculated in the Adobe RTCDP platform.   https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/tutorials/create-a-segment#estimate-and-preview-an-audience   Thanks, Bryan

You can use the following example who have more than 50 identity values.  The dataset name would be the profile snapshot table specific to the Adobe Experience Platform instance. SELECT key, identityCountInGraph, count(identityCountInGraph) as graphCountFROM (SELECT key, cardinality(value) as identi...

Hi @Michael_Soprano , The reason you have multiple is due the merge policies which are present in the Adobe Experience Platform Environment.  The profile snapshot is run daily after the daily segmentation job.

The profile store is a different storage layer than the datalake.   Please refer to the following diagram.

@Michael_Soprano These functions are not directly in the UI, but could be done using the UI functionality for selecting arrays for targeting.

Hi @Michael_Soprano  PQL is the syntax when a segment is created from an API.  You can define values within an array attribute using the UI similar to the following screenshot.

A null value is a relational database term which is used to represent a value which does not exist in the column of the database table. If data is ingested into the Adobe Experience Platform profile store the data will be represented as the text of null or an empty string depending on the transforma...