I am trying to create a query that will pull the unique clicks on a specific link within in the email and also pull acct_number on a daily basis and then do an extract of the DE. I do not need to have Subscriber Key or Email appended to the file. Since this is a file that will be used for a different purpose the less bulky the better. So far I have been able to build a query that will get all of the link click but not a specific link or acct_number to be included. I have been able to get subscriber key but I still need acct_number. Current query:
SELECT DISTINCT o.SubscriberKey as Subscriber_Key ,o.JobID as job_id ,o.EventDate as click_date ,o.IsUnique as is_unique FROM _Click o JOIN _Job j ON o.JobID = j.JobID JOIN _Subscribers sub ON sub.SubscriberID = o.SubscriberID AND CAST(o.EventDate as date) >= CAST(getdate()-1 as date) WHERE o.JobID IN ( '10119480' ) AND o.IsUnique = 'false'