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

1 Answer 1


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
    Commented Jul 8, 2019 at 14:58
  • Yes, you can use the Import Activity to do this. Commented Jul 8, 2019 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
    Commented Jul 8, 2019 at 17:50

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .