data management - last event of any time

[Michael_Soprano]

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

[supratim320]

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

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]

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

Option3: How often your query runs??

[supratim320]

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.

[kautuk_sahni]

@Michael_Soprano Did you find the suggestion helpful? Please let us know if you need more information. If a response worked, kindly mark it as correct for posterity; alternatively, if you found a solution yourself, we’d appreciate it if you could share it with the community. Thank you!