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

Switching field values in bulk

  • March 20, 2023
  • 3 replies
  • 1624 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

Darshil_Shah1
Darshil_Shah1
Community Manager
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. 🙂

 

    Michael_Florin-2
    Michael_Florin-2
    New Participant
    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}}

    SanfordWhiteman
    SanfordWhitemanAccepted solution
    New Participant
    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. 

    Terms & ConditionsAccessibility statement

    Loading footer...