Data Views

Query system data views using Automation Studio for up to six months of Marketing Cloud Engagement subscriber and journey information.

When you create an SQL Query activity, you write the SQL statement that defines the query. You can write the query against a data extension or the data views provided in the system. Click and open tracking data displays in Central Standard Time, doesn’t observe Daylight Savings Time, and is rounded to the nearest second.

Note When profile attributes are created in Enterprise 2.0 accounts, new columns are added to the _EnterpriseAttribute table. Data view queries in Enterprise 2.0 accounts can return results from profile attribute columns in addition to the columns listed here.

Note If Add subscribers to this list isn’t selected for a triggered send, some data is not available at the enterprise level. Enterprise-level data views don't include sends, opens, clicks, unsubscribes, Forward To A Friend data, and bounces. You can find this data by querying data views in the sender's Marketing Cloud Engagement account.

Note Some data views allow you to retrieve more than six months’ data. However, queries returning large datasets can take longer to process and can impact system performance.

• Data View: Automation Instance
  Get a big-picture view of all automations within a tenant, and improve the efficiency and success rate of your automations by reviewing automation health. Query the _AutomationInstance data view in Automation Studio to prevent failures by identifying long-running processes, and fix failed automations by addressing the cause of failure.
• Data View: Automation Activity Instance
  Improve the efficiency and success rate of your automations by reviewing automation activity health. Query the _AutomationActivityInstance data view in Automation Studio to prevent failures by identifying activities that often fail or run long.
• Data View: Bounce
  To view bounce data for emails sent from your account, query the _Bounce data view in Automation Studio. Bounce data is retained for six months.
• Data View: BusinessUnitUnsubscribes
  To find unsubscribe data for subscribers in your account at the enterprise level, query the _BusinessUnitUnsubscribes data view in Automation Studio. You can run this data view on the parent account only and not on child business units.
• Data View: Click
  To view click data for emails sent from your account, query the _Click data view in Automation Studio. Click data is retained for six months.
• Data View: Complaint
  To view complaint data for emails sent from your account, query the _Complaint data view in Automation Studio. Complaint data is retained for six months.
• Data View: EnterpriseAttribute
  To view your subscribers and their profile attributes, query the _EnterpriseAttribute data view in Automation Studio.
• Data View: FTAF
  To view data about messages that were forwarded to friends, query the _FTAF data view in Automation Studio. Forward data is retained for six months.
• Data View: GroupConnect Contact Subscriptions
  To view active LINE followers and users who have blocked your brand, query the data view in Automation Studio. With Contact Subscriptions, you can view your current subscribers each day.
• Data View: GroupConnect MobileLineOrphanContactView
  To view orphaned contacts, query the _MobileLineOrphanContactView data view in Automation Studio. Contacts are orphaned when a GroupConnect contact import has multiple ContactKeys for the same LINE Address ID.
• Data View: Job
  To view email send job data, query the _Job data view in Automation Studio.
• Data View: Journey
  To find a journey's status, created and last modified date, and other general journey information, query the _Journey data view.
• Data View: Journey Activity
  To view data about activities used in your journeys, use the _JourneyActivity data view in Automation Studio.
• Data View: ListSubscribers
  To view subscribers on lists in your account, query the _ListSubscribers data view in Automation Studio.
• Data View: Open
  To view email opens for your account, query the _Open data view in Automation Studio. Open data is retained for six months.
• Data View: Reconcilable Disposition
  To view reconciliation disposition data for emails sent from your account, query the _ReconcilableDispositionView data view in Automation Studio. Data is retained for seven days.
• Data View: Sent
  View the subscribers you sent emails to by querying the _Sent data view.
• Data View: SMSMessageTracking
  To view your message send and receive history from MobileConnect SMS sends, query the _SMSMessageTracking data view. Information from this query relates to the owner of a private short code or long code. Query information can also relate to a client using a shared short code to which the subscriber has opted in.
• Data View: Social Network Impressions
  To view impression data on content shared from your email sends via Social Forward, query the _SocialNetworkImpressions data view in Automation Studio.
• Data View: Social Network Tracking
  To view tracking data on content shared from your email sends via Social Forward, query the _SocialNetworkTracking data view.
• Data View: Subscribers
  To view email subscribers and their statuses, query the _Subscribers data view in Automation Studio. Subscriber attributes aren’t available. This data view only returns results at the Enterprise level, and not for child business units.
• Data View: SMSSubscriptionLog
  To find subscription log information from MobileConnect SMS sends, query the _SMSSubscriptionLog data view in Automation Studio. For example, you can view a history of all mobile numbers subscribed to a keyword.
• Data View: Undeliverable SMS
  To find failed SMS message deliveries to MobileConnect subscribers, query the _UndeliverableSMS data view.
• Data View: Unsubscribe
  To find unsubscribes related to your email sends, query the _Unsubscribe data view in Automation Studio.