Unpacking data into multiple fields

Anonymous
Not applicable

Unpacking data into multiple fields

We are populating a custom field with some complex data that tells us a lot about where that lead has come from which populates into MKTO with a + seperating each part of the data so that we can split it out in Excel. The data looks like this:
Samepage-signup+web-SPIO+organic+SIOB-dac+NA+NA+May 10, 2014

I want to split some of that information across several MKTO fields and am looking at a smart campaign which looks like this:
0EM50000000RxWi.jpg

However we would need to use this everywhere we have data entering MKTO and update it everytime we have a new way for leads entering MKTO.

Is there a logic I could use to automatically unpack the data across the required MKTO fields?
Tags (1)
1 REPLY 1
Josh_Hill13
Level 10 - Champion Alumni

Re: Unpacking data into multiple fields

Yes, you would have to keep this list updated with each new camaign value.

Alternatively, why not let the URL parameters and forms auto populate this for you?