Tips for Identifying Bad Data – Identifying Fields with Suspicious Values

Brian_Law_MKTO
Marketo Employee
Marketo Employee

Good data governance is keeping your Marketo database up-to-date, accurate and useful. Here is how to create a smart list to identify fields with abnormal values.

In this example, I created the smart list in my master data management program.

Smart List - Imported and Web Form Records with Possible Field Value Issues

In this example, I am assuming unusual values coming from records created from salesforce.com is intended behavior. If you are interested in reviewing your entire database rather than records created by list imports and web form fillouts simply remove the first filter in the smart list.

pastedImage_0.png

Here are the values used in the smart list above:

??

!

@

$

%

^

I intentionally left out #, & and * which are often used. Feel free to adjust your own smart list according to your requirements.

1032
0