Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

manjulap9198882
Level 1
Level 1

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

1 Accepted Solution
pablo_rosero1
Correct answer by
Level 10
Level 10

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

View solution in original post

1 Reply
pablo_rosero1
Correct answer by
Level 10
Level 10

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

View solution in original post