--- schema_version: "1" id: f7307074d66818bf53f5c8b1f4d013a76a1762e6a8cd5299ff97c4d5d3677ff1 title: Data Views collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_data_views.md canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_views.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 85e8ebfb6ba12bbc608b5d0f5b359fa7bd096d061bbae0a792bcccfa5d2c1e11 description: Query system data views using Automation Studio for up to six months of Marketing Cloud Engagement subscriber and journey information. products: - Marketing - Marketing Cloud Engagement release: "264" --- # 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png) 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png) 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png) 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_automation_instance.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_automation_activity_instance.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_bounce.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_businessunitunsubscribes.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_click.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_complaint.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_enterpriseattribute.htm&release=264.0.0&type=5)** To view your subscribers and their profile attributes, query the \_EnterpriseAttribute data view in Automation Studio. - **[Data View: FTAF](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_ftaf.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_groupconnect_contact_subscriptions.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_orphaned_contact.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_job.htm&release=264.0.0&type=5)** To view email send job data, query the \_Job data view in Automation Studio. - **[Data View: Journey](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_journey.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_journey_activity.htm&release=264.0.0&type=5)** To view data about activities used in your journeys, use the \_JourneyActivity data view in Automation Studio. - **[Data View: ListSubscribers](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_listsubscribers.htm&release=264.0.0&type=5)** To view subscribers on lists in your account, query the \_ListSubscribers data view in Automation Studio. - **[Data View: Open](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_open.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_reconcilable_disposition.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_sent.htm&release=264.0.0&type=5)** View the subscribers you sent emails to by querying the `_Sent` data view. - **[Data View: SMSMessageTracking](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_sms_message_tracking.htm&release=264.0.0&type=5)** 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 by using a shared short code to which the subscriber has opted in. - **[Data View: Social Network Impressions](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_social_network_impressions.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_social_network_tracking.htm&release=264.0.0&type=5)** To view tracking data on content shared from your email sends via Social Forward, query the \_SocialNetworkTracking data view. - **[Data View: Subscribers](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_subscribers.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_sms_subscription_log.htm&release=264.0.0&type=5)** 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](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_undeliverable_sms.htm&release=264.0.0&type=5)** To find failed SMS message deliveries to MobileConnect subscribers, query the \_UndeliverableSMS data view. - **[Data View: Unsubscribe](https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_unsubscribe.htm&release=264.0.0&type=5)** To find unsubscribes related to your email sends, query the \_Unsubscribe data view in Automation Studio.