Annual Revenue Token

Highlighted
Anonymous
Not applicable

Annual Revenue Token

I'm trying to use the {{Company.Annual Revenue}} in my email, but when it generates it shows 123456789 rather than $12,345,789. What do I need to do for my email to show the currency format rather than just the plain numbers?

4 REPLIES 4
Highlighted
Level 10 - Champion Alumni

Re: Annual Revenue Token

You can use velocity or you can try to change your field type to Currency.

You may have better luck going to your CRM Admin to check the field type and formatting and if that's getting into marketo.

Highlighted
Anonymous
Not applicable

Re: Annual Revenue Token

I was able to check the field type and it's already set to Currency. How would we go about using velocity? Would it be using an Email Script under My Tokens under the campaign? And what's the difference between using the {{Company.Annual Revenue}} token and the {Lead.AnnualRevenue} token?

Highlighted
Anonymous
Not applicable

Re: Annual Revenue Token

Hi Chris,

See some examples of Velocity scripting at,

http://developers.marketo.com/email-scripting/examples/

In your original question you said that you are trying to use the {{Company.Annual Revenue}}

The answer is whatever field is populated with the correct data.

regards


Rajesh Talele

Note: Velocity scripting only 'formats the data for display. The field value remains unformatted.'

Highlighted
Level 10 - Community Moderator

Re: Annual Revenue Token

The Velocity code you need is:

${esc.d}${number.format($lead.AnnualRevenue)}

Note you don't want .currency() within Velocity (regardless of the Marketo field type) because that will add decimal points for integer dollar amounts.