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

1 Answer 1


You don't mention what the issue is with Engagement Splits as they sound like exactly what you need here.

In the absence of engagement splits, you could roll your own, but you would need to add your data extension to an attribute group in order to use in a decision split. This is similar to Eliot's answer.

Create Data Extension - (DoubleOptIns) enter image description here

Add Your Data Extension to Contact Model

Add your data extension to an Attribute Group in Audience Builder -> Contact Builder -> Data Designer. You would link the new data extension from Contact.ContactKey to you data extension's SubscriberKey field.

enter image description here

Query Activity

Create a new Query Activity in Journey Builder -> Automation Studio -> Activities. The SQL needed should be similar to this:

    _Click WITH (NOLOCK)
    LinkName = 'Double Optin Link' AND
    IsUnique = 1

And the query should be set to Update the DoubleOptIn data extension:enter image description hereenter image description here


Create a new Automation in the Overview tab of Automation Studio and add your newly created Query Activity. Schedule the Automation to run once per hour.enter image description here

Decision Split

You should now be able to use your new data extension in your Journey Builder Decision Splits.

enter image description here

  • Thanks a lot Andrew. This seems to be exactly what I need. Unfortunately it is not working in my account. I have built it up the way you described, but there is no data populated in the DE "DoubleOptIns".
    – Oliver
    Commented Jun 2, 2017 at 10:07
  • Hi Oliver, What is the "Alias" of your double optin link?
    – Macca
    Commented Jun 2, 2017 at 10:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .