Updated Data Views visualization

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.


Questions? Comments?

Leave a comment below or email me at zuzanna@sfmarketing.cloud.


7 thoughts on “Updated Data Views visualization

  1. Dawid M

    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?

    Best, M.

    Like

    1. Marta

      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.

      Like

  2. Pingback: 5 Essential Salesforce Marketing Cloud Data Views | The DRIP

  3. Melanie

    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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s