Export/See all Field Values

[Anonymous]

Hello all,

is it possible to see or export all values stored in a Marketo String field (free text)?

Thanks in advance.

[Eben_Saputra]

Devraj Grewal​ suggestion is correct, but there is another (I think) easier, faster solution

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

[Devraj_Grewal · Accepted solution]

Vanessa,

You can create a smart list and in the "Smart List" tab bring in this string field as a filter and define it as "is not empty". In the "People" tab of the smart list, create a view to only show this string field as a column. The smart list will then populate with only people who have a value for this string field. You can then export the smart list results​ to view all the field's values.

[Anonymous]

thanks Devraj Grewal!

[Anonymous]

Hello Devraj,

thank you for the quick reply! True, it's quite a roundabout, but your method works. Thanks!