Skip to main content
KT_CD
Level 2
Mar 20, 2023 9:42 PM UTC
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
User Group Leader
Mar 20, 2023 10:16 PM UTC

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
User Group Leader
SanfordWhitemanUser Group LeaderAccepted solution
User Group Leader
Mar 20, 2023 10:16 PM UTC

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
Mar 21, 2023 12:08 PM UTC

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
Mar 21, 2023 12:41 PM UTC

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