data management - last event of any time | Community
Skip to main content
Michael_Soprano
Level 10
February 10, 2025

data management - last event of any time

  • February 10, 2025
  • 1 reply
  • 688 views

How would you approach the task to create manage last purchase / transaction / donation but taking account data management?

One see these options:

a) sent these as a an event and use Datasets override in order to keep some events longer then others (to keep CDP costs at control) 

b) CDP would be build on the top on EDW which would store that data and upload it on a batch basis to CDP

c) build some sort of automation which would enable to transform event data into profile data. However CDP does not provide easy way to do that .... Other platform has features which enables such an automations ...

1 reply

Level 5
February 12, 2025

We have been recently working along the same line. Your options sum up the situation very correctly. My 2 cents on your proposed options

 

Option 1: these are surely event data and TTL can be set up at dataset level (reference: Solved: Re: Setting Time to Live (TTL) for Customer Profil... - Adobe Experience League Community - 714444)

 

Option 2: We have this situation in our case, but we have not implemented it for we had our separate reasons - but it could be a fitting situation

 

Option 3: for latest data retrieval we have implemented this via scheduled query job to stamp the event data into profile level - this might require multiple attributes at profile level (require multiple "latest" attribute such as: latest traversed page, latest purchase amount, latest purchase timestamp etc)

 

 

Michael_Soprano
Level 10
February 13, 2025

Good to know that I am not the only one which faces such a tasks 🙂 

Option3: How often your query runs??

Level 5
February 13, 2025

In our case, it is scheduled at weekly because the campaign is setup weekly. On top of it, the audience is used to filter out only the high value purchases, so the query can work with small and relevant records only.