I am using MC connect and setting a Journey for a Campaign.
I want to update the Campaign Member Status to "open", "clicked" or "not responding" based on engagement with a 3-5 email send journey. If they open any of the emails they become "opened", etc.
My initial thought was to use the JB update Campaign Member Activity after an engagement split. But given that engagement splits only look at a defined email for defined set of time (ie 48 hours), this will miss a portion of my customer interactions.
See this post Looking for Journey Builder Best Practice for Engagement on Multiple Emails which is related
Also by nature of the wait activity, the customer status will not get updated until my wait is over, thus very late (potentially)
So i believe the best solution is write SSJS script to that runs hourly to look at dataviews and update Campaign Member Status.
Or Handle this on the Sales Cloud side (which i do not want to do)
Am i right? other ideas?