Editing the Default Value for Ignored Fields During List Import | Community
Skip to main content
A
Anonymous
August 12, 2014
Solved

Editing the Default Value for Ignored Fields During List Import

  • August 12, 2014
  • 1 reply
  • 1282 views
Hi,

When I import a list from a csv. file, in the preview Marketo automatically assigns any empty columns to 'Phone Number' as the default value. I then have to manually change each of these to IGNORE, which is quite time consuming.

Is there any easy way to change this default value back to IGNORE?


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
I am not sure that you can change what it matches to by default. I believe it is "helping" by looking for a match.

When you load lists, you should only load the columns you want to insert or update. Not only will this prevent you from having to deal with this, but the file will load much faster. If you find a certain field always matching phone number, you should try to exclude them from the upload file.

Also, make sure that your column headers are populated and match Marketo field names. If a blank column header is getting picked up, next time make sure that column has data for the system to read and ignore if it doesn't match a Marketo field name.

Elixiter wrote a great How To Here: elixiter.com/importing-a-static-list-into-marketo/  It even includes a list of some of the most common field names across Marketo and SFDC.

1 reply

A
Anonymous
Accepted solution
August 12, 2014
I am not sure that you can change what it matches to by default. I believe it is "helping" by looking for a match.

When you load lists, you should only load the columns you want to insert or update. Not only will this prevent you from having to deal with this, but the file will load much faster. If you find a certain field always matching phone number, you should try to exclude them from the upload file.

Also, make sure that your column headers are populated and match Marketo field names. If a blank column header is getting picked up, next time make sure that column has data for the system to read and ignore if it doesn't match a Marketo field name.

Elixiter wrote a great How To Here: elixiter.com/importing-a-static-list-into-marketo/  It even includes a list of some of the most common field names across Marketo and SFDC.
Terms & ConditionsAccessibility statement

Loading footer...