Skip to main content
Connectors

Outreach connector

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

Written By Lauri Raivio

Last updated 16 days ago

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.

What is the Outreach connector

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

  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.

Authenticating Outreach

Authenticate with your Outreach credentials. You provide:

FieldDescription
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.

Configuring the Outreach connector

When you set up the connector, you provide:

FieldDescription
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.

Tables and columns synced from Outreach

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

ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
buyer_intent_scoreFLOAT64
company_typeSTRING
created_atTIMESTAMP
custom1STRING
custom10STRING
custom100STRING
custom101STRING
custom102STRING
custom103STRING
custom104STRING
custom105STRING
custom106STRING
custom107STRING
custom108STRING
custom109STRING
custom11STRING
custom110STRING
custom111STRING
custom112STRING
custom113STRING
custom114STRING
custom115STRING
custom116STRING
custom117STRING
custom118STRING
custom119STRING
custom12STRING
custom120STRING
custom121STRING
custom122STRING
custom123STRING
custom124STRING
custom125STRING
custom126STRING
custom127STRING
custom128STRING
custom129STRING
custom13STRING
custom130STRING
custom131STRING
custom132STRING
custom133STRING
custom134STRING
custom135STRING
custom136STRING
custom137STRING
custom138STRING
custom139STRING
custom14STRING
custom140STRING
custom141STRING
custom142STRING
custom143STRING
custom144STRING
custom145STRING
custom146STRING
custom147STRING
custom148STRING
custom149STRING
custom15STRING
custom150STRING
custom16STRING
custom17STRING
custom18STRING
custom19STRING
custom2STRING
custom20STRING
custom21STRING
custom22STRING
custom23STRING
custom24STRING
custom25STRING
custom26STRING
custom27STRING
custom28STRING
custom29STRING
custom3STRING
custom30STRING
custom31STRING
custom32STRING
custom33STRING
custom34STRING
custom35STRING
custom36STRING
custom37STRING
custom38STRING
custom39STRING
custom4STRING
custom40STRING
custom41STRING
custom42STRING
custom43STRING
custom44STRING
custom45STRING
custom46STRING
custom47STRING
custom48STRING
custom49STRING
custom5STRING
custom50STRING
custom51STRING
custom52STRING
custom53STRING
custom54STRING
custom55STRING
custom56STRING
custom57STRING
custom58STRING
custom59STRING
custom6STRING
custom60STRING
custom61STRING
custom62STRING
custom63STRING
custom64STRING
custom65STRING
custom66STRING
custom67STRING
custom68STRING
custom69STRING
custom7STRING
custom70STRING
custom71STRING
custom72STRING
custom73STRING
custom74STRING
custom75STRING
custom76STRING
custom77STRING
custom78STRING
custom79STRING
custom8STRING
custom80STRING
custom81STRING
custom82STRING
custom83STRING
custom84STRING
custom85STRING
custom86STRING
custom87STRING
custom88STRING
custom89STRING
custom9STRING
custom90STRING
custom91STRING
custom92STRING
custom93STRING
custom94STRING
custom95STRING
custom96STRING
custom97STRING
custom98STRING
custom99STRING
custom_idSTRING
domainSTRING
external_sourceSTRING
followersINT64
founded_atTIMESTAMP
idINT64
industrySTRING
linked_in_employeesINT64
linked_in_urlSTRING
localitySTRING
nameSTRING
namedBOOL
natural_nameSTRING
number_of_employeesINT64
sharing_team_idSTRING
touched_atTIMESTAMP
trashed_atTIMESTAMP
updated_atTIMESTAMP
website_urlSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
created_atTIMESTAMP
default_for_outbound_voicemailBOOL
idINT64
nameSTRING
orderINT64
outcomeSTRING
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • call_dispositions__calls (4 columns)
  • call_dispositions__creator (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
created_atTIMESTAMP
idINT64
nameSTRING
orderINT64
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • call_purposes__calls (4 columns)
  • call_purposes__creator (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
answered_atTIMESTAMP
completed_atTIMESTAMP
created_atTIMESTAMP
dialed_atTIMESTAMP
directionSTRING
external_vendorSTRING
fromSTRING
idINT64
noteSTRING
outcomeSTRING
recording_deletion_reasonSTRING
recording_urlSTRING
returned_atTIMESTAMP
sequence_actionSTRING
should_record_callBOOL
stateSTRING
state_changed_atTIMESTAMP
toSTRING
uidSTRING
updated_atTIMESTAMP
user_call_typeSTRING
vendor_call_idSTRING
voicemail_recording_urlSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
auth_idINT64
created_atTIMESTAMP
editableBOOL
emailSTRING
email_hashSTRING
email_providerSTRING
email_signatureSTRING
ews_custom_search_folderBOOL
ews_delegate_syncBOOL
ews_endpointSTRING
ews_impersonationBOOL
ews_ssl_verify_modeINT64
exchange_versionSTRING
idINT64
imap_hostSTRING
imap_portINT64
imap_sslBOOL
max_emails_per_dayINT64
max_mailings_per_dayINT64
max_mailings_per_weekINT64
opt_out_messageSTRING
opt_out_signatureSTRING
provider_idINT64
provider_typeSTRING
send_disabledBOOL
send_errored_atTIMESTAMP
send_max_retriesINT64
send_methodSTRING
send_periodINT64
send_permanent_error_atTIMESTAMP
send_requires_syncBOOL
send_success_atTIMESTAMP
send_thresholdINT64
sendgrid_webhook_urlSTRING
smtp_hostSTRING
smtp_portINT64
smtp_sslBOOL
smtp_usernameSTRING
sync_active_frequencyINT64
sync_disabledBOOL
sync_errored_atTIMESTAMP
sync_finished_atTIMESTAMP
sync_methodSTRING
sync_outreach_folderBOOL
sync_passive_frequencyINT64
sync_permanent_error_atTIMESTAMP
sync_success_atTIMESTAMP
updated_atTIMESTAMP
user_idINT64
usernameSTRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
attributable_sequence_idINT64
attributable_sequence_nameSTRING
body_htmlSTRING
body_textSTRING
bounced_atTIMESTAMP
click_countINT64
clicked_atTIMESTAMP
created_atTIMESTAMP
delivered_atTIMESTAMP
desired_atTIMESTAMP
error_backtraceSTRING
error_reasonSTRING
follow_up_sequence_idINT64
follow_up_sequence_nameSTRING
follow_up_sequence_starting_dateTIMESTAMP
follow_up_task_scheduled_atTIMESTAMP
follow_up_task_typeSTRING
idINT64
mailbox_addressSTRING
mailing_typeSTRING
marked_as_spam_atTIMESTAMP
meeting_descriptionSTRING
meeting_durationINT64
meeting_locationSTRING
meeting_titleSTRING
message_idSTRING
notify_thread_conditionSTRING
notify_thread_scheduled_atTIMESTAMP
notify_thread_statusSTRING
open_countINT64
opened_atTIMESTAMP
optimized_scheduled_atTIMESTAMP
override_safety_settingsBOOL
replied_atTIMESTAMP
reply_sentimentSTRING
retry_atTIMESTAMP
retry_countINT64
retry_intervalINT64
schedule_idINT64
scheduled_atTIMESTAMP
stateSTRING
state_changed_atTIMESTAMP
subjectSTRING
track_linksBOOL
track_opensBOOL
unsubscribed_atTIMESTAMP
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
amountINT64
close_dateTIMESTAMP
created_atTIMESTAMP
currency_typeSTRING
custom1STRING
custom10STRING
custom100STRING
custom101STRING
custom102STRING
custom103STRING
custom104STRING
custom105STRING
custom106STRING
custom107STRING
custom108STRING
custom109STRING
custom11STRING
custom110STRING
custom111STRING
custom112STRING
custom113STRING
custom114STRING
custom115STRING
custom116STRING
custom117STRING
custom118STRING
custom119STRING
custom12STRING
custom120STRING
custom121STRING
custom122STRING
custom123STRING
custom124STRING
custom125STRING
custom126STRING
custom127STRING
custom128STRING
custom129STRING
custom13STRING
custom130STRING
custom131STRING
custom132STRING
custom133STRING
custom134STRING
custom135STRING
custom136STRING
custom137STRING
custom138STRING
custom139STRING
custom14STRING
custom140STRING
custom141STRING
custom142STRING
custom143STRING
custom144STRING
custom145STRING
custom146STRING
custom147STRING
custom148STRING
custom149STRING
custom15STRING
custom150STRING
custom16STRING
custom17STRING
custom18STRING
custom19STRING
custom2STRING
custom20STRING
custom21STRING
custom22STRING
custom23STRING
custom24STRING
custom25STRING
custom26STRING
custom27STRING
custom28STRING
custom29STRING
custom3STRING
custom30STRING
custom31STRING
custom32STRING
custom33STRING
custom34STRING
custom35STRING
custom36STRING
custom37STRING
custom38STRING
custom39STRING
custom4STRING
custom40STRING
custom41STRING
custom42STRING
custom43STRING
custom44STRING
custom45STRING
custom46STRING
custom47STRING
custom48STRING
custom49STRING
custom5STRING
custom50STRING
custom51STRING
custom52STRING
custom53STRING
custom54STRING
custom55STRING
custom56STRING
custom57STRING
custom58STRING
custom59STRING
custom6STRING
custom60STRING
custom61STRING
custom62STRING
custom63STRING
custom64STRING
custom65STRING
custom66STRING
custom67STRING
custom68STRING
custom69STRING
custom7STRING
custom70STRING
custom71STRING
custom72STRING
custom73STRING
custom74STRING
custom75STRING
custom76STRING
custom77STRING
custom78STRING
custom79STRING
custom8STRING
custom80STRING
custom81STRING
custom82STRING
custom83STRING
custom84STRING
custom85STRING
custom86STRING
custom87STRING
custom88STRING
custom89STRING
custom9STRING
custom90STRING
custom91STRING
custom92STRING
custom93STRING
custom94STRING
custom95STRING
custom96STRING
custom97STRING
custom98STRING
custom99STRING
external_created_atTIMESTAMP
health_categorySTRING
health_scoreINT64
idINT64
map_linkSTRING
map_next_stepsSTRING
map_number_of_overdue_tasksINT64
map_statusSTRING
nameSTRING
next_stepSTRING
opportunity_typeSTRING
probabilityINT64
prospecting_rep_idSTRING
sharing_team_idSTRING
touched_atTIMESTAMP
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
created_atTIMESTAMP
idINT64
nameSTRING
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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

  • personas__prospects (4 columns)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
account_nameSTRING
added_atTIMESTAMP
address_citySTRING
address_countrySTRING
address_stateSTRING
address_streetSTRING
address_street2STRING
address_zipSTRING
angel_list_urlSTRING
available_atTIMESTAMP
call_opted_outBOOL
calls_opt_statusSTRING
calls_opted_atTIMESTAMP
campaign_nameSTRING
click_countINT64
companySTRING
company_followersINT64
company_founded_atSTRING
company_industrySTRING
company_linked_inSTRING
company_linked_in_employeesSTRING
company_localitySTRING
company_naturalSTRING
company_sizeINT64
company_start_dateSTRING
company_typeSTRING
created_atTIMESTAMP
custom1STRING
custom10STRING
custom100STRING
custom101STRING
custom102STRING
custom103STRING
custom104STRING
custom105STRING
custom106STRING
custom107STRING
custom108STRING
custom109STRING
custom11STRING
custom110STRING
custom111STRING
custom112STRING
custom113STRING
custom114STRING
custom115STRING
custom116STRING
custom117STRING
custom118STRING
custom119STRING
custom12STRING
custom120STRING
custom121STRING
custom122STRING
custom123STRING
custom124STRING
custom125STRING
custom126STRING
custom127STRING
custom128STRING
custom129STRING
custom13STRING
custom130STRING
custom131STRING
custom132STRING
custom133STRING
custom134STRING
custom135STRING
custom136STRING
custom137STRING
custom138STRING
custom139STRING
custom14STRING
custom140STRING
custom141STRING
custom142STRING
custom143STRING
custom144STRING
custom145STRING
custom146STRING
custom147STRING
custom148STRING
custom149STRING
custom15STRING
custom150STRING
custom16STRING
custom17STRING
custom18STRING
custom19STRING
custom2STRING
custom20STRING
custom21STRING
custom22STRING
custom23STRING
custom24STRING
custom25STRING
custom26STRING
custom27STRING
custom28STRING
custom29STRING
custom3STRING
custom30STRING
custom31STRING
custom32STRING
custom33STRING
custom34STRING
custom35STRING
custom36STRING
custom37STRING
custom38STRING
custom39STRING
custom4STRING
custom40STRING
custom41STRING
custom42STRING
custom43STRING
custom44STRING
custom45STRING
custom46STRING
custom47STRING
custom48STRING
custom49STRING
custom5STRING
custom50STRING
custom51STRING
custom52STRING
custom53STRING
custom54STRING
custom55STRING
custom56STRING
custom57STRING
custom58STRING
custom59STRING
custom6STRING
custom60STRING
custom61STRING
custom62STRING
custom63STRING
custom64STRING
custom65STRING
custom66STRING
custom67STRING
custom68STRING
custom69STRING
custom7STRING
custom70STRING
custom71STRING
custom72STRING
custom73STRING
custom74STRING
custom75STRING
custom76STRING
custom77STRING
custom78STRING
custom79STRING
custom8STRING
custom80STRING
custom81STRING
custom82STRING
custom83STRING
custom84STRING
custom85STRING
custom86STRING
custom87STRING
custom88STRING
custom89STRING
custom9STRING
custom90STRING
custom91STRING
custom92STRING
custom93STRING
custom94STRING
custom95STRING
custom96STRING
custom97STRING
custom98STRING
custom99STRING
date_of_birthTIMESTAMP
degreeSTRING
email_opted_outBOOL
emails_opt_statusSTRING
emails_opted_atTIMESTAMP
engaged_atTIMESTAMP
engaged_scoreFLOAT64
event_nameSTRING
external_idSTRING
external_ownerSTRING
external_sourceSTRING
facebook_urlSTRING
first_nameSTRING
genderSTRING
github_urlSTRING
github_usernameSTRING
google_plus_urlSTRING
graduation_dateTIMESTAMP
idINT64
job_start_dateTIMESTAMP
last_nameSTRING
linked_in_connectionsINT64
linked_in_idSTRING
linked_in_slugSTRING
linked_in_urlSTRING
middle_nameSTRING
nameSTRING
nicknameSTRING
occupationSTRING
open_countINT64
opted_outBOOL
opted_out_atTIMESTAMP
persona_nameJSON
personal_note1STRING
personal_note2STRING
preferred_contactSTRING
quora_urlSTRING
regionSTRING
reply_countINT64
schoolSTRING
scoreFLOAT64
sharing_team_idSTRING
sms_opt_statusSTRING
sms_opted_atSTRING
sms_opted_outBOOL
sourceSTRING
specialtiesSTRING
stack_overflow_idSTRING
stack_overflow_urlSTRING
stage_nameSTRING
time_zoneSTRING
time_zone_ianaSTRING
time_zone_inferredSTRING
titleSTRING
touched_atTIMESTAMP
trashed_atTIMESTAMP
twitter_urlSTRING
twitter_usernameSTRING
updated_atTIMESTAMP
updater_idINT64
updater_typeSTRING
website_url1STRING
website_url2STRING
website_url3STRING
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
active_atTIMESTAMP
bounce_countINT64
call_completed_atTIMESTAMP
click_countINT64
created_atTIMESTAMP
deliver_countINT64
error_reasonSTRING
failure_countINT64
idINT64
negative_reply_countINT64
neutral_reply_countINT64
open_countINT64
opt_out_countINT64
pause_reasonSTRING
positive_reply_countINT64
replied_atTIMESTAMP
reply_countINT64
schedule_countINT64
stateSTRING
state_changed_atTIMESTAMP
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
bounce_countINT64
click_countINT64
created_atTIMESTAMP
dateDATE
deliver_countINT64
display_nameSTRING
failure_countINT64
idINT64
intervalINT64
negative_reply_countINT64
neutral_reply_countINT64
open_countINT64
opt_out_countINT64
orderINT64
positive_reply_countINT64
reply_countINT64
schedule_countINT64
step_typeSTRING
task_auto_displaySTRING
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
descriptionSTRING
automation_percentageFLOAT64
bounce_countINT64
click_countINT64
created_atTIMESTAMP
deliver_countINT64
duration_in_daysINT64
enabledBOOL
enabled_atTIMESTAMP
failure_countINT64
finish_on_replyBOOL
idINT64
last_used_atTIMESTAMP
lockedBOOL
locked_atTIMESTAMP
max_activationsINT64
nameSTRING
negative_reply_countINT64
neutral_reply_countINT64
num_contacted_prospectsINT64
num_replied_prospectsINT64
open_countINT64
opt_out_countINT64
positive_reply_countINT64
primary_reply_actionSTRING
primary_reply_pause_durationINT64
reply_countINT64
schedule_countINT64
schedule_interval_typeSTRING
secondary_reply_actionSTRING
secondary_reply_pause_durationINT64
sequence_step_countINT64
sequence_typeSTRING
share_typeSTRING
throttle_capacityINT64
throttle_max_adds_per_dayINT64
throttle_pausedBOOL
throttle_paused_atTIMESTAMP
transactionalBOOL
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
body_htmlSTRING
body_textSTRING
created_atTIMESTAMP
idINT64
nameSTRING
share_typeSTRING
tagsSTRING
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
colorSTRING
created_atTIMESTAMP
idINT64
nameSTRING
orderINT64
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
actionSTRING
autoskip_atTIMESTAMP
compiled_sequence_template_htmlSTRING
completedBOOL
completed_atTIMESTAMP
created_atTIMESTAMP
due_atTIMESTAMP
idINT64
noteSTRING
opportunity_associationSTRING
scheduled_atTIMESTAMP
stateSTRING
state_changed_atTIMESTAMP
task_typeSTRING
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
archivedBOOL
archived_atTIMESTAMP
bcc_recipientsSTRING
body_htmlSTRING
body_textSTRING
bounce_countINT64
cc_recipientsSTRING
click_countINT64
created_atTIMESTAMP
deliver_countINT64
failure_countINT64
idINT64
last_used_atTIMESTAMP
nameSTRING
negative_reply_countINT64
neutral_reply_countINT64
open_countINT64
opt_out_countINT64
positive_reply_countINT64
reply_countINT64
schedule_countINT64
share_typeSTRING
subjectSTRING
tagsSTRING
to_recipientsSTRING
track_linksBOOL
track_opensBOOL
updated_atTIMESTAMP
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)
ColumnTypeDescription
_kaivo_idSTRINGPrimary key that uniquely identifies the row. Auto-generated by Kaivo.
accounts_view_idINT64
active_prospects_countINT64
activity_notifications_disabledBOOL
batches_view_idINT64
bounce_warning_email_enabledBOOL
bridge_phoneSTRING
bridge_phone_extensionSTRING
buyer_language_preferenceSTRING
calendar_events_view_idINT64
calls_view_idINT64
controlled_tab_defaultSTRING
created_atTIMESTAMP
current_sign_in_atTIMESTAMP
custom1STRING
custom2STRING
custom3STRING
custom4STRING
custom5STRING
daily_digest_email_enabledBOOL
default_ruleset_idINT64
default_schedule_idINT64
duties_set_atSTRING
emailSTRING
enable_voice_recordingsBOOL
engagement_emails_enabledBOOL
first_nameSTRING
global_idSTRING
idINT64
imports_view_idJSON
inbound_bridge_phoneSTRING
inbound_bridge_phone_extensionSTRING
inbound_call_behaviorSTRING
inbound_phone_typeSTRING
inbound_voicemail_custom_message_textSTRING
inbound_voicemail_message_text_voiceSTRING
inbound_voicemail_prompt_typeSTRING
kaia_recordings_view_idINT64
keep_bridge_phone_connectedBOOL
language_preferenceSTRING
last_nameSTRING
last_sign_in_atTIMESTAMP
link_to_sequence_state_in_task_flowBOOL
live_listen_view_idINT64
lockedBOOL
mailbox_error_email_enabledBOOL
mailings_delivered_countINT64
mailings_replied_countINT64
mailings_view_idINT64
meeting_engagement_notification_enabledBOOL
meeting_types_view_idINT64
nameSTRING
notifications_enabledBOOL
oce_click_to_dial_everywhereBOOL
oce_gmail_toolbarBOOL
oce_gmail_tracking_stateSTRING
oce_salesforce_email_decoratingBOOL
oce_salesforce_phone_decoratingBOOL
oce_universal_task_flowBOOL
oce_window_modeBOOL
onboarded_atTIMESTAMP
opportunities_view_idINT64
orca_standalone_enabledBOOL
password_expires_atTIMESTAMP
phone_country_codeSTRING
phone_numberSTRING
phone_typeSTRING
phones_view_idINT64
plugin_alert_notification_enabledBOOL
preferred_voice_regionSTRING
prefers_local_presenceBOOL
primary_timezoneSTRING
prospect_detail_defaultSTRING
prospects_view_idINT64
reports_sequence_performance_view_idINT64
reports_team_perf_view_idINT64
reports_team_performance_intraday_view_idINT64
reports_team_performance_view_idINT64
reports_view_idINT64
scim_external_idSTRING
scim_sourceSTRING
secondary_timezoneSTRING
send_invite_fallbackBOOL
sender_notifications_excludedBOOL
sequence_states_view_idINT64
sequences_view_idINT64
snippets_view_idINT64
tasks_due_countINT64
tasks_view_idINT64
teams_view_idINT64
templates_view_idINT64
tertiary_timezoneSTRING
texting_email_notificationsBOOL
titleSTRING
unknown_reply_email_enabledBOOL
updated_atTIMESTAMP
use_sales_navigator_for_linked_in_tasksBOOL
user_guidSTRING
usernameSTRING
users_view_idINT64
voicemail_notification_enabledBOOL
weekly_digest_email_enabledBOOL
_kaivo_extracted_atTIMESTAMPTimestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

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)

How the Outreach sync works

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.

Frequently asked questions

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.

Can I sync only some tables or columns?

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?

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?

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.

Common use cases for Outreach data

Sequence performance

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

Activity reporting

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

Pipeline context

Join opportunities with prospects to connect outreach activity to deals.

Rep performance

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

Use Outreach data in your AI and BI tools

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.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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

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

Was this helpful?

Still need help? Share an idea