Is there a faster way to see Field Values in bulk?

Question

Hello, 
This is the first time I'm using Marketo. I come from a Salesforce background. I know in Salesforce for Picklist fields you can go into Object Manager, click an Object with picklist fields, go into the Fields section of that Object, click the Picklist field you want to look at, and within the Picklist field you can see all the values visually associated with that picklist field without running a report. Does Marketo have something similar to this?
 
I've inherited a Marketo Database with over 750 custom fields that have fiscal year references going back to 2014/2015. We are in 2022! Currently I'm using the solution I found here of running a Smart List and adding a filter of "FIELD = Not Empty". Then I'm exporting the data for every single one of these 750 custom fields to see what data is inside it.
 
I'm currently at number 230/750. Please, is there a faster way to do this? No one in our company knows what these fields mean or do after COVID related layoffs so I'm trying to re-establish some order here and much needed Database Cleanup!
 
There was this comment made by Eben Saputra but I have no idea what they are talking about after step 1:
"Devraj Grewal​ suggestion is correct, but there is another (I think) easier, faster solution

Go to any marketing program (or create one)
Drop the required lead field
Select the + button as if you are trying to add multiple value
At the popup, click the drop down and add all value. The Value will be added to the right
Select all values there (CTRL+A)
Copy to Excel"

Thanks,
George

SanfordWhiteman · Accepted Answer

How many people are there your database? Seems to me it might be easier to pull the whole lead database, depending on size, then just crunch this offline.

Darshil_Shah1 · Answer

If you'd like to get the different and unique non-empty values that people have for any of the string field in Marketo DB, you can do following -

1. In the smart list (campaign/smart campaign's smart list), pull in the field of interest's filter from the tree in right into the canvas.

2. In the filter, click on the green + icon (highlighted in the below snapshot) -

3. Click on the arrow on drop down field, this'll pull all the different values the respective field has in the DB. Click on "Add All >>" at the botton of the drop down -

4. This will add all the values available in the drop down in the Selected Values area on the right (snapshot below) -

5. If you have multiple person partitions, it's advisable to house this campaign/SL in the workspace that can see all the person partitions, so that all the unique non-empty field values are pulled from the entire DB.

I'm pretty sure that the instructions you quoted in your post above also depicts the method I stated above. 🙂

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded