Salesforce | Lead Standard Dataset
This article details the dataset structure that ChannelMix considers "standard" for the Lead 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 |
| CreatedDate | Dimension | Required. Date on which this lead is created. |
| ConvertedDate | Dimension | Date on which this lead was converted. |
| Id | Dimension | ID of the Lead. |
| Status | Dimension | Status code for this converted lead. Status codes are defined in Status and represented in the API by the LeadStatus object. |
| LeadSource | Dimension | The lead’s source. |
| OwnerId | Dimension | ID of the lead’s owner. |
| ConvertedAccountId | Dimension | Object reference ID that points to the account into which the lead converted. |
| ConvertedContactId | Dimension | Object reference ID that points to the contact into which the lead converted. |
| ConvertedOpportunityId | Dimension | Object reference ID that points to the opportunity into which the lead has been converted. |
| Country | Dimension | The lead’s country. |
| State | Dimension | State for the address of the lead. |
| City | Dimension | City for the lead’s address. |
| PostalCode | Dimension | Postal code for the address of the lead. Label is Zip/Postal Code. |
| Insert Date | Timestamp | ChannelMix Field: when the row was inserted into the dataset |
| Channelmix Profile | Dimension | ChannelMix Field: the ChannelMix Profile associated to the data |