Contacts who are CampaignMembers



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', 'Campaign Name', 'Contact Id', c.firstname, c.lastname, cm.status 'Member Status'
     FROM "CampaignMember" cm,
          "Contact" c, 
          "Campaign" ca
     WHERE = cm.contactid  AND

Open Query