How do I refer content from a data sheet to an email?

Question

Hello, wonderful Marketo community!I'm working on creating an email that is fairly simple, except for two tiny pieces that are throwing me off. (Of course, these tiny pieces are the most important parts of the email!)Basically, what I need to do is have a snippet/token/whatever of dynamic content that refers back to a data sheet. In this case, we're trying to inform consumers of how much money they might be able to save in a rebate program that is being promoted, along with providing them an individual promotion code to enter. The dollar amount and promo code will come from a data sheet, which should be tied to individual customers.Mind you, I'm not the one in charge of segmenting that customer data or executing the campaigns. My job is simply to code the emails/landing pages, so my Marketo knowledge at-large might be spotty...Would this be better done with a snippet or a token? How would I go about having that snippet or token refer to the data sheet? While I excel at HTML ninja skills, I'm a little new to the whole notion of a REST API or anything of that nature, so if that's the route I need to go down, what's a good ELI5 way to approach it?For clarification, I've attached the PDF proof for what it is we're trying to do.Any and all help is, as always, greatly appreciated.Thanks!

Kenny_Elkington · Accepted Answer

I'd say the best way to do this would be to create custom object records for your promotion, and then refer to fields on these records using velocity script. Based on the pdf, you'd want a record type with approximately these fields:

Annual Savings

Seasonal Earnings(you may need four of these if it's individual to each season)

Activation code

You could then refer to each of these with individual tokens in the email:

Annual Savings = ${FlexPromtionList.get(0).AnnualSavings}

Seasonal Earanings = ${FlexPromotionList.get(0).SeasonalEarnings}

Activation Code = ${FlexPromotionList.get(0).ActivationCode}

P.S. If you could extend your service grid in Portland about 3 blocks east, that would be great.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded