Skip to content
Book a demoStart free
Connectors

LiveChat connector

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

LiveChat connector pricing, tier and credits on kaivo.io

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

Sync your LiveChat conversations into BigQuery with Kaivo to analyse chat volume and response times alongside the rest of your data.

CategoryCustomer Service
AuthenticationAPI key
SetupSelf-service

Getting started with the LiveChat connector

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

Field Description
Token
A LiveChat Personal Access Token with at least the chats--all:ro scope.

|

To connect your account, go to LiveChat’s Developer Consoleand navigate to Settings → Authorization → Personal Access Tokens.Create a new Personal Access Token and give it the following scope:

  • chats--all:ro

After creation, the page will show your Account ID and Token. Paste these into this form; the other details are not needed.

When you set up the connector, you provide:

Field Description
Account ID
Your LiveChat account ID, shown alongside the Personal Access Token in the Developer Console.

| | Backfill start date |

Archived chats with a thread creation date before this will not be fetched.

|

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

Archives (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_ab_cursor_at TIMESTAMP
id STRING
thread__id STRING
thread__active BOOL
thread__properties__lc2__greeting_id FLOAT64
thread__properties__lc2__greeting_unique_id STRING
thread__properties__routing__continuous BOOL
thread__properties__routing__group_status_at_start STRING
thread__properties__routing__idle BOOL
thread__properties__routing__pinned BOOL
thread__properties__routing__referrer STRING
thread__properties__routing__start_url STRING
thread__properties__routing__unassigned BOOL
thread__properties__routing__unreplied BOOL
thread__properties__routing__last_transfer_timestamp FLOAT64
thread__properties__source__client_id STRING
thread__properties__source__customer_client_id STRING
thread__properties__rating__score FLOAT64
thread__created_at TIMESTAMP
thread__customer_visit__ip STRING
thread__customer_visit__user_agent STRING
thread__customer_visit__geolocation__country STRING
thread__customer_visit__geolocation__country_code STRING
thread__customer_visit__geolocation__city STRING
thread__customer_visit__geolocation__timezone STRING
thread__customer_visit__geolocation__latitude STRING
thread__customer_visit__geolocation__longitude STRING
thread__summary__status STRING
thread__summary__text STRING
thread__summary__updated_at TIMESTAMP
thread__previous_thread_id STRING
thread__previous_accessible_thread_id STRING
thread__next_thread_id STRING
thread__next_accessible_thread_id STRING
properties__routing__continuous BOOL
properties__routing__pinned BOOL
properties__routing__was_pinned BOOL
properties__source__client_id STRING
properties__source__customer_client_id STRING
is_followed BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
name STRING
events_seen_up_to TIMESTAMP
present BOOL
name_is_default BOOL
created_at TIMESTAMP
visit__id FLOAT64
visit__started_at TIMESTAMP
visit__ended_at TIMESTAMP
visit__referrer STRING
visit__ip STRING
visit__user_agent STRING
visit__browser_language STRING
visit__geolocation__country STRING
visit__geolocation__country_code STRING
visit__geolocation__city STRING
visit__geolocation__timezone STRING
visit__geolocation__latitude STRING
visit__geolocation__longitude STRING
visit__previous_visit_started_at TIMESTAMP
statistics__chats_count FLOAT64
statistics__threads_count FLOAT64
statistics__visits_count FLOAT64
statistics__page_views_count FLOAT64
statistics__greetings_accepted_count FLOAT64
statistics__greetings_converted_count FLOAT64
statistics__tickets_count FLOAT64
statistics__tickets_inbox_count FLOAT64
statistics__tickets_archive_count FLOAT64
statistics__tickets_spam_count FLOAT64
statistics__tickets_trash_count FLOAT64
statistics__orders_count FLOAT64
statistics__last_activity_at TIMESTAMP
statistics__last_visit_at TIMESTAMP
statistics__last_chat_at TIMESTAMP
statistics__last_campaign_interaction_at TIMESTAMP
agent_last_event_created_at TIMESTAMP
customer_last_event_created_at TIMESTAMP
followed BOOL
online BOOL
state STRING
greeting_id FLOAT64
email_verified BOOL
email STRING
avatar STRING
visibility STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Archives__users__visit__last_pages

Section titled “Subtable: Archives__users__visit__last_pages”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
opened_at TIMESTAMP
url STRING
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
haku STRING
cart_value STRING
product_page STRING
breadcrumb STRING
cart_content STRING
product_logo STRING
outlet STRING
nosearchresults STRING
price STRING
blacklisted STRING
haku STRING
device STRING
cart_sum STRING
search_result STRING
product_page STRING
default_blacklisted STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Archives__thread__access__group_ids

Section titled “Subtable: Archives__thread__access__group_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
type STRING
id STRING
created_at TIMESTAMP
visibility STRING
properties__lc2__greeting_id FLOAT64
properties__lc2__greeting_unique_id STRING
properties__lc2__welcome_message BOOL
properties__lc2__form_type STRING
properties__chats__formatting STRING
properties__chats__welcome_message_source STRING
properties__source__client_id STRING
text STRING
author_id STRING
custom_id STRING
template_id STRING
system_message_type STRING
text_vars__customer STRING
text_vars__agent STRING
text_vars__score STRING
text_vars__thread_id STRING
text_vars__initiator STRING
text_vars__targets STRING
postback__type STRING
postback__id STRING
postback__thread_id STRING
postback__event_id STRING
postback__value STRING
form_id STRING
form_type STRING
source STRING
subtype STRING
details STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Archives__thread__events__elements

Section titled “Subtable: Archives__thread__events__elements”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Archives__thread__events__elements__buttons

Section titled “Subtable: Archives__thread__events__elements__buttons”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
text STRING
value STRING
postback_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Archives__thread__events__elements__buttons__user_ids

Section titled “Subtable: Archives__thread__events__elements__buttons__user_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Archives__thread__events__fields

Section titled “Subtable: Archives__thread__events__fields”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Archives__thread__custom_variables

Section titled “Subtable: Archives__thread__custom_variables”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
key STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Chats (71 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
last_event_per_type__message__thread_id STRING
last_event_per_type__message__thread_created_at TIMESTAMP
last_event_per_type__message__event__type STRING
last_event_per_type__message__event__id STRING
last_event_per_type__message__event__created_at TIMESTAMP
last_event_per_type__message__event__visibility STRING
last_event_per_type__message__event__properties__chats__formatting STRING
last_event_per_type__message__event__properties__source__client_id STRING
last_event_per_type__message__event__text STRING
last_event_per_type__message__event__author_id STRING
last_event_per_type__message__event__custom_id STRING
last_event_per_type__rich_message__thread_id STRING
last_event_per_type__rich_message__thread_created_at TIMESTAMP
last_event_per_type__rich_message__event__type STRING
last_event_per_type__rich_message__event__id STRING
last_event_per_type__rich_message__event__created_at TIMESTAMP
last_event_per_type__rich_message__event__visibility STRING
last_event_per_type__rich_message__event__properties__source__client_id STRING
last_event_per_type__rich_message__event__author_id STRING
last_event_per_type__rich_message__event__custom_id STRING
last_event_per_type__rich_message__event__template_id STRING
last_event_per_type__system_message__thread_id STRING
last_event_per_type__system_message__thread_created_at TIMESTAMP
last_event_per_type__system_message__event__type STRING
last_event_per_type__system_message__event__id STRING
last_event_per_type__system_message__event__created_at TIMESTAMP
last_event_per_type__system_message__event__visibility STRING
last_event_per_type__system_message__event__text STRING
last_event_per_type__system_message__event__system_message_type STRING
last_event_per_type__system_message__event__text_vars__customer STRING
last_event_per_type__system_message__event__text_vars__score STRING
last_event_per_type__system_message__event__text_vars__thread_id STRING
last_event_per_type__system_message__event__text_vars__agent STRING
last_event_per_type__filled_form__thread_id STRING
last_event_per_type__filled_form__thread_created_at TIMESTAMP
last_event_per_type__filled_form__event__type STRING
last_event_per_type__filled_form__event__id STRING
last_event_per_type__filled_form__event__created_at TIMESTAMP
last_event_per_type__filled_form__event__visibility STRING
last_event_per_type__filled_form__event__properties__lc2__form_type STRING
last_event_per_type__filled_form__event__properties__source__client_id STRING
last_event_per_type__filled_form__event__author_id STRING
last_event_per_type__filled_form__event__custom_id STRING
last_event_per_type__filled_form__event__form_id STRING
last_event_per_type__filled_form__event__form_type STRING
last_thread_summary__id STRING
last_thread_summary__properties__lc2__greeting_id FLOAT64
last_thread_summary__properties__lc2__greeting_unique_id STRING
last_thread_summary__properties__routing__continuous BOOL
last_thread_summary__properties__routing__group_status_at_start STRING
last_thread_summary__properties__routing__idle BOOL
last_thread_summary__properties__routing__pinned BOOL
last_thread_summary__properties__routing__referrer STRING
last_thread_summary__properties__routing__start_url STRING
last_thread_summary__properties__routing__unassigned BOOL
last_thread_summary__properties__routing__unreplied BOOL
last_thread_summary__properties__routing__last_transfer_timestamp FLOAT64
last_thread_summary__properties__source__client_id STRING
last_thread_summary__properties__source__customer_client_id STRING
last_thread_summary__properties__rating__score FLOAT64
last_thread_summary__active BOOL
last_thread_summary__created_at TIMESTAMP
properties__routing__continuous BOOL
properties__routing__pinned BOOL
properties__routing__was_pinned BOOL
properties__source__client_id STRING
properties__source__customer_client_id STRING
is_followed BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Chats__last_event_per_type__rich_message__event__elements

Section titled “Subtable: Chats__last_event_per_type__rich_message__event__elements”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Chats__last_event_per_type__rich_message__event__elements__buttons

Section titled “Subtable: Chats__last_event_per_type__rich_message__event__elements__buttons”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
text STRING
value STRING
postback_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Chats__last_event_per_type__rich_message__event__elements__buttons__user_ids

Section titled “Subtable: Chats__last_event_per_type__rich_message__event__elements__buttons__user_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Chats__last_event_per_type__filled_form__event__fields

Section titled “Subtable: Chats__last_event_per_type__filled_form__event__fields”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
name STRING
events_seen_up_to TIMESTAMP
present BOOL
name_is_default BOOL
created_at TIMESTAMP
visit__id FLOAT64
visit__started_at TIMESTAMP
visit__ended_at TIMESTAMP
visit__referrer STRING
visit__ip STRING
visit__user_agent STRING
visit__browser_language STRING
visit__geolocation__country STRING
visit__geolocation__country_code STRING
visit__geolocation__city STRING
visit__geolocation__timezone STRING
visit__geolocation__latitude STRING
visit__geolocation__longitude STRING
visit__previous_visit_started_at TIMESTAMP
statistics__chats_count FLOAT64
statistics__threads_count FLOAT64
statistics__visits_count FLOAT64
statistics__page_views_count FLOAT64
statistics__greetings_accepted_count FLOAT64
statistics__greetings_converted_count FLOAT64
statistics__tickets_count FLOAT64
statistics__tickets_inbox_count FLOAT64
statistics__tickets_archive_count FLOAT64
statistics__tickets_spam_count FLOAT64
statistics__tickets_trash_count FLOAT64
statistics__orders_count FLOAT64
statistics__last_activity_at TIMESTAMP
statistics__last_visit_at TIMESTAMP
statistics__last_chat_at TIMESTAMP
statistics__last_campaign_interaction_at TIMESTAMP
agent_last_event_created_at TIMESTAMP
customer_last_event_created_at TIMESTAMP
followed BOOL
online BOOL
state STRING
greeting_id FLOAT64
email_verified BOOL
email STRING
avatar STRING
visibility STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
opened_at TIMESTAMP
url STRING
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
haku STRING
cart_value STRING
product_page STRING
breadcrumb STRING
cart_content STRING
product_logo STRING
outlet STRING
nosearchresults STRING
price STRING
blacklisted STRING
haku STRING
device STRING
cart_sum STRING
search_result STRING
product_page STRING
default_blacklisted STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Chats__last_thread_summary__user_ids

Section titled “Subtable: Chats__last_thread_summary__user_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Chats__last_thread_summary__access__group_ids

Section titled “Subtable: Chats__last_thread_summary__access__group_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Chats__last_thread_summary__tags

Section titled “Subtable: Chats__last_thread_summary__tags”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Threads (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
active BOOL
properties__lc2__greeting_id FLOAT64
properties__lc2__greeting_unique_id STRING
properties__routing__continuous BOOL
properties__routing__group_status_at_start STRING
properties__routing__idle BOOL
properties__routing__pinned BOOL
properties__routing__referrer STRING
properties__routing__start_url STRING
properties__routing__unassigned BOOL
properties__routing__unreplied BOOL
properties__source__client_id STRING
properties__source__customer_client_id STRING
properties__rating__score FLOAT64
created_at TIMESTAMP
customer_visit__ip STRING
customer_visit__user_agent STRING
customer_visit__geolocation__country STRING
customer_visit__geolocation__country_code STRING
customer_visit__geolocation__city STRING
customer_visit__geolocation__timezone STRING
customer_visit__geolocation__latitude STRING
customer_visit__geolocation__longitude STRING
summary__status STRING
summary__text STRING
summary__updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
created_at TIMESTAMP
visibility STRING
properties__lc2__greeting_id FLOAT64
properties__lc2__greeting_unique_id STRING
properties__lc2__welcome_message BOOL
properties__lc2__form_type STRING
properties__chats__formatting STRING
properties__source__client_id STRING
text STRING
author_id STRING
custom_id STRING
template_id STRING
system_message_type STRING
text_vars__customer STRING
text_vars__agent STRING
text_vars__score STRING
text_vars__thread_id STRING
postback__type STRING
postback__id STRING
postback__thread_id STRING
postback__event_id STRING
postback__value STRING
form_id STRING
form_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Threads__events__elements__buttons

Section titled “Subtable: Threads__events__elements__buttons”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
text STRING
value STRING
postback_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Threads__events__elements__buttons__user_ids

Section titled “Subtable: Threads__events__elements__buttons__user_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_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 LiveChat 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 LiveChat?

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

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

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

Use Chats and Threads to track conversation volume by agent and over time.

Analyse thread timestamps to measure response and resolution times.

Report on chats by agent to monitor workload and outcomes.

Join LiveChat conversations with order data in BigQuery to connect chats to outcomes.

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

  • HubSpot: Sync HubSpot to BigQuery.
  • Dixa: Sync Dixa to BigQuery.
  • Freshservice: Sync Freshservice to BigQuery.
  • Genesys: Sync Genesys to BigQuery.
  • Gorgias: Sync Gorgias to BigQuery.
  • giosg: Sync giosg to BigQuery.