Contacts who are CampaignMembers

Salesforce

 

Salesforce is the most popular cloud CRM with a focus on sales and support. Skyvia requires Salesforce Enterprise edition or higher.

A list of Contact objects containing only contacts who are CampaignMembers of a set of campaign

Query Text

SELECT cm.campaignid 'Campaign Id',  ca.name 'Campaign Name',
       c.id 'Contact Id', c.firstname, c.lastname, cm.status 'Member Status'
     FROM "CampaignMember" cm,
          "Contact" c, 
          "Campaign" ca
     WHERE c.id = cm.contactid  AND
           cm.campaignid=ca.id
     ORDER BY ca.name
  

Open Query