ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC TIP | Column must appear in GROUP BY clause

Adobe Campaign Classic tips

Creating aggregated data reports may not be a daily task, but there are times when you might be tasked with generating such reports. For instance, you could group and track log clicks to create the coveted ‘Hot Clicks Report’.

You tell yourself, ‘It’s nothing major,’ and believe you have an idea of how to do it. However, when you set everything up in the enrichment or query activity, you encounter the following error:

25/07/2023 19:31:15 query2 PGS-220000 PostgreSQL error: ERROR: 
column "t0.itrackinglogid" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: 
…nternalName, D2.sLabel, Count(T1.iTrackingUrlId), T0.iTracki…

Long story short Adobe Campaign Classic somehow always adds to the select clause primary key of the targeting dimension, thus never added to group clause and this message will start to haunt us. To remove this error you will need to check following option in Advanced parameters of Add data…

In short, Adobe Campaign Classic somehow always adds the primary key of the targeting dimension to the select clause. To resolve this error, you will need to check the following option in the Advanced Parameters of ‘Add Data…’

Good to remember:

Eventhough Add data... feature exists in Query, Enrichment, Change dimension but the ‘Disable automatic adding of the primary keys of targeting dimension’ only is found in the Query activity

You can only access the Advanced parameters from Edit additional data... So you will spend ages looking for it when adding data

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.

#SQL #workflow
Marcel Szimonisz
Marcel Szimonisz
MarTech consultant As a marketing automation consultant, I specialize in solving problems, automating processes, and driving innovation in my clients' marketing platforms.

I hold certifications in Adobe Campaign v6 (3x certified) and Salesforce Marketing Cloud (5x certified).

Additionally, I serve as a community advisor for Adobe Campaign, offering expert insights and guidance.

In addition to my professional pursuits, I also enjoy exploring various programming languages, CMSs, and frameworks, further enhancing my technical expertise and staying at the forefront of industry advancements.
Take a look at our subscription offering in case you are looking for a Marketing Automation Consultant.

Leave a comment

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

Similar posts that you may find useful

Salesforce marketing cloud journey exit criteria and goals
Marketing Automation, Salesforce Marketing Cloud

SFMC | How to use journey exit criteria and goals

3 minutes read

I might be really slow learning but I learned about this feature two years into working with salesforce marketing cloud, and I said to myself what a nice feature to have. Let me tell you what it is and give you some real life examples when to use it. Exit criteria and goals share a … Read more

Continue reading
SFMC tips and tricks
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | Redirect error inside try catch

1 minute read

If you have Redirect function inside the try catch block, either as mixture of SSJS with AMPScript or only in SSJS, it will throw an 500 – Internal Server Error. Let’s take a look on few examples what can create an error that will take you some quality debugging time to figure it out. And … Read more

Continue reading
Adobe Campaign Classic tips
ACC Tips & Tricks, Adobe Campaign

ACC TIPS | Reselect temporary schema in query

less than a minute read

When working with the Query activity in Adobe Campaign Classic, you have the choice to select either the Temporary schema or the Database schema. If you opt for the Temporary schema, it is essential to reselect it even if it is preselected with a default value. Here’s why it’s important to explicitly reselect the Temporary … Read more

Continue reading
Adobe Campaign post
Adobe Campaign, Marketing Automation

ACC | Implementing DKIM

2 minutes read

Have you ever wondered how to implement DKIM in Adobe Campaign Classic, look no further here is how you can do it. Implementing DKIM for Adobe Campaign Classic, gave many hard times as there is no official documentation you can follow step by step. But nothing is lost, it is easier than you may think. … Read more

Continue reading
Adobe Campaign Classic OOP concepts in ES5
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

ACC | How to utilize OOP in ES5

3 minutes read

In this blog I will be exploring object-oriented programming (OOP) and Adobe Campaign Classic in ES5. As you may already know, Adobe Campaign Classic relies on ES5, the version of JavaScript specifically used by the platform. In ES5, there are a few limitations in terms of what you cannot do compared to newer versions of … Read more

Continue reading