Accounts
This table has 1 row per account and per org id.
Depending on how your organization handles duplicate accounts, a single customer may have multiple account records to reflect different areas of business or selling motions. Many field definitions may have different meanings between customers, based on how your plugin mappings are configured.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| 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. | |
| COMPANY_TYPE | Varchar | This field's definition may vary, see notes above for details. | ||
| CREATED_AT | Timestamp_NTZ | The UTC datetime that the account 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. Use parse_json(custom_fields_long) to access nested fields. | {"custom1":"9000"} | |
| CUSTOM_ID | Varchar | A custom ID for the account, often referencing an ID in an external system. | ||
| DESCRIPTION | Varchar | A description of the account. | ||
| 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. |
| DOMAIN | Varchar | The email domain associated with an account, often used in blocking emails to partners that aren't prospects. | ||
| 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. | |
| INDUSTRY | Varchar | The industry associated with an account. Industry types may vary between customers. | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| LINKED_IN | Varchar | The URL associated with the company's LinkedIn page. | ||
| LINKED_IN_EMPLOYEES | Number | The # of employees based on the company's LinkedIn page. | ||
| NAME | Varchar | The name of the account. If account name is NULL this is a placeholder for an account. | ||
| NAMED | Boolean | A Boolean field for if an account is "named" or targeted. | ||
| OWNER_ID | Varchar | The associated user ID responsible for the account. 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 | |
| SIZE | Number | Relative size of a company, whose UOM may vary based on mappings. See note above this table for details. | ||
| 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. | |
| TOUCHED_AT | Timestamp_NTZ | The UTC datetime field for the last time a prospect associated with this account was contacted via Outreach. | ||
| TRASHED_AT | Timestamp_NTZ | The UTC datetime that an account was moved to the recycle bin in the app. Eventually, trashed accounts will be deleted. | ||
| 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' | |
| WEBSITE | Varchar | A website URL associated with an account. |