MC Snippets
Data

Data Extension Definition

Column Name
Customer Key
Field Type
Max Length
Required
Primary Key
ContactKey
ContactKey
Text
255
false
false

Values

/* Welcome to MC Snippets SQL Mode! Run SQL Queries against all the available Data views, share with friends and have fun! Data Views reference: https://help.salesforce.com/s/articleView?id=sf.mc_as_data_views.htm&type=5 */ SELECT j.jobid, j.emailname, j.deliveredtime AS 'SendTime', o.eventdate AS 'OpenTime', s.emailaddress, s.subscriberkey FROM [_job] AS j INNER JOIN [_open] AS o ON j.jobid = o.jobid INNER JOIN [_subscribers] AS s ON o.subscriberid = s.subscriberid WHERE o.isunique = 1