Leads and Contacts - Never the twain shall meet. | Community
Skip to main content
July 19, 2016
Solved

Leads and Contacts - Never the twain shall meet.

  • July 19, 2016
  • 1 reply
  • 2407 views

Marketo Integration With Salesforce

A long-standing, heretofore unresolved problem in Salesforce campaign reporting, is that campaigns typically involve both lead and contact records, and while one can produce a campaign member or calldown report that combines leads and contacts, one can't surface custom fields on the lead or contact object.

Enter customer reports, with which one can tie campaigns to leads, to surface those fields. But it can't link to both leads and contacts, so you end up having one report for leads and one for contacts. Not much better.

Is anyone aware of a Salesforce App or Marketo Launchpoint app that will allow:

1) A combined view of campaigns with both leads and contacts, AND custom fields

2) A view that allows one to combine and group multiple campaigns

If this view can be done from Marketo, that's not the entire problem, because reps need to work from such a report and click-to-dial to make calls, and log activities against the record.

Has nobody solved this problem with either a Salesforce or Marketo add-on?

(Reading SFDC discussion groups, there's some indication Salesforce is addressing it, but it's a couple releases out at least.)

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grégoire_Miche2

Hi David,

One workaround of the problem in SFDC is to use the possibility brought by SFDC a couple of years ago to create custom fields in the campaign member object. You will be able to create either versatile formula fields that can bring both lead and contact info or plain fields that you will have to populate with workflows, process builder or triggers. These campaign member custom fields can be used in campaign with campaign member reports. So you can get advanced fields for leads and contacts in 1 report.

Example of such a formula field that brings back the acquisition program name for both leads and contacts in one unique field:

if( isblank(ContactId),Lead.mkto2__Acquisition_Program__c, Contact.mkto2__Acquisition_Program__c )

-Greg

1 reply

Grégoire_Miche2
Grégoire_Miche2Accepted solution
New Participant
July 19, 2016

Hi David,

One workaround of the problem in SFDC is to use the possibility brought by SFDC a couple of years ago to create custom fields in the campaign member object. You will be able to create either versatile formula fields that can bring both lead and contact info or plain fields that you will have to populate with workflows, process builder or triggers. These campaign member custom fields can be used in campaign with campaign member reports. So you can get advanced fields for leads and contacts in 1 report.

Example of such a formula field that brings back the acquisition program name for both leads and contacts in one unique field:

if( isblank(ContactId),Lead.mkto2__Acquisition_Program__c, Contact.mkto2__Acquisition_Program__c )

-Greg

July 19, 2016

This is interesting...thank you. going to look at this.

Addendum: Does this only work for Marketo fields?

Trying to pick up other custom fields such as Lead.utm_keyword but SFDC reports not finding the field.

Grégoire_Miche2
New Participant
July 19, 2016

You are welcome