Coupon codes mapping

Question

HI Community,

I have a csv file that contains unique coupon codes, within a campaign I have to assign a unique code as per the customer.

can anyone please let me know how can I achieve it using enrichment

Rch_ · Accepted Answer

Hi @sah_, For 3rd point it will be like creating a link between those row number. Attaching snip as well:  Thanks,

Rch_ · Answer

Hi @sah_,

When you load the CSV using the Data Loading (file) activity, just skip selecting a schema — Campaign will automatically create a temporary table for you behind the scenes. This is great if you don’t need to store the coupons long-term or reference them later.

Here’s how you can handle the unique assignment using enrichment:

1. Load the CSV file with coupon codes (as a temporary table).
2. Add a Row Number in the enrichment step to both:

- Your recipient data
- The loaded coupon data

*Use this RowNum() function*

3. Join the two datasets using the row number (1st row to 1st row, 2nd to 2nd, etc.)

This way, each customer gets exactly one coupon — no custom schema needed.

Thanks,

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded