Stack Exchange network consists of 178 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I tried to query _Open and _Click in Automation (Marketing Cloud), but I got errors all the time. Does anybody know what I did wrong?
I don’t think _Open data is recorded at the parent business unit level, only the business unit in which the send takes place. Try dropping the ENT prefix
You have SubscriberKey set as a Primary Key, and with Opens and Clicks you will most likely have multiple records for a SubscriberKey.
Either adjust your SQL to select the first record per subscriber, or remove the Primary Key in your data extension
Required, but never shown