Skip to main content
KaitlynNelson1
Level 3
July 6, 2022
Solved

How to see if behavior and demographic add up to person score

Hi there, 

 

Wondering if anyone has an easy way to see if demographic and behavior score equals person score. I have created a view so that I can just see the 3 scores, but I would like to be able to see at a glance how many of the scores do not add up in the person score. I am assuming it might be best to export the database and work in excel to create a formula, but I am no excel magician so not sure how to do that. 

Any help is appreciated!! 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Darshil_Shah1
Darshil_Shah1Accepted solution
Adobe Champion, Community Advisor, UG Leader
July 6, 2022

You can use a webhook to accomplish this (if exporting data to excel and validating there is not an option due to a large number of records). The webhook can validate if the Demographic and Behavior Scores added together equals the Person Score or not and write the response back to a field in Marketo.

 

Validating this in excel is also not very complex, it's just basic arithmetic formula added within a if condition to check if the demographic and behavior scores added together match the person score or not. This may be a viable option if the db size is not that large.

 

View in thread

1 reply

Darshil_Shah1
Adobe Champion, Community Advisor, UG Leader
Darshil_Shah1Adobe Champion, Community Advisor, UG LeaderAccepted solution
Adobe Champion, Community Advisor, UG Leader
July 6, 2022

You can use a webhook to accomplish this (if exporting data to excel and validating there is not an option due to a large number of records). The webhook can validate if the Demographic and Behavior Scores added together equals the Person Score or not and write the response back to a field in Marketo.

 

Validating this in excel is also not very complex, it's just basic arithmetic formula added within a if condition to check if the demographic and behavior scores added together match the person score or not. This may be a viable option if the db size is not that large.

 

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...