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.

  • I recommend editing your question title to something like "Querying for clicks by link" in order to make it more easily found by other users, since the question is not specific to your links' business purpose. – Chris Nov 10 '16 at 20:48

The _Click data view contains fields URL and LinkName that can be used to break down engagement by link.


, count(*) as [Clicks] 
from _Click with (nolock) 
where JobID = 1234


| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.