Skip to main content
KT_CD
Level 2
March 20, 2023
Solved

Switching field values in bulk

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.
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. 

View in thread

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. 

Translate
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}}

Translate
Darshil_Shah1
Adobe Champion, Community Advisor, UG Leader
Darshil_Shah1Adobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
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. 🙂

 

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...