Salesforce | Campaign Standard Dataset

This article details the dataset structure that Alight Analytics 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.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.