I read a lot about the query activity and Data View: Click, but I can not get this query activity to run.
In an AMP scripted multilingual Double Opt-in process I want to check the click on a confirmation link to accordingly split the journey. Engagement Split is not working here so I need to use the decision split.
I have built up a DE with all fields as described here. Then I tried to do it this way with no success.
How should my SQL looks like, if I want to use a field in the decision split "Click on Confirmation-Link TRUE or FALSE". Linkname/alias is 'Confirmation'.
Thanks for your help Oliver