AnsweredAssumed Answered

How to prevent campaign bloat and sfdc campaign status sync

Question asked by Justin Eichelberger on Mar 2, 2018
Latest reply on Mar 6, 2018 by Justin Eichelberger

Hey!  I am having a bit of a conundrum here at work.  I've got our Customer Success Team at Marketo working on it, but I want to open it up to as many potential helpers as possible.  If anyone has any ideas, feel free to chime in.


The problem revolves around having a call to action in an email, how the url for that CTA is tagged with the SDFDC campaign id, and how the future actions taken are recorded in the SFDC Campaign status.  In all of our solutions, scalability or manual resource requirements are the issue.


Let’s dig deeper.

Consider an email with one CTA to an asset download.

The url has a querystring (term is sc, the value is the sfdc campaign id…i.e. sc=982339487). 

That sc code is then cookied on the machine when the recipient clicks the link and goes to the page of the asset. 

The next step is to add the recipient to the SFDC campaign that matches the id, and give it the status that corresponds to the action taken. In this example, “Asset Download”

Any other actions (form fills, asset downloads, etc) that follow the CTA are tagged with the sc code. 

Those actions are then synced to the same SFDC campaign with the new actions status.  Here is a list of some of the statuses:

•    Trialed

•    EP Trial Requested

•    DNSP Trial Requested

•    WSAT Trial Requested

•    Asset Download

•    System Analyzer Download

•    Request for Contact


So, as you can see, an email recipient can start at Asset Download, take a generic trial and get a “Trialed” status, then download another asset to go back to “Asset Download”.

Of course this is all dependent on the recipient not clearing their cookies, or overwriting the cookie with a new sc id (clicking another call to action with a different sc id).


Our sc id process is to look in the URL for a new sc code, if none, look at the cookie for one present, then use a default as last option.


The SFDC campaign statuses are pretty static, but there are 10 statuses for responded. I’ve detailed 7 of them above.


This means there are about 10 (could reduce with a  little bit of grouping, but not much) smart campaigns in Marketo to track each CTA that gets put in an email.  That’s quite a problem on its own. 


Every CTA in an email has these statuses.  And a member can go between them depending on their actions.  And in one email, there may  be multiple CTA’s.  Multiple.


I need a solution to capture the action taken (form fill, asset download, etc.)  I need to get the sc code.  I need to add the person to the sfdc campaign with the proper status. I can’t have 7-10 smart campaigns for every CTA, for every email, for every program. 


X# of programs * Y# of emails * Z# of CTAs * 10 smartcampaigns = too many smart campaigns.

I hope this is enough info to explain the process.  If there are any more questions, I’ll be happy to answer.