Calls

This table has 1 row per call and per org id.

Many timestamps will be blank for manually logged calls. Calls completed via Outreach will be the most detail rich.

Column	Type	Definition	Sample Value(s)	Sample Use
ANSWERED_AT	Timestamp_NTZ	The UTC datetime that the phone call finished ringing and connected. This includes voicemails.
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.
CALLEE_HELD	Boolean	A Boolean value for if the dialer put the call on hold.
CALL_DISPOSITION_ID	Varchar	Maps a call outcome to a disposition in the CALL_DISPOSITIONS table.
CALL_PURPOSE_ID	Varchar	Maps a call to the reason for the call in the CALL_PURPOSES table.
COMPLETED_AT	Timestamp_NTZ	The UTC datetime for when the call was hung up.		The difference between answered_at and completed_At is call duration!
CREATED_AT	Timestamp_NTZ	The UTC datetime for when a call was recorded. For most calls this is synonymous with dialed_at.
DIALED_AT	Timestamp_NTZ	The UTC datetime for when the user clicked "dial" in the app.
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.
EXTERNAL_VENDOR	Varchar	If a call service was used, it will show the provider name. If manually logged it will be NULL.
FROM	Varchar	The phone number that initiated the call. For inbound calls this is the prospects phone #.
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.
IS_DELETED_IN_APP	Boolean	Is the latest dml_type "delete" or "backfill-delete".		Where is_deleted_in_app = false Only keeps undeleted rows.
MISSED_AT	Timestamp_NTZ	For inbound calls, this is the UTC datetime for when the prospect had called.
NOTE	Varchar	Any freeform notes associated with the call.
OPPORTUNITY_ID	Varchar	If the call is associated with an opportunity, its ID will be listed here.		Maps to the OPPORTUNITIES table
OUTBOUND	Boolean	A Boolean field for if the call was outbound. False implies inbound.		case when OUTBOUND = FALSE then 'Inbound' else 'Outbound' end as call_direction
OUTCOME	Varchar	A freeform text field for the outcome of a call. Often Null.
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
PHONE_ID	Varchar	The phone ID of the rep.		Maps to the PHONES table
PHONE_NUMBER_ID	Varchar	An ID for the Phone number that was dialed.		Maps to the PHONE_NUMBERS table
PROSPECT_ID	Varchar	The ID of the prospect that was called.		Maps to the PROSPECTS table
RINGING_AT	Timestamp_NTZ	The UTC datetime for when the dial tone is first heard.		differences between Dialed_at and Ringing_at can be used to triage bad call connectivity
SEQUENCE_ACTION	Varchar	A nominal field for the action the call causes in the sequence.
SEQUENCE_ID	Varchar	The sequence ID if this call was done in sequence.		Maps to the SEQUENCES table
SEQUENCE_STATE_ID	Varchar	The sequence state ID if this call was done in sequence.		Maps to the SEQUENCE_STATES table
SEQUENCE_STEP_ID	Varchar	The sequence step of the associated sequence state ID.		maps to the SEQUENCE_STEPS table
SHOULD_RECORD_CALL	Boolean	A Boolean flag for if this call will be recorded or not.
STATE	Varchar	A nominal field describing the current state of the call. if a call occurs mid ETL you may see "ringing".	'ringing', 'complete', 'no_answer', 'canceled'
STATE_CHANGED_AT	Timestamp_NTZ	The UTC datetime of when a calls state has changed. This is redundant if looking for answered_at or completed_at datetimes.
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.
TASK_ID	Varchar	The associated task ID if the call is on behalf of a call task.		Maps to the TASKS table
TO	Varchar	The phone number that was dialed. For inbound calls it is the reps phone number.
TRANSFEREE_USER_ID	Varchar	The user ID that initiated a call transfer.		Maps to the USERS table
TRANSFERRED_FROM_CALL_ID	Varchar	The call ID of the original call that was transfered.		Maps to the CALLS table
TRANSFERRED_TO_USER_ID	Varchar	The User ID the call was transferred to.		Maps to the USERS table
UID	Varchar	A unique call hashed ID provided for Twilio calls. It does not not map to anything, but can be used for unique counts.
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'
USER_CALL_TYPE	Varchar	If the call was conducted over VoIP or Bridge.	'voip', 'bridge'
USER_ID	Varchar	The user ID associated with the call.		Maps to the USERS table
XFEREE_HELD	Boolean	A Boolean flag for if the transferee put the call on hold.
XFEREE_ID	Varchar	An ID that maps to who was transferred.		Maps to the PROSPECTS table