Leads

Columns

Name

Type

ReadOnly

Description

Id [KEY]

String

False

The unique identifier for this record.

LeadOwner_Id

String

False

The Id of the lead owner.

LeadOwner_Name

String

True

The name of the lead owner.

Company

String

False

The company of the lead.

FirstName

String

False

The first name of the lead.

LastName

String

False

The last name of the lead.

Title

String

False

The designation of the lead.

Email

String

False

The email of the lead.

Phone

String

False

The phone number of the lead.

Fax

String

False

The fax number of the lead.

Mobile

String

False

The mobile number of the lead.

Website

String

False

The website of the lead.

LeadSource

String

False

The source of the lead.

LeadStatus

String

False

The status of the lead.

Industry

String

False

The induystr in which the lead is in.

No_ofEmployees

Int

False

The number of employees in the lead's company.

AnnualRevenue

Double

False

The annual revenue of the lead.

Rating

String

False

The rating of the lead.

Tag

String

False

A list of tag related to the lead.

CreatedBy_Id

String

False

The Id of the User who created the record.

CreatedBy_Name

String

True

The name of the user who created the record.

EmailOptOut

Bool

False

Whether the lead has opted out of emails or not.

SkypeID

String

False

The skype id of the lead.

ModifiedBy_Id

String

False

The Id of the User who modified the record.

ModifiedBy_Name

String

True

The name of the User who modified the record.

CreatedTime

Datetime

False

The time when the record was created.

ModifiedTime

Datetime

False

The time when the record was modified.

FullName

String

False

The full name of the lead.

Salutation

String

False

The salutation that the lead likes to be referred to.

SecondaryEmail

String

False

The secondary email of the lead.

Twitter

String

False

The twitter handle of the lead.

LastActivityTime

Datetime

False

The last time the lead had any activity.

Street

String

False

The street where the lead resides in.

City

String

False

The city where the lead resides in.

State

String

False

The state where the lead resides in.

ZipCode

String

False

The zip code of the place where the lead resides in.

Country

String

False

The country where the lead resides in.

Description

String

False

A description of the lead.

MostRecentVisit

Datetime

False

The last time the lead visited.

FirstVisit

Datetime

False

The first time the lead visited.

Referrer

String

False

The referrer of the lead.

FirstPageVisited

String

False

The first URL that the lead has visited.

NumberOfChats

Int

False

The number of chats had with the lead.

AverageTimeSpent_Minutes_

String

False

The average time the lead has spent in minutes.

DaysVisited

Int

False

The number of days the lead has visitied.

VisitorScore

Long

False

The visitor score calculated for this lead.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

Word

String

Used to search for a specific word in records.

DuplicateCheckFields

String

The field/s to be used for checking in an upsert.

Converted

Boolean

Set to true to return only converted records.

Approved

Boolean

Set to true to return only approved records.

CustomViewId

String

The custom view Id to be used for filtering this record.

Trigger

String

To trigger the rule while inserting record into CRM account.

Last updated