Spliting the Text Values from one text field to multiple other custom fields in Marketo.

Rajesh_Khatri
Level 2

Spliting the Text Values from one text field to multiple other custom fields in Marketo.

Hello,

As you all know that Marketo CONTACTdoes not flows in to Salesforce (SFDC)lead queue, it always creates a duplicate lead in SFDC. Now the challenge is we are creating multiple leads in SFDC and post calling through telemarketing team, the dead leads remain in SFDC as it is for a long period of time. So I thought of creating one TEXT field in SFDC and list down the Lead Number, Lead Status and Dead Reason in that particular field. But as there could be multiple leads for one contact, there field would carry multiple line values. As we cannot create multiple fields in SFDC. Then these values will be pushed to Marketo Contact record. Once I receive them in Text field of Marketo Contact Record, I want to pick up each line from this and place in a different field of Marketo. I will create almost 5 fields in Marketo LEAD1, LEAD2, LEAD3, LEAD4 AND LEAD5. Every line will be placed in a different field. If I am able to do so, then through smart campaigns, I will segment the dead leads and delete them off.

My question is: How can we pick up the first line and place in field LEAD1 and second line in LEAD2 and so on.

Thanks in advance.

Regards

Rajesh Khatri

3 REPLIES 3
SanfordWhiteman
Level 10 - Community Moderator

Re: Spliting the Text Values from one text field to multiple other custom fields in Marketo.

Why not concatenate the values with a ; (and also add a ; at beginning and end) and then use a [contains] filter? I'm not seeing why the values need to be split permanently here.

Rajesh_Khatri
Level 2

Re: Spliting the Text Values from one text field to multiple other custom fields in Marketo.

Hi Sanford,

Thanks for your reply.  I think you are right, even split wont help.

Here is the scenario:

I have contact named "Rajesh" in SFDC he has 4 leads. Now my main field in SFDC "ALL FIELDS" contains all these 4 leads:

     SFDC LEAD ID,  LEAD STATUS, DEAD REASON

1.  00162727ERT, DEAD, NO PRODUCT REQUIREMENT

2.  00132754WEQ, IN PROGRESS

3.  001215423POI, NEW

4.  00892727NMT, DEAD, NO PRODUCT REQUIREMENT

Now the above field is a text field and I just want to delete two Leads which are Dead, those are Number 1 and 4.

How can I pickup these two leads and send for deletion?

SanfordWhiteman
Level 10 - Community Moderator

Re: Spliting the Text Values from one text field to multiple other custom fields in Marketo.

Get a CSV with all the lead IDs that you want to purge (column 1) and the status and reason (columns 2, 3).

Import the CSV using the Marketo REST Bulk Import API, using SFDC Lead ID as the dedupe key. Then run a Smart List to delete the leads.