SOLVED

Switching field values in bulk

Go to solution
KT_CD
Level 2

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?

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Switching field values in bulk

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 solution in original post

3 REPLIES 3
SanfordWhiteman
Level 10 - Community Moderator

Re: Switching field values in bulk

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
Level 10

Re: Switching field values in bulk

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
Level 10 - Community Advisor + Adobe Champion

Re: Switching field values in bulk

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