We need some help.
We have a smart campaign that powers our demographic score program logic.
The trigger in this case is designed to fire off when any of the data values changes occur that would affect our demographic score calculation. Therefore, the campaign has triggers for a number of different fields.
See below image:
What we are experiencing is that when a person has multiple data value changes made in Salesforce, when the sync occurs, it causes multiple occurances of the smart campaign to execute.
This causes issues because it not calculating the scores correctly.
I thought that I could circumvent this by adding a field called "demographic score lock", which would get set to true by the first spawn of the campaign as it's first Flow step, however, it doesn't work, unfortunately, multiple executions occur in a split second before the flow step can lock the others out.
So my question is, architectually, how can I have a smart campaign that has multiple triggers, and have a lead qualify for multiple triggers in the same campaign (i.e. data value changes "country" AND data value changes "email"), but limit the system from only executing it once until the first campaign has fully executed? I had a flow step at the end of a bunch of daisy chained request campaigns that sets the lock back to false.
Seriously, any help would be grately appreciated.
Cheers,
Sean