How to create dynamic table in email based on data uploaded weekly
We would like to send customers their purchase history in dynamic table using information uploaded to CDO on a weekly basis? Upon upload, the CDO will trigger a service to push the contacts into the same campaign and send out the email to all the records within the CDO.
This will be an evergreen campaign so there should not need to reactivate the campaign weekly and the contacts may or may not repeat, depending if they had made any purchase the previous week.
Understand that Eloqua can only retrieve ONE record per contact via CDO + Field Merge, which is not what we want.