Help please! Need to limit multiple triggers firing

[Sean_Richards]

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

[Amit_Jain]

Hi Sean,

Would you mind sharing the screenshot for the flow as well? I'll be able to answer this only when I see the full smart campaign setup. DM me if needed.

Also when you say, not able to calculate the score correctly, do you mean, it's doubling up the score sometime?

Regards,

Amit

[Sean_Richards]

Hi Amit,

Here is the flow and also the daisy chain. Essentially, it resets person score back to behaviour score, then kicks off a chain of request campaigns.

The issue is that if this chain is started 3 times from 3 data value changes, yes, it tends to double the end result, or not quite double as there is three campaigns running, all making demographic score changes in parallel.

[Jay_Jiang]

Hey Sean, can't you just make it run once per hour or something? 

You have a 15 minute wait step, meaning any updates to the contact record would have 15 minutes to poll before what ever field triggered the scoring campaign first causes it to run through once and calculate a final score.

Alternatively, you can set up daily batch campaigns for each/groups of the scoring fields and you would cascade the schedule every half an hour accordingly if one calculation relied on a pre-req

[Priyank_Joshi3]

Hi Sean,

1) There's an error which I notice in your flow step where Demographic score should be '=0' instead of 0.

2) Update qualification rules so that each record can qualify once or once every 24hours.

3) Like the way you have used filter to limit records you can also ad more filters say Country is not empty OR email address Is not empty etc..  

4) You can use flow step with request campaign, that way lead with flow from one campaign to another based on it's execution of defined flow step. 

[dubelclique]

Echoing the method suggested in #4 above, we use use individual "Request Campaign" steps in the flow to process each potential individual data value change independently. Each "Request Campaign" flow step looks like this:

If [Field we're scoring on] is NOT EMPTY

Requested Campaign: [Smart Campaign for field we're scoring on]

Default Choice: Do Nothing

Each individual smart campaign processes the score change for that field based on values stored in program tokens. Each individual smart campaign also includes a Send Email step (with no email selected) to help prioritize the campaign against anything else running at the moment. Kind of a hack, but it helps.

--joe

[SanfordWhiteman]

This doesn't help with the potentially parallel execution, however. B/c the issue is that Sean doesn't want independent processing.

[dubelclique]

Interesting... I would have expected a similar problem to what Sean's describing, which we've not seen. Then again, it's also entirely possible we're not seeing as many data values change simultaneously from SFDC.

For my own understanding, do successive Request Campaign flow steps process without regard to those campaigns actually completing?

--joe

[SanfordWhiteman]

---

For my own understanding, do successive Request Campaign flow steps process without regard to those campaigns actually completing?

Yes.

[dubelclique]

Thanks for the clarification, Sanford!