Skip to main content
Level 2
May 26, 2026
Solved

UTM Generation in Custom form

  • May 26, 2026
  • 1 reply
  • 14 views

I am  trying to build a calculated field in a Workfront custom form to automatically generate a complete UTM tracking URL based on user-entered campaign parameters.

The goal is for users to populate fields such as Destination URL, UTM Medium, UTM Source, UTM Campaign, and Contact Type, and have the form dynamically concatenate those values into a finalized URL string.

Example desired output:
https://example.com?utm_medium=email&utm_source=newsletter&utm_campaign=springcampaign&contact_type=prospect

Wondering if anyone has done this before as I’m having issues getting the calculated field to generate the final url.  

Best answer by ninoskuflic

Hi ​@SarahLa4, I actually wrote a blog article about this exact thing - I’m sure this can help: https://www.ninoskuflic.com/blog/exploring-marketing-automation-capabilities-with-workfront-fusion-dub-co-and-utms. Do you need the code for the custom calculated field? 😃

1 reply

ninoskuflic
ninoskuflicAccepted solution
Level 5
May 26, 2026

Hi ​@SarahLa4, I actually wrote a blog article about this exact thing - I’m sure this can help: https://www.ninoskuflic.com/blog/exploring-marketing-automation-capabilities-with-workfront-fusion-dub-co-and-utms. Do you need the code for the custom calculated field? 😃

If this solved your issue, please mark it as solved so others can find the solution faster.
ninoskuflic
Level 5
May 26, 2026

If you need the code, this is what I’ve used:

 

CONCAT(
{DE:Website URL},
"?utm_source=", {DE:Campaign source},
"&utm_medium=", {DE:Campaign medium},
"&utm_campaign=", {DE:Campaign name},

IF(
ISBLANK({DE:Campaign ID}),
"",
CONCAT("&utm_id=", {DE:Campaign ID})
),

IF(
ISBLANK({DE:Campaign term}),
"",
CONCAT("&utm_term=", {DE:Campaign term})
),

IF(
ISBLANK({DE:Campaign content}),
"",
CONCAT("&utm_content=", {DE:Campaign content})
)
)

These were my fields:

 

If this solved your issue, please mark it as solved so others can find the solution faster.
Lyndsy-Denk
Community Advisor
Community Advisor
May 26, 2026

Beautiful! In case anyone was wondering: anyone can build the custom form and build the calculation, but with Fusion there are additional whiz-bang things that can happen thereafter.