Field-level reference for 33 Salesforce Marketing Cloud system data views, SendLog templates, and synchronized CRM extensions — types, keys, joins, and example SQL. Open any table in DataViews.pro to build queries with auto-joins and the SQL Sandbox.
Schema reference last reviewed 2026-06-17
_AutomationInstance — Automation Studio run history (1–31 days, real-time, UTC timestamps). One row pe…_AutomationActivityInstance — Per-activity execution within an automation run (1–31 days, UTC). Join JobID to …_MobileLineAddressContactSubscriptionView — GroupConnect LINE follower subscriptions (active and blocked). Requires SYSTEM_D…_MobileLineOrphanContactView — Orphaned ContactKeys from GroupConnect imports when multiple contacts share the …_Journey — Journey Builder journey versions, status, and dates. BU-scoped to where the jour…_JourneyActivity — Activities on the Journey canvas. Join JourneyActivityObjectID to TriggererSendD…_SMSMessageTracking — MobileConnect SMS send and MO/MT tracking. Retained indefinitely; use WHERE for …_SMSSubscriptionLog — MobileConnect keyword subscription history per mobile number. Replaces legacy _M…_UndeliverableSMS — Mobile numbers held after repeated SMS delivery failures. Pair with _SMSMessageT…_MobileAddress — MobileConnect contact demographics (unsupported but still populated). BU-scoped;…_PushAddress — MobilePush device registrations: system tokens, opt-in status, and application b…_PushTag — Tags assigned to MobilePush devices for audience segmentation and triggered send…_Coupon — Coupon definitions for Content Builder Block SDK live content. Requires Block SD…_Sent — Per-subscriber email send events. Parent BU sees all child BU sends. Six-month r…_Job — Email send job metadata (subject, from, classification). Scoped to the BU where …_ReconcilableDispositionView — Final delivery disposition for transactional sends using Sendable Reconcilable D…SendLog — Standard corporate SendLog layout for triggered and journey email sends. Composi…_SocialNetworkTracking — Social Forward tracking events with subscriber-level engagement keys._SocialNetworkImpressions — Social Forward impression events from email content regions. Six-month retention…_Subscribers — All Subscribers list: status, email, and lifecycle dates. Enterprise-level; use …_ListSubscribers — Current list and publication list membership and status for subscribers. No six-…_EnterpriseAttribute — Enterprise 2.0 profile attributes from Email Studio. Parent BU only (Ent. prefix…_Unsubscribe — Unsubscribe events tied to sends (preference center, complaints, list-unsubscrib…_BusinessUnitUnsubscribes — Contacts currently unsubscribed at the Business Unit level (snapshot, not event …Account_Salesforce — Synchronized Account object from Salesforce CRM. Primary key is the 18-character…Contact_Salesforce — Synchronized Contact object. Join to Account_Salesforce on AccountId for account…Lead_Salesforce — Synchronized Lead object for prospect records before conversion to Contact/Accou…_Open — Email open events (image pixel). Seven-day retention in SFMC; six months in stan…_Click — Email link click events with URL, link name, and resolved link content._Bounce — Hard and soft bounce events with SMTP diagnostics. Monitor with _Complaint for d…_Complaint — ISP feedback loop spam complaint events. Results in unsubscribe; pairs with _Uns…_SurveyResponse — Survey question and answer events from email sends. Six-month retention._FTAF — Forward To A Friend behavioral events. Six-month retention.