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
Solved! Go to 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"));
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"));
@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.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies