We have our own custom score calculation, every day our custom score field will be altered and an internal notification will be triggered to sales, I set up the program. What's really challenging is How do I trigger only one alert based on two different people scores. So that one alert knows the other one is triggered hence the next alert is not sent.
See the below example,
Person A - Score(-200) - Score is nearing 0 (-200)
Person B - Score 0 - Score is Zero
We currently have two alerts, Alert-1 - Person A score is nearing Zero and Person B - Score is Zero
Currently both the alerts are triggered, one doesn't know another one is triggered. Ideally if a person reached a score of Zero we don’t want to be notified by Alert-1 (Person A score is nearing Zero). If there is no records with score Zero and a record with Score -200 we need only Alert-1.
Person Name and Score
Person - A Score is -200 (Lesser than 0)
Day - 1
Alert - 1
Score is nearing 0
Person - A Score is -200 (Lesser than 0)
Person - B Score is 0
Day - 2
Alert - 2 (We have a record with score 0, don't send the alert 1)
Any idea how do we handle this in Marketo?
Just to clarify, when you say "two different people scores", are you talking about the different scores of two different people, or about the different values in two different score fields for one person?
I'm interpreting this as the latter.
Sequence of events and frequency of alert is probably the trick here as the few ways I'm thinking you could set this up would be looking at those factors.
The simplest solution that immediately comes to my mind is to create a single smart campaign that can be triggered off both events, where the flow includes a wait step and then a validation to check whether the score has now become zero, sending alert two if true and alert one if false. I would then put a restriction on that smart campaign to allow a person to only run through it once a day (or more/less frequently depending on what best suits you). This would help you control the frequency of alerts going out, and give you some opportunity to check whether the score does become zero before committing to sending alert one.
Hope that helps.
Thanks I appreciate your reply it does helps, I should have been more specific in my case I have a single score field allocated to different persons.
To put it in a simple words If Rafa and Roger finishes a score of -200 and 0 on a single run, I want to send only one Alert to sales specifying Roger has better score than Rafa. If you see my above example I mentioned as Person A and Person B. Agree alerts/sequence of alerts and triggers are tricky just trying to crack this one, actually it opens to lot of other unknown territory.
What is the relationship between these persons... how could I know from looking at Roger that he is competing with Rafa for the AM's attention?
OK, that's a very different scenario from trying to have the same lead trip only one trigger campaign.
In Marketo, leads run through trigger campaigns independently, in the context of only that lead. They have no built-in communication/coordination with each other.
The only way to do what you describe in Marketo is to use a webhook to coordinate across triggers. This would allow you to see Another person with Account Manager = 'Sandy' recently set off an alert, don't send another alert right now.
This is in essence the same thing we do when limiting webinar registrations to one registrant per company/domain (others from the same company get an alert saying they may attend under Joe Registrant's invite). But it can't be done with Marketo alone, you have to integrate a webhook-based counter.
Yes exactly - leads run through trigger campaigns independently, hence one score/alert doesn't know another ones value/triggered. Probably a simple Mathematical function will do (Max, Min).
Create one of a smart list to get the Max/Min score from the database, thoughts?
What're you going to do with the Smart (or Static) List? Exporting to Excel and counting occurrences before reimporting puts you way out of the realm of triggered events.
After over night score calculation, set up a simple batch campaign define a smart list which gives Maximum score from the database and in the flow step use send alert.
You still aren't explaining how you're going to extract a single lead from a batch based on on aggregate calculation. There's no such filter as "max(field) from members".