
Hi all, thought I'd share something we're doing in case it is a help to others. I couldn't find any mention on the picnet support page of SB Mailer support for Google Analytics campaign tracking. I wanted link clicks to show in Google Analytics, grouped by campaign. We set up a process builder flow that, when triggered, updates the destination URL field with:
([sbm__sbx_EmailLink__c].sbm__sbx_DestinationUrl__c) &
IF(RIGHT(([sbm__sbx_EmailLink__c].sbm__sbx_DestinationUrl__c), 1) ="/","",
"/") &
"utm_source=SBMailer&utm_medium=email&utm_campaign=" &
([sbm__sbx_EmailLink__c].sbm__sbx_Campaign__c.Id) &
"&utm_content=" &
SUBSTITUTE(([sbm__sbx_EmailLink__c].sbm__sbx_Campaign__c.Name)," ","%20")
That will take something like "https://ethnos.ca" and turn it into "https://ethnos.ca/utm_source=SBMailer&utm_medium=email&utm_campaign=7011200000162hWAAQ&utm_content=Campaign%20Name"