I'm trying to query the
_Click data view and return a
SubscriberKey for every user that clicked a link in a particular email. I've try several different ways to get at this and none are returning any results. My query validates and runs.
SELECT DISTINCT a.SubscriberKey FROM _Click a Where a.JobID = 12345 AND a.URL = 'https://www.mylink.com?UTM-STUFF'
I tried to write this to a data extension with just one field called SubscriberKey (text, 250 chars) but it didn't return any results.
SELECT a.SubscriberKey, a.JobID FROM _Click a INNER JOIN _Job b ON a.JobID = b.JobID WHERE a.JobID = 59881 AND a.URL = 'https://www.mylink.com?UTM-STUFF'
And many other iterations. But nothing returns any results.
Is there something obvious I might be missing?