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.

[SanfordWhiteman]

You don't want Price+Customer ID to be the dedupe fields. You want Product+Customer ID. Price is just a standard field. This is the way to have multiple Product-Customer-Price records.

[kenmckown]

That makes sense, I did not make the Price field the de-dupe field, just the Customer ID, but adding Product as well makes sense. How do these tie to emails? Do I have to upload values to these fields and then use tokens to pull them in? I am familiar with how Eloqua did it, I worked in that system for over 15 years, but Marketo's option is new to me.