It’s been one and a half years since the original article about Data Views has been published and since then, it’s become the most viewed article on sfmarketing.cloud. I’ve received many questions and comments about it over time, and have decided it’s high time to update the Data Views visualization.
Here’s what has been revised:
- Added the new BusinessUnitUnsubscribes Data View, which allows you to find subscribers in your account and their child business unit unsubscribe data
- Added the GroupConnect Data Views, GroupConnect and MobileLineOrphanContactView which allow you to to view active LINE followers, users who have blocked your brand and orphaned contacts for the same LINE Address ID in GroupConnect Contact Import
- Added relationships between MobileConnect Data Views, SMSMessagetracking, SMSSubscriptionLog and UndeliverableSMS
- Added commas after column names for easier copy & paste into Query Studio
The new visualization is available below in PNG format (click on the photo to enlarge it) and in PDF format that you can download here.
You can also bookmark my new website, dataviews.io, which is an online version of the above visualization.
Please let me know in case you have any comments or further questions about the Data Views or the visualization, I will be happy to address them during the next revision.
Leave a comment below or email me at email@example.com.
7 thoughts on “Updated Data Views visualization”
This is so useful, I use the earlier version regularly!
LikeLiked by 1 person
Hi, What exactly the “JobID” is in tracking Data Views?
My test shows me as in one Journey on one Activity there can be different JobID. How they are assigned?
JobID is a unique identifier for every single action in Marketing Cloud as for example email send. every send, doesn’t matter if with one subscriber or 3000 gets unique JobId. That’s why in the journey the tracking looks a little bit different.
Would be great if you could add Mobile Push data views (Push Address, Push Tag) as well
Pingback: 5 Essential Salesforce Marketing Cloud Data Views | The DRIP
Hello, I love this visualization. Do you know if there’s a view or a way to use views to get the “Not Sents”. I know you can get them from Tracking Extracts, but I would prefer from Data Views if there is a way. Thanks for your help
Hi Melanie, no – unfortunately this info is not available through data views 😦