Field Values Report | Community
Skip to main content
A
Anonymous
June 4, 2014
Solved

Field Values Report

  • June 4, 2014
  • 3 replies
  • 1666 views
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?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by
Run a smart list, "name of field = not empty"

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

3 replies

A
Anonymous
Accepted solution
June 4, 2014
Run a smart list, "name of field = not empty"

export all the values and do a pivot table in excel.
A
Anonymous
June 4, 2014
Thanks Sierra!   Does this work with large databases (>3 mil)?
A
Anonymous
June 4, 2014
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.

After that you could run several smart campaigns to get the numbers on how many people have the different values.

Best regards

Steffen
Terms & ConditionsAccessibility statement

Loading footer...