2

In Marketing Cloud - I cannot view internal data views (_Sent, _Click, _Open, _Bounce) using a SQL Query Activity. Is access to data views part of business unit set up or is this a permissions issue?

4
  • what is the error message you are getting?
    – EazyE
    Jan 22 '20 at 18:44
  • Here is an example of the message that I get when trying to validate the syntax in SQL Query activity "Errors: [_Job] is not a known data extension or system data view. You can only query existing data extensions or system data views." Jan 23 '20 at 18:03
  • I can add the "ent" to the beginning ("ent._Job") - but then I get only information at the parent level. No information from my specific business unit. Jan 23 '20 at 18:05
  • Also - I have used the same query in other business units for the same client, so I know it works. Jan 23 '20 at 18:05
6

You need to ask support to enable Data Views for your account first.

Check out Zuzanna's article about Data Views. You can start from there..

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.