I am trying to segment all subscribers who have clicked Link A(LinkName) which is present in emails that have been sent in multiple sends.
For example in the last week I may have done multiple email sends(which are triggered through multiple jobids). I want all those subscribers to be added to a DE who have clicked Link A(LinkName) across these jobids.
I know that we can use the _click data view to query this data. I set up a query activity for this purpose and selected a target data extension. I tried running the query but the target DE is showing as 0 records. The query is this:
select distinct s.SubscriberKey, s.JobID, s. BatchID, c.LinkContent, c.LinkName, convert(char(19),c.EventDate,20) as ClickDate from [_sent] s inner join [_click] c on s.JobID = c.JobID and s.SubscriberID = c.SubscriberID and c.IsUnique = 1 Where cast(s.EventDate As Date) > cast('2020-01-01' as Date) and c.LinkName =[the name of the link in the email]
Could someone assist me. Is this query correct?