I am looking for a method of capturing a subscriber's click activity in a data extension. Ideally utilising the link Alias combined with the subscriberID.

Simple Use case sample:

Subscriber receives [Email 1] and clicks on "Destination - Spain" and "Destination - Portugal" which link through to our transactional website. On click the subscriberID and link Alias are captured into a Data Extension.

Subscriber receivers [Email 2] which contains an ordered list of destinations and based upon a lookup into the above DE features "Spain" and "Portugal" in the subject line and highlights these two destinations as "FEATURED".

Is this possible?


Yes. You'll need SFMC Support to enable the System Data Views. The _Click System Data View is a record of all clicks by Subscriber. You could write a Query Activity to add rows to a Data Extension.

|improve this answer|||||
  • The theory here is to query all clicks and add rows to a Data Extension, doing so a scheduled or automated process? – Paul Moody Aug 7 '15 at 12:19
  • You could definitely automate it in Automation Studio. – Adam Spriggs Aug 7 '15 at 13:50
  • Simple as that - delayed reaction but this is incredibly powerful. – Paul Moody Apr 22 '16 at 13:10

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.