SOLVED

Exporting Data

Go to solution
amyvoigt_PBC
Level 2

I am looking to export data from form fills, I know you make a smart list but how do you see all the fields filled out and are you able to export that data?

1 ACCEPTED SOLUTION
SanfordWhiteman
Level 10 - Community Moderator
That's not exporting "full form fill data" in any way. It's exporting the current values of the fields, regardless of how they were updated.

The data from form submissions is starkly different from the data stored on the lead, especially after time has passed. Form fills are a different dimension exportable ONLY via API.

View solution in original post

4 REPLIES 4
PeeyushSachdeva
Level 3

Hi @amyvoigt_PBC,

 

You can export full form fill data from Marketo — including all the fields filled out as follows:

 

1. Create a Smart List with filter you want:

Example: Filled Out Form = [Select your form]

Optionally add constraints like Web Page, Date of Activity, etc.

This list will pull all leads who submitted the form.


2. Once the list loads (In the People Tab:

Click the “View” dropdown (top left) >  Edit View > Choose Fields that you would like to add.

You can select which fields to display: First Name, Last Name, Email, Company, any custom fields, etc.

 

3. Then, Export the Smart List
Once you have the data visible:

Click the “Export” button (bottom center).

Choose:

CSV format

 

Whether to include all visible columns or select specific ones.

 

This will give you a spreadsheet with one row per lead, showing the current value of each field.

 

SanfordWhiteman
Level 10 - Community Moderator
That's not exporting "full form fill data" in any way. It's exporting the current values of the fields, regardless of how they were updated.

The data from form submissions is starkly different from the data stored on the lead, especially after time has passed. Form fills are a different dimension exportable ONLY via API.
PeeyushSachdeva
Level 3

I totally agree with you, @SanfordWhiteman . This method only exports the current values stored on the lead record, regardless of how or when they were updated. To access the full form fill data as submitted at the time of the form completion, it would indeed require using the API, since that level of submission detail isn't directly exportable through the UI.

SanfordWhiteman
Level 10 - Community Moderator

You can only export Filled Out Form data using the API.

 

There’s aren’t column(s) that reflect form fields directly.