Skip to content

Instantly share code, notes, and snippets.

@zuzannamj

zuzannamj/joining-data-views.sql

Last active November 11, 2023 15:49
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zuzannamj/7924f0375b33932d3af60a39ab3f63cb to your computer and use it in GitHub Desktop.
Save zuzannamj/7924f0375b33932d3af60a39ab3f63cb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
joining-data-views.sql
select
s.subscriberkey
from _sent s
left join _open o
on s.jobid = o.jobid and s.listid = o.listid and s.batchid = o.batchid and s.subscriberid = o.subscriberid and o.isunique = 1
left join _click c
on s.jobid = c.jobid and s.listid = c.listid and s.batchid = c.batchid and s.subscriberid = c.subscriberid and c.isunique = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment