1

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

Improve this question

1 Answer 1

Reset to default
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.

Examples:

LookupRows('ZipCode','City',HomeCity)

%%[ var @rs

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

]%%
Improve this answer
3
  • 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, 2019 at 14:58
  • Yes, you can use the Import Activity to do this.
    – Jackson Chen
    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
    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 .