I have a bunch of unique promo codes in a spreadsheet. Is there any way I can have Marketo assign a unique promo code to a lead and send it to them via email?

Anonymous · ‎05-05-2016

All in the title. Thanks in advance!

Grégoire_Miche2 · ‎05-05-2016

Hi Jonathan,

You will need a custom field to store the code for each lead This custom field will be usable as a token in the email.

The easiest way to upload the codes: Export your leads, run the assignment in Excel using a random function and vlookup, reimport in Marketo

-Greg

Anonymous · ‎06-02-2016

I think this is how I will go about doing this. But I'm just curious, would there be any way to accomplish this without creating a custom field?

Grégoire_Miche2 · ‎06-02-2016

Hi Jonathan,

AFAIK, velocity scripts cannot call any outside web service, so no, there is no other way.

-Greg

Geoff_Krajeski1 · ‎06-03-2016

I have previously used the same method Grégoire Michel describes above.

Short of funds for an outside service partner, this will work!

Josh_Hill13 · ‎05-05-2016

Here are other threads for examples

Rajesh_Talele13 · ‎09-03-2018

This video shows a working example of how we did it in Marketo.

Hope this helps..

Rajesh

Re: I have a bunch of unique promo codes in a spreadsheet. Is there any way I can have Marketo assign a unique promo code to a lead and send it to them via email?