In this session the team cleans up the Lead query then dives into building out a Salesforce Campaign, adding campaign members and building a Marketing Cloud query to pull those campaign members in to feed into the Lead Nurture Journey
Build Components
| Asset | Notes/tips |
| Query Best Practices | In Select statement start each line with a comma |
| Salesforce Sales Cloud – Campaign | How to create a Salesforce Campaign |
| Salesforce Sales Cloud – Contacts | How to create a contact |
| Salesforce Sales Cloud – Campaign member | How to create a campaign member, add a contact to a campaign |
| Marketing Cloud – Contact Builder | How to add fields to synchronized data extensions |
| Marketing Cloud – Query best practices | How to set a static field in the Select Statement |
handsonsfmc.com 
Leave a comment