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 | Bool | 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. | |
| GeocodeAccuracy | String | False |
Accuracy level of the geocode for the 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. | |
| PhotoUrl | String | True |
URL for the contact's photo. | |
| 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. | |
| CurrencyIsoCode | String | False |
ISO code for the currency in which the revenue amount is expressed. | |
| AnnualRevenue | Decimal | 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. | |
| OwnerIdType | String | False |
Specifies the type of the 'OwnerId' polymorphic field to use in the statement. | |
| OwnerIdExternalFieldName | String | False |
Specifies the external field name of the 'OwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| IsConverted | Bool | False |
Indicates whether the lead has been converted. | |
| ConvertedDate | Date | 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 | Bool | 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. |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the lead. |
| LastActivityDate | Date | 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. | |
| CleanStatus | String | False |
Indicates the record's clean status compared with Data.com. | |
| CompanyDunsNumber | String | False |
The D-U-N-S number for the company. | |
| DandbCompanyId | String | False |
DandBCompany.Id |
ID of the DandbCompany associated with this record. |
| EmailBouncedReason | String | False |
Reason why an email sent to the lead bounced. | |
| EmailBouncedDate | Datetime | False |
Date and time the email sent to the lead bounced. | |
| IndividualId | String | False |
Individual.Id |
ID of the data privacy record associated with this record. |
| IsPriorityRecord | Bool | True |
Indicates whether the record has the PriorityRecord characteristic. | |
| SOQL | String | False |
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 | False |
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 | False |
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 | True |
Timestamp for the last system update to the lead. | |
| LastModifiedDate | Datetime | True |
Date and time the lead record was last modified. |