This might have been answered before but I cant find anything so please point in the right direction if there is something.
I’m trying to build Last Touch reporting for MQLs, so the last point that was touched before they became an MQL - specifially regarding campaigns. There is Last Touch Converting Campaign which is great but Hubspot records the internal data rather than the campaign name. I’ve looked at using the UTM field but that doesnt account for submissions that werent driven there by marketing activity (I would still like to know that it was an asset from that campaign that was the last touchpoint even if its found organically).
The only way I can think to do it is have a step at the end of all my workflows updating the UTM Campaign field, but this doesnt feel scalable and a recipe for disaster?
Does anyone have any other ideas or know if its possible to extract the internal mapping of campaign names?
All help gratefully appreciated
Hi @CDavis_Vertice,
Thank you for posting to the Community!
I understand that you’re seeking a scalable solution to accurately report the last campaign touchpoint for MQLs, including submissions not driven by marketing activities, and are looking for ways to extract actual campaign names rather than internal HubSpot data.
I’d like to tag in some of our Top Contributors to see if they have any ideas -- Hi @HubSpot_Corey@colinwitt and @eburnaman Do any of you all have any advice for @CDavis_Vertice?
Thank you!
Cassie, Community Manager
Yeah thanks guys - it doesnt seem like anyone has cracked this. I’ve even been arguing with Hubspot about the Last Touch Converting Campaign field which absolutely doesnt work the way they claim it does, so even if I could map the internal values it would not be accurate. I’m told they are looking at exposing those internal values though.
The only two ways I can think to do this
- have a hidden field with the campaign name on each form and then map that onto a MQL Conversion Campaign field when the Contact is triggered to MQL stage.
- Envelope the campaign name in the form names and map the campaign name based on Recent Conversion using a workflow - that will get very large very quickly though
Both options have so much scope for error but I think option 1 is the more robust and scalable
I also didnt find any other solution, and I am currently using your 1) opition. I have a hidden field on all forms, that always overwrites, if there was an old value already with the new value (workflow: check if field is empty, if not overwrite it with new value). Another workflow transfers this information to another field, when the contact is converted to an MQL..