Prospects

Get details of prospects.

Select

The 本製品 will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

Id supports the '=,IN,>=,<=,>,<' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
Emails supports the '=,IN' operators.
EngagedAt supports the '=,>=,<=,>,<' operators.
EngagedScore supports the '=,>=,<=,>,<' operators.
ExternalSource supports the '=,IN' operators.
FirstName supports the '=,IN' operators.
LastName supports the '=,IN' operators.
LinkedInId supports the '=,IN' operators.
LinkedInSlug supports the '=,IN' operators.
SharingTeamId supports the '=,IN' operators.
StackOverflowId supports the '=,IN' operators.
TimeZone supports the '=' operator.
Title supports the '=,IN' operators.
TouchedAt supports the '=,>=,<=,>,<' operators.
TwitterUsername supports the '=' operator.
UpdatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM Prospects WHERE Id = 1

SELECT * FROM Prospects WHERE Id IN (1, 2)

SELECT * FROM Prospects WHERE Id >= 1

SELECT * FROM Prospects WHERE Id <= 1

SELECT * FROM Prospects WHERE Id > 1

SELECT * FROM Prospects WHERE Id < 2

SELECT * FROM Prospects WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE EngagedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Prospects WHERE Emails = '[email protected]'

SELECT * FROM Prospects WHERE FirstName = 'test'

SELECT * FROM Prospects WHERE LastName = 'test'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of Prospect.
AccountName	String	Name of prospect.
AddedAt	Datetime	The date and time the prospect was added to any system.
AddressCity	String	The prospect's city.
AddressCountry	String	The prospect's country.
AddressState	String	The prospect's state.
AddressStreet	String	The prospect's street address.
AddressStreet2	String	The prospect's second street address.
AddressZip	String	The prospect's postal code.
AngelListUrl	String	The prospect's AngelList URL.
AvailableAt	Datetime	The date and time the prospect is available to contact again.
CallOptedOut	Boolean	Whether the prospect is opted out of calling or opted out in general if granular opt-out is not enabled.
CallsOptedAt	Datetime	The date and time the prospect opted in out of calls.
CallsOptStatus	String	A string that represents whether a prospect has opted into or out of calls.
CampaignName	String	The name of the campaign the prospect is associated with.
ClickCount	Integer	The number of clicks the prospect has made since the last touch point.
Company	String	The name of the company the prospect works at. If associated with an account, this is the name of the account.
CompanyFollowers	String	The company Followers.
CompanyFoundedAt	Datetime	The date and time when company founded at.
CompanyIndustry	String	Company Industry.
CompanyLinkedIn	String	Company LinkedIn.
CompanyLinkedInEmployees	String	Company LinkedIn employees.
CompanyLocality	String	Company locality.
CompanyNatural	String	Company natural name.
CompanySize	String	Company size.
CompanyStartDate	String	Company start date.
CompanyType	String	Company type.
ContactHistogram	String	The last 12 months of email contact history with the prospect with the current month being the last element.
CreatedAt	Datetime	The date and time the prospect was created.
DateOfBirth	Date	The date the prospect was born.
Degree	String	The degrees the prospect has received.
EmailOptedOut	Boolean	Whether the prospect is opted out of email or opted out in general if granular opt-out is not enabled.
Emails	String	A list of email addresses associated with the prospect.
EmailsOptedAt	Datetime	he date and time the prospect opted in out of emails.
EmailsOptStatus	String	The date and time the prospect opted in out of emails.
EngagedAt	Datetime	The date and time the prospect last engaged.
EngagedScore	Double	A number representing the quality of the lead based on the number of the prospect's opens, clicks and mailing replies.
EventName	String	The name of the event the prospect was met at.
ExternalId	String	A custom ID for the prospect often referencing an ID in an external system.
ExternalOwner	String	A custom owner for the prospect often referencing an ownering in an external system.
ExternalSource	String	The source of the resource's creation.
FacebookUrl	String	The prospect's Facebook URL.
FirstName	String	The first name of the prospect.
Gender	String	The gender of the prospect.
GithubUrl	String	The prospect's GitHub URL.
GithubUsername	String	The prospect's GitHub username.
GooglePlusUrl	String	The prospect's Google+ URL.
GraduationDate	Date	The graduation date of the prospect.
HomePhones	String	A list of home phone numbers associated with the prospect.
JobStartDate	Date	The starting date of the prospect's current job.
LastName	String	The last name of the prospect.
LinkedInConnections	String	The number of connections on the prospect's LinkedIn profile.
LinkedInId	String	The prospect's LinkedIn ID.
LinkedInSlug	String	The prospect's LinkedIn slug.
LinkedInUrl	String	The prospect's LinkedIn URL.
MiddleName	String	The middle name of the prospect.
MobilePhones	String	A list of mobile phone numbers associated with the prospect.
Name	String	The full name of the prospect.
Nickname	String	The nickname of the prospect.
Occupation	String	The occupation of the prospect.
OpenCount	Integer	The number of opens the prospect has made since the last touch point.
OptedOut	Boolean	A boolean value representing whether this prospect is currently opted out of all mailings.
OptedOutAt	Datetime	The date and time the prospect opted out of emails.
OtherPhones	String	A list of other phone numbers associated with the prospect.
PersonalNote1	String	A note field related to the prospect.
PersonalNote2	String	A second note field related to the prospect.
PreferredContact	String	The preferred contact method for the prospect.
QuoraUrl	String	The prospect's Quora URL.
Region	String	The primary geographic region of the prospect.
ReplyCount	Integer	The number of replies the prospect has made since the last touch point.
School	String	The schools the prospect has attended.
Score	Double	A custom score given to measure the quality of the lead.
SharingTeamId	String	The ID of the sharing team associated with this object.
Source	String	A custom source representing where the lead was first acquired.
Specialties	String	A description of the prospect's specialties.
StackOverflowId	String	The prospect's StackOverflow ID.
StackOverflowUrl	String	The prospect's StackOverflow URL.
StageName	String	Stage Name.
Tags	String	A list of tag values associated with the account.
TimeZone	String	The prospect's current timezone, preferably in the IANA format.
TimeZoneIana	String	The prospect's current IANA timezone, if available.
TimeZoneInferred	String	The prospect's current inferred IANA timezone if available.
Title	String	The title of the prospect.
TouchedAt	Datetime	The date and time the prospect was last touched.
TrashedAt	Datetime	The date a prospect was soft deleted.
TwitterUrl	String	The prospect's Twitter URL.
TwitterUsername	String	The prospect's Twitter username.
UpdatedAt	Datetime	The date and time the prospect was last updated.
VoipPhones	String	A list of voip phone numbers associated with the prospect.
WebsiteUrl1	String	The URL of the prospect's website.
WebsiteUrl2	String	The value of the prospect's second website URL field.
WebsiteUrl3	String	The value of the prospect's third website URL field.
WorkPhones	String	A list of work phone numbers associated with the prospect.
LinksSelf	String	Link self.
AccountId	Integer	Account Id.
AccountType	String	Account type.
BatchesLinks	String	Batches links.
CallsLinks	String	Calls link.
CreatorId	Integer	Creator Id.
CreatorType	String	Creator type.
TasksLinks	String	Task links.
OwnerId	Integer	Owner Id.
OwnerType	String	Owner type.
SequenceStatesLinks	String	Sequence states links.
UpdaterId	Integer	Updater Id.
UpdaterType	String	Updater type.
Type	String	Type.

SSIS Components for Outreach

Prospects

Select

Columns