CampaignMember
Links leads and contacts to campaigns, tracking participation and response details.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the campaign member record. | |
| IsDeleted | Bool | True |
Indicates whether the campaign member record has been deleted (true) or is active (false). | |
| CampaignId | String | False |
Campaign.Id |
ID of the campaign associated with the member. |
| LeadId | String | False |
Lead.Id |
ID of the lead associated with this campaign member, if applicable. |
| ContactId | String | False |
Contact.Id |
ID of the contact associated with this campaign member, if applicable. |
| Status | String | False |
Current status of the campaign member, such as Sent, Responded, or Attended. | |
| HasResponded | Bool | True |
Indicates whether the lead or contact has responded to the campaign. | |
| CreatedDate | Datetime | True |
Date and time when the campaign member record was created. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the campaign member record. |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the campaign member record. |
| FirstRespondedDate | Date | True |
Date and time when the lead or contact first responded to the campaign. | |
| CurrencyIsoCode | String | False |
ISO code for the currency in which the revenue amount is expressed. | |
| Salutation | String | True |
Honorific abbreviation, word, or phrase to be used in front of the name in greetings. | |
| Name | String | True |
Name of the record. | |
| FirstName | String | True |
First name of the contact or person account. | |
| LastName | String | True |
Last name of the contact or person account. Required for person accounts. | |
| Title | String | True |
Title of the contact or person, for example CEO or Vice President. | |
| Street | String | True |
Street address. | |
| City | String | True |
City portion of the address. | |
| State | String | True |
State or province portion of the address. | |
| PostalCode | String | True |
Postal code portion of the address. | |
| Country | String | True |
Country portion of the address. | |
| String | True |
Email address for the contact or person account. | ||
| Phone | String | True |
Phone number for the contact or account. | |
| Fax | String | True |
Fax number for the contact or account. | |
| MobilePhone | String | True |
Contact's mobile phone number. | |
| Description | String | True |
Text description of the record. | |
| DoNotCall | Bool | True |
Indicates that the contact does not want to receive calls. | |
| HasOptedOutOfEmail | Bool | True |
Indicates whether the contact has opted out of email communications. | |
| HasOptedOutOfFax | Bool | True |
Indicates whether the contact has opted out of fax communications. | |
| LeadSource | String | True |
Source from which the lead was obtained. | |
| CompanyOrAccount | String | True |
Number of CompanyOrAc associated with this record. | |
| Type | String | True |
Type of account or classification. | |
| LeadOrContactId | String | True |
ID of the LeadOrContact associated with this record. | |
| LeadOrContactOwnerId | String | True |
ID of the LeadOrContactOwner associated with this record. | |
| LeadOrContactOwnerIdType | String | False |
Specifies the type of the 'LeadOrContactOwnerId' polymorphic field to use in the statement. | |
| LeadOrContactOwnerIdExternalFieldName | String | False |
Specifies the external field name of the 'LeadOrContactOwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| SOQL | String | False |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | False |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | False |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. | |
| SystemModstamp | Datetime | True |
System-maintained timestamp for tracking the latest modification. | |
| LastModifiedDate | Datetime | True |
Date and time when the campaign member record was last updated. |