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?QueryData-Extension

  • 1
    Can you provide the SQL outside of an image and show what error you are receiving? Feb 22 '18 at 14:16
  • Need more info regarding error as Gortonington said. The ENT. activity is used when the data extension is outside the business unit (ie. shared or parent). You might start there. Feb 22 '18 at 14:55
  • What error are you getting? Feb 24 '18 at 7:50

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

  • I already tried that, but still receive the errors -_-
    – Ben
    Feb 23 '18 at 12:54
  • Can you provide the error message you receive? Feb 23 '18 at 13:00

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.