Best way to find empty fields? | Community
Skip to main content
Frank_Breen2
Frank_Breen2
Level 8
October 28, 2016
Question

Best way to find empty fields?

  • October 28, 2016
  • 3 replies
  • 4455 views

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.

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

3 replies

A
Anonymous
October 28, 2016

Frank, we utilized Field Trip app exchange tool in SFDC to analyze the fields and cleanup. Probably that will be helpful.

Devraj_Grewal
Devraj_Grewal
Level 10
October 28, 2016

Frank,

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.

Carl_Delafonta2
Carl_Delafonta2
Level 3
July 21, 2017

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 ?

SanfordWhiteman
SanfordWhiteman
Level 10
July 22, 2017

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).

Carl_Delafonta2
Carl_Delafonta2
Level 3
July 24, 2017

Hi Sandford,

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.

Terms & ConditionsAccessibility statement

Loading footer...