I am trying to get the converted leads from a campaign.

trying to get a Lead with converted history didn't provide the data (no campaign info).

Following Q&A states, that there is no direct connection between lead and campaign

Following picture shows 7 converted leads from the campaign

Is it possible to know whom these 7 leads are?

enter image description here


The Campaigns with Leads and Converted Lead Information report type provides this information.

Campaigns with Leads and Converted Lead Information


Leads that have been converted during a Campaign will have both the LeadId and ContactId fields populated on their CampaignMember record.

You can easily get these records using SOQL:

SELECT Id, ...
    SELECT LeadId 
    FROM CampaignMember 
        && LeadId != null 
        && ContactId != null
  • That report made it. but better to split your answer to 2 answers. So I can accept that one :-) – Saariko Sep 29 '14 at 13:07
  • @Saariko Is two answers really the best way to go? I'm happy to do it but it just seems a bit odd. – Alex Tennant Sep 29 '14 at 13:23
  • Nope. That's the correct way. – Saariko Sep 29 '14 at 14:25
  • 1
    @Saariko I found a post on SE meta which said that :) – Alex Tennant Sep 29 '14 at 14:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.