Boolean Count

Anonymous · ‎10-31-2016

We have multiple boolean fields used in part of our segmentation.

What I would like to do is sum up the "True" values of these fields and denote this number in a separate field.

Is there a way to do this inside of Marketo? The boolean values change on a weekly basis.

Thank you

And if it can avoid using a Score Field on the original boolean field that would be best as multiple processes check the field and could leave to inflated numbers

Message was edited by: Josh Hampleman

Justin_Norris1 · ‎10-31-2016

I like Courtney's suggestion best, although if you need a solution that doesn't involve a round trip to the CRM, you can also check out FlowBoost (do a search in these forums for more info) or the Hoosh Excel webhook.

Also, I know you mentioned you didn't want a score field, but...

I'm not sure why you couldn't have a central processing campaign that you could schedule on a recurring basis. At that point you could zero out the field and recalculate it, e.g.,

If Boolean A = True, booleanCounter +1

If Boolean B = True, booleanCounter +1

etc.

Then you can reference that booleanCounter field anywhere you want, but the calculation of it is centralized, so I don't believe it would lead to inflated numbers.

View solution in original post