Hi Guys, Does anyone know of a good permanent way to record UTM parameters when someone is filling in a form? Because UTM parameters are stored at a lead level, they are overwritten every time a person fills in a form. I have created static lists at an individual program level and then smart campaigns that throw people into different lists depending upon their utms, but this is unmanageable when you have numerous banner adverts running on 6 or 7 websites as well as social posts etc. I can't create dozens of list in every program we are running. Thanks, Gerard

Gerard DonnellyIf your goal is just to have a permanent record of the UTM history for the lead, that is accomplished fairly simply using a UTM history field and token concatenation. E.g., create a field called UTM history and then every time the UTM fields change, you have a campaign that adds the new values into the history field. Trigger: Data value changes, utm_mediumFlow: Change Data value: UTM History, New value = {{system.datetime}}: {{lead.utm_medium}}, {{lead.utm_source}} [....] | {{lead.utm history}}(Obviously replace with tokens for your field names). The last token is the critical one as it brings in the current field value (all existing history) and lets you append the new values to it. There are lots of flavors of this approach in the community that you can find. All this being said - I don't find this approach particularly useful for aggregate analysis and reporting. It is a neat way to see some of the touch history for a specific lead, but it is very difficult to do meaningful attribution based on that field. If getting an aggregate view of the impact of your marketing channels and assigning attribution is your goal, I would not use this approach. Ideally, you would have a Marketo program (or SFDC campaign) for each utm_campaign value that you deploy, and when a person acquires that utm_campaign value they would get added to the program. Now you have a flexible and relatively scalable way of modelling the different campaigns that are represented by those utm_values and you can run attribution reports in Marketo or the analytics tool of your choice, as most of these are based on programs/campaigns. It is also possible to create your history field as structured data (like a JSON array) using a tool like FlowBoost. The JSON can be ingested into an external database and analyzed more flexibly by a BI tool.A lot depends on your what you are trying to do with the data. ---Justin Norris | Perkuto

Your Achievements

0% to

Next /

to gain points, level up, and earn exciting badges like the new !

View All Badges

Open Alert Bar

SOLVED

Permanently Recording UTM Parameters for Campaigns

Hi Yanir,

I'm going to install and give your script a go. Can you tell me what you do with the referrer value? I have the 5 UTM fields for FT and LT, but I just don't quite know what data is coming through the referrer data and where you suggest I house it?

Thanks in advance.

Sean

Sean Richards

Permanently Recording UTM Parameters for Campaigns

Re: Permanently Recording UTM Parameters for Campaigns