Consolidating Email Link Performance report links using Excel & VBA

Once more into the breach of Excel, my least favorite app... and yet one I can’t quite eliminate from my life.

The definitive guide to setting up copyright year {{my.tokens}} for Emails and LPs

Don’t settle for sloppy: here’s how you set up auto-updating and time-zone-accurate {{my.tokens}} to output the current year.

Appending the referrer’s query string to the current URL

You can easily transplant UTM-based attribution data from one page to another — as long as the source page trusts the target enough to pass the (full) referrer.

Avoiding the dreaded “Invalid Image URL” error with tokenized assets

In Marketo, tokens are critical to keeping your head on straight. But in some parts of the UI, what you think is special {{token.notation}} is just plain ol’ curly braces.

Switch a Marketo form’s Thank You page based on the current URL

At first glance, you might think I’m just regurgitating a built-in Marketo Forms 2.0 feature. But, surprisingly, it’s not in there until you add a tiny bit of code.

Rounding to the nearest 100, 1000, and so on in Velocity

Rounding to the nearest 10ⁿ in Velocity is a lot harder than you probably think — especially because “rounding” itself has more than one meaning.

Velocitip: Distinguish Alerts from real Emails — and a bit on Email to Salesforce

Copying an email using Send Alert lets sales stay in the loop. Prepending a note (“This is a CC”) to the Subject: or body is even smoother.

De-creepifying ZoomInfo FormComplete on Marketo forms

ZoomInfo’s FormComplete [https://www.zoominfo.com/solutions/formcomplete] plugin is... potentially pretty cool. (I’m not here to endorse any product... though I didn’t say anything mean, which