What data view objects are available in Marketing Cloud and how do you query them?
Suggested answer
Data views are system-managed tables queryable via SQL in Automation Studio Query Activities:
_Subscribers — all subscriber records and status.
_Sent — send event records (JobID, ListID, BatchID, SubscriberID, EventDate).
_Open — open tracking events (IsUnique).
_Click — click tracking events (URL, IsUnique).
_Bounce — bounce events (BounceType: SoftBounce/HardBounce).
_Unsubscribed — unsubscribe events.
_JourneyActivity — Journey Builder activity-level events.
Data views retain data for 6 months. Example: SELECT s.SubscriberKey, o.EventDate FROM _Sent s JOIN _Open o ON s.JobID = o.JobID AND s.SubscriberID = o.SubscriberID WHERE s.JobID = 12345.
Practice content for interview preparation; not an official vendor answer. Verify details against current product documentation.
Community comments (0)
No comments yet.
Sign in or create a free account to add a comment. Comments are moderated before they appear.