Database missing industry fields for majority of leads, how to fix? | Community
Skip to main content
J
Jananim
New Participant
March 30, 2021
Solved

Database missing industry fields for majority of leads, how to fix?

  • March 30, 2021
  • 1 reply
  • 1395 views

Hi all, 


We are trying to clean up our database so we will be able to segment our leads better and move forward with better marketing. We have found a way to take a list of the email domains in Marketo that are missing information and use zoominfo to populate industry. However, I am struggling with how to link it to the specific emails that are missing this information in Marketo. So far, I am planning to map the email addresses by domain in excel and then import them into the marketo database. But I'm wondering if there is a better way to accomplish this?

 

Does anyone have any suggestions?

 

Thanks!

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 SanfordWhiteman

Without development, yes, the easiest way is going to be export to CSV, fix up, and reimport.

 

If you are/have a developer, you might find it easier to merge changes by calling a webhook or using the import API. Also note if you have multiple leads with the same email, you have to use one of these programmatic methods, since the simple UI-based CSV import uses Email Address as the lookup field and will only update a single lead with that address.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
March 30, 2021

Without development, yes, the easiest way is going to be export to CSV, fix up, and reimport.

 

If you are/have a developer, you might find it easier to merge changes by calling a webhook or using the import API. Also note if you have multiple leads with the same email, you have to use one of these programmatic methods, since the simple UI-based CSV import uses Email Address as the lookup field and will only update a single lead with that address.

Terms & ConditionsAccessibility statement

Loading footer...