I'm facing some troubles with personalized contents in email.
I have Marketing cloud connected to Service Cloud and I need to fetch a RTA field from Opportunity (standard service cloud object) in my email. I synchronized Service Cloud Object in my marketing cloud and now I have the resulting synchronized Data extension.
Now for my email (and customer Journey) I try to set up an automation to pull my data from synchronized data extension into an new data extension by a query activity.
Everything works fine but the RTA field is never populated in teh new data extension.
I need to retrieve this field in the email because it contains the url of an image I need to display in the email. The image should be different for every customer so I need to use AMP Script too.