Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Populate an email with data outside of the database

Avatar

Level 3

Hi there,

Query here for Adobe Campaign Classic:

Here's a scenario i'm trying to find a workaround for.

We have a marketing email that we want to send and we need to populate with a unique discount code for each recipient.

We have the codes in a .csv file and the email addresses to target, but how do i populate the creative with data field outside of the database?

We could upload and target a list of email addresses and codes and populate this way, however, the send needs to be linked to the recipient database, to capture potential unsubscriptions and engagement etc.

Ideal scenario would be to match the emails on the .csv file Vs the recipient database and then enrich the discount code from the .csv file.

Is this possible? (tried and failed using the edit schema tool)

Thanks in advance,

Andy

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

Use Data loading (file) activity, then join to your query using an enrichment.

From there it'll be available in the rest of the workflow until the delivery.

You can also optionally capture the codes sent in broadLog by altering the delivery mapping's storage.

Thanks,

-Jon

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi,

Use Data loading (file) activity, then join to your query using an enrichment.

From there it'll be available in the rest of the workflow until the delivery.

You can also optionally capture the codes sent in broadLog by altering the delivery mapping's storage.

Thanks,

-Jon