Prospects
This table has 1 row per prospect and per org id.
Depending on how your org handles duplicate prospects, a single "individual" may have multiple prospect records to reflect different areas of business or selling motion. Many field definitions may have different meanings between customers, based on how one's plugin mappings are configured.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| ACCOUNT_ID | Varchar | The ID a prospect is currently associated with. | Maps to the ACCOUNTS table | |
| ADDRESS_CITY | Varchar | The city associated with a prospect. | ||
| ADDRESS_COUNTRY | Varchar | The country associated with a prospect. | ||
| ADDRESS_STATE | Varchar | The state associated with a prospect. | ||
| ADDRESS_STREET | Varchar | The street and home # associated with a prospect. | ||
| ADDRESS_STREET2 | Varchar | Secondary information associated with a prospect's street, like PO box or extensions. | ||
| ADDRESS_ZIP | Varchar | The zip code associated with a prospect. | ||
| AVAILABLE_AT | Timestamp_NTZ | The UTC time that indicates when a prospect is next available. | ||
| BENTO | Varchar | A collection of machines that power the Outreach app. Orgs live inside these. | This may distinguish orgs that are in different data centers. | |
| CALLS_OPTED_AT | Timestamp_NTZ | The UTC datetime for when a prospect opted into calls. | ||
| CALLS_OPTED_OUT_AT | Timestamp_NTZ | The UTC datetime for when a prospect opted out of calls. | ||
| CALLS_OPT_STATUS | Varchar | A string for if a prospect has explicitly opted out of or opted into being called. | 'opted_out', 'opted_in' | |
| CAMPAIGN_NAME | Varchar | The most recent marketing campaign associated with a prospect. See notes above table. | 'Social Selling', 'Unleash Direct Mail', 'Client Onboarding' | |
| CLICK_COUNT | Number | The cumulative sum of all links the prospect has clicked when click_tracking is enabled on mailings. | ||
| CREATED_AT | Timestamp_NTZ | The UTC datetime that the prospect was created in Outreach. | ||
| CREATOR_ID | Varchar | The ID for whomever created a record in Outreach, or who updated it if records are overwritten when changed. Maps to different tables based on the "creator_type" field. | ||
| CREATOR_TYPE | Varchar | The object type that created this row. | 'plugin', 'app', 'user', 'trigger', 'import' | This will dictate what table the creator_id maps to. |
| CUSTOM_FIELDS_LONG | Varchar | JSON-encoded custom fields. | ||
| DML_AT | Timestamp_NTZ | A datetime (local to server) in which the row was last modified. dml_at can be used to identify updated and new records, but as tables may not see changed records every day, it is not authoritative on when the table was last synced. | 2019-01-01 12:14:01:10 | Where dml_at::date >= current_date-7 This will return all rows modified in the last 7 days. |
| DML_TYPE | Varchar | The type of manipulation that last occurred to a row. | 'update', 'delete', 'insert', 'backfill', 'backfill-delete' | Where dml_type <> 'delete' Excludes deleted rows. |
| EMAILS_OPTED_AT | Timestamp_NTZ | The UTC datetime for when a prospect opted into emails. | ||
| EMAILS_OPTED_OUT_AT | Timestamp_NTZ | The UTC datetime for when a prospect opted out of emails. | ||
| EMAILS_OPT_STATUS | Varchar | A string for if a prospect has explicitly opted out of or opted into being emailed. | 'opted_out', 'opted_in' | |
| ENGAGED_AT | Timestamp_NTZ | The UTC datetime for when a prospect last opened, clicked, or replied to an email. | ||
| ENGAGED_SCORE | Number | The cumulative count of all engagements via Outreach. Represents responsiveness to contact. | ||
| EXTERNAL_ID | Varchar | A custom ID for the prospect, often referencing an ID in an external system. | ||
| EXTERNAL_OWNER | Varchar | A custom owner for the prospect, often referencing an owner in an external system. | ||
| EXTERNAL_SOURCE | Varchar | The source of the resource’s creation. | 'outreach-extension', 'outreach-api' | |
| FIRST_NAME | Varchar | The first name of the prospect. | ||
| GENDER | Varchar | The assumed gender of a prospect. | ||
| HOME_PHONE | Varchar | The phone number associated with a prospect's home. | PHONE_NUMBERS and CONTACTS is a stronger, normalized source of prospect info | |
| ID | Varchar | Represents an individual row of data in a table. Fields in other tables that match to this ID will be called thisTable_id. e.g. ID in the calls table will appear as the call_id in another table. | Count(1), count(id), and count(distinct id) are equivalent in a table without joins or groupings for a given bento & o_id. | |
| IMPORTED_FROM | Varchar | Generally Null; this is owned by the PLUGIN_MAPPINGS table. | 'outreach-extension', 'outreach-api' | |
| INFERRED_TIME_ZONE | Varchar | When available, a string showing the timezone of a Prospect. | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| LAST_NAME | Varchar | The last name of the prospect. | ||
| LINKED_IN | Varchar | The linkedin URL for a prospect. | ||
| LINKED_IN_CONNECTIONS | Number | Known # of LinkedIn connections. | ||
| LINKED_IN_ID | Varchar | The unique id for a prospect's LinkedIn profile | ||
| LINKED_IN_SLUG | Varchar | The unique LinkedIn value for building the LinkedIn URL. | ||
| MIDDLE_NAME | Varchar | The middle name of the prospect. | ||
| MOBILE_PHONE | Varchar | The mobile phone number associated with a prospect. | PHONE_NUMBERS and CONTACTS is a stronger, normalized source of prospect info | |
| NICKNAME | Varchar | Any known alternative names associated with a prospect. | ||
| OCCUPATION | Varchar | Known job title of a prospect. | ||
| OPEN_COUNT | Number | The cumulative number of times a prospect has opened a mailing from Outreach that was open tracking enabled. | ||
| OPTED_OUT_AT | Timestamp_NTZ | The UTC datetime that a prospect opted out of Outreach contacts in general. | ||
| OWNER_ID | Varchar | The ID associated with the user that is currently responsible for the prospect. | Maps to the USERS table | |
| O_ID | Varchar | Organization ID, also called instance ID. This is the ID for your unique Outreach account. | Most commonly used on joins alongside other primary keys. where a.o_id = b.o_id and a.id = b.a_id | |
| PERSONAL_NOTE1 | Varchar | Freeform text field for prospect notes in Outreach. | ||
| PERSONAL_NOTE2 | Varchar | Freeform text field for prospect notes in Outreach. | ||
| PERSONA_ID | Varchar | The ID associated with the prospects persona record in the PERSONAS table. | ||
| REGION | Varchar | The geo-region associated with a prospect. See notes above table for details. | ||
| REPLY_COUNT | Number | The cumulative number of times a prospect has replied to mailings from Outreach. | ||
| SCORE | Number | A generic score field that can be mapped to any integer field. See notes above table for details. | ||
| SMS_OPTED_AT | Timestamp_NTZ | The UTC datetime for when a prospect opted into texts. | ||
| SMS_OPTED_OUT_AT | Timestamp_NTZ | The UTC datetime for when a prospect opted out of texts. | ||
| SMS_OPT_STATUS | Varchar | A string for if a prospect has explicitly opted out of or opted into being texted. | 'opted_out', 'opted_in' | |
| SOURCE | Varchar | A generic source field that can be mapped to any string field. See notes above table for details. | 'Webinar', 'Marketing Event', 'Inbound Lead' | |
| SPECIALTIES | Varchar | Any known job specialities associated with a prospect. | ||
| STAGE_CHANGED_AT | Timestamp_NTZ | The UTC datetime that a prospect entered its current stage. | ||
| STAGE_ID | Varchar | An ID for the prospect's current stage. | ||
| SURROGATE_ID | Varchar | An md5 hash of bento, o_id and ID for a table. | This can be used to get distinct counts of records if an account has more than 1 org instance. Two orgs will both have a prospect with ID of "1" but each will have a different surrogate ID. | |
| TIME_ZONE | Varchar | Known timezone for a prospect, used when auto scheduling emails and tasks. | 'EDT', 'CDT', 'PDT' | |
| TIME_ZONE_OFFSET | Number | The hour conversion of that timezone from UTC in seconds. | If time_zone is PDT then this would be -25200 | |
| TITLE | Varchar | Known job title of a prospect. | ||
| TOUCHED_AT | Timestamp_NTZ | The UTC datetime for the last time a prospect was interacted with via Outreach (this includes when a user is sequenced, changes sequence step, or is taken out of sequence; when a task is updated; when a call disposition is recorded; or when the prospect engages with an email). | Select ID from prospects where touched_at > opted_out_at and opted_out_at is not null ; returns all prospects contacted post opt out | |
| TRASHED_AT | Timestamp_NTZ | This represents the UTC datetime a prospect was soft deleted based on dissociation with an account. Trashed prospects will eventually be deleted. | ||
| TRASHED_BY_ACCOUNT_ID | Varchar | The account ID a prospect was associated with when an account was put in the recycle bin. | Maps to the ACCOUNTS table | |
| UPDATED_AT | Timestamp_NTZ | The UTC datetime for the last time this record was updated. | 2019-01-01 20:14:01:10 | Almost equivalent to dml_at (but adjusted for time zones), but doesn't include record creation or deletion. |
| UPDATER_ID | Varchar | Same as creator_id above, but refers to who last did the update of the record. | ||
| UPDATER_TYPE | Varchar | Same as creator_type above, but may allow different field values. | 'plugin', 'app', 'user', 'trigger', 'import' | |
| WORK_PHONE | Varchar | The work phone number associated with a prospect | PHONE_NUMBERS and CONTACTS is a stronger, normalized source of prospect info |