Switching field values in bulk | Community
Skip to main content
K
KT_CD
Level 2
March 20, 2023
Solved

Switching field values in bulk

  • March 20, 2023
  • 3 replies
  • 1632 views

I uploaded a list that had company name and job title values switched (example: Job Title: Google, Company: Marketing Automation Manager). Is there anyway to run a retrofix in bulk for this?

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

Not built-in. You could use a webhook-enabled service to do this, but if you can just change the CSV and re-merge only those fields you might as well do that. 

3 replies

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
March 20, 2023

Not built-in. You could use a webhook-enabled service to do this, but if you can just change the CSV and re-merge only those fields you might as well do that. 

Michael_Florin-2
Michael_Florin-2
Level 10
March 21, 2023

Or: You use a third field as temporary bucket.

 

Change Data Value: TempField = {{lead.Job Title}}

Change Data Value: Job Title = {{company.Company Name}}

Change Data Value: Company Name = {{lead.TempField}}

Darshil_Shah1
Community Advisor and Adobe Champion
Darshil_Shah1Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
March 21, 2023

I'd just swap the Company Name and Job Title column headers in the CSV file, remove other columns except for Email Address (assuming you haven't changed your de-duplication field for the list import by reaching out to Marketo support), and re-upload the list. 🙂

 

    Terms & ConditionsAccessibility statement

    Loading footer...