How to get sum of last 2 purchase amount of each customer in ACS

manjulap9198882

04-02-2020

Hi,

I have linked the profile schema with transactional custom schema by using customer ID field in Adobe Campaign Standard. Now i want to pull customers whose last 2 bills total amount is greater than $1000. By using collection option (in additional data section in query) i am able to fetch the last 2 transactional records. But aggregate function is not working on collection data. Could you please help me to achieve the same.

 

Thanks,

Manju

Accepted Solutions (1)

Accepted Solutions (1)

pablo_rosero1

08-04-2020

Hi @manjulap9198882,

 

Sorry for the delay in responding. I'm not entirely sure but if you're using Aggregate then follow these instructions on and after number 3. Make sure it's numerical and the data is correctly set.

 

https://docs.adobe.com/content/help/en/campaign-standard/using/managing-processes-and-data/targeting... 

 

Hope this helps!

Pablo

Answers (0)