How to Set Up "Accumulative" Attributes for Historical Purchases in Adobe RTCDP?

[yesraptors12]

Hello RTCDP Community,

I'm seeking some guidance on how to effectively track and segment customers based on their cumulative purchase history within Adobe Real-Time Customer Data Platform.

Currently, we have Adobe Data Collection in place with the Web SDK on our conversion 'Thank You' page. This setup captures each purchase event, including transaction details such as the transaction amount, items purchased, and date.

Here's the challenge: If a user makes multiple transactions over time, for example, one for $100 and another for $500, we would like to have an attribute that reflects their total historical purchase amount ($600 in this case).

Could anyone guide me on how to create and update an attribute that accumulates the historical purchase amount for a profile? i.e. we can create segment like "Historical Purchase > $500"

(P.S. There is no CRM in place for historical purchase for us to ingest)

Thank you in advance for your assistance!

Best regards,
Rap

[abhinavbalooni · Accepted solution]

Hey @yesraptors12 

You should be able to achieve this using computed attributes. This is one of the use cases for the attributes.

Have a look at the documentation here: 

https://experienceleague.adobe.com/docs/experience-platform/profile/computed-attributes/ui.html?lang...

Should be pretty straight forward but feel free to reach out if you need further help.

Cheers,

Abhinav