How can we personalize the emails when sending to Salesforce Report or Campaign? How do we use personalization strings with data from Salesforce as Reports and Campaigns? or should we directly use AMPscript ?

Thank you


Only fields that you have already configured and mapped in your Field Mapping will be available.

Your other three options are:

  1. Using a Lookup or LookupRows on the synchronized DE
  2. Or a RetrieveSalesforceObject
  3. Or importing the campaign or report into a sendable data extension.



%%[ var @rs

Set @rs= RetrieveSalesforceObjects('Lead', 'Id, FirstName,LastName', 'region', '=', 'west','AnnualRevenue', '>', '1000000')

  • Hello @JacksonChen Thank you! What is the process for importing or sending Campaign/report data into a data extension ? is there a convenient feature for that with the connector ? (instead of of extract the file corresponding to the Campaign or report data and import them into a data extension) Thanks – Ludivine L Jul 8 '19 at 14:58
  • Yes, you can use the Import Activity to do this. – Jackson Chen Jul 8 '19 at 17:02
  • OK, so there is no feature that allows to directly "send" SF campaign or report data directly into a Data Extension in SFMC with the Marketing cloud connector ? – Ludivine L Jul 8 '19 at 17:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.