Profile creation date in Experience Platform | Community
Skip to main content
E
edgar_herrera
March 4, 2024
Solved

Profile creation date in Experience Platform

  • March 4, 2024
  • 2 replies
  • 1318 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Kumar29917170hcyp

    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")); 

    2 replies

    K
    Adobe Employee
    Kumar29917170hcypAdobe EmployeeAccepted solution
    Adobe Employee
    March 5, 2024

    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
      Adobe Employee
      NimashaJainAdobe Employee
      Adobe Employee
      March 15, 2024

      @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.

      Terms & ConditionsAccessibility statement

      Loading footer...