Adobe Campaign Standard - Workflow - Query Aggregated Function Performance | Community
Skip to main content
C
Cloudnifier
April 19, 2022
Solved

Adobe Campaign Standard - Workflow - Query Aggregated Function Performance

  • April 19, 2022
  • 2 replies
  • 888 views

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.
    Best answer by Sukrity_Wadhwa

    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!

    2 replies

    B
    Adobe Employee
    bisswangAdobe Employee
    Adobe Employee
    April 28, 2022

    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

      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity ManagerAccepted solution
      Community Manager
      May 16, 2022

      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
      Terms & ConditionsAccessibility statement

      Loading footer...