Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Populate an email with data outside of the database

andysayers909
Level 3
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
wodnicki
Correct answer by
Community Advisor
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
wodnicki
Correct answer by
Community Advisor
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