Campaign
Tracks marketing campaigns, including outreach activities and associated leads, contacts, and opportunities.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier for the campaign record. | |
| IsDeleted | Bool | Indicates whether the campaign has been deleted (true) or is active (false). | |
| Name | String | Name of the campaign, used for identification and display. | |
| ParentId | String |
Campaign.Id | ID of the parent object in the hierarchy. |
| Type | String | Category of the campaign, such as email, webinar, or trade show. | |
| Status | String | Current status of the campaign, such as Planned, In Progress, or Completed. | |
| StartDate | Date | The start date of the campaign's active period. | |
| EndDate | Date | The end date of the campaign's active period. | |
| CurrencyIsoCode | String | ISO code for the currency in which the revenue amount is expressed. | |
| ExpectedRevenue | Decimal | The projected revenue expected to be generated from the campaign. | |
| BudgetedCost | Decimal | The planned budget allocated for the campaign. | |
| ActualCost | Decimal | The actual cost incurred for executing the campaign. | |
| ExpectedResponse | Double | The percentage of expected responses based on campaign reach. | |
| NumberSent | Double | The total number of messages or invitations sent as part of the campaign. | |
| IsActive | Bool | Indicates whether the campaign is currently active (true) or not (false). | |
| Description | String | A summary or notes describing the campaign's purpose and content. | |
| TenantId | String |
PardotTenant.Id | ID of the Tenant associated with this record. |
| NumberOfLeads | Int | The total number of leads associated with the campaign. | |
| NumberOfConvertedLeads | Int | The number of leads converted to contacts or opportunities through the campaign. | |
| NumberOfContacts | Int | The total number of contacts associated with the campaign. | |
| NumberOfResponses | Int | The total number of responses received from the campaign's audience. | |
| NumberOfOpportunities | Int | The number of sales opportunities generated from the campaign. | |
| NumberOfWonOpportunities | Int | The number of sales opportunities won as a result of the campaign. | |
| AmountAllOpportunities | Decimal | The total value of all opportunities related to the campaign. | |
| AmountWonOpportunities | Decimal | The total value of all won opportunities associated with the campaign. | |
| OwnerId | String |
User.Id | ID of the user or queue that owns the campaign. |
| CreatedById | String |
User.Id | ID of the user who created the campaign record. |
| LastModifiedDate | Datetime | Timestamp of the most recent update to the campaign. | |
| LastModifiedById | String |
User.Id | ID of the user who last modified the campaign record. |
| LastActivityDate | Date | The date of the most recent activity associated with the campaign. | |
| LastViewedDate | Datetime | The date the campaign was last viewed by a user. | |
| LastReferencedDate | Datetime | The date the campaign was last referenced in a related record or operation. | |
| CampaignMemberRecordTypeId | String |
RecordType.Id | The record type ID for campaign member records associated with this campaign. |
| SOQL | String | 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 | 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 | 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 | System-maintained timestamp for tracking the latest modification. | |
| CreatedDate | Datetime | Timestamp of when the campaign was initially created. |