Salesforce | Campaign Standard Dataset
This article details the dataset structure that ChannelMix considers standard for the Campaign dataset from Saleforce. A full data refresh will occur daily. To add custom fields from Salesforce, please log a ticket to the Data Solutions Team.
| Field | Type | Description |
| ActualCost | Decimal | Amount of money spent to run the campaign. |
| AmountAllOpportunities | Decimal | Amount of money in all opportunities associated with the campaign, including closed/won opportunities. Label is Value Opportunities in Campaign. |
| AmountWonOpportunities | Decimal | Amount of money in closed or won opportunities associated with the campaign. Label is Value Won Opportunities in Campaign. |
| BudgetedCost | Decimal | Amount of money budgeted for the campaign. |
| CampaignImageId | Dimension | ID of the campaign image. Available in API version 42.0 and later. |
| CampaignMemberRecordTypeId | Dimension | The record type ID for CampaignMember records associated with the campaign. |
| CurrencyIsoCode | Dimension | Available only for organizations with the multicurrency feature enabled. Contains the ISO code for any currency allowed by the organization. |
| Description | Dimension | Description of the campaign. Limit: 32 KB. Only the first 255 characters display in reports. |
| EndDate | Date | Ending date for the campaign. Responses received after this date are still counted. |
| ExpectedResponse | Decimal | Percentage of responses you expect to receive for the campaign. |
| ExpectedRevenue | Decimal | Amount of money you expect to generate from the campaign. |
| HierarchyActualCost | Number | Calculated field for the total amount of money spent to run the campaigns in a campaign hierarchy. Label is Total Actual Cost in Hierarchy. |
| HierarchyBudgetedCost | Decimal | Calculated field for the total amount of money budgeted for the campaigns in a campaign hierarchy. Label isTotal Budgeted Cost in Hierarchy. |
| HierarchyExpectedRevenue | Decimal | Calculated field for the total amount of money you expect to generate from the campaigns in a campaign hierarchy. Label is Total Expected Revenue in Hierarchy. |
| HierarchyNumberSent | Number | Calculated field for the total number of individuals targeted by the campaigns in a campaign hierarchy. For example, the number of email messagess sent. Label is Total Num Sent in Hierarchy. |
| IsActive | Boolean | Indicates whether this campaign is active (true) or not (false). Default value is false. Label is Active. |
| LastActivityDate | Date | Value is one of the following, whichever is the most recent: Due date of the most recent event logged against the record. Due date of the most recently closed task associated with the record. |
| LastReferencedDate | Date | The timestamp for when the current user last viewed a record related to this record. |
| LastViewedDate | Date | The timestamp for when the current user last viewed this record. If this value is null, this record might only have been referenced (LastReferencedDate) and not viewed. |
| Name | Dimension | Required. Name of the campaign. Limit: is 80 characters. |
| NumberOfContacts | Number | Number of contacts associated with the campaign. Label is Total Contacts. |
| NumberOfConvertedLeads | Number | Number of leads that were converted to an account and contact due to the marketing efforts in the campaign. Label is Converted Leads. |
| NumberOfLeads | Number | Number of leads associated with the campaign. Label is Leads in Campaign. |
| NumberOfOpportunities | Number | Number of opportunities associated with the campaign. Label is Opportunities in Campaign. |
| NumberOfResponses | Number | Number of contacts and unconverted leads with a Member Status equivalent to “Responded” for the campaign. Label is Responses in Campaign. |
| NumberOfWonOpportunities | Number | Number of closed or won opportunities associated with the campaign. Label is Won Opportunities in Campaign. |
| NumberSent | Number | Number of individuals targeted by the campaign. For example, the number of emails sent. Label is Num Sent. |
| OwnerId | Dimension | ID of the user who owns this campaign. Default value is the user logging in to the API to perform the create. |
| ParentCampaign | Dimension | The campaign above the selected campaign in the campaign hierarchy. |
| ParentId | Dimension | ID of the parent Campaign record, if any. |
| RecordTypeId | Dimension | ID of the record type assigned to this object. |
| StartDate | Date | Starting date for the campaign. |
| Status | Dimension | Status of the campaign, for example, Planned, In Progress. Limit: 40 characters. |
| TotalAmountAllOpportunities | Decimal | Calculated field for total amount of all opportunities associated with the campaign hierarchy, including closed/won opportunities. Label is Total Value Opportunities in Hierarchy. |
| TotalAmountAllWonOpportunities | Decimal | Calculated field for amount of all closed/won opportunities associated with the campaign hierarchy. Label is Total Value Won Opportunities in Hierarchy. |
| TotalNumberofContacts | Number | Calculated field for number of contacts associated with the campaign hierarchy. Label is Total Contacts in Hierarchy. |
| TotalNumberofConvertedLeads | Number | Calculated field for the total number of leads associated with the campaign hierarchy that were converted into accounts, contacts, and opportunities. Label is Total Converted Leads in Hierarchy. |
| TotalNumberofLeads | Number | Calculated field for total number of leads associated with the campaign hierarchy. This number also includes converted leads. Label is Total Leads in Hierarchy. |
| TotalNumberofOpportunities | Number | Calculated field for the total number of opportunities associated with the campaign hierarchy. Label is Total Opportunities in Hierarchy. |
| TotalNumberofResponses | Number | Calculated field for number of contacts and unconverted leads that have a Member Status equivalent to “Responded” for the campaign hierarchy. Label is Total Responses in Hierarchy. |
| TotalNumberofWonOpportunities | Number | Calculated field for the total number of won opportunities associated with the campaign hierarchy. Label is Total Won Opportunities in Hierarchy. |
| Type | Dimension | Type of campaign, for example, Direct Mail or Referral Program. Limit: 40 characters. |
| Insert Date | DateTime | Internal use: when the row was inserted in the table |
| ChannelMix Profile | Dimension | When needed, distinguishes between profiles defined through ChannelMix. |