Adobe Campaign Standard - Workflow - Query Aggregated Function Performance | Community
Skip to main content
Cloudnifier
New Participant
Apr 19, 2022 7:27 AM UTC
Solved

Adobe Campaign Standard - Workflow - Query Aggregated Function Performance

I have a requirement on journey below:

1. Import Invoice Header Level Data into ACS including (Invoice ID, Amount, Discount, Coupon Discount etc)
2. Setup a ACS workflow to query profile which meet the requirement based on invoice data, e.g. Query Profile who total spending > $1200 in past 30 days.
3. Workflow will trigger daily to find out the profile who fulfill the requirement and save as audience list.

I would like to know the feasbility on ACS's performance this kind of journey which the total invoice volume is around 30-40 million. Can the ACS workflow work fine on this volume?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Sukrity_Wadhwa
    Sukrity_WadhwaAccepted solution
    Employee
    May 16, 2022 1:12 PM UTC

    Hi @cloudnifier,

    This question was addressed in one of our Adobe Campaign Community Q&A Coffee Breaks on Apr 21st at 8am PT with Scott Segrin, Eric Knee, David Loyd, Peter Mancuso from Adobe Campaign Enterprise Architecture Team. 

    You can check the response here: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic/adobe-campaign-community-q-amp-a-coffee-break-april-21st-8am-pt/m-p/449195/highlight/true#M2227 

    Feel free to reach out on the same thread in case you have any follow up questions.

    Thanks!

    Sukrity Wadhwa
    View reply

    2 replies

    Sukrity_Wadhwa
    Sukrity_WadhwaAccepted solution
    Employee
    May 16, 2022 1:12 PM UTC

    Hi @cloudnifier,

    This question was addressed in one of our Adobe Campaign Community Q&A Coffee Breaks on Apr 21st at 8am PT with Scott Segrin, Eric Knee, David Loyd, Peter Mancuso from Adobe Campaign Enterprise Architecture Team. 

    You can check the response here: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic/adobe-campaign-community-q-amp-a-coffee-break-april-21st-8am-pt/m-p/449195/highlight/true#M2227 

    Feel free to reach out on the same thread in case you have any follow up questions.

    Thanks!

    Translate
    Sukrity Wadhwa
    bisswang
    Employee
    Apr 28, 2022 9:56 PM UTC

    Hi,

    the volume should be fine as long as the proper indexes are used in the data model

    The query may run few minutes but as it's a background job, I don't see an issue with that

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...