SOLVED

Field Values Report

Go to solution
Anonymous
Not applicable

Field Values Report

I've got a few fields with dirty data. I want look at what the spread of values are so I can clean up this data.  Does Marketo have a report or functionality that could help with this?
Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Field Values Report

Run a smart list, "name of field = not empty"

export all the values and do a pivot table in excel.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Re: Field Values Report

Run a smart list, "name of field = not empty"

export all the values and do a pivot table in excel.
Anonymous
Not applicable

Re: Field Values Report

Thanks Sierra!   Does this work with large databases (>3 mil)?
Anonymous
Not applicable

Re: Field Values Report

Hi Tiffany,
I might be wrong and you can test it but when you run the smart campaign you will get leads which you can export. When there are 3million leads you cannot import them to Excel because it's limited around 60000 records.

When you want to see the different values and there are not too much you could also filter for the field, click in the value field and Marketo will display different possible values.
0EM50000000RxPF.jpg
After that you could run several smart campaigns to get the numbers on how many people have the different values.

Best regards

Steffen