I've pulled the last 30 days of data from 3 data view tables (Job, Open, and Click) into 3 different data extensions. I'm attempting to run a query to dump data from my 3 different data extensions into a single data extension. I'm looking to take data from the JobDataView, OpenDataView, and ClickDataView data extensions and put the below data from them into a single data extension, something like this:
| JobDataView | OpenDataView | ClickDataView |
|---|---|---|
| JobID | JobID | JobID |
| EmailID | SubscriberKey | EventDate |
| EmailName | EventDate | URL |
| EmailSubject | LinkName | |
| FromName | LinkContent | |
| FromEmail |
This is what my current query is:
SELECT JobDataView.JobID, JobDataView.EmailID, JobDataView.EmailName, JobDataView.EmailSubject, JobDataView.FromName, JobDataView.FromEmail, OpenDataView.SubscriberKey, OpenDataView.EventDate, ClickDataView.URL, ClickDataView.LinkName, ClickDataView.LinkContent
FROM JobDataView
FULL JOIN OpenDataView ON OpenDataView.JobID = JobDataView.JobID
FULL JOIN ClickDataView ON ClickDataView.JobID = JobDataView.JobID
It seems to only pull in data for SubscriberKey and EventDate, everything else is showing null in query studio. I'm trying to get all of the data points in my table above into a single data extension.
How can I get my query to pull all of the data points above into a single data extension?