Based on who clicks a certain element in a mail, I'd like to add these subscribers to a journey. So, I have the following in place:
This query populates a data extension hourly (on the full hour)
SELECT c.SubscriberKey, m.EmailAddress, m.Country, m.Language, m.Gender, m.FirstName, m.LastName, m.Store, m.StoreId, c.LinkName FROM _Click c JOIN MasterSubscribers m on c.SubscriberKey = m.SubscriberKey WHERE c.LinkName = 'WeLove_BornholmTable' AND m.Consent_status = 'Confirmed' AND c.EventDate > dateadd(hh,-24,getdate())
The journey is using that data extension for running hourly (on the 30th minute of the hour) The journey consists of both sends and waiting steps meaning that the journey will last 19 days (the last 12 days are pure waiting) which is the amount of time I find apropriate for having the same content sent again.
So, 1) The query is overwriting the data extension 2) The journey has Contact entry - re-entry only after exiting 3) The journey has Contact evaluation - evaluate new records only
Would you suggest seetings differently for 1), 2) or 3) and why? Setting up a journey like this is quite new to me and any advice would really, really come in handy. Thank you!