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:
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?