Skip to content
Book a demoStart free
Connectors

Mantle connector

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

Mantle connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Mantle 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 payment and finance data instead of moving it.

Sync your Mantle billing data into BigQuery with Kaivo to analyse subscriptions, recurring revenue, and churn alongside the rest of your data.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Mantle 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 Mantle app’s API key, generated in the Mantle dashboard (sidebar → select your app). Each key is tied to a specific app.

|

When you set up the connector, you provide:

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

|

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

customers (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id STRING
url STRING
name STRING
test BOOL
email STRING
domain STRING
icon_url STRING
industry STRING
created_at STRING
updated_at STRING
country_code STRING
last30_revenue FLOAT64
lifetime_value FLOAT64
shopify_domain STRING
shopify_shop_id STRING
first_interaction_at STRING
average_monthly_revenue 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.
id STRING
name STRING
email STRING
label STRING
created_at STRING
updated_at 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 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.
id STRING
app__id STRING
app__name STRING
app__slug STRING
app__icon_url STRING
app__created_at STRING
app__api_client_id STRING
app__development BOOL
app__display_name STRING
app_id STRING
platform_id STRING
installed_at STRING
subscription__id STRING
subscription__plan__type STRING
subscription__plan__description STRING
subscription__plan__id STRING
subscription__plan__name STRING
subscription__plan__amount FLOAT64
subscription__plan__public BOOL
subscription__plan__visible BOOL
subscription__plan__interval STRING
subscription__plan__created_at STRING
subscription__plan__trial_days FLOAT64
subscription__plan__updated_at STRING
subscription__plan__flex_billing BOOL
subscription__plan__currency_code STRING
subscription__plan__deprecated_at STRING
subscription__plan__lifetime_value FLOAT64
subscription__plan__monthly_revenue FLOAT64
subscription__plan__subscriber_count FLOAT64
subscription__plan__active_trial_count FLOAT64
subscription__plan__average_lifetime_value FLOAT64
subscription__total FLOAT64
subscription__active BOOL
subscription__cancel_on STRING
subscription__subtotal FLOAT64
subscription__created_at STRING
subscription__activated_at STRING
subscription__trial_starts_at STRING
subscription__trial_expires_at STRING
subscription__current_period_end STRING
subscription__presentment_total FLOAT64
subscription__billing_cycle_anchor STRING
subscription__current_period_start STRING
subscription__presentment_subtotal FLOAT64
last30_revenue FLOAT64
lifetime_value FLOAT64
trial_starts_at STRING
uninstalled_at STRING
trial_expires_at STRING
churn_prediction FLOAT64
churn_prediction_label__label STRING
churn_prediction_label__status STRING
average_monthly_revenue FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customers__app_installations__reviews

Section titled “Subtable: customers__app_installations__reviews”
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
date STRING
rating FLOAT64
content STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customers__app_installations__subscription__plan__customer_tags

Section titled “Subtable: customers__app_installations__subscription__plan__customer_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 JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customers__app_installations__subscription__plan__shopify_plans

Section titled “Subtable: customers__app_installations__subscription__plan__shopify_plans”
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: customers__app_installations__subscription__plan__customer_exclude_tags

Section titled “Subtable: customers__app_installations__subscription__plan__customer_exclude_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 JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customers__app_installations__subscription__line_items

Section titled “Subtable: customers__app_installations__subscription__line_items”
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
amount FLOAT64
plan_id STRING
currency_code STRING
presentment_amount FLOAT64
presentment_currency_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscriptions (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
plan__type STRING
plan__description STRING
plan__id STRING
plan__name STRING
plan__amount FLOAT64
plan__public BOOL
plan__visible BOOL
plan__interval STRING
plan__created_at STRING
plan__trial_days FLOAT64
plan__updated_at STRING
plan__flex_billing BOOL
plan__currency_code STRING
plan__lifetime_value FLOAT64
plan__monthly_revenue FLOAT64
plan__subscriber_count FLOAT64
plan__active_trial_count FLOAT64
plan__average_lifetime_value FLOAT64
total FLOAT64
active BOOL
frozen_at STRING
subtotal FLOAT64
created_at STRING
canceled_at STRING
activated_at STRING
trial_starts_at STRING
trial_expires_at STRING
current_period_end STRING
presentment_total FLOAT64
billing_cycle_anchor STRING
current_period_start STRING
presentment_subtotal FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscriptions__plan__customer_tags

Section titled “Subtable: subscriptions__plan__customer_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 JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscriptions__plan__shopify_plans

Section titled “Subtable: subscriptions__plan__shopify_plans”
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: subscriptions__plan__customer_exclude_tags

Section titled “Subtable: subscriptions__plan__customer_exclude_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 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
amount FLOAT64
plan_id STRING
currency_code STRING
presentment_amount FLOAT64
presentment_currency_code STRING
_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 Mantle 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 Mantle?

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

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

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

Use subscriptions to track recurring revenue and churn over time.

Join customers with subscriptions to measure lifetime value.

Bring Mantle data into BigQuery to report on it next to your finance data.

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