Profile creation date in Experience Platform

[edgar_herrera]

Using the Profile Count Trend graph, from the Profiles section, I detected an increase in new profiles added to the Adobe Experience Platform on a specific day.

I tried to get the primary identity of those profiles that entered that specific day using the Query Service, querying the Profile Snapshot dataset using the _repo.createDate value as a filter, but the values are not close to what I detected in the graph. This may be because, according to the business model, a customer can buy without being registered in the store, i.e., a customer can perform a transaction without having customer attributes, such as createDate, registered in Experience Platform.

Is there a way to get those new profiles created on that specific day?

Thanks in advance

[Kumar_Saurabh_ · Accepted solution]

Hi @edgar_herrera ,

By using the _repo.createDate from the Profile Snapshot dataset you can only fetch all the profiles created on that day using Individual Profile class Datasets.
In addition, you can fetch all the Identities from the Event dataset who have transacted that day and were the first-time transactors. 
Sample query:-
SELECT DISTINCT customerid
FROM   transaction_dataset
WHERE  timestamp = Date("yyyy-mm-dd")
       AND customerid NOT IN (SELECT customerid
                              FROM   transaction_dataset
                              WHERE  timestamp <> Date("yyyy-mm-dd")); 

[NimashaJain]

@edgar_herrera Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.