Skip to content
Book a demoStart free
Connectors

Close connector

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

Close connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Close 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 CRM data instead of moving it.

Sync your Close CRM data into BigQuery with Kaivo to report on pipeline, activity, and sales performance alongside the rest of your data.

CategoryCRM
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Close 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 API Key.

Field Description
API Key
Close.com API key (usually starts with ‘api_’; find yours here).

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

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

activity_custom_fields (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
accepts_multiple_values BOOL
created_by STRING
custom_activity_type_id STRING
date_created STRING
date_updated STRING
id STRING
is_shared BOOL
name STRING
organization_id STRING
required BOOL
updated_by 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.

  • activity_custom_fields__choices (4 columns)
  • activity_custom_fields__editable_with_roles (4 columns)
answered_detached_call_tasks (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
assigned_to STRING
assigned_to_name STRING
contact_id STRING
contact_name STRING
created_by STRING
created_by_name STRING
date STRING
date_created STRING
date_updated STRING
id STRING
is_complete BOOL
lead_id STRING
lead_name STRING
object_id STRING
object_type STRING
organization_id STRING
phone STRING
phone_formatted STRING
phone_number_description STRING
recording_url STRING
updated_by STRING
updated_by_name STRING
view STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
call_activities (38 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
call_method STRING
contact_id STRING
created_by STRING
created_by_name STRING
date_created STRING
date_updated STRING
direction STRING
disposition STRING
duration FLOAT64
has_recording BOOL
id STRING
is_forwarded BOOL
is_joinable BOOL
is_to_group_number BOOL
lead_id STRING
local_country_iso STRING
local_phone STRING
local_phone_formatted STRING
note STRING
note_html STRING
organization_id STRING
phone STRING
recording_duration FLOAT64
recording_url STRING
remote_country_iso STRING
remote_phone STRING
remote_phone_formatted STRING
source STRING
status STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name STRING
voicemail_duration FLOAT64
_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_activities__coach_legs (4 columns)
  • call_activities__note_mentions (4 columns)
  • call_activities__recording_history (4 columns)
  • call_activities__users (4 columns)
contact_custom_fields (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
accepts_multiple_values BOOL
created_by STRING
date_created STRING
date_updated STRING
id STRING
is_shared BOOL
name STRING
organization_id STRING
updated_by 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.

  • contact_custom_fields__choices (4 columns)
  • contact_custom_fields__editable_with_roles (4 columns)
contacts (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_by STRING
custom_cf_v_yv_m_yf_z8i_p1_a_uo4c_a_ef_em_dw_ra9w_wrn_gov_p8ot_b6pt3_o STRING
custom_cf_q10_n0iddlg_v_lr_sy60_a_asa_aa_dmpqhwm8u_td62hqk_w8b_g STRING
date_created STRING
date_updated STRING
display_name STRING
id STRING
lead_id STRING
name STRING
organization_id STRING
title STRING
updated_by 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.

  • contacts__emails (6 columns)
  • contacts__integration_links (5 columns)
  • contacts__phones (7 columns)
  • contacts__urls (4 columns)
created_activities (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
created_by STRING
created_by_name STRING
date_created STRING
date_updated STRING
id STRING
lead_id STRING
organization_id STRING
source STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name 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.

  • created_activities__users (4 columns)
custom_activities (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
api_create_only BOOL
created_by STRING
date_created STRING
date_updated STRING
id STRING
is_archived BOOL
name STRING
organization_id STRING
updated_by 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.

  • custom_activities__editable_with_roles (4 columns)
  • custom_activities__fields (9 columns)
  • custom_activities__fields__editable_with_roles (4 columns)
custom_email_connected_accounts (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
id STRING
organization_id STRING
user_id 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.

  • custom_email_connected_accounts__identities (4 columns)
delete_bulk_actions (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_by STRING
date_created STRING
date_updated STRING
id STRING
n_leads FLOAT64
n_leads_processed FLOAT64
organization_id STRING
query STRING
send_done_email BOOL
status STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dialer (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
caller_id STRING
date_created STRING
date_updated STRING
id STRING
is_user_dependent BOOL
music_preference STRING
organization_id STRING
ring_mode STRING
source_type STRING
source_value STRING
status STRING
user_id STRING
visibility_mode 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.

  • dialer__users (4 columns)
edit_bulk_actions (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_by STRING
custom_field_name STRING
custom_field_value STRING
date_created STRING
date_updated STRING
id STRING
lead_status_id STRING
n_leads FLOAT64
n_leads_processed FLOAT64
n_objects FLOAT64
n_objects_processed FLOAT64
organization_id STRING
query STRING
send_done_email BOOL
status STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
email_activities (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
body_html STRING
body_preview STRING
body_text STRING
contact_id STRING
created_by STRING
created_by_name STRING
date_created STRING
date_updated STRING
direction STRING
envelope__date STRING
envelope__is_autoreply BOOL
envelope__message_id STRING
envelope__subject STRING
followup_sequence_add_cc_bcc BOOL
has_reply BOOL
id STRING
lead_id STRING
need_smtp_credentials BOOL
organization_id STRING
sender STRING
status STRING
subject STRING
thread_id STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name 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.

  • email_activities__attachments (4 columns)
  • email_activities__bcc (4 columns)
  • email_activities__body_html_quoted (5 columns)
  • email_activities__body_text_quoted (5 columns)
  • email_activities__cc (4 columns)
  • email_activities__envelope__bcc (4 columns)
  • email_activities__envelope__cc (4 columns)
  • email_activities__envelope__from (5 columns)
  • email_activities__envelope__reply_to (4 columns)
  • email_activities__envelope__sender (5 columns)
  • email_activities__envelope__to (5 columns)
  • email_activities__message_ids (4 columns)
  • email_activities__opens (4 columns)
  • email_activities__references (4 columns)
  • email_activities__send_attempts (4 columns)
  • email_activities__to (4 columns)
  • email_activities__users (4 columns)
email_bulk_actions (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
contact_preference STRING
created_by STRING
date_created STRING
date_updated STRING
id STRING
n_leads FLOAT64
n_leads_processed FLOAT64
organization_id STRING
query STRING
send_done_email BOOL
status STRING
template_id STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
email_followup_tasks (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
assigned_to STRING
assigned_to_name STRING
body_preview STRING
contact_id STRING
contact_name STRING
created_by STRING
created_by_name STRING
date STRING
date_created STRING
date_updated STRING
email_id STRING
id STRING
is_complete BOOL
lead_id STRING
lead_name STRING
object_id STRING
object_type STRING
organization_id STRING
subject STRING
total_emails_count_in_thread INT64
updated_by STRING
updated_by_name STRING
view STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
email_sequences (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
allow_manual_enrollment BOOL
created_by_id STRING
date_created STRING
date_updated STRING
id STRING
name STRING
organization_id STRING
status STRING
timezone 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.

  • email_sequences__schedule__ranges (6 columns)
  • email_sequences__steps (14 columns)
email_templates (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
body STRING
created_by STRING
date_created STRING
date_updated STRING
id STRING
is_archived BOOL
is_shared BOOL
name STRING
organization_id STRING
subject 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.

  • email_templates__attachments (4 columns)
  • email_templates__bcc (4 columns)
  • email_templates__cc (4 columns)
email_thread_activities (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
created_by STRING
created_by_name STRING
date_created STRING
date_updated STRING
id STRING
importance__type STRING
importance__reason STRING
latest_normalized_subject STRING
lead_id STRING
n_emails FLOAT64
organization_id STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name 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.

  • email_thread_activities__latest_emails (17 columns)
  • email_thread_activities__latest_emails__bcc (4 columns)
  • email_thread_activities__latest_emails__cc (4 columns)
  • email_thread_activities__latest_emails__envelope__bcc (4 columns)
  • email_thread_activities__latest_emails__envelope__cc (4 columns)
  • email_thread_activities__latest_emails__envelope__from (5 columns)
  • email_thread_activities__latest_emails__envelope__reply_to (4 columns)
  • email_thread_activities__latest_emails__envelope__sender (5 columns)
  • email_thread_activities__latest_emails__envelope__to (5 columns)
  • email_thread_activities__latest_emails__to (4 columns)
  • email_thread_activities__participants (5 columns)
  • email_thread_activities__users (4 columns)
events (184 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action STRING
data__version FLOAT64
data__type STRING
data__description STRING
data___type STRING
data__accepts_multiple_values BOOL
data__activity_at STRING
data__annualized_expected_value FLOAT64
data__annualized_value FLOAT64
data__assigned_to STRING
data__assigned_to_name STRING
data__auto_record_calls STRING
data__body STRING
data__body_html STRING
data__body_preview STRING
data__body_text STRING
data__call_method STRING
data__checksum STRING
data__confidence FLOAT64
data__contact_id STRING
data__contact_name STRING
data__content_type STRING
data__created_at STRING
data__created_by STRING
data__created_by_id STRING
data__created_by_name STRING
data__custom_cf_5qd_oho_vm_op_qy0at_d_tryq_j8o_wo_is_ok4_ki_bj_nx_lvrk_z7_v FLOAT64
data__custom_cf_awri6c_v_whb_m_qx_bip9dep0ixa_c87_b7_ose7d_tl_r_nl_ri_pf STRING
data__custom_cf_cvz_bkgt_ra_iv_mq0_dp5c_lwf_ro_y_zg5i_au7l_wiabx_eym2_bw STRING
data__custom_cf_di2d_do4jj_bemt5ny3xym_b_yl_np_xx_tclxj6_q2_w6_ndp_hj6 STRING
data__custom_cf_k_oe_fts9f_o9bvkt_jwim_wm7n7_gjb3_x4n2vh8_w5_r8d_t_hoi STRING
data__custom_cf_lt9_z_cz_hr_e0_g_cl_vm01t_vw2_cb_ev8b8u_xbzj_fh1_gv4ykzb STRING
data__custom_cf_lt_jc_gow_cs01cw8y0_o9_j_njm_b_xd_bp_ua_jb5_mz_x_xznl0_nam STRING
data__custom_cf_nu_kher_zo_tt_uu7nz_ksg_vdbyykq_z_ib_o_pmj_uv_ifqi_slz_ab STRING
data__custom_cf_p0mjvx_yba_xj_ne_e6_kn_ia_xg59zo_nmm3k_qmxe5_sa_vc_lu7r STRING
data__custom_cf_p73vuzy_u1_v_lh_gb44mwqi_s4_ar_w534o_fc4tod_c2_ee6ica STRING
data__custom_cf_suiy0_eotd7_co_yz_ds1_vz_r_mx_whcx_n_ja_lr1_ep9q6t_dnzn0 STRING
data__custom_cf_sse_ory_a4_jq0e_dk88_mmbktsh_bauj_cjb_ke55af_o_rp_cl_nx STRING
data__custom_cf_u3f7_s52x_vw_jud_wy_i3wz_m_ou_fwv_slmg51_nd_t3_ea4t_uph_a STRING
data__custom_cf_v_yv_m_yf_z8i_p1_a_uo4c_a_ef_em_dw_ra9w_wrn_gov_p8ot_b6pt3_o STRING
data__custom_cf_wtcel2_bz_w336el_zoqzpwd_fu4_ac_fx3c_wm3_o_vz1day_vdm STRING
data__custom_cf_ymc_dz_ilw1_xqnphbnf_qgx_uf43r_kuwh_lx_xi_d3sf_o_cr1qn FLOAT64
data__custom_cf_zw_as_j_gt_pgj4lh_f5_rivqe_avk_zpj_hys4m_ebj8_c_pt_gph0_q FLOAT64
data__custom_cf_zbz0bzj_da_hf_m6_p2jqrwmi_u0tj_jf_tq_uck_u_ydh_bz_bqbpq STRING
data__custom_cf_f_azgv_y_ooq9_l4_vkqz_g_iic_q_jxd_o4_ffdhi_mb_u2tbquk_u9_d STRING
data__custom_cf_g_zz1l_muhs5_pmvjj1_k2k5_gv8e_o0x_k7x_qt_oc_l6_ymln8yn STRING
data__custom_cf_gcw47h_ad_u6f_wu_c5_su5_sh3_t_lv2f1_txyv8_js7_inlp_ad5r STRING
data__custom_cf_h_oco7_r7g_giut_nmw76nl_etc_kygmmn7_mh_oe3x_iir8cb_a0 STRING
data__custom_cf_he_au31b78_fd_ir_rbnl_cu_yw6n_ag_z1_bwvqk5mji_v196_iv_w STRING
data__custom_cf_hibn_q_pje2_z5_czi_kvcki_dza_vse_ci8s_t7_yefgq_js_mu_jq_c STRING
data__custom_cf_j_u_qgz6_v_zfr_zuci8p_mgp_m_qx_w8x9a_bcl4_c_fi_i_vnp94_g4_s FLOAT64
data__custom_cf_m_ff_oc5g_mgt_b_kf_o_fv_wsqh8zf_ka_bc8_i_id_nol_zxm_pix_vxn STRING
data__custom_cf_m_y09j88_m_rv_aducy_h_bac_umhxktess_scmbr1_zm_ho0n_v_ky STRING
data__custom_cf_q10_n0iddlg_v_lr_sy60_a_asa_aa_dmpqhwm8u_td62hqk_w8b_g STRING
data__custom_cf_r2_u_yed3zt23z_neum2_zt_rp_nb70_ano_ind_ev5u_u_mq_e1kd_r STRING
data__custom_cf_un_y82a_frl_zf_tzy_xvo8w_vw0_ry2mk_wb_ml_ym1_nc7_m1_n1_gf STRING
data__custom_cf_uo2_g_jfwz_g_tm_t0_b81h7s_c8_laa6_qons_wb_rk72_w68_c1_lsi STRING
data__custom_activity_type_id STRING
data__date STRING
… and 124 more columns

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

  • events__changed_fields (4 columns)
  • events__data__addresses (9 columns)
  • events__data__attachments (7 columns)
  • events__data__bcc (4 columns)
  • events__data__cc (4 columns)
  • events__data__choices (4 columns)
  • events__data__contact_ids (4 columns)
  • events__data__custom_cf_1_kx_kgcp_xml_pn_nj0spc_it_ox0_ci_ri_czze_ws_q4t6_v_fskv_s (4 columns)
  • events__data__custom_cf_2y_b_ao_hro24_z_kb_o_rl_l2f_eaa_k_wk5x_et_gp_tyajkl_nohs_wn (4 columns)
  • events__data__custom_cf_l_wg_vd_w_kb_ew_z0_np_nrja_o_qqf3lq_hs_ch5g_v2_vq_fem_w_vp_vg (4 columns)
  • events__data__custom_cf_cf_gj2bq_q_mirim_kq4z_d_bjlggxapzzg_qqrp_mr0qm_cr4q_k (4 columns)
  • events__data__custom_cf_jao9_l23_ikm2_c_ldum_pc0s_g5_ya6_naem4_z_dkj_w_bv_ec9tsl (4 columns)
  • events__data__custom_cf_kl_k0_yh_q4j_g_bn_sw_rgz_v68_i4_ympqv_z7g_wl0w_cjg_he_d_nfd (4 columns)
  • events__data__editable_with_roles (4 columns)
  • events__data__email_ids (4 columns)
  • events__data__emails (6 columns)
  • events__data__envelope__bcc (4 columns)
  • events__data__envelope__cc (4 columns)
  • events__data__envelope__from (5 columns)
  • events__data__envelope__reply_to (4 columns)
  • events__data__envelope__sender (5 columns)
  • events__data__envelope__to (5 columns)
  • events__data__group_ids (4 columns)
  • events__data__mentions (4 columns)
  • events__data__message_ids (4 columns)
  • events__data__note_mentions (4 columns)
  • events__data__opens (4 columns)
  • events__data__participants (5 columns)
  • events__data__payload__data__date_ranges (4 columns)
  • events__data__payload__data__metrics (4 columns)
  • events__data__payload__data__users (4 columns)
  • events__data__permissions_granted (4 columns)
  • events__data__phones (6 columns)
  • events__data__recording_history (4 columns)
  • events__data__references (4 columns)
  • events__data__send_attempts (4 columns)
  • events__data__to (4 columns)
  • events__data__urls (4 columns)
  • events__data__user_ids (4 columns)
  • events__data__users (4 columns)
  • events__previous_data__attachments (4 columns)
  • events__previous_data__contact_ids (4 columns)
google_connected_accounts (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
id STRING
organization_id STRING
user_id 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.

  • google_connected_accounts__identities (4 columns)
  • google_connected_accounts__synced_calendars (4 columns)
incoming_email_tasks (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
assigned_to STRING
assigned_to_name STRING
body_preview STRING
contact_id STRING
contact_name STRING
created_by STRING
created_by_name STRING
date STRING
date_created STRING
date_updated STRING
id STRING
is_complete BOOL
lead_id STRING
lead_name STRING
object_type STRING
organization_id STRING
subject STRING
updated_by STRING
updated_by_name STRING
view 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.

  • incoming_email_tasks__cleared_followups (4 columns)
  • incoming_email_tasks__emails (4 columns)
incoming_sms_tasks (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
assigned_to STRING
assigned_to_name STRING
contact_id STRING
contact_name STRING
created_by STRING
created_by_name STRING
date STRING
date_created STRING
date_updated STRING
id STRING
is_complete BOOL
lead_id STRING
lead_name STRING
local_phone STRING
object_id STRING
object_type STRING
organization_id STRING
remote_phone STRING
remote_phone_description STRING
remote_phone_formatted STRING
text STRING
updated_by STRING
updated_by_name STRING
view STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
integration_links (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_by STRING
date_created STRING
date_updated STRING
id STRING
name STRING
organization_id STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lead_custom_fields (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
accepts_multiple_values BOOL
created_by STRING
date_created STRING
date_updated STRING
id STRING
is_shared BOOL
name STRING
organization_id STRING
updated_by 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.

  • lead_custom_fields__choices (4 columns)
  • lead_custom_fields__editable_with_roles (4 columns)
lead_status_change_activities (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
created_by STRING
created_by_name STRING
date_created STRING
date_updated STRING
id STRING
lead_id STRING
new_status_id STRING
new_status_label STRING
old_status_id STRING
old_status_label STRING
organization_id STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name 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.

  • lead_status_change_activities__users (4 columns)
lead_statuses (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
label STRING
organization_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lead_tasks (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
assigned_to STRING
assigned_to_name STRING
created_by STRING
created_by_name STRING
date STRING
date_created STRING
date_updated STRING
due_date STRING
id STRING
is_complete BOOL
is_primary_lead_notification BOOL
lead_id STRING
lead_name STRING
organization_id STRING
text STRING
updated_by STRING
updated_by_name STRING
view STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
leads (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_by STRING
created_by_name STRING
custom__company_size FLOAT64
custom__current_vendor_software STRING
custom__custom_field STRING
custom__industry STRING
custom__lead_owner STRING
custom__socials STRING
custom_cf_5qd_oho_vm_op_qy0at_d_tryq_j8o_wo_is_ok4_ki_bj_nx_lvrk_z7_v FLOAT64
custom_cf_cvz_bkgt_ra_iv_mq0_dp5c_lwf_ro_y_zg5i_au7l_wiabx_eym2_bw STRING
custom_cf_g_zz1l_muhs5_pmvjj1_k2k5_gv8e_o0x_k7x_qt_oc_l6_ymln8yn STRING
custom_cf_he_au31b78_fd_ir_rbnl_cu_yw6n_ag_z1_bwvqk5mji_v196_iv_w STRING
custom_cf_m_y09j88_m_rv_aducy_h_bac_umhxktess_scmbr1_zm_ho0n_v_ky STRING
custom_cf_uo2_g_jfwz_g_tm_t0_b81h7s_c8_laa6_qons_wb_rk72_w68_c1_lsi STRING
date_created STRING
date_updated STRING
display_name STRING
html_url STRING
id STRING
name STRING
organization_id STRING
status_id STRING
status_label STRING
updated_by STRING
updated_by_name STRING
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.

  • leads__addresses (9 columns)
  • leads__contacts (15 columns)
  • leads__contacts__emails (6 columns)
  • leads__contacts__integration_links (5 columns)
  • leads__contacts__phones (7 columns)
  • leads__contacts__urls (4 columns)
  • leads__integration_links (5 columns)
  • leads__opportunities (37 columns)
  • leads__opportunities__attachments (4 columns)
  • leads__opportunities__custom_cf_cf_gj2bq_q_mirim_kq4z_d_bjlggxapzzg_qqrp_mr0qm_cr4q_k (4 columns)
  • leads__opportunities__integration_links (4 columns)
  • leads__tasks (22 columns)
meeting_activities (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
date_created STRING
date_updated STRING
duration FLOAT64
ends_at STRING
id STRING
is_recurring BOOL
lead_id STRING
location STRING
note STRING
organization_id STRING
source STRING
starts_at STRING
title STRING
user_id STRING
user_name 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.

  • meeting_activities__attached_call_ids (4 columns)
  • meeting_activities__attendees (9 columns)
  • meeting_activities__calendar_event_uids (4 columns)
  • meeting_activities__conference_links (4 columns)
  • meeting_activities__integrations (4 columns)
  • meeting_activities__provider_calendar_ids (4 columns)
  • meeting_activities__user_note_mentions (4 columns)
  • meeting_activities__users (4 columns)
missed_call_tasks (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
assigned_to STRING
assigned_to_name STRING
contact_id STRING
contact_name STRING
created_by STRING
created_by_name STRING
date STRING
date_created STRING
date_updated STRING
id STRING
is_complete BOOL
lead_id STRING
lead_name STRING
local_phone STRING
object_id STRING
object_type STRING
organization_id STRING
phone STRING
phone_formatted STRING
phone_number_description STRING
updated_by STRING
updated_by_name STRING
view STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
note_activities (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
created_by STRING
created_by_name STRING
date_created STRING
date_updated STRING
id STRING
lead_id STRING
note STRING
note_html STRING
organization_id STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name 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.

  • note_activities__attachments (8 columns)
  • note_activities__note_mentions (4 columns)
  • note_activities__users (4 columns)
opportunities (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
annualized_expected_value FLOAT64
annualized_value FLOAT64
confidence FLOAT64
contact_id STRING
contact_name STRING
created_by STRING
created_by_name STRING
custom_cf_lt9_z_cz_hr_e0_g_cl_vm01t_vw2_cb_ev8b8u_xbzj_fh1_gv4ykzb STRING
custom_cf_wtcel2_bz_w336el_zoqzpwd_fu4_ac_fx3c_wm3_o_vz1day_vdm STRING
custom_cf_zw_as_j_gt_pgj4lh_f5_rivqe_avk_zpj_hys4m_ebj8_c_pt_gph0_q FLOAT64
custom_cf_j_u_qgz6_v_zfr_zuci8p_mgp_m_qx_w8x9a_bcl4_c_fi_i_vnp94_g4_s FLOAT64
date_created STRING
date_updated STRING
date_won STRING
expected_value FLOAT64
id STRING
lead_id STRING
lead_name STRING
note STRING
organization_id STRING
pipeline_id STRING
pipeline_name STRING
status_display_name STRING
status_id STRING
status_label STRING
status_type STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name STRING
value FLOAT64
value_currency STRING
value_formatted STRING
value_period 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.

  • opportunities__attachments (4 columns)
  • opportunities__custom_cf_cf_gj2bq_q_mirim_kq4z_d_bjlggxapzzg_qqrp_mr0qm_cr4q_k (4 columns)
  • opportunities__integration_links (4 columns)
opportunity_custom_fields (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
accepts_multiple_values BOOL
created_by STRING
date_created STRING
date_updated STRING
id STRING
is_shared BOOL
name STRING
organization_id STRING
updated_by 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.

  • opportunity_custom_fields__choices (4 columns)
  • opportunity_custom_fields__editable_with_roles (4 columns)
opportunity_due_tasks (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
assigned_to STRING
assigned_to_name STRING
contact_id STRING
contact_name STRING
created_by STRING
created_by_name STRING
date STRING
date_created STRING
date_updated STRING
id STRING
is_complete BOOL
is_primary_lead_notification BOOL
lead_id STRING
lead_name STRING
object_id STRING
object_type STRING
opportunity_note STRING
opportunity_value FLOAT64
opportunity_value_formatted STRING
opportunity_value_period STRING
organization_id STRING
updated_by STRING
updated_by_name STRING
view STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
opportunity_status_change_activities (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
created_by STRING
created_by_name STRING
date_created STRING
date_updated STRING
id STRING
lead_id STRING
new_pipeline_id STRING
new_pipeline_name STRING
new_status_id STRING
new_status_label STRING
new_status_type STRING
old_pipeline_id STRING
old_pipeline_name STRING
old_status_id STRING
old_status_label STRING
old_status_type STRING
opportunity_confidence FLOAT64
opportunity_date_won STRING
opportunity_id STRING
opportunity_value FLOAT64
opportunity_value_currency STRING
opportunity_value_formatted STRING
opportunity_value_period STRING
organization_id STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name 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.

  • opportunity_status_change_activities__users (4 columns)
opportunity_statuses (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
label STRING
organization_id STRING
pipeline_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
pipelines (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_created STRING
date_updated STRING
id STRING
name STRING
organization_id STRING
updated_by 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.

  • pipelines__statuses (6 columns)
roles (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_created STRING
date_updated STRING
editable BOOL
id STRING
name STRING
organization_id 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.

  • roles__permissions (4 columns)
  • roles__visibility_user_lcf_ids (4 columns)
send_as (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
allowed_user_id STRING
allowing_user_id STRING
id STRING
organization_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sequence_subscription_bulk_actions (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_type STRING
contact_preference STRING
created_by STRING
date_created STRING
date_updated STRING
id STRING
n_leads FLOAT64
n_leads_processed FLOAT64
organization_id STRING
query STRING
send_done_email BOOL
sender_account_id STRING
sender_email STRING
sender_name STRING
sequence_id STRING
status STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
smart_views (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
date_created STRING
date_updated STRING
id STRING
is_shared BOOL
is_user_dependent BOOL
name STRING
organization_id STRING
s_query__query__type STRING
s_query__query__negate BOOL
sharing_settings__created_at STRING
sharing_settings__created_by_id STRING
sharing_settings__updated_at STRING
sharing_settings__updated_by_id STRING
sharing_settings__whole_org BOOL
user_id 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.

  • smart_views__s_query__query__queries (20 columns)
  • smart_views__s_query__query__queries__queries (5 columns)
  • smart_views__s_query__query__queries__queries__queries (36 columns)
  • smart_views__s_query__query__queries__queries__queries__condition__object_ids (4 columns)
  • smart_views__s_query__sort (4 columns)
  • smart_views__selected_fields (5 columns)
  • smart_views__sharing_settings__group_ids (4 columns)
  • smart_views__sharing_settings__user_ids (4 columns)
sms_activities (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
contact_id STRING
created_by STRING
created_by_name STRING
date_created STRING
date_sent STRING
date_updated STRING
direction STRING
id STRING
lead_id STRING
local_phone STRING
local_phone_formatted STRING
organization_id STRING
remote_country_iso STRING
remote_phone STRING
remote_phone_formatted STRING
source STRING
status STRING
text STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name 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.

  • sms_activities__attachments (4 columns)
task_completed_activities (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
activity_at STRING
created_by STRING
created_by_name STRING
date_created STRING
date_updated STRING
id STRING
lead_id STRING
organization_id STRING
task_assigned_to STRING
task_assigned_to_name STRING
task_id STRING
task_text STRING
updated_by STRING
updated_by_name STRING
user_id STRING
user_name 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.

  • task_completed_activities__users (4 columns)
users (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_created STRING
date_updated STRING
email STRING
email_verified_at STRING
first_name STRING
id STRING
last_name STRING
last_used_timezone 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.

  • users__organizations (4 columns)
voicemail_tasks (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
assigned_to STRING
assigned_to_name STRING
contact_id STRING
contact_name STRING
created_by STRING
created_by_name STRING
date STRING
date_created STRING
date_updated STRING
id STRING
is_complete BOOL
lead_id STRING
lead_name STRING
local_phone STRING
object_id STRING
object_type STRING
organization_id STRING
phone STRING
phone_formatted STRING
phone_number_description STRING
updated_by STRING
updated_by_name STRING
view STRING
voicemail_duration FLOAT64
voicemail_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
zoom_connected_accounts (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_type STRING
email STRING
id STRING
organization_id STRING
user_id 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.

  • zoom_connected_accounts__identities (4 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Close 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 Close?

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

It depends on how much history is in your Close 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 Close’s schema changes?

Section titled “What happens when Close’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 Close, 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 Close 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 Close connector in Kaivo and all of its synced data is deleted with it.

Track opportunities through opportunity_statuses and pipelines to see value and win rates.

Use events and created_activities to measure calls, emails, and outreach by rep.

Join leads with lead_statuses to see how leads progress and where they stall.

Group opportunities by user to compare results across the sales team.

Once Close 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 Close 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 Close connector pricing and plan details.

  • Custobar: Sync Custobar to BigQuery.
  • HubSpot: Sync HubSpot to BigQuery.
  • Attio: Sync Attio to BigQuery.
  • Cuuma: Sync Cuuma to BigQuery.
  • Pipedrive: Sync Pipedrive to BigQuery.
  • Rentman: Sync Rentman to BigQuery.