SFMC Data Views Atlas.
Relationship-first reference for the Data Views I use most. Click a node in the graph, inspect fields, or generate a JOIN path.
Mapped views
Every page includes fields, notes, direct relationships and links to the current Salesforce documentation used for verification.
_Sent
Subscribers targeted by email sends. Core anchor for send-level tracking joins.
_Open
Email open events, including unique-event flag and triggered-send identifiers.
_Click
Tracked email click events with link metadata and unique-event flag.
_Bounce
Bounce events and SMTP diagnostic information for email sends.
_Unsubscribe
Unsubscribe events associated with email sends.
_Job
Email send job metadata such as email name, status, sender and scheduling information.
_Journey
Journey metadata at the version level: IDs, name, version number, lifecycle dates and status.
_JourneyActivity
Activities contained in journey versions, including the bridge to triggered email tracking.
_Subscribers
Email subscriber addresses and current status at enterprise level.
_BusinessUnitUnsubscribes
Enterprise-level unsubscribe state by business unit. Query from the parent account.
_AutomationInstance
Automation run-level health: status, duration, schedule context and first error detail.
_AutomationActivityInstance
Activity-level execution health for Automation Studio: runtime, activity type, status and error details.
_SMSMessageTracking
MobileConnect SMS send/receive tracking, delivery-status context and Journey identifiers.
_SMSSubscriptionLog
MobileConnect subscription history by mobile number/keyword, including opt-in and opt-out state.
_UndeliverableSMS
Current MobileConnect held/undeliverable mobile-number state and bounce history.