Hello Everyone!
We have been trying to set-up our “Salesforce Campaigns Object” and create custom responses in Salesforce and make sure that everything is mapped correctly to Marketo. We are planning to always create our campaign first from Marketo and sync it manually to Salesforce from Marketo using the “Campaign Sync” functionality since Marketo will push in a one-way direction the different “Statuses” of our campaigns. We are also going to create the following custom fields in SFDC, so it will automatically sync down to Marketo.
We are seeking some advice on how we can sync the following fields back from Marketo to the “Salesforce Campaign Object” everytime we set-up a campaign in Marketo and sync it over to Salesforce? So basically, we will be adding these fields to every campaign we set-up in Marketo in the future and we would like these fields to be synced to the Salesforce Campaign from Marketo.
Campaign Management
(1) Campaign Name
(2) Parent Campaign
(3) Market (e.g. Health System, Health Plan)
(4) Country
(5) Status (e.g. Planned, In-Progress, Completed)
(6) Start Date
(7) End Date
(8) Budgeted Cost
(9) Actual Cost
(10) Type (e.g. Advertising, Email, Tradeshow, etc.)
Campaign Performance
(1) Members (Leads and Contacts)
(2) Engagements (defined by Type of Campaign)
(3) Leads in Campaign
(4) Contacts in Campaign
(5) Opportunities in Campaign
(6) Value Opportunities in Campaign
(7) Won Opportunities in Campaign
(8) Value Won Opportunities in Campaign
So just to offer a bit more clarity on what we are trying to do…
(1) We want to use Marketo as the source of truth to set up the Programs, which would then sync the data to the SFDC, creating a Campaign by way of the campaign object.
(2) To do that, we’d have to set up Tags (or something) in Marketo to apply the right attributes (Industry, Parent Campaign, Country, Cost, etc.) and have that populate the campaign setup fields in SFDC.
(3) Reporting is not an issue. Marketo will sync membership, engagement, etc. to SFDC, and SFDC will have data on the performance beyond that in terms of Opportunities, ROI, etc.
So, we are just wondering how we can connect the Marketo Program attributes to the SFDC Campaign attributes.
Not sure if that makes sense. We have found a bit of information on how we might be able to make this work, but on the SFDC side with some custom scripts to pull in more info. Alternatively, we may need to set them all up in SFDC first, then in Marketo we sync to that pre-existing SFDC campaign.
I would really appreciate any advice on this matter.
Any screenshots would be super helpful. Happy to connect via email if it helps.
... View more