What is the best way to find fields with no data in them, both Marketo only and SFDC fields. I want to try to decommission some fields that are not used and would prefer a full delete rather than hiding.
Don't forget to first bring in each field in the field management area of admin to double check it is not being actively used in any smart lists, reports, smart campaigns, etc.
Hello! I'm also looking for a quick way to identify all empty fields in Marketo, in order do some clean up. My CRM is Microsoft Dynamics. Anyone knows of a add-on that would allow me to do so ?
Well, FlowBoost's FBCounter, if you want to bend its usual use somewhat... pass an object with all possible {{lead.tokens}} in and upsert a counter record whenever you find a value that's non-empty. Then when the run is finished you'll see every field that has values (so the inverse would be the fields that don't have values).
That would definitely work! Can I do this for all my fields with just one webhook ? However, if I have to create a webhook for each field, it's a bit of a long process. If it's not too complicated, I'll surely give it a try.
You can use just one hook -- if you have a number of textarea fields that are non-empty for a given lead, the payload will be large, but shouldn't get out of hand.
.png)