Lead
Tracks potential customers or business opportunities before they are converted into accounts and contacts.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the lead. | |
| IsDeleted | Boolean | True |
Indicates whether the lead has been deleted. | |
| MasterRecordId | String | True |
Lead.Id |
ID of the master record for merged leads. |
| LastName | String | False |
Last name of the lead. | |
| FirstName | String | False |
First name of the lead. | |
| Salutation | String | False |
Salutation used for the lead, such as Mr. or Ms. | |
| Name | String | True |
Full name of the lead, including first and last name. | |
| Title | String | False |
Job title of the lead. | |
| Company | String | False |
Name of the company the lead is associated with. | |
| Street | String | False |
Street address of the lead's company or location. | |
| City | String | False |
City of the lead's address. | |
| State | String | False |
State or province of the lead's address. | |
| PostalCode | String | False |
Postal or ZIP code of the lead's address. | |
| Country | String | False |
Country of the lead's address. | |
| Latitude | Double | False |
Geographic latitude of the lead's address. | |
| Longitude | Double | False |
Geographic longitude of the lead's address. | |
| Phone | String | False |
Primary business phone number for the lead. | |
| MobilePhone | String | False |
Mobile phone number of the lead. | |
| Fax | String | False |
Fax number for the lead. | |
| String | False |
Email address of the lead. | ||
| Website | String | False |
Website associated with the lead's company. | |
| Description | String | False |
Additional notes or description about the lead. | |
| LeadSource | String | False |
Origin of the lead, such as Web or Trade Show. | |
| Status | String | False |
Current status of the lead, such as Open or Qualified. | |
| Industry | String | False |
Industry the lead's company belongs to. | |
| Rating | String | False |
Rating of the lead, such as Hot, Warm, or Cold. | |
| AnnualRevenue | Double | False |
Annual revenue of the lead's company. | |
| NumberOfEmployees | Int | False |
Total number of employees at the lead's company. | |
| OwnerId | String | False |
ID of the user who owns this lead. | |
| IsConverted | Boolean | False |
Indicates whether the lead has been converted. | |
| ConvertedDate | Datetime | True |
Date and time the lead was converted. | |
| ConvertedAccountId | String | True |
Account.Id |
ID of the account created from the converted lead. |
| ConvertedContactId | String | True |
Contact.Id |
ID of the contact created from the converted lead. |
| ConvertedOpportunityId | String | True |
Opportunity.Id |
ID of the opportunity created from the converted lead. |
| IsUnreadByOwner | Boolean | False |
Indicates whether the lead is marked as unread by the owner. | |
| CreatedDate | Datetime | True |
Date and time the lead record was created. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the lead. |
| LastModifiedDate | Datetime | True |
Date and time the lead record was last modified. | |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the lead. |
| SystemModstamp | Datetime | True |
Timestamp for the last system update to the lead. | |
| LastActivityDate | Datetime | True |
Date of the most recent activity on the lead. | |
| LastViewedDate | Datetime | True |
Date and time the lead was last viewed. | |
| LastReferencedDate | Datetime | True |
Date and time the lead was last referenced in a related record. | |
| Jigsaw | String | False |
Data.com key associated with the lead. | |
| JigsawContactId | String | True |
Data.com contact ID for the lead. | |
| EmailBouncedReason | String | True |
Reason why an email sent to the lead bounced. | |
| EmailBouncedDate | Datetime | True |
Date and time the email sent to the lead bounced. | |
| SICCode__c | String | False |
Standard Industrial Classification (SIC) code for the lead's company. | |
| Primary__c | String | False |
Indicates whether this lead is marked as primary. | |
| NumberofLocations__c | Double | False |
Total number of locations associated with the lead's company. | |
| ProductInterest__c | String | False |
Products the lead has expressed interest in. | |
| CurrentGenerators__c | String | False |
Current generators used by the lead's company. | |
| New_Text_Field__c | String | False |
Custom text field for additional lead information. | |
| External_Id_Field__c | String | False |
Custom external ID used to reference the lead in external systems. | |
| External_Id_2__c | String | False |
Secondary external ID used for integration or reference. | |
| AutoNumberTest__c | String | True |
Automatically generated number for testing purposes. | |
| Formula__c | Datetime | True |
Custom formula field that calculates a date and time value. |