I am sending out newsletters that I have advertisements in them and I need to be able to pull a list for each advertiser when their link has been clicked identifying those who have clicked. I am sending newsletters a few times a week so it would be easiest if all the links for one advertiser can be hosted in one list. How would I go about doing this? Currently I have a query that is created that jumbles all of the clicks together and I have to manually go through and separate them.
The _Click data view contains fields URL and LinkName that can be used to break down engagement by link.
SELECT URL , count(*) as [Clicks] from _Click with (nolock) where JobID = 1234