How to get sum of last 2 purchase amount of each customer in ACS | Community
Skip to main content
M
manjulap9198882
February 4, 2020
Solved

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

  • February 4, 2020
  • 1 reply
  • 3693 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by pablo_rosero1

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-activities/query.html 

 

Hope this helps!

Pablo

1 reply

pablo_rosero1
pablo_rosero1Accepted solution
Level 9
April 8, 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-activities/query.html 

 

Hope this helps!

Pablo

Terms & ConditionsAccessibility statement

Loading footer...