Displaying Custom Data in an Email

[kenmckown]

I was curious if anyone has a good solution for this issue.

We are about to send out price change emails for various products. We want to display that new price in an email based on their ID, NOT their email address, as some emails may have multiple products.

I am trying to solution storing that data and using a custom token to display that price in the email sent to that person via their ID (either Salesforce ID or another ID already stored in Marketo)

What are the best solutions for this?

[SanfordWhiteman]

You’re looking at a Marketo Custom Object or a JSON field (Textarea field w/JSON).

In both cases you do the output using a Velocity (Email Script) token.

Which one to choose depends on how many products you’re talking about. Would be good to know more about the shape and scope of the data.

[kenmckown]

We have around 20 products, but won't be using them all for this particular example, but maybe in the future. We would want to match this on their customer ID to display the price change in an email. I have created a test Custom Object in our instance, and create a field for New Price and one for Customer ID, which I made the dedupe rule.