Skip to content
Book a demoStart free
Connectors

Outreach connector

Set up the Outreach connector in Kaivo: authentication, configuration, the 17 BigQuery tables it syncs, and answers to common questions.

Outreach connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Outreach data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your marketing and sales data instead of moving it.

Sync your Outreach sales engagement data into BigQuery with Kaivo to measure outreach activity, sequences, and rep performance alongside your pipeline.

CategoryMarketing & Sales
AuthenticationAPI key
SetupSelf-service

Getting started with the Outreach connector

Section titled “Getting started with the Outreach connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Outreach account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Outreach credentials. You provide:

Field Description
Client Secret
The Client Secret of your Outreach developer application.

| | Refresh Token |

The token for obtaining the new access token.

|

Prerequisites

Outreach only supports OAuth, so you need your own Outreach developer application:

  1. In the Outreach developer portal, create an app, then note its Client ID and Client Secret and set a Redirect URI.
  2. Complete the OAuth authorization once to obtain a Refresh Token (see Outreach’s OAuth guide).

Then enter those values below.

Need help, or want an easier way to connect? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
Client ID
The Client ID of your Outreach developer application.

| | Redirect URI |

A Redirect URI is the location where the authorization server sends the user once the app has been successfully authorized and granted an authorization code or access token.

| | Start Date |

Any data before this date will not be fetched.

|

Kaivo syncs 17 tables from Outreach into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

accounts (175 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
buyer_intent_score FLOAT64
company_type STRING
created_at TIMESTAMP
custom1 STRING
custom10 STRING
custom100 STRING
custom101 STRING
custom102 STRING
custom103 STRING
custom104 STRING
custom105 STRING
custom106 STRING
custom107 STRING
custom108 STRING
custom109 STRING
custom11 STRING
custom110 STRING
custom111 STRING
custom112 STRING
custom113 STRING
custom114 STRING
custom115 STRING
custom116 STRING
custom117 STRING
custom118 STRING
custom119 STRING
custom12 STRING
custom120 STRING
custom121 STRING
custom122 STRING
custom123 STRING
custom124 STRING
custom125 STRING
custom126 STRING
custom127 STRING
custom128 STRING
custom129 STRING
custom13 STRING
custom130 STRING
custom131 STRING
custom132 STRING
custom133 STRING
custom134 STRING
custom135 STRING
custom136 STRING
custom137 STRING
custom138 STRING
custom139 STRING
custom14 STRING
custom140 STRING
custom141 STRING
custom142 STRING
custom143 STRING
custom144 STRING
custom145 STRING
custom146 STRING
custom147 STRING
custom148 STRING
custom149 STRING
custom15 STRING
custom150 STRING
custom16 STRING
custom17 STRING
custom18 STRING
custom19 STRING
custom2 STRING
custom20 STRING
custom21 STRING
custom22 STRING
custom23 STRING
custom24 STRING
custom25 STRING
custom26 STRING
custom27 STRING
custom28 STRING
custom29 STRING
custom3 STRING
custom30 STRING
custom31 STRING
custom32 STRING
custom33 STRING
custom34 STRING
custom35 STRING
custom36 STRING
custom37 STRING
custom38 STRING
custom39 STRING
custom4 STRING
custom40 STRING
custom41 STRING
custom42 STRING
custom43 STRING
custom44 STRING
custom45 STRING
custom46 STRING
custom47 STRING
custom48 STRING
custom49 STRING
custom5 STRING
custom50 STRING
custom51 STRING
custom52 STRING
custom53 STRING
custom54 STRING
custom55 STRING
custom56 STRING
custom57 STRING
custom58 STRING
custom59 STRING
custom6 STRING
custom60 STRING
custom61 STRING
custom62 STRING
custom63 STRING
custom64 STRING
custom65 STRING
custom66 STRING
custom67 STRING
custom68 STRING
custom69 STRING
custom7 STRING
custom70 STRING
custom71 STRING
custom72 STRING
custom73 STRING
custom74 STRING
custom75 STRING
custom76 STRING
custom77 STRING
custom78 STRING
custom79 STRING
custom8 STRING
custom80 STRING
custom81 STRING
custom82 STRING
custom83 STRING
custom84 STRING
custom85 STRING
custom86 STRING
custom87 STRING
custom88 STRING
custom89 STRING
custom9 STRING
custom90 STRING
custom91 STRING
custom92 STRING
custom93 STRING
custom94 STRING
custom95 STRING
custom96 STRING
custom97 STRING
custom98 STRING
custom99 STRING
custom_id STRING
domain STRING
external_source STRING
followers INT64
founded_at TIMESTAMP
id INT64
industry STRING
linked_in_employees INT64
linked_in_url STRING
locality STRING
name STRING
named BOOL
natural_name STRING
number_of_employees INT64
sharing_team_id STRING
touched_at TIMESTAMP
trashed_at TIMESTAMP
updated_at TIMESTAMP
website_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • accounts__assigned_teams (4 columns)
  • accounts__assigned_users (4 columns)
  • accounts__batches (4 columns)
  • accounts__creator (4 columns)
  • accounts__default_plugin_mapping (4 columns)
  • accounts__favorites (4 columns)
  • accounts__owner (4 columns)
  • accounts__prospects (4 columns)
  • accounts__tags (4 columns)
  • accounts__tasks (4 columns)
  • accounts__updater (4 columns)
call_dispositions (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
default_for_outbound_voicemail BOOL
id INT64
name STRING
order INT64
outcome STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • call_dispositions__calls (4 columns)
  • call_dispositions__creator (4 columns)
call_purposes (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
id INT64
name STRING
order INT64
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • call_purposes__calls (4 columns)
  • call_purposes__creator (4 columns)
calls (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
answered_at TIMESTAMP
completed_at TIMESTAMP
created_at TIMESTAMP
dialed_at TIMESTAMP
direction STRING
external_vendor STRING
from STRING
id INT64
note STRING
outcome STRING
recording_deletion_reason STRING
recording_url STRING
returned_at TIMESTAMP
sequence_action STRING
should_record_call BOOL
state STRING
state_changed_at TIMESTAMP
to STRING
uid STRING
updated_at TIMESTAMP
user_call_type STRING
vendor_call_id STRING
voicemail_recording_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • calls__batches (4 columns)
  • calls__call_disposition (4 columns)
  • calls__call_purpose (4 columns)
  • calls__opportunity (4 columns)
  • calls__outbound_voicemail (4 columns)
  • calls__phone (4 columns)
  • calls__phone_number (4 columns)
  • calls__prospect (4 columns)
  • calls__sequence (4 columns)
  • calls__sequence_state (4 columns)
  • calls__sequence_step (4 columns)
  • calls__tags (4 columns)
  • calls__task (4 columns)
  • calls__user (4 columns)
mailboxes (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
auth_id INT64
created_at TIMESTAMP
editable BOOL
email STRING
email_hash STRING
email_provider STRING
email_signature STRING
ews_custom_search_folder BOOL
ews_delegate_sync BOOL
ews_endpoint STRING
ews_impersonation BOOL
ews_ssl_verify_mode INT64
exchange_version STRING
id INT64
imap_host STRING
imap_port INT64
imap_ssl BOOL
max_emails_per_day INT64
max_mailings_per_day INT64
max_mailings_per_week INT64
opt_out_message STRING
opt_out_signature STRING
provider_id INT64
provider_type STRING
send_disabled BOOL
send_errored_at TIMESTAMP
send_max_retries INT64
send_method STRING
send_period INT64
send_permanent_error_at TIMESTAMP
send_requires_sync BOOL
send_success_at TIMESTAMP
send_threshold INT64
sendgrid_webhook_url STRING
smtp_host STRING
smtp_port INT64
smtp_ssl BOOL
smtp_username STRING
sync_active_frequency INT64
sync_disabled BOOL
sync_errored_at TIMESTAMP
sync_finished_at TIMESTAMP
sync_method STRING
sync_outreach_folder BOOL
sync_passive_frequency INT64
sync_permanent_error_at TIMESTAMP
sync_success_at TIMESTAMP
updated_at TIMESTAMP
user_id INT64
username STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • mailboxes__creator (4 columns)
  • mailboxes__mail_aliases (4 columns)
  • mailboxes__mailings (4 columns)
  • mailboxes__prospect_email_exclusions (4 columns)
  • mailboxes__updater (4 columns)
  • mailboxes__user (4 columns)
mailings (49 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attributable_sequence_id INT64
attributable_sequence_name STRING
body_html STRING
body_text STRING
bounced_at TIMESTAMP
click_count INT64
clicked_at TIMESTAMP
created_at TIMESTAMP
delivered_at TIMESTAMP
desired_at TIMESTAMP
error_backtrace STRING
error_reason STRING
follow_up_sequence_id INT64
follow_up_sequence_name STRING
follow_up_sequence_starting_date TIMESTAMP
follow_up_task_scheduled_at TIMESTAMP
follow_up_task_type STRING
id INT64
mailbox_address STRING
mailing_type STRING
marked_as_spam_at TIMESTAMP
meeting_description STRING
meeting_duration INT64
meeting_location STRING
meeting_title STRING
message_id STRING
notify_thread_condition STRING
notify_thread_scheduled_at TIMESTAMP
notify_thread_status STRING
open_count INT64
opened_at TIMESTAMP
optimized_scheduled_at TIMESTAMP
override_safety_settings BOOL
replied_at TIMESTAMP
reply_sentiment STRING
retry_at TIMESTAMP
retry_count INT64
retry_interval INT64
schedule_id INT64
scheduled_at TIMESTAMP
state STRING
state_changed_at TIMESTAMP
subject STRING
track_links BOOL
track_opens BOOL
unsubscribed_at TIMESTAMP
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • mailings__attachments (4 columns)
  • mailings__calendar (4 columns)
  • mailings__follow_up_sequence (4 columns)
  • mailings__mailbox (4 columns)
  • mailings__opportunity (4 columns)
  • mailings__prospect (4 columns)
  • mailings__recipients (4 columns)
  • mailings__references (4 columns)
  • mailings__schedule (4 columns)
  • mailings__sequence (4 columns)
  • mailings__sequence_state (4 columns)
  • mailings__sequence_step (4 columns)
  • mailings__task (4 columns)
  • mailings__tasks (4 columns)
  • mailings__template (4 columns)
  • mailings__user (4 columns)
opportunities (173 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
amount INT64
close_date TIMESTAMP
created_at TIMESTAMP
currency_type STRING
custom1 STRING
custom10 STRING
custom100 STRING
custom101 STRING
custom102 STRING
custom103 STRING
custom104 STRING
custom105 STRING
custom106 STRING
custom107 STRING
custom108 STRING
custom109 STRING
custom11 STRING
custom110 STRING
custom111 STRING
custom112 STRING
custom113 STRING
custom114 STRING
custom115 STRING
custom116 STRING
custom117 STRING
custom118 STRING
custom119 STRING
custom12 STRING
custom120 STRING
custom121 STRING
custom122 STRING
custom123 STRING
custom124 STRING
custom125 STRING
custom126 STRING
custom127 STRING
custom128 STRING
custom129 STRING
custom13 STRING
custom130 STRING
custom131 STRING
custom132 STRING
custom133 STRING
custom134 STRING
custom135 STRING
custom136 STRING
custom137 STRING
custom138 STRING
custom139 STRING
custom14 STRING
custom140 STRING
custom141 STRING
custom142 STRING
custom143 STRING
custom144 STRING
custom145 STRING
custom146 STRING
custom147 STRING
custom148 STRING
custom149 STRING
custom15 STRING
custom150 STRING
custom16 STRING
custom17 STRING
custom18 STRING
custom19 STRING
custom2 STRING
custom20 STRING
custom21 STRING
custom22 STRING
custom23 STRING
custom24 STRING
custom25 STRING
custom26 STRING
custom27 STRING
custom28 STRING
custom29 STRING
custom3 STRING
custom30 STRING
custom31 STRING
custom32 STRING
custom33 STRING
custom34 STRING
custom35 STRING
custom36 STRING
custom37 STRING
custom38 STRING
custom39 STRING
custom4 STRING
custom40 STRING
custom41 STRING
custom42 STRING
custom43 STRING
custom44 STRING
custom45 STRING
custom46 STRING
custom47 STRING
custom48 STRING
custom49 STRING
custom5 STRING
custom50 STRING
custom51 STRING
custom52 STRING
custom53 STRING
custom54 STRING
custom55 STRING
custom56 STRING
custom57 STRING
custom58 STRING
custom59 STRING
custom6 STRING
custom60 STRING
custom61 STRING
custom62 STRING
custom63 STRING
custom64 STRING
custom65 STRING
custom66 STRING
custom67 STRING
custom68 STRING
custom69 STRING
custom7 STRING
custom70 STRING
custom71 STRING
custom72 STRING
custom73 STRING
custom74 STRING
custom75 STRING
custom76 STRING
custom77 STRING
custom78 STRING
custom79 STRING
custom8 STRING
custom80 STRING
custom81 STRING
custom82 STRING
custom83 STRING
custom84 STRING
custom85 STRING
custom86 STRING
custom87 STRING
custom88 STRING
custom89 STRING
custom9 STRING
custom90 STRING
custom91 STRING
custom92 STRING
custom93 STRING
custom94 STRING
custom95 STRING
custom96 STRING
custom97 STRING
custom98 STRING
custom99 STRING
external_created_at TIMESTAMP
health_category STRING
health_score INT64
id INT64
map_link STRING
map_next_steps STRING
map_number_of_overdue_tasks INT64
map_status STRING
name STRING
next_step STRING
opportunity_type STRING
probability INT64
prospecting_rep_id STRING
sharing_team_id STRING
touched_at TIMESTAMP
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • opportunities__account (4 columns)
  • opportunities__assigned_teams (4 columns)
  • opportunities__assigned_users (4 columns)
  • opportunities__creator (4 columns)
  • opportunities__default_plugin_mapping (4 columns)
  • opportunities__external_creator (4 columns)
  • opportunities__favorites (4 columns)
  • opportunities__opportunity_health_factors (4 columns)
  • opportunities__opportunity_stage (4 columns)
  • opportunities__owner (4 columns)
  • opportunities__primary_prospect (4 columns)
  • opportunities__prospects (4 columns)
  • opportunities__stage (4 columns)
  • opportunities__tags (4 columns)
  • opportunities__updater (4 columns)
personas (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at TIMESTAMP
id INT64
name STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • personas__prospects (4 columns)
prospects (243 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_name STRING
added_at TIMESTAMP
address_city STRING
address_country STRING
address_state STRING
address_street STRING
address_street2 STRING
address_zip STRING
angel_list_url STRING
available_at TIMESTAMP
call_opted_out BOOL
calls_opt_status STRING
calls_opted_at TIMESTAMP
campaign_name STRING
click_count INT64
company STRING
company_followers INT64
company_founded_at STRING
company_industry STRING
company_linked_in STRING
company_linked_in_employees STRING
company_locality STRING
company_natural STRING
company_size INT64
company_start_date STRING
company_type STRING
created_at TIMESTAMP
custom1 STRING
custom10 STRING
custom100 STRING
custom101 STRING
custom102 STRING
custom103 STRING
custom104 STRING
custom105 STRING
custom106 STRING
custom107 STRING
custom108 STRING
custom109 STRING
custom11 STRING
custom110 STRING
custom111 STRING
custom112 STRING
custom113 STRING
custom114 STRING
custom115 STRING
custom116 STRING
custom117 STRING
custom118 STRING
custom119 STRING
custom12 STRING
custom120 STRING
custom121 STRING
custom122 STRING
custom123 STRING
custom124 STRING
custom125 STRING
custom126 STRING
custom127 STRING
custom128 STRING
custom129 STRING
custom13 STRING
custom130 STRING
custom131 STRING
custom132 STRING
custom133 STRING
custom134 STRING
custom135 STRING
custom136 STRING
custom137 STRING
custom138 STRING
custom139 STRING
custom14 STRING
custom140 STRING
custom141 STRING
custom142 STRING
custom143 STRING
custom144 STRING
custom145 STRING
custom146 STRING
custom147 STRING
custom148 STRING
custom149 STRING
custom15 STRING
custom150 STRING
custom16 STRING
custom17 STRING
custom18 STRING
custom19 STRING
custom2 STRING
custom20 STRING
custom21 STRING
custom22 STRING
custom23 STRING
custom24 STRING
custom25 STRING
custom26 STRING
custom27 STRING
custom28 STRING
custom29 STRING
custom3 STRING
custom30 STRING
custom31 STRING
custom32 STRING
custom33 STRING
custom34 STRING
custom35 STRING
custom36 STRING
custom37 STRING
custom38 STRING
custom39 STRING
custom4 STRING
custom40 STRING
custom41 STRING
custom42 STRING
custom43 STRING
custom44 STRING
custom45 STRING
custom46 STRING
custom47 STRING
custom48 STRING
custom49 STRING
custom5 STRING
custom50 STRING
custom51 STRING
custom52 STRING
custom53 STRING
custom54 STRING
custom55 STRING
custom56 STRING
custom57 STRING
custom58 STRING
custom59 STRING
custom6 STRING
custom60 STRING
custom61 STRING
custom62 STRING
custom63 STRING
custom64 STRING
custom65 STRING
custom66 STRING
custom67 STRING
custom68 STRING
custom69 STRING
custom7 STRING
custom70 STRING
custom71 STRING
custom72 STRING
custom73 STRING
custom74 STRING
custom75 STRING
custom76 STRING
custom77 STRING
custom78 STRING
custom79 STRING
custom8 STRING
custom80 STRING
custom81 STRING
custom82 STRING
custom83 STRING
custom84 STRING
custom85 STRING
custom86 STRING
custom87 STRING
custom88 STRING
custom89 STRING
custom9 STRING
custom90 STRING
custom91 STRING
custom92 STRING
custom93 STRING
custom94 STRING
custom95 STRING
custom96 STRING
custom97 STRING
custom98 STRING
custom99 STRING
date_of_birth TIMESTAMP
degree STRING
email_opted_out BOOL
emails_opt_status STRING
emails_opted_at TIMESTAMP
engaged_at TIMESTAMP
engaged_score FLOAT64
event_name STRING
external_id STRING
external_owner STRING
external_source STRING
facebook_url STRING
first_name STRING
gender STRING
github_url STRING
github_username STRING
google_plus_url STRING
graduation_date TIMESTAMP
id INT64
job_start_date TIMESTAMP
last_name STRING
linked_in_connections INT64
linked_in_id STRING
linked_in_slug STRING
linked_in_url STRING
middle_name STRING
name STRING
nickname STRING
occupation STRING
open_count INT64
opted_out BOOL
opted_out_at TIMESTAMP
persona_name JSON
personal_note1 STRING
personal_note2 STRING
preferred_contact STRING
quora_url STRING
region STRING
reply_count INT64
school STRING
score FLOAT64
sharing_team_id STRING
sms_opt_status STRING
sms_opted_at STRING
sms_opted_out BOOL
source STRING
specialties STRING
stack_overflow_id STRING
stack_overflow_url STRING
stage_name STRING
time_zone STRING
time_zone_iana STRING
time_zone_inferred STRING
title STRING
touched_at TIMESTAMP
trashed_at TIMESTAMP
twitter_url STRING
twitter_username STRING
updated_at TIMESTAMP
updater_id INT64
updater_type STRING
website_url1 STRING
website_url2 STRING
website_url3 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • prospects__account (4 columns)
  • prospects__active_sequence_states (4 columns)
  • prospects__assigned_teams (4 columns)
  • prospects__assigned_users (4 columns)
  • prospects__batches (4 columns)
  • prospects__calls (4 columns)
  • prospects__contact_histogram (3 columns)
  • prospects__contact_histogram__list (4 columns)
  • prospects__creator (4 columns)
  • prospects__default_plugin_mapping (4 columns)
  • prospects__email_addresses (4 columns)
  • prospects__email_contacts (16 columns)
  • prospects__emails (4 columns)
  • prospects__favorites (4 columns)
  • prospects__home_phones (4 columns)
  • prospects__mailings (4 columns)
  • prospects__mobile_phones (4 columns)
  • prospects__opportunities (4 columns)
  • prospects__opportunity_prospect_roles (4 columns)
  • prospects__other_phones (4 columns)
  • prospects__owner (4 columns)
  • prospects__persona (4 columns)
  • prospects__phone_numbers (4 columns)
  • prospects__sequence_states (4 columns)
  • prospects__stage (4 columns)
  • prospects__tags (4 columns)
  • prospects__tasks (4 columns)
  • prospects__trashed_by_account (4 columns)
  • prospects__updater (4 columns)
  • prospects__voip_phones (4 columns)
  • prospects__work_phones (4 columns)
sequence_states (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active_at TIMESTAMP
bounce_count INT64
call_completed_at TIMESTAMP
click_count INT64
created_at TIMESTAMP
deliver_count INT64
error_reason STRING
failure_count INT64
id INT64
negative_reply_count INT64
neutral_reply_count INT64
open_count INT64
opt_out_count INT64
pause_reason STRING
positive_reply_count INT64
replied_at TIMESTAMP
reply_count INT64
schedule_count INT64
state STRING
state_changed_at TIMESTAMP
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • sequence_states__account (4 columns)
  • sequence_states__active_step_mailings (4 columns)
  • sequence_states__active_step_tasks (4 columns)
  • sequence_states__calls (4 columns)
  • sequence_states__creator (4 columns)
  • sequence_states__mailbox (4 columns)
  • sequence_states__mailings (4 columns)
  • sequence_states__opportunity (4 columns)
  • sequence_states__prospect (4 columns)
  • sequence_states__sequence (4 columns)
  • sequence_states__sequence_step (4 columns)
  • sequence_states__tasks (4 columns)
sequence_steps (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
bounce_count INT64
click_count INT64
created_at TIMESTAMP
date DATE
deliver_count INT64
display_name STRING
failure_count INT64
id INT64
interval INT64
negative_reply_count INT64
neutral_reply_count INT64
open_count INT64
opt_out_count INT64
order INT64
positive_reply_count INT64
reply_count INT64
schedule_count INT64
step_type STRING
task_auto_display STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • sequence_steps__call_purpose (4 columns)
  • sequence_steps__calls (4 columns)
  • sequence_steps__creator (4 columns)
  • sequence_steps__mailings (4 columns)
  • sequence_steps__sequence (4 columns)
  • sequence_steps__sequence_templates (4 columns)
  • sequence_steps__task_priority (4 columns)
  • sequence_steps__tasks (4 columns)
  • sequence_steps__updater (4 columns)
sequences (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
automation_percentage FLOAT64
bounce_count INT64
click_count INT64
created_at TIMESTAMP
deliver_count INT64
duration_in_days INT64
enabled BOOL
enabled_at TIMESTAMP
failure_count INT64
finish_on_reply BOOL
id INT64
last_used_at TIMESTAMP
locked BOOL
locked_at TIMESTAMP
max_activations INT64
name STRING
negative_reply_count INT64
neutral_reply_count INT64
num_contacted_prospects INT64
num_replied_prospects INT64
open_count INT64
opt_out_count INT64
positive_reply_count INT64
primary_reply_action STRING
primary_reply_pause_duration INT64
reply_count INT64
schedule_count INT64
schedule_interval_type STRING
secondary_reply_action STRING
secondary_reply_pause_duration INT64
sequence_step_count INT64
sequence_type STRING
share_type STRING
throttle_capacity INT64
throttle_max_adds_per_day INT64
throttle_paused BOOL
throttle_paused_at TIMESTAMP
transactional BOOL
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • sequences__calls (4 columns)
  • sequences__content_category_memberships (4 columns)
  • sequences__creator (4 columns)
  • sequences__mailings (4 columns)
  • sequences__owner (4 columns)
  • sequences__ruleset (4 columns)
  • sequences__schedule (4 columns)
  • sequences__sequence_states (4 columns)
  • sequences__sequence_steps (4 columns)
  • sequences__tags (4 columns)
  • sequences__tasks (4 columns)
  • sequences__updater (4 columns)
snippets (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
body_html STRING
body_text STRING
created_at TIMESTAMP
id INT64
name STRING
share_type STRING
tags STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • snippets__content_category_memberships (4 columns)
  • snippets__creator (4 columns)
  • snippets__owner (4 columns)
  • snippets__updater (4 columns)
stages (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
color STRING
created_at TIMESTAMP
id INT64
name STRING
order INT64
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • stages__creator (4 columns)
  • stages__prospects (4 columns)
  • stages__updater (4 columns)
tasks (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action STRING
autoskip_at TIMESTAMP
compiled_sequence_template_html STRING
completed BOOL
completed_at TIMESTAMP
created_at TIMESTAMP
due_at TIMESTAMP
id INT64
note STRING
opportunity_association STRING
scheduled_at TIMESTAMP
state STRING
state_changed_at TIMESTAMP
task_type STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • tasks__account (4 columns)
  • tasks__call (4 columns)
  • tasks__calls (4 columns)
  • tasks__completer (4 columns)
  • tasks__creator (4 columns)
  • tasks__default_plugin_mapping (4 columns)
  • tasks__mailing (4 columns)
  • tasks__mailings (4 columns)
  • tasks__opportunity (4 columns)
  • tasks__owner (4 columns)
  • tasks__prospect (4 columns)
  • tasks__prospect_account (4 columns)
  • tasks__prospect_contacts (4 columns)
  • tasks__prospect_owner (4 columns)
  • tasks__prospect_phone_numbers (4 columns)
  • tasks__prospect_stage (4 columns)
  • tasks__sequence (4 columns)
  • tasks__sequence_sequence_steps (4 columns)
  • tasks__sequence_state (4 columns)
  • tasks__sequence_state_sequence_step (4 columns)
  • tasks__sequence_state_sequence_step_overrides (4 columns)
  • tasks__sequence_state_starting_template (4 columns)
  • tasks__sequence_step (4 columns)
  • tasks__sequence_step_override_templates (4 columns)
  • tasks__sequence_template (4 columns)
  • tasks__sequence_template_template (4 columns)
  • tasks__subject (4 columns)
  • tasks__task_priority (4 columns)
  • tasks__task_theme (4 columns)
  • tasks__template (4 columns)
templates (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
archived BOOL
archived_at TIMESTAMP
bcc_recipients STRING
body_html STRING
body_text STRING
bounce_count INT64
cc_recipients STRING
click_count INT64
created_at TIMESTAMP
deliver_count INT64
failure_count INT64
id INT64
last_used_at TIMESTAMP
name STRING
negative_reply_count INT64
neutral_reply_count INT64
open_count INT64
opt_out_count INT64
positive_reply_count INT64
reply_count INT64
schedule_count INT64
share_type STRING
subject STRING
tags STRING
to_recipients STRING
track_links BOOL
track_opens BOOL
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • templates__content_category_memberships (4 columns)
  • templates__creator (4 columns)
  • templates__owner (4 columns)
  • templates__recipients (4 columns)
  • templates__sequence_templates (4 columns)
  • templates__updater (4 columns)
users (103 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accounts_view_id INT64
active_prospects_count INT64
activity_notifications_disabled BOOL
batches_view_id INT64
bounce_warning_email_enabled BOOL
bridge_phone STRING
bridge_phone_extension STRING
buyer_language_preference STRING
calendar_events_view_id INT64
calls_view_id INT64
controlled_tab_default STRING
created_at TIMESTAMP
current_sign_in_at TIMESTAMP
custom1 STRING
custom2 STRING
custom3 STRING
custom4 STRING
custom5 STRING
daily_digest_email_enabled BOOL
default_ruleset_id INT64
default_schedule_id INT64
duties_set_at STRING
email STRING
enable_voice_recordings BOOL
engagement_emails_enabled BOOL
first_name STRING
global_id STRING
id INT64
imports_view_id JSON
inbound_bridge_phone STRING
inbound_bridge_phone_extension STRING
inbound_call_behavior STRING
inbound_phone_type STRING
inbound_voicemail_custom_message_text STRING
inbound_voicemail_message_text_voice STRING
inbound_voicemail_prompt_type STRING
kaia_recordings_view_id INT64
keep_bridge_phone_connected BOOL
language_preference STRING
last_name STRING
last_sign_in_at TIMESTAMP
link_to_sequence_state_in_task_flow BOOL
live_listen_view_id INT64
locked BOOL
mailbox_error_email_enabled BOOL
mailings_delivered_count INT64
mailings_replied_count INT64
mailings_view_id INT64
meeting_engagement_notification_enabled BOOL
meeting_types_view_id INT64
name STRING
notifications_enabled BOOL
oce_click_to_dial_everywhere BOOL
oce_gmail_toolbar BOOL
oce_gmail_tracking_state STRING
oce_salesforce_email_decorating BOOL
oce_salesforce_phone_decorating BOOL
oce_universal_task_flow BOOL
oce_window_mode BOOL
onboarded_at TIMESTAMP
opportunities_view_id INT64
orca_standalone_enabled BOOL
password_expires_at TIMESTAMP
phone_country_code STRING
phone_number STRING
phone_type STRING
phones_view_id INT64
plugin_alert_notification_enabled BOOL
preferred_voice_region STRING
prefers_local_presence BOOL
primary_timezone STRING
prospect_detail_default STRING
prospects_view_id INT64
reports_sequence_performance_view_id INT64
reports_team_perf_view_id INT64
reports_team_performance_intraday_view_id INT64
reports_team_performance_view_id INT64
reports_view_id INT64
scim_external_id STRING
scim_source STRING
secondary_timezone STRING
send_invite_fallback BOOL
sender_notifications_excluded BOOL
sequence_states_view_id INT64
sequences_view_id INT64
snippets_view_id INT64
tasks_due_count INT64
tasks_view_id INT64
teams_view_id INT64
templates_view_id INT64
tertiary_timezone STRING
texting_email_notifications BOOL
title STRING
unknown_reply_email_enabled BOOL
updated_at TIMESTAMP
use_sales_navigator_for_linked_in_tasks BOOL
user_guid STRING
username STRING
users_view_id INT64
voicemail_notification_enabled BOOL
weekly_digest_email_enabled BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • users__batches (4 columns)
  • users__calendar (4 columns)
  • users__content_categories (4 columns)
  • users__content_category_ownerships (4 columns)
  • users__creator (4 columns)
  • users__duties (6 columns)
  • users__favorites (4 columns)
  • users__job_role (4 columns)
  • users__mailbox (4 columns)
  • users__mailboxes (4 columns)
  • users__outbound_voicemails (4 columns)
  • users__phone (4 columns)
  • users__phones (4 columns)
  • users__profile (4 columns)
  • users__recipients (4 columns)
  • users__role (4 columns)
  • users__sms_phone (4 columns)
  • users__teams (4 columns)
  • users__updater (4 columns)
  • users__voicemail_prompts (4 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Outreach supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Outreach?

Section titled “How long does the initial sync take for Outreach?”

It depends on how much history is in your Outreach account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Outreach’s schema changes?

Section titled “What happens when Outreach’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Outreach, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Outreach instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Outreach connector in Kaivo and all of its synced data is deleted with it.

Use sequences and sequence_states to see which cadences move prospects forward.

Bring calls, mailings, and tasks together to measure outreach volume by rep.

Join opportunities with prospects to connect outreach activity to deals.

Group activity by users to compare effort and results across the team.

Once Outreach data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Outreach data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Outreach connector pricing and plan details.