How much person score has changed in a timeframe | Community
Skip to main content
GerardoH26
GerardoH26
New Participant
May 30, 2024
Solved

How much person score has changed in a timeframe

  • May 30, 2024
  • 2 replies
  • 3147 views

Hi all,

 

I'm trying to build a smart campaign to alert our sales team when the person's score experiences a change of 50 or more in a time period of 6 months. I have made many smart campaigns and tests and none works for me

 

1. This one only affects people whose score is exactly +49 so if a person's score is +50, +51 etc, it won't work...

 

2. The problem with this is that works for new leads in the first 6 months, but if a person has a score of 100 and increases to 103, It will be affected because 

  1. New value is greater than 49
  2. The action happened in past 6 months

It is the same for trigger campaigns so I don't know what to do, I would appreciate it if someone has a good idea or had handled this problem before!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

Sorry, it can’t be done with Marketo Smart Campaigns alone. Your attempts don’t even take into account multiple score changes — they’re dealing with one Change Score activity each!

 

For complex score logic like this you seek help from a webhook-compatible service. You could even use a Google Sheet w/Visualization Query Language: relay each score delta to the Sheet and then use VQL to query a pivot table and get  a lead’s total delta in the past 6 months.

 

(I’d almost always use something more purpose-built but that Sheets setup could be done.)

 

2 replies

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
May 31, 2024

Sorry, it can’t be done with Marketo Smart Campaigns alone. Your attempts don’t even take into account multiple score changes — they’re dealing with one Change Score activity each!

 

For complex score logic like this you seek help from a webhook-compatible service. You could even use a Google Sheet w/Visualization Query Language: relay each score delta to the Sheet and then use VQL to query a pivot table and get  a lead’s total delta in the past 6 months.

 

(I’d almost always use something more purpose-built but that Sheets setup could be done.)

 

    GerardoH26
    GerardoH26Author
    New Participant
    May 31, 2024

    Conclusion: It is not possible to perform this with Marketo.

    I'm not good at coding but I will try this, thanks!

    uditmathur
    uditmathur
    Community Manager
    May 31, 2024

    Hi,

    The solution you are trying to achieve is not straightway possible as Marketo natively can not add 2 numbers.

    A possible way to achieve this is to create a custom score field & set it to "0" for all your leads.

    Then create a trigger campaign to increment this value with same as the person score is added. For eg. if person score is changed with +5 points the custom score field should also be increased by +5 to that the new value to score field to be +5 & so on.

    Than create a campaign to can check when the custom score filed value reaches 50 trigger the Send alert campaign.

    By this you can be sure that the value is changed exactly +50 irrespective of the person score.

     

    Hope this helps.

    GerardoH26
    GerardoH26Author
    New Participant
    May 31, 2024

    I tried implementing this but the problem here is that if a person gets +5 each month, in 6 months will have 30 (it should not notify and it will not notify, so the program is ok) but in 10 months will have 50 (here his score in the last 6 months is 30. And it will notify because the 50 score was reached)

    Terms & ConditionsAccessibility statement

    Loading footer...