Skip to main content
Salesforce

Return to Question

deleted 12 characters in body
Source Link
NGix
NGix
  • 919
  • 9
  • 27

I'm confused with LeadId and ContactId fields, these are contacts or leads associated with a campaign, to my understanding, it's who was a prospect (lead or contact) at the moment of associating with campaign. When I run a query:

select count(id, LeadId, ContactId) from CampaignMember where LeadId != null and ContactId != null

And... I get a list of CampaignMembers with both lead and contact id fields! How?

In addition, when I join converted leads on CampaignMembers (contactId and convertedContactId) I see that some of the associated contacts were leads before, while leadId is empty. Doesn't make sense. Thanks!

I'm confused with LeadId and ContactId fields, these are contacts or leads associated with a campaign, to my understanding, it's who was a prospect (lead or contact) at the moment of associating with campaign. When I run a query:

select id, LeadId, ContactId from CampaignMember where LeadId != null and ContactId != null

And... I get a list of CampaignMembers with both lead and contact id fields! How?

In addition, when I join converted leads on CampaignMembers (contactId and convertedContactId) I see that some of the associated contacts were leads before, while leadId is empty. Doesn't make sense. Thanks!

I'm confused with LeadId and ContactId fields, these are contacts or leads associated with a campaign, to my understanding, it's who was a prospect (lead or contact) at the moment of associating with campaign. When I run a query:

select count(id) from CampaignMember where LeadId != null and ContactId != null

And... I get a list of CampaignMembers with both lead and contact id fields! How?

In addition, when I join converted leads on CampaignMembers (contactId and convertedContactId) I see that some of the associated contacts were leads before, while leadId is empty. Doesn't make sense. Thanks!

Source Link
NGix
NGix
  • 919
  • 9
  • 27

Confusion with CampaignMember Object

I'm confused with LeadId and ContactId fields, these are contacts or leads associated with a campaign, to my understanding, it's who was a prospect (lead or contact) at the moment of associating with campaign. When I run a query:

select id, LeadId, ContactId from CampaignMember where LeadId != null and ContactId != null

And... I get a list of CampaignMembers with both lead and contact id fields! How?

In addition, when I join converted leads on CampaignMembers (contactId and convertedContactId) I see that some of the associated contacts were leads before, while leadId is empty. Doesn't make sense. Thanks!