Skip to content
Book a demoStart free
Connectors

Coevera connector

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

Coevera connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Coevera 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 Pipeliner CRM data into BigQuery with Kaivo to report on pipeline, accounts, and forecasts in one place.

CategoryCRM
AuthenticationUsername and password
SetupSelf-service

Getting started with the Coevera connector

Section titled “Getting started with the Coevera connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Coevera 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.

Connect with your Coevera login. You provide:

Field Description
Password
The API password paired with the token above (shown only once when you generate your API keys).

|

When you set up the connector, you provide:

Field Description
Username
The API token for your Pipeliner space, used as the Basic auth username. Generate API keys under Sales Pipeline → API Access in the Pipeliner customer portal.

| | Data Center |

The data center region hosting your Pipeliner space.

| | Space ID |

Your Pipeliner Space ID, shown when you obtain API Access; it identifies the space to sync from.

|

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

accounts (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_class FLOAT64
account_type STRING
account_type_id STRING
address STRING
city STRING
comments STRING
country STRING
created STRING
currency_exchange_rates_list STRING
currency_exchange_rates_list_id STRING
customer_type STRING
customer_type_id STRING
email1 STRING
email2 STRING
email3 STRING
email4 STRING
email5 STRING
formatted_name STRING
health__last_calculation STRING
health__score FLOAT64
health__trend STRING
health_category STRING
health_status FLOAT64
home_page STRING
id STRING
industry STRING
industry_id STRING
is_archived BOOL
is_delete_protected BOOL
is_deleted BOOL
is_favorite BOOL
is_unsubscribed BOOL
modified STRING
name STRING
owner STRING
owner_id STRING
phone1 STRING
phone2 STRING
phone3 STRING
phone4 STRING
phone5 STRING
picture STRING
picture_id STRING
quick_parent_account_name STRING
revision FLOAT64
share_mode FLOAT64
state_province STRING
unit STRING
unit_id STRING
zip_code 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__documents (4 columns)
  • accounts__health__indicators (11 columns)
  • accounts__health__indicators__rule__values (3 columns)
  • accounts__health__indicators__rule__values__list (4 columns)
  • accounts__sharing_clients (4 columns)
  • accounts__sharing_units (4 columns)
  • accounts__tags (4 columns)
activities (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
activity_type STRING
activity_type_id STRING
call_duration FLOAT64
created STRING
currency_exchange_rates_list STRING
currency_exchange_rates_list_id STRING
due_date STRING
end_date STRING
formatted_name STRING
has_3rd_party_mapping BOOL
id STRING
invitees_can_edit BOOL
is_delete_protected BOOL
is_deleted BOOL
is_recurrence_active BOOL
is_recurrence_exception BOOL
location STRING
modified STRING
owner STRING
owner_id STRING
priority FLOAT64
revision FLOAT64
share_mode FLOAT64
start_date STRING
status FLOAT64
subject STRING
table_name STRING
unit STRING
unit_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.

  • activities__account_relations (4 columns)
  • activities__comments (4 columns)
  • activities__contact_relations (4 columns)
  • activities__custom_entity_relations (4 columns)
  • activities__documents (4 columns)
  • activities__invitees_clients (4 columns)
  • activities__invitees_contacts (4 columns)
  • activities__lead_relations (4 columns)
  • activities__opportunity_relations (4 columns)
  • activities__project_relations (4 columns)
  • activities__quote_relations (4 columns)
  • activities__sharing_clients (4 columns)
  • activities__sharing_units (4 columns)
clients (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
created STRING
default_unit STRING
default_unit_id STRING
email STRING
first_name STRING
formatted_name STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
last_active STRING
last_name STRING
master_right STRING
master_right_id STRING
middle_name STRING
modified STRING
name STRING
phone STRING
picture_url STRING
position STRING
region STRING
revision FLOAT64
timezone STRING
user_profile_id FLOAT64
user_recalculation_state 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.

  • clients__account_favorite (4 columns)
  • clients__appointment_favorite (4 columns)
  • clients__contact_favorite (4 columns)
  • clients__lead_favorite (4 columns)
  • clients__opportunity_favorite (4 columns)
  • clients__profile_favorite (4 columns)
  • clients__report_favorite (4 columns)
  • clients__task_favorite (4 columns)
  • clients__unit_manager_ids (4 columns)
  • clients__unit_member_ids (4 columns)
  • clients__unit_membership (4 columns)
cloud_objects (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
company_cloud_object_folder STRING
company_cloud_object_folder_id STRING
created STRING
filename STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
is_public BOOL
mime_type STRING
modified STRING
revision FLOAT64
size FLOAT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts (51 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_position STRING
address STRING
city STRING
comments STRING
contact_type STRING
contact_type_id STRING
country STRING
created STRING
currency_exchange_rates_list STRING
currency_exchange_rates_list_id STRING
email1 STRING
email2 STRING
email3 STRING
email4 STRING
email5 STRING
first_name STRING
formatted_name STRING
gender FLOAT64
id STRING
is_archived BOOL
is_delete_protected BOOL
is_deleted BOOL
is_favorite BOOL
is_unsubscribed BOOL
last_name STRING
middle_name STRING
modified STRING
modified_by_user STRING
owner STRING
owner_id STRING
phone1 STRING
phone2 STRING
phone3 STRING
phone4 STRING
phone5 STRING
picture STRING
picture_id STRING
position STRING
primary_account STRING
primary_account_position STRING
primary_account_relationship FLOAT64
quick_account_name STRING
revision FLOAT64
share_mode FLOAT64
state_province STRING
title STRING
unit STRING
unit_id STRING
zip_code 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__account_relations (4 columns)
  • contacts__documents (4 columns)
  • contacts__primary_account_account_roles (4 columns)
  • contacts__sharing_clients (4 columns)
  • contacts__sharing_units (4 columns)
  • contacts__tags (4 columns)
data (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
calc_value FLOAT64
created STRING
data_set_id STRING
has_draft BOOL
id STRING
is_delete_protected BOOL
is_deleted BOOL
is_published BOOL
modified STRING
option_name STRING
revision FLOAT64
sort_order FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
entities (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
abstract_entity_id STRING
access_mode FLOAT64
allows_multiple_relation BOOL
created STRING
default_view_field_id STRING
entity_name STRING
entity_type FLOAT64
has_draft BOOL
icon FLOAT64
id STRING
is_delete_protected BOOL
is_deleted BOOL
modified STRING
preference_order FLOAT64
table_data_ex STRING
table_ex STRING
table_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
entity_fitnesses (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created STRING
entity_type FLOAT64
entity_type_id STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
lead_type STRING
lead_type_id STRING
modified STRING
oppty_type STRING
oppty_type_id STRING
revision 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.

  • entity_fitnesses__indicator_relations (4 columns)
entity_scorings (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created STRING
entity_type FLOAT64
id STRING
is_delete_protected BOOL
is_deleted BOOL
is_enabled BOOL
modified STRING
name STRING
revision FLOAT64
settings__filter__typename STRING
settings__filter__filter_main_box__typename STRING
settings__filter__filter_main_box__entity STRING
settings__filter__filter_main_box__id STRING
settings__filter__is_enabled BOOL
settings__filter__operator STRING
sort_order FLOAT64
use_lang 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.

  • entity_scorings__settings__categories (9 columns)
  • entity_scorings__settings__filter__filter_main_box__filter_fields (4 columns)
  • entity_scorings__settings__filter__filter_sibling_boxes (4 columns)
  • entity_scorings__settings__rules (21 columns)
  • entity_scorings__settings__rules__conditions__filter_main_box__filter_fields (6 columns)
  • entity_scorings__settings__rules__conditions__filter_main_box__filter_fields__values (3 columns)
  • entity_scorings__settings__rules__conditions__filter_main_box__filter_fields__values__list (4 columns)
  • entity_scorings__settings__rules__conditions__filter_sibling_boxes (8 columns)
  • entity_scorings__settings__rules__conditions__filter_sibling_boxes__filter_fields (6 columns)
  • entity_scorings__settings__rules__conditions__filter_sibling_boxes__filter_fields__values (3 columns)
  • entity_scorings__settings__rules__conditions__filter_sibling_boxes__filter_fields__values__list (4 columns)
fields (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
api_name STRING
calc_formula STRING
column_name STRING
column_source FLOAT64
composite_field_id STRING
created STRING
data_set_id STRING
default_value STRING
entity_name STRING
has_draft BOOL
id STRING
is_available_for_advanced_formula BOOL
is_available_for_webresource BOOL
is_delete_protected BOOL
is_deleted BOOL
is_published BOOL
is_unique BOOL
modified STRING
name STRING
options__decimal_places FLOAT64
original_dataset_field_id STRING
primitive_type STRING
relation_id STRING
relation_with_entity_id STRING
sequence_id STRING
sequence_pattern STRING
settings__typename STRING
settings__decimal_places FLOAT64
shared_with_field_id STRING
source_field_id STRING
source_type_id STRING
system_readonly BOOL
system_required BOOL
system_type FLOAT64
translated_name STRING
type_id STRING
use_in_global_search BOOL
use_in_interface_preview BOOL
use_lang 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.

  • fields__data_set (4 columns)
  • fields__field_permissions (4 columns)
forecasts (49 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created STRING
end_date STRING
field STRING
field_id STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
modified STRING
name STRING
owner STRING
owner_id STRING
pipeline STRING
pipeline_id STRING
revision FLOAT64
settings__currency_id STRING
settings__date_field_id STRING
settings__end_date STRING
settings__field_filter__filter_main_box__entity STRING
settings__field_filter__filter_main_box__id STRING
settings__field_filter__is_enabled BOOL
settings__field_filter__operator STRING
settings__field_id STRING
settings__filter__filter_main_box__entity STRING
settings__filter__filter_main_box__id STRING
settings__filter__is_custom BOOL
settings__filter__is_enabled BOOL
settings__filter__operator STRING
settings__hide_empty_rows BOOL
settings__list_view_options__sort_by STRING
settings__list_view_options__sort_order STRING
settings__period STRING
settings__pipeline_id STRING
settings__pipeline_view_options__group_by STRING
settings__pipeline_view_options__show_card_fitness BOOL
settings__pipeline_view_options__show_card_labels BOOL
settings__pipeline_view_options__show_card_ranking BOOL
settings__pipeline_view_options__show_card_value BOOL
settings__pipeline_view_options__show_card_velocity BOOL
settings__pipeline_view_options__sort_by STRING
settings__pipeline_view_options__sort_order STRING
settings__quota_comparison_type STRING
settings__start_date STRING
settings__trend_view_options__running_total BOOL
share_mode FLOAT64
share_mode_params FLOAT64
start_date 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.

  • forecasts__type (4 columns)
  • forecasts__settings__type (4 columns)
  • forecasts__settings__columns (7 columns)
  • forecasts__settings__field_filter__filter_main_box__filter_fields (4 columns)
  • forecasts__settings__field_filter__filter_sibling_boxes (4 columns)
  • forecasts__settings__filter__filter_main_box__filter_fields (4 columns)
  • forecasts__settings__filter__filter_sibling_boxes (4 columns)
  • forecasts__settings__items (8 columns)
  • forecasts__settings__items__values (5 columns)
  • forecasts__settings__items_by_level (8 columns)
  • forecasts__settings__items_by_level__b637ee4d_0c37_4dab_a985_e20f3485c3aa__values (5 columns)
  • forecasts__settings__list_view_options__columns (7 columns)
  • forecasts__shared_clients (4 columns)
  • forecasts__shared_units (4 columns)
form_views (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_type STRING
account_type_id STRING
contact_type STRING
contact_type_id STRING
created STRING
entity_type_id STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
lead_type STRING
lead_type_id STRING
modified STRING
name STRING
oppty_type STRING
oppty_type_id STRING
owner STRING
owner_id STRING
revision FLOAT64
share_mode FLOAT64
use_lang 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.

  • form_views__hidden_item_ids (4 columns)
  • form_views__item_colors (4 columns)
  • form_views__sharing_clients (4 columns)
  • form_views__sharing_units (4 columns)
lead_oppties (68 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active_quote STRING
active_quote_id STRING
cf_lead_source1 STRING
cf_lead_source1_id STRING
cf_other_lead_source STRING
closing_date STRING
created STRING
currency_exchange_rates_list STRING
currency_exchange_rates_list_id STRING
days_in_step FLOAT64
formatted_name STRING
id STRING
is_archived BOOL
is_delete_protected BOOL
is_deleted BOOL
is_favorite BOOL
is_value_auto_calculate BOOL
label_flag FLOAT64
lead_type STRING
lead_type_id STRING
lost_date STRING
modified STRING
modified_by_user STRING
name STRING
oppty_type STRING
oppty_type_id STRING
owner STRING
owner_id STRING
primary_account STRING
primary_contact STRING
product_currency STRING
product_currency_id STRING
product_price_list STRING
product_price_list_id STRING
qualify_date STRING
quick_account_email STRING
quick_account_name STRING
quick_account_phone STRING
quick_contact_name STRING
quick_email STRING
quick_phone STRING
ranking FLOAT64
reason_of_close STRING
reason_of_close_description STRING
reason_of_close_id STRING
revision FLOAT64
scoring__entity_scoring_id STRING
scoring__entity_scoring_name STRING
scoring__entity_scoring_use_lang BOOL
scoring__last_calculation STRING
scoring__raw_score FLOAT64
scoring__score FLOAT64
scoring__trend STRING
share_mode FLOAT64
status FLOAT64
step STRING
step_id STRING
table_name STRING
unit STRING
unit_id STRING
value__base_value FLOAT64
value__currency_id STRING
value__value_foreign FLOAT64
was_qualified BOOL
won_date 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_oppties__account_relations (4 columns)
  • lead_oppties__contact_relations (4 columns)
  • lead_oppties__documents (4 columns)
  • lead_oppties__product_relations (4 columns)
  • lead_oppties__product_sections (4 columns)
  • lead_oppties__quote_relations (4 columns)
  • lead_oppties__scoring__categories (9 columns)
  • lead_oppties__scoring__rules (9 columns)
  • lead_oppties__sharing_clients (4 columns)
  • lead_oppties__sharing_units (4 columns)
  • lead_oppties__tags (4 columns)
leads (51 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
cf_lead_source1 STRING
cf_lead_source1_id STRING
cf_other_lead_source STRING
created STRING
currency_exchange_rates_list STRING
currency_exchange_rates_list_id STRING
days_in_step FLOAT64
formatted_name STRING
id STRING
is_archived BOOL
is_delete_protected BOOL
is_deleted BOOL
is_favorite BOOL
label_flag FLOAT64
lead_type STRING
lead_type_id STRING
lost_date STRING
modified STRING
modified_by_user STRING
name STRING
owner STRING
owner_id STRING
primary_account STRING
primary_contact STRING
qualify_date STRING
quick_account_email STRING
quick_account_name STRING
quick_account_phone STRING
quick_contact_name STRING
quick_email STRING
quick_phone STRING
ranking FLOAT64
reason_of_close_description STRING
revision FLOAT64
scoring__entity_scoring_id STRING
scoring__entity_scoring_name STRING
scoring__entity_scoring_use_lang BOOL
scoring__last_calculation STRING
scoring__raw_score FLOAT64
scoring__score FLOAT64
scoring__trend STRING
share_mode FLOAT64
status FLOAT64
step STRING
step_id STRING
table_name STRING
unit STRING
unit_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.

  • leads__account_relations (4 columns)
  • leads__contact_relations (4 columns)
  • leads__documents (4 columns)
  • leads__scoring__categories (9 columns)
  • leads__scoring__rules (9 columns)
  • leads__sharing_clients (4 columns)
  • leads__sharing_units (4 columns)
  • leads__tags (4 columns)
memos (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
modified STRING
owner STRING
owner_id STRING
revision FLOAT64
subject STRING
table_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.

  • memos__account_relations (4 columns)
  • memos__comments (4 columns)
  • memos__contact_relations (4 columns)
  • memos__custom_entity_relations (4 columns)
  • memos__documents (4 columns)
  • memos__lead_relations (4 columns)
  • memos__opportunity_relations (4 columns)
  • memos__project_relations (4 columns)
  • memos__quote_relations (4 columns)
  • memos__sharing_clients (4 columns)
  • memos__sharing_units (4 columns)
notes (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account STRING
account_id STRING
created STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
lead STRING
lead_oppty_id STRING
modified STRING
note STRING
oppty STRING
owner STRING
owner_id STRING
revision FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
oppty_product_relations (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
comment STRING
created STRING
currency_exchange_rates_list STRING
currency_exchange_rates_list_id STRING
discount_percentage FLOAT64
discount_value FLOAT64
id STRING
is_delete_protected BOOL
is_deleted BOOL
modified STRING
modified_by_user STRING
oppty STRING
oppty_id STRING
oppty_product_relation_type STRING
oppty_product_relation_type_id STRING
paired_oppty_product_relation STRING
paired_oppty_product_relation_id STRING
price FLOAT64
product STRING
product_id STRING
quantity FLOAT64
quote STRING
quote_id STRING
revision FLOAT64
sort_order FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
pipelines (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
color FLOAT64
created STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
modified STRING
name STRING
revision 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.

  • pipelines__opportunity_types (4 columns)
  • pipelines__steps (4 columns)
products (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
allowed_pipelines FLOAT64
created STRING
currency_exchange_rates_list STRING
currency_exchange_rates_list_id STRING
formatted_name STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
modified STRING
name STRING
oppty_product_relation_type_id STRING
product_category STRING
product_category_id STRING
product_pipelines__allowed_pipelines FLOAT64
product_type STRING
product_type_id STRING
revision FLOAT64
sku STRING
unit_symbol 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.

  • products__product_pipeline_relations (4 columns)
  • products__product_pipelines__pipelines (4 columns)
profiles (99 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
created STRING
entity FLOAT64
id STRING
is_delete_protected BOOL
is_deleted BOOL
modified STRING
name STRING
owner STRING
owner_id STRING
revision FLOAT64
settings__entity_types__show_account BOOL
settings__entity_types__show_activities BOOL
settings__entity_types__show_contact BOOL
settings__entity_types__show_document BOOL
settings__entity_types__show_email BOOL
settings__entity_types__show_lead BOOL
settings__entity_types__show_mass_email BOOL
settings__entity_types__show_memo BOOL
settings__entity_types__show_note BOOL
settings__entity_types__show_online_form BOOL
settings__entity_types__show_opportunity BOOL
settings__entity_types__show_project BOOL
settings__entity_types__show_quote BOOL
settings__entity_types__show_text_message BOOL
settings__entity_types__show_whats_app_message BOOL
settings__filter__filter_by_period__period STRING
settings__filter__filter_main_box__entity STRING
settings__filter__filter_main_box__id STRING
settings__filter__has_attachment BOOL
settings__filter__is_custom BOOL
settings__filter__is_enabled BOOL
settings__filter__operator STRING
settings__filter__show_only_favorite BOOL
settings__filter_by_period__period STRING
settings__has_attachment BOOL
settings__related_messages BOOL
settings__role__show_managing_unit_items BOOL
settings__role__show_my_items BOOL
settings__role__show_my_shared_items BOOL
settings__role__show_unassigned_items BOOL
settings__show_only_favorite BOOL
settings__show_only_my BOOL
settings__target__goal FLOAT64
settings__target__show_target_on_top BOOL
settings__target__target_period_compare__period STRING
settings__target__target_period_current__period STRING
settings__target__target_source STRING
settings__target__target_value_field_id STRING
settings__target__target_value_type STRING
settings__view__bubble_chart_size_calculated_by STRING
settings__view__conversion_value STRING
settings__view__entity_types__show_account BOOL
settings__view__entity_types__show_activities BOOL
settings__view__entity_types__show_contact BOOL
settings__view__entity_types__show_document BOOL
settings__view__entity_types__show_email BOOL
settings__view__entity_types__show_lead BOOL
settings__view__entity_types__show_mass_email BOOL
settings__view__entity_types__show_memo BOOL
settings__view__entity_types__show_note BOOL
settings__view__entity_types__show_opportunity BOOL
settings__view__entity_types__show_project BOOL
settings__view__entity_types__show_text_message BOOL
settings__view__entity_types__show_whats_app_message BOOL
settings__view__group_by STRING
settings__view__matrix__axis_x__date_display STRING
settings__view__matrix__axis_x__field_id STRING
settings__view__matrix__axis_x__sort_order STRING
settings__view__matrix__axis_y__field_id STRING
settings__view__matrix__axis_y__sort_order STRING
settings__view__matrix__bubble_display STRING
settings__view__matrix__show_account_names BOOL
settings__view__matrix__show_segmentation_grid BOOL
settings__view__period__period STRING
settings__view__period_granularity STRING
settings__view__report_by STRING
settings__view__show_card_fitness BOOL
settings__view__show_card_labels BOOL
settings__view__show_card_ranking BOOL
settings__view__show_card_value BOOL
settings__view__show_card_velocity BOOL
settings__view__show_deleted_units BOOL
settings__view__show_due_date BOOL
settings__view__show_email BOOL
settings__view__show_excluded_items BOOL
settings__view__show_inactive_clients BOOL
settings__view__show_linked_items BOOL
settings__view__show_memo BOOL
settings__view__show_outside_target BOOL
settings__view__show_progress BOOL
settings__view__show_unassigned_lead BOOL
settings__view__sort_by STRING
settings__view__sort_by_modified BOOL
settings__view__sort_order STRING
share_mode FLOAT64
use_lang 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.

  • profiles__pipelines (4 columns)
  • profiles__settings__entity_types__show_custom_entities (4 columns)
  • profiles__settings__filter__filter_main_box__filter_fields (4 columns)
  • profiles__settings__filter__filter_sibling_boxes (4 columns)
  • profiles__settings__lead_process (4 columns)
  • profiles__settings__quote_process (4 columns)
  • profiles__settings__sales_pipeline (4 columns)
  • profiles__settings__view__grid_columns (7 columns)
quotes (45 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
description STRING
created STRING
currency_exchange_rates_list STRING
currency_exchange_rates_list_id STRING
formatted_name STRING
id STRING
is_active_in_opportunity BOOL
is_archived BOOL
is_delete_protected BOOL
is_deleted BOOL
is_favorite BOOL
modified STRING
modified_by_user STRING
name STRING
oppty STRING
oppty_id STRING
owner STRING
owner_id STRING
primary_account STRING
primary_contact STRING
product_currency STRING
product_currency_id STRING
quick_account_email STRING
quick_account_name STRING
quick_account_phone STRING
quick_contact_name STRING
quick_email STRING
quick_phone STRING
quote_number STRING
quote_type STRING
quote_type_id STRING
reason_of_close_description STRING
revision FLOAT64
share_mode FLOAT64
status FLOAT64
step STRING
step_id STRING
total_amount__base_value FLOAT64
total_amount__currency_id STRING
total_amount__value_foreign FLOAT64
unit STRING
unit_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.

  • quotes__account_relations (4 columns)
  • quotes__contact_relations (4 columns)
  • quotes__documents (4 columns)
  • quotes__product_relations (4 columns)
  • quotes__product_sections (4 columns)
  • quotes__sharing_clients (4 columns)
  • quotes__sharing_units (4 columns)
reports (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
access_link STRING
created STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
is_favorite BOOL
modified STRING
name STRING
owner STRING
owner_id STRING
reports_folder STRING
reports_folder_id STRING
revision FLOAT64
settings__typename STRING
settings__filter__typename STRING
settings__filter__is_enabled BOOL
settings__is_advanced_report BOOL
share_mode FLOAT64
share_mode_params 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.

  • reports__settings__filter__owner_ids (4 columns)
  • reports__settings__filter__unit_ids (4 columns)
  • reports__settings__items (11 columns)
  • reports__settings__structure (50 columns)
  • reports__settings__structure__entity_subtypes (5 columns)
  • reports__settings__structure__main_box__display_fields (8 columns)
  • reports__settings__structure__main_box__entity_subtypes (5 columns)
  • reports__settings__structure__sibling_boxes (11 columns)
  • reports__settings__structure__sibling_boxes__display_fields (5 columns)
  • reports__settings__structure__sibling_boxes__entity_subtypes (5 columns)
  • reports__settings__structure__tabs__filter__filter_main_box__filter_fields (6 columns)
  • reports__settings__structure__tabs__filter__filter_main_box__filter_fields__values (3 columns)
  • reports__settings__structure__tabs__filter__filter_main_box__filter_fields__values__list (4 columns)
  • reports__settings__structure__tabs__filter__filter_sibling_boxes (4 columns)
  • reports__settings__structure__tabs__view__aggregation_fields (9 columns)
  • reports__settings__structure__tabs__view__column_fields (4 columns)
  • reports__settings__structure__tabs__view__drilldown_fields (5 columns)
  • reports__settings__structure__tabs__view__group_fields (6 columns)
  • reports__settings__structure__tabs__view__row_fields (4 columns)
  • reports__settings__structure__tabs__view__sort_fields (7 columns)
  • reports__sharing_clients (4 columns)
  • reports__sharing_units (4 columns)
steps (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created STRING
has_readonly_form BOOL
has_version_increment BOOL
id STRING
is_delete_protected BOOL
is_deleted BOOL
lead_process STRING
lead_process_id STRING
modified STRING
name STRING
percent FLOAT64
pipeline STRING
pipeline_id STRING
quote_process STRING
quote_process_id STRING
revision FLOAT64
sort_order FLOAT64
timeframe 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.

  • steps__documents (4 columns)
  • steps__step_checklists (4 columns)
tags (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
color FLOAT64
created STRING
id STRING
is_delete_protected BOOL
is_deleted BOOL
modified STRING
name STRING
revision FLOAT64
supported_entities FLOAT64
use_lang BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

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

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

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

Use leads and lead_oppties to track pipeline value and conversion over time.

Use forecasts and entity_scorings to build a clearer view of expected revenue.

Join accounts with contacts and activities to understand your customers.

Once Coevera 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 Coevera 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 Coevera 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.