Field Mapping Management when Importing External Lead Sources

0 Likes

Field Mapping Management when Importing External Lead Sources

We need the ability to build field mapping for leads coming in from external systems.

Leads come in from a third-party source. We don't have any influence over what these companies call the fields in their systems. Marketo requires the column headings to exactly match the fields in the Marketo system. Someone on our team must manually process the lead files each week to fix the column headings so Marketo can import the lead data correctly. We have done what we can internally to automate that process as much as possible, but it still takes a person a day per week to process and upload all the files. If we could build field mapping profiles, we could just apply that profile to the file and import.

I had this functionality when working with Silverpop in 2008, and I'm really feeling the deficiency here!

Susan
3 Comments
Anonymous
Not applicable
If you go into admin, and go to field management and select a field, you can add additional import alias options, this might be a solution for you - just add in the variations from your vendors - make sure there aren't conflicts.
Anonymous
Not applicable
Also, when you import it automatically gives you an easy way to add aliases.  You can have whatever you want as the headers.
kh-lschutte
Community Manager
Status changed to: Already have it