1 of 1 people found this helpful
There are 2 ways to do this:
1. May almost be too obvious for you to have thought of: in your scoring SCs, always bump up the aggregate as well as the individual.
2. Call a webhook, which will keep the aggregate in line with the individuals each time it's called.
I would add a 3rd option to Sandy's fine suggestions - assuming you use Salesforce.com:
3. Create a formula field in SFDC to sum the different scores.
The downside of this method is that the scoring aggregation only occurs if and when the person gets synced to SFDC.
BTW - I hope I'm not violating forum rules by mentioning that Sandy provided an excellent webhook for a client of mine a year or so back that performed a similar function.
Thanks for the great suggestions!
We do have a CRM, but it's not SalesForce. So our data is powered by a Custom DB where the Lead Score fields live.
Sounds like the (obvious :-) ) suggestions by Sanford to increment the Aggregate at the same time we increment the Product Lead Score is the easiest way to go.
That'll work, yep (+ pls mark my answer as Correct when you get a chance).
The 'hook is only necessary when you need thresholds, multiplication, or other fancy conditions.
Note that Denise's mention of the "other side" doing the calculation could well apply to a custom DB, too: any SQL database can use triggers or calc'd fields.