Velocity token to identify Campaign Run Id during email build

[Thomas_Terry1]

Just a crazy question, likely only answerable by Sanford Whiteman​

Is it possible to use velocity script to identify the Campaign Run Id during the email build process?

Or is this totally impossible?

FYI - I'm not referring to building an email via the UI editor. Instead, it is the automated process that occurs after the campaign is initiated.

[SanfordWhiteman]

To be precise, do you want to include the Campaign Run ID somewhere else in the email, like on a link?

[Thomas_Terry1]

Yes, exactly. We want to use a concatenation of Asset Id, Campaign Id and Run Id to uniquely identify a send. We would append the Campaign Run Id as a URL parameter.

[SanfordWhiteman]

Thomas, sent the solution via email (since I have your address) for now -- will add officially to the blog and link there tomorrow.

[Thomas_Terry1]

Hi Sandy, you are awesome. I look forward to seeing your blog post on the topic.

[Vimal_Ghosh]

Can you please provide the solution. I have a similar scenario

[SanfordWhiteman]

https://blog.teknkl.com/campaign-campaignrun-program-email-ids-in-velocity/

[Vimal_Ghosh]

Thanks. Is there a way to get the CampaignRunId as part of the Webhook. I wanted to send that id to an external system when the email is triggered. Also, is there a way to get a custom attribute included within an email when the open event is triggered

[SanfordWhiteman]

You can't use Velocity in webhooks (well, not unless you do some very crazy things that aren't suitable for a Community post).

You can't change the default open logging but you could include your own custom open-tracking pixel if you insisted on it.

I have to wonder why such a setup is necessary. What are you trying to do, really? Note Mark's comment about the Campaign Run ID.

[Vimal_Ghosh]

We have campaigns created within Marketo which uses different email templates. Emails contains placeholders, which will be replaced by actual values from a lead record using tokens. The trigger here is a change in the values for specific fields in lead record. The values are changed by an external system using Marketo APIs. So this campaign can be executed multiple times and leads can receive emails multiple times. We have a unique identifier from the external system which trigger these changes. I can include this in our Lead record as well. However, wanted to get that data once the user opens the mail. Essentially trying to understand whether the trigger initiated by the external system is effective or not and there are back office operations after that. So, I am hoping to tie the campaign , a particular run, the lead and the unique identifier which triggered the decision. Any inputs here is highly appreciated