CDO field Merges
I have "opportunities CDO" in Eloqua which linked to the "contact" table.
Contact A has 3 records in "opportunities CDO" as record 1, record 2 and record 3. The fields in "opportunities CDO" are Country, Product, Category, Amount, SalesPerson.
I built a segment on CDO opportunity with the following conditions "country = UK, Product = A and Category = SMB."
I am sending an email to the contacts who fall in this above segment. The email message has to go to Contact A with details saved in record 1 in "opportunity CDO." The field merges used are "Amount", "Sales person".
CDO field merges allow filters on "First created, Last created, Last modified". I want my email to pull & display the values in these fields" country, Product and Category" of record 1.