I would like to use data view _CLICK to extract all a list of all clicked URLs along with the count (how many unique subscribers clicked on the link) for specific job ids.
Can anyone help me with the approach? This is what I got so far
SELECT c.JobID, j.EmailName, c.LinkName, c.LinkContent, c.URL, c.IsUnique, count(*) as Total_Count FROM _Click c INNER JOIN _Job j ON j.JobID = c.JobID where c.JobID IN ('123456','111111') and c.IsUnique = 'true' GROUP BY c.jobid, c.URL
Basically I am looking for an output like this:
It would be great to include email name in the output (if possible).