I want to be able to trigger activities and journeys based on Click behaviours, but from what I understand, to do this I would need to create a SQL query, a Data Extension, automation, and a DE relationship to a journey if I wanted to use it for decision splits and exit criteria.
I want to find a quicker and more scalable solution so that I could reference one Data Extension for all clicks, but I don't know if this is possible (or wise).
The structure: - DE with columns: Contact ID, Email Name, Link Clicked, Date/Time of Click - SQL that populates all Lead/Contact click activity from all emails into this DE - 4x Automations that runs every 15mins of the hour
I'm still very much a newbie with SQL.
Can anyone help me with what the SQL would look like for this scenario? If the scenario isn't possible, could anyone share a simple SQL query that I could use to identify clicks from all emails in a journey?
Thanks in advance!