Skip to content
Book a demoStart free
Connectors

Productive connector

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

Productive connector pricing, tier and credits on kaivo.io

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

Sync your Productive agency data into BigQuery with Kaivo to analyse projects, time, and profitability in one place.

CategoryProject Management
AuthenticationAPI key
SetupSelf-service

Getting started with the Productive connector

Section titled “Getting started with the Productive connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Productive 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
Your Productive API token. Generate one under Settings → API integrations in your Productive account.

|

When you set up the connector, you provide:

Field Description
Organization ID
Your Productive organization ID, shown on the Settings → API integrations page (app.productive.io//settings/api-integrations).

|

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

activities (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__event STRING
attributes__deal_id FLOAT64
attributes__item_id FLOAT64
attributes__page_id FLOAT64
attributes__root_id FLOAT64
attributes__task_id FLOAT64
attributes__item_name STRING
… and 20 more columns

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

  • activities__attributes__changeset (3 columns)
  • activities__attributes__changeset__description (4 columns)
  • activities__attributes__changeset__date (4 columns)
  • activities__attributes__changeset__name (4 columns)
  • activities__attributes__changeset__note (4 columns)
  • activities__attributes__changeset__tags (3 columns)
  • activities__attributes__changeset__tags__value (4 columns)
  • activities__attributes__changeset__time (4 columns)
  • activities__attributes__changeset__event (4 columns)
  • activities__attributes__changeset__hours (4 columns)
  • activities__attributes__changeset__price (5 columns)
  • activities__attributes__changeset__title (4 columns)
  • activities__attributes__changeset__number (4 columns)
  • activities__attributes__changeset__pay_on (4 columns)
  • activities__attributes__changeset__person (6 columns)
  • activities__attributes__changeset__company (6 columns)
  • activities__attributes__changeset__project (6 columns)
  • activities__attributes__changeset__sent_on (4 columns)
  • activities__attributes__changeset__service (5 columns)
  • activities__attributes__changeset__type_id (4 columns)
  • activities__attributes__changeset__unit_id (4 columns)
  • activities__attributes__changeset__assignee (6 columns)
  • activities__attributes__changeset__currency (4 columns)
  • activities__attributes__changeset__ended_on (4 columns)
  • activities__attributes__changeset__quantity (4 columns)
  • activities__attributes__changeset__settings (18 columns)
  • activities__attributes__changeset__person_id (6 columns)
  • activities__attributes__changeset__task_list (4 columns)
  • activities__attributes__changeset__started_on (4 columns)
  • activities__attributes__changeset__total_time (4 columns)
  • activities__attributes__changeset__unit_price (5 columns)
  • activities__attributes__changeset__approved_at (4 columns)
  • activities__attributes__changeset__attachments (3 columns)
  • activities__attributes__changeset__attachments__value (4 columns)
  • activities__attributes__changeset__invoiced_on (4 columns)
  • activities__attributes__changeset__responsible (6 columns)
  • activities__attributes__changeset__deal_type_id (4 columns)
  • activities__attributes__changeset__finalized_on (4 columns)
  • activities__attributes__changeset__service_type (4 columns)
  • activities__attributes__changeset__access_type_id (4 columns)
  • activities__attributes__changeset__estimated_time (4 columns)
  • activities__attributes__changeset__billing_type_id (4 columns)
  • activities__attributes__changeset__project_manager (5 columns)
  • activities__attributes__changeset__copied_from_task (4 columns)
  • activities__attributes__changeset__document_type_id (4 columns)
  • activities__attributes__changeset__dynamic_group_id (4 columns)
  • activities__attributes__changeset__booking_method_id (4 columns)
  • activities__attributes__changeset__invoicing_settings (6 columns)
  • activities__attributes__changeset__workflow_status_id (6 columns)
  • activities__attributes__changeset__time_locking_reminders (4 columns)
approval_policies (190 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
meta__settings__system_flags__value STRING
meta__settings__system_flags__updated_at STRING
meta__settings__system_flags__setting_type STRING
meta__page_size FLOAT64
meta__total_count FLOAT64
meta__total_pages FLOAT64
meta__current_page FLOAT64
meta__max_page_size FLOAT64
meta__organization_features__docs__type STRING
… and 180 more columns

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

  • approval_policies__data (4 columns)
attachments (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__url STRING
attributes__name STRING
attributes__size FLOAT64
attributes__resized BOOL
attributes__temp_url STRING
attributes__created_at STRING
attributes__content_type STRING
… and 15 more columns
boards (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__position FLOAT64
attributes__placement FLOAT64
relationships__project__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
bookings (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__note STRING
attributes__time FLOAT64
attributes__draft BOOL
attributes__hours FLOAT64
attributes__approved BOOL
attributes__canceled BOOL
attributes__ended_on STRING
… and 29 more columns
comments (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__body STRING
attributes__draft BOOL
attributes__hidden BOOL
attributes__created_at STRING
attributes__updated_at STRING
attributes__commentable_type STRING
relationships__deal__meta__included BOOL
… and 12 more columns
companies (33 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__vat STRING
attributes__name STRING
attributes__due_days FLOAT64
attributes__settings__invoicing_settings__tax_rate_id STRING
attributes__settings__invoicing_settings__date_interval__end_date STRING
attributes__settings__invoicing_settings__date_interval__date_interval_id STRING
attributes__settings__invoicing_settings__subsidiary_id STRING
… and 23 more columns

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

  • companies__attributes__contact__phones (6 columns)
  • companies__attributes__contact__websites (6 columns)
  • companies__attributes__contact__addresses (11 columns)
  • companies__attributes__tag_list (4 columns)
contact_entries (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__type STRING
attributes__vat STRING
attributes__city STRING
attributes__name STRING
attributes__phone STRING
attributes__state STRING
attributes__address STRING
… and 13 more columns
custom_field_options (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__position FLOAT64
relationships__custom_field__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_fields (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__description STRING
attributes__name STRING
attributes__global BOOL
attributes__position FLOAT64
attributes__required BOOL
attributes__sensitive BOOL
attributes__created_at STRING
… and 13 more columns
dashboards (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__created_at STRING
attributes__updated_at STRING
relationships__creator__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
deal_statuses (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__color_id FLOAT64
attributes__position FLOAT64
attributes__status_id FLOAT64
attributes__lost_reason_enabled BOOL
attributes__probability_enabled BOOL
attributes__time_tracking_enabled BOOL
… and 6 more columns
deals (101 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__cost FLOAT64
attributes__date STRING
attributes__name STRING
attributes__budget BOOL
attributes__number STRING
attributes__profit FLOAT64
attributes__expense FLOAT64
… and 91 more columns

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

  • deals__attributes__tag_list (4 columns)
document_types (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__locale STRING
attributes__tax1_name STRING
attributes__tax1_value STRING
attributes__dual_currency BOOL
attributes__line_item_tax BOOL
attributes__exportable_type_id FLOAT64
… and 7 more columns
entitlements (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__note STRING
attributes__used STRING
attributes__pending STRING
attributes__end_date STRING
attributes__allocated FLOAT64
attributes__start_date STRING
relationships__event__meta__included BOOL
… and 5 more columns
events (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__color_id FLOAT64
attributes__event_type_id FLOAT64
attributes__half_day_bookings BOOL
attributes__limitation_type_id FLOAT64
attributes__sync_personal_integrations BOOL
relationships__organization__data__type STRING
… and 2 more columns
exchange_rates (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__date STRING
attributes__out_of_date 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.

  • exchange_rates__attributes__rates (6 columns)
expenses (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__date STRING
attributes__name STRING
attributes__draft BOOL
attributes__amount FLOAT64
attributes__profit FLOAT64
attributes__approved BOOL
attributes__currency STRING
… and 42 more columns
filters (38 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__description STRING
attributes__name STRING
attributes__hidden BOOL
attributes__params__date__eq STRING
attributes__params__date__gt_eq STRING
attributes__params__date__lt_eq STRING
attributes__params__status__eq STRING
… and 28 more columns

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

  • filters__attributes__params__assignee_id__eq (4 columns)
  • filters__attributes__params__payment_status__eq (4 columns)
  • filters__attributes__params__workflow_status_category_id__eq (4 columns)
holiday_calendars (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__country STRING
attributes__autogenerate_holidays BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
holidays (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__date STRING
attributes__name STRING
relationships__organization__data__type STRING
relationships__organization__data__id STRING
relationships__holiday_calendar__meta__included BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoice_attributions (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__amount FLOAT64
attributes__date_to STRING
attributes__currency STRING
attributes__amount_default FLOAT64
attributes__currency_default STRING
attributes__amount_normalized FLOAT64
attributes__currency_normalized STRING
… and 5 more columns
invoices (77 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__note STRING
attributes__amount FLOAT64
attributes__number STRING
attributes__pay_on STRING
attributes__paid_on STRING
attributes__sent_on STRING
attributes__subject STRING
… and 67 more columns

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

  • invoices__attributes__tag_list (4 columns)
line_items (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__description STRING
attributes__amount FLOAT64
attributes__unit_id FLOAT64
attributes__currency STRING
attributes__position FLOAT64
attributes__quantity STRING
attributes__tax_name STRING
… and 22 more columns
lost_reasons (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
relationships__organization__data__type STRING
relationships__organization__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
memberships (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__type_id FLOAT64
attributes__target_type STRING
attributes__access_type_id FLOAT64
attributes__dynamic_group_id FLOAT64
relationships__deal__meta__included BOOL
relationships__page__meta__included BOOL
relationships__team__meta__included BOOL
… and 7 more columns
organization_memberships (278 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__updated_at STRING
attributes__preferences STRING
attributes__weekly_emails BOOL
attributes__time_reminders BOOL
attributes__tasks_layout_id FLOAT64
attributes__email_notifications BOOL
attributes__granular_notification_preferences__deals__emails__app BOOL
… and 268 more columns
organizations (74 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__weight FLOAT64
attributes__metrics STRING
attributes__currency STRING
attributes__due_days FLOAT64
attributes__email_key STRING
attributes__time_zone STRING
… and 64 more columns

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

  • organizations__attributes__addons (4 columns)
  • organizations__attributes__working_hours (4 columns)
page_versions (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__created_at STRING
attributes__updated_at STRING
attributes__body_snapshot STRING
attributes__title_snapshot STRING
relationships__page__meta__included BOOL
relationships__person__meta__included BOOL
relationships__organization__data__type STRING
… and 2 more columns

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

  • page_versions__attributes__prosemirror_steps (6 columns)
  • page_versions__attributes__prosemirror_steps__slice__content (5 columns)
pages (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__body STRING
attributes__title STRING
attributes__public BOOL
attributes__edited_at STRING
attributes__created_at STRING
attributes__updated_at STRING
attributes__version_number FLOAT64
… and 10 more columns
payment_reminder_sequences (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__created_at STRING
attributes__updated_at STRING
attributes__default_sequence BOOL
relationships__creator__meta__included BOOL
relationships__updater__meta__included BOOL
relationships__organization__data__type STRING
… and 3 more columns
payment_reminders (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__body STRING
attributes__from STRING
attributes__subject STRING
attributes__created_at STRING
attributes__updated_at STRING
attributes__before_due_date BOOL
attributes__reminder_period FLOAT64
… and 7 more columns

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

  • payment_reminders__attributes__cc (4 columns)
  • payment_reminders__attributes__to (4 columns)
  • payment_reminders__attributes__bcc (4 columns)
payments (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__note STRING
attributes__amount FLOAT64
attributes__paid_on STRING
attributes__currency STRING
attributes__amount_default FLOAT64
attributes__currency_default STRING
attributes__amount_normalized FLOAT64
… and 5 more columns
pipelines (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__icon_id STRING
attributes__position FLOAT64
attributes__created_at STRING
attributes__updated_at STRING
attributes__pipeline_type_id FLOAT64
relationships__creator__meta__included BOOL
… and 4 more columns
prices (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__rate FLOAT64
attributes__unit_id FLOAT64
attributes__currency STRING
attributes__quantity STRING
attributes__updated_at STRING
attributes__rate_default FLOAT64
… and 16 more columns
project_assignments (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__watched BOOL
attributes__created_at STRING
relationships__person__meta__included BOOL
relationships__project__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
relationships__favorite_filter__meta__included BOOL
… and 4 more columns
projects (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__number STRING
attributes__template BOOL
attributes__created_at STRING
attributes__sample_data BOOL
attributes__public_access BOOL
attributes__time_on_tasks BOOL
… and 14 more columns

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

  • projects__attributes__task_custom_fields_ids (4 columns)
rate_cards (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__created_at STRING
attributes__updated_at STRING
attributes__prices_count FLOAT64
relationships__company__meta__included BOOL
relationships__creator__meta__included BOOL
relationships__organization__data__type STRING
… and 2 more columns
reports_booking-reports (44 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__time FLOAT64
attributes__count FLOAT64
attributes__draft BOOL
attributes__group STRING
attributes__mandays STRING
attributes__currency STRING
attributes__end_date STRING
… and 34 more columns
reports_timesheet_reports (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__count FLOAT64
attributes__group STRING
attributes__friday_time FLOAT64
attributes__monday_time FLOAT64
attributes__sunday_time FLOAT64
attributes__tuesday_time FLOAT64
attributes__saturday_time FLOAT64
… and 20 more columns
salaries (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__cost FLOAT64
attributes__note STRING
attributes__hours STRING
attributes__currency STRING
attributes__ended_on STRING
attributes__overhead BOOL
attributes__started_on STRING
… and 16 more columns

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

  • salaries__attributes__working_hours (4 columns)
sections (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__position FLOAT64
relationships__deal__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
service_types (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
relationships__assignees__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
services (82 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__cost FLOAT64
attributes__name STRING
attributes__price FLOAT64
attributes__profit FLOAT64
attributes__revenue FLOAT64
attributes__unit_id FLOAT64
attributes__billable BOOL
… and 72 more columns
sessions (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__token STRING
attributes__device STRING
attributes__browser STRING
attributes__last_ip STRING
attributes__machine BOOL
attributes__user_id FLOAT64
… and 9 more columns
subsidiaries (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__facility_costs FLOAT64
attributes__show_delivery_date BOOL
attributes__invoice_number_format STRING
attributes__facility_costs_default FLOAT64
attributes__facility_costs_normalized FLOAT64
relationships__bill_from__meta__included BOOL
… and 5 more columns
tags (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
task_lists (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__position FLOAT64
attributes__email_key STRING
attributes__placement FLOAT64
relationships__board__meta__included BOOL
relationships__project__meta__included BOOL
relationships__organization__data__type STRING
… and 2 more columns
tasks (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__description STRING
attributes__title STRING
attributes__closed BOOL
attributes__number STRING
attributes__private BOOL
attributes__type_id FLOAT64
attributes__due_date STRING
… and 27 more columns

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

  • tasks__attributes__tag_list (4 columns)
  • tasks__attributes__repeat_on_weekday (4 columns)
  • tasks__attributes__todo_assignee_ids (4 columns)
tax_rates (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__primary_component_name STRING
attributes__primary_component_value STRING
relationships__subsidiary__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
time_entries (46 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__cost FLOAT64
attributes__date STRING
attributes__note STRING
attributes__time FLOAT64
attributes__approved BOOL
attributes__currency STRING
attributes__invoiced BOOL
… and 36 more columns
time_entry_versions (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__event STRING
attributes__item_id FLOAT64
attributes__item_type STRING
attributes__created_at STRING
relationships__creator__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
… and 1 more columns

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

  • time_entry_versions__attributes__object_changes__date (4 columns)
  • time_entry_versions__attributes__object_changes__time (4 columns)
  • time_entry_versions__attributes__object_changes__person_id (4 columns)
  • time_entry_versions__attributes__object_changes__created_at (4 columns)
  • time_entry_versions__attributes__object_changes__creator_id (4 columns)
  • time_entry_versions__attributes__object_changes__approved_at (4 columns)
  • time_entry_versions__attributes__object_changes__billing_point_id (4 columns)
timers (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__person_id FLOAT64
attributes__started_at STRING
attributes__total_time FLOAT64
relationships__time_entry__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__email STRING
attributes__sysadmin BOOL
attributes__last_name STRING
attributes__time_zone STRING
attributes__first_name STRING
attributes__preferences STRING
attributes__intercom_hash STRING
… and 7 more columns

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

  • users__attributes__beta_features (4 columns)
  • users__attributes__sysadmin_permissions (4 columns)
widgets (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__width FLOAT64
attributes__height FLOAT64
attributes__row_position FLOAT64
attributes__widget_type_id FLOAT64
attributes__column_position FLOAT64
relationships__filter__meta__included BOOL
relationships__dashboard__meta__included BOOL
… and 3 more columns
workflow_statuses (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
attributes__color_id FLOAT64
attributes__position FLOAT64
attributes__category_id FLOAT64
relationships__workflow__meta__included BOOL
relationships__organization__data__type STRING
relationships__organization__data__id STRING
… and 1 more columns
workflows (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
attributes__name STRING
relationships__organization__data__type STRING
relationships__organization__data__id STRING
relationships__workflow_statuses__meta__included 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 Productive 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 Productive?

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

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

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

Use bookings and deals with companies to compare billed work against budgets.

Join activities with bookings to measure how time is spent.

Use deals and deal_statuses to track pipeline and conversion.

Use Productive data in your AI and BI tools

Section titled “Use Productive data in your AI and BI tools”

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

  • ClickUp: Sync ClickUp to BigQuery.
  • GitHub: Sync GitHub to BigQuery.
  • GitLab: Sync GitLab to BigQuery.
  • Harvest: Sync Harvest to BigQuery.
  • Jira: Sync Jira to BigQuery.
  • Kellokortti: Sync Kellokortti to BigQuery.