Marketo Booleans are nullable, but don’t worry about it too much

Boolean fields aren’t only true or false, they also can be null — the unset/unknown state. Whether nullability is cool or cumbersome depends on your attitude.

Velocitip: Find the 𝑿-th 𝒀-day (e.g. 4th Wednesday) of this month

For all its scream-inducing quirks, I still love Velocity. Here's how to automatically compute your next recurring meeting instead of manually updating all the time.

An easy-to-make, hard-to-trace mistake with Bulk Import API payloads

A valid .csv file on disk isn’t necessarily ready to go on the wire to an API. If your app ingests CSVs, gotta remember the edge cases.

Beware the 𝚏𝚘𝚛𝚖.𝚜𝚞𝚋𝚖𝚒𝚝𝚝𝚊𝚋𝚕𝚎(𝚝𝚛𝚞𝚎) footgun

Front end code doesn’t run in isolation, which is one reason the work is so tricky. Like when supposedly “Marketo-aware” vendors forget they’re not the only ones listening for Forms 2.0 events.

Sorting numeric-string-keyed objects in Velocity (like they would sort in JS)

One of our clients recently did a big import of JSON-formatted values into a Textarea field. The result in Velocity, after the usual #evaluate trick to rehydrate JSON, is equivalent

What happens if you leave the protocol (http:// or https://) off email links completely? It’s complicated

Outlook does the right thing sometimes, while everyone else is wrong. Crazy, I know!

Hitting SMTP rate limits at certain domains? Put leads into fixed-size daily buckets (using FlowBoost)

Dealing with rate limits on the recipient side is easy with FlowBoost + a little bucketing logic. (And no, you can’t do this with Random Sample!)

Verifying the mkt_tok was added to Marketo links

A quick old-school troubleshooting tip.