What is the best way to configure a MC Journey with decision splits evaluated against a field from SFDC? As the value of the field changes over time the decision split should evaluate against the current value.
I have a salesforce data entry source based-off Campaign and Campaign Members. The decision split evaluates Campaign Member status after a set date. The Campaign Member Status changes in SFDC over time, a second decision split re-evaluates the status at a later time.
Both decision splits are based off Contact Data of the DE from the Entry Source created by MC. The decision split evaluated the static data and not against the current value from SFDC. The problem is that the statuses are not refreshed in the DE when status values are changed in SFDC.
I also attempted to select a different Contact Data, e.g. synchronized salesforce data extension, but decision split only shows Entry Source DE. See screenshot below.