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?– EazyEJan 22, 2020 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."– Becky AllturnaODJan 23, 2020 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.– Becky AllturnaODJan 23, 2020 at 18:05
-
Also - I have used the same query in other business units for the same client, so I know it works.– Becky AllturnaODJan 23, 2020 at 18:05
Add a comment
|
1 Answer
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..
answered Jan 22, 2020 at 16:38
