background shape
background shape

How to aggregate data in technical workflow

Every now and then, you may receive a request to aggregate data within an Adobe Campaign Classic workflow. However, if you group by something other than the targeting dimension, you may encounter an error such as “‘w0.iid’ must appear in the GROUP BY clause or be used as an aggregate function.

What do we aggregate in adobe campaign classic? Most likely, you will be tasked to aggregate recipient-generated data, also known as delivery, broad, and tracking logs.

The reason behind Adobe Campaign always adding the primary key to the SELECT clause, in aggregate queries, remains unknown. However, we must find workarounds to deal with this situation. If you cannot avoid grouping by the targeting dimension, here is a fix for you:

Please note that this option is only available in the query activity and cannot be found in the enrichment feature.

  1. In query Add data – create as many aggregates as you want use group by check box where needed.
  2. Save add data modal window when you are done.
  3. Open Edit additional data – on the bottom section you will see Advanced parameters section
  4. In Advanced parameters check following option – Disable automatic adding of the primary keys of targeting dimension.
  5. Finish

Oh hi there 👋
I have a FREE e-book for you.

Sign up now to get an in-depth analysis of Adobe and Salesforce Marketing Clouds!

We don’t spam! Read our privacy policy for more info.

Share With Others

One Comment “How to aggregate data in technical workflow”

  • ParthaSarathy S

    says:

    Useful information..!!

    Reply

Leave a Comment

Your email address will not be published. Required fields are marked *

MarTech consultant

Marcel Szimonisz

Marcel Szimonisz

I specialize in solving problems, automating processes, and driving innovation through major marketing automation platforms.

Buy me a coffee
Optimized by Optimole