Displaying Custom Data in an Email | Community
Skip to main content
K
kenmckown
Level 4
February 25, 2025
Question

Displaying Custom Data in an Email

  • February 25, 2025
  • 1 reply
  • 2564 views

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?

1 reply

SanfordWhiteman
SanfordWhiteman
Level 10
February 25, 2025

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.

 

 

K
kenmckownAuthor
Level 4
February 25, 2025

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
SanfordWhiteman
Level 10
February 25, 2025
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.
Terms & ConditionsAccessibility statement

Loading footer...