Maxio connector

Kaivo is a fully managed data platform that syncs your Maxio 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.

What is the Maxio connector

Sync your Maxio (Chargify) billing data into BigQuery with Kaivo to analyse subscriptions, invoices, and recurring revenue.

Category	Finance & Payments
Authentication	API key
Setup	Self-service

Getting started with the Maxio connector

1. Sign up for Kaivo and create a workspace.
2. Connect your Maxio 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.

Authenticating Maxio

Authenticate with your API Key.

Field	Description
API Key
Your Maxio Advanced Billing (Chargify) API key.

|

Configuring the Maxio connector

When you set up the connector, you provide:

Field	Description
Domain
Your Chargify site domain, e.g. your-company.chargify.com.

|

Tables and columns synced from Maxio

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

coupons (30 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
allow_negative_balance	BOOL
amount	INT64
amount_in_cents	INT64
apply_on_cancel_at_end_of_period	BOOL
archived_at	STRING
code	STRING
compounding_strategy	STRING
conversion_limit	STRING
created_at	STRING
discount_type	STRING
duration_interval	INT64
duration_interval_span	STRING
duration_interval_unit	STRING
duration_period_count	INT64
end_date	STRING
exclude_mid_period_allocations	BOOL
id	INT64
name	STRING
percentage	INT64
product_family_id	INT64
product_family_name	STRING
recurring	BOOL
recurring_scheme	STRING
stackable	BOOL
start_date	STRING
updated_at	STRING
use_site_exchange_rate	BOOL
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: coupons__coupon_restrictions

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.
handle	STRING
id	STRING
item_id	INT64
item_type	STRING
name	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

customers (29 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address	STRING
address_2	STRING
cc_emails	STRING
city	STRING
country	STRING
country_name	STRING
created_at	TIMESTAMP
default_subscription_group_uid	STRING
email	STRING
first_name	STRING
id	INT64
last_name	STRING
locale	STRING
organization	STRING
parent_id	INT64
phone	STRING
portal_customer_created_at	STRING
portal_invite_last_accepted_at	STRING
portal_invite_last_sent_at	TIMESTAMP
reference	STRING
state	STRING
state_name	STRING
tax_exempt	BOOL
updated_at	TIMESTAMP
vat_number	STRING
verified	STRING
zip	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

invoices (55 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address__city	STRING
billing_address__country	STRING
billing_address__line2	STRING
billing_address__state	STRING
billing_address__street	STRING
billing_address__zip	STRING
collection_method	STRING
consolidation_level	STRING
credit_amount	STRING
currency	STRING
customer__chargify_id	INT64
customer__email	STRING
customer__first_name	STRING
customer__last_name	STRING
customer__organization	STRING
customer_id	INT64
discount_amount	STRING
due_amount	STRING
due_date	DATE
group_primary_subscription_id	INT64
issue_date	DATE
memo	STRING
number	STRING
paid_amount	STRING
paid_date	DATE
parent_invoice_number	INT64
parent_invoice_uid	INT64
payment_instructions	STRING
product_family_name	STRING
product_name	STRING
refund_amount	STRING
seller__address__city	STRING
seller__address__country	STRING
seller__address__line2	STRING
seller__address__state	STRING
seller__address__street	STRING
seller__address__zip	STRING
seller__name	STRING
seller__phone	STRING
sequence_number	INT64
shipping_address__city	STRING
shipping_address__country	STRING
shipping_address__line2	STRING
shipping_address__state	STRING
shipping_address__street	STRING
shipping_address__zip	STRING
site_id	INT64
status	STRING
subscription_id	INT64
subtotal_amount	STRING
tax_amount	STRING
total_amount	STRING
uid	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

subscriptions (167 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
activated_at	STRING
automatically_resume_at	STRING
balance_in_cents	INT64
bank_account__bank_account_holder_type	STRING
bank_account__bank_account_type	STRING
bank_account__bank_name	STRING
bank_account__billing_address	STRING
bank_account__billing_address_2	STRING
bank_account__billing_city	STRING
bank_account__billing_country	STRING
bank_account__billing_state	STRING
bank_account__billing_zip	STRING
bank_account__chargify_token	STRING
bank_account__current_vault	STRING
bank_account__customer_id	INT64
bank_account__customer_vault_token	STRING
bank_account__first_name	STRING
bank_account__gateway_handle	STRING
bank_account__id	INT64
bank_account__last_name	STRING
bank_account__masked_bank_account_number	STRING
bank_account__masked_bank_routing_number	STRING
bank_account__site_gateway_setting_id	INT64
bank_account__vault_token	STRING
cancel_at_end_of_period	BOOL
canceled_at	STRING
cancellation_message	STRING
cancellation_method	STRING
coupon_code	STRING
coupon_use_count	INT64
coupon_uses_allowed	INT64
created_at	STRING
credit_balance_in_cents	INT64
credit_card__billing_address	STRING
credit_card__billing_address_2	STRING
credit_card__billing_city	STRING
credit_card__billing_country	STRING
credit_card__billing_state	STRING
credit_card__billing_zip	STRING
credit_card__card_type	STRING
credit_card__chargify_token	STRING
credit_card__current_vault	STRING
credit_card__customer_id	INT64
credit_card__customer_vault_token	STRING
credit_card__disabled	BOOL
credit_card__expiration_month	INT64
credit_card__expiration_year	INT64
credit_card__first_name	STRING
credit_card__gateway_handle	STRING
credit_card__id	INT64
credit_card__last_name	STRING
credit_card__masked_card_number	STRING
credit_card__payment_type	STRING
credit_card__site_gateway_setting_id	INT64
credit_card__vault_token	STRING
currency	STRING
current_billing_amount_in_cents	INT64
current_period_ends_at	STRING
current_period_started_at	STRING
customer__address	STRING
customer__address_2	STRING
customer__cc_emails	STRING
customer__city	STRING
customer__country	STRING
customer__country_name	STRING
customer__created_at	STRING
customer__default_subscription_group_uid	STRING
customer__email	STRING
customer__first_name	STRING
customer__id	INT64
customer__last_name	STRING
customer__locale	STRING
customer__organization	STRING
customer__parent_id	INT64
customer__phone	STRING
customer__portal_customer_created_at	STRING
customer__portal_invite_last_accepted_at	STRING
customer__portal_invite_last_sent_at	STRING
customer__reference	STRING
customer__state	STRING
customer__state_name	STRING
customer__tax_exempt	BOOL
customer__updated_at	STRING
customer__vat_number	STRING
customer__verified	BOOL
customer__zip	STRING
delayed_cancel_at	STRING
dunning_communication_delay_enabled	BOOL
dunning_communication_delay_time_zone	STRING
expires_at	STRING
group__primary	STRING
group__primary_subscription_id	STRING
group__scheme	STRING
group__uid	STRING
id	INT64
locale	STRING
net_terms	INT64
next_assessment_at	STRING
next_product_handle	STRING
next_product_id	INT64
next_product_price_point_id	INT64
offer_id	INT64
on_hold_at	STRING
payer_id	INT64
payment_collection_method	STRING
payment_type	STRING
prepaid_dunning	BOOL
prepayment_balance_in_cents	INT64
previous_state	STRING
product__description	STRING
product__accounting_code	STRING
product__archived_at	STRING
product__created_at	STRING
product__default_product_price_point_id	INT64
product__expiration_interval	INT64
product__expiration_interval_unit	STRING
product__handle	STRING
product__id	INT64
product__initial_charge_after_trial	BOOL
product__initial_charge_in_cents	INT64
product__interval	INT64
product__interval_unit	STRING
product__name	STRING
product__price_in_cents	INT64
product__product_family__description	STRING
product__product_family__accounting_code	STRING
product__product_family__created_at	STRING
product__product_family__handle	STRING
product__product_family__id	INT64
product__product_family__name	STRING
product__product_family__updated_at	STRING
product__product_price_point_name	STRING
product__request_billing_address	BOOL
product__request_credit_card	BOOL
product__require_billing_address	BOOL
product__require_credit_card	BOOL
product__require_shipping_address	BOOL
product__return_params	STRING
product__tax_code	STRING
product__taxable	BOOL
product__trial_interval	INT64
product__trial_interval_unit	STRING
product__trial_price_in_cents	INT64
product__update_return_params	STRING
product__update_return_url	STRING
product__updated_at	STRING
product__version_number	INT64
product_price_in_cents	INT64
product_price_point_id	INT64
product_price_point_type	STRING
product_version_number	INT64
reason_code	STRING
receives_invoice_emails	BOOL
reference	STRING
referral_code	STRING
scheduled_cancellation_at	STRING
signup_payment_id	INT64
signup_revenue	STRING
snap_day	STRING
state	STRING
stored_credential_transaction_id	INT64
total_revenue_in_cents	INT64
trial_ended_at	STRING
trial_started_at	STRING
updated_at	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscriptions__coupon_codes

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: subscriptions__coupons

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.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

transactions (29 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
amount_in_cents	INT64
card_expiration	STRING
card_number	STRING
card_type	STRING
component_id	INT64
created_at	STRING
customer_id	INT64
ending_balance_in_cents	INT64
gateway_order_id	INT64
gateway_transaction_id	STRING
gateway_used	STRING
id	INT64
item_name	STRING
kind	STRING
memo	STRING
parent_id	INT64
payment_id	INT64
product_id	INT64
refunded_amount_in_cents	INT64
role	STRING
starting_balance_in_cents	INT64
statement_id	INT64
subscription_id	INT64
success	BOOL
tax_id	INT64
transaction_type	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the Maxio sync works

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

Frequently asked questions

How long does the initial sync take for Maxio?

It depends on how much history is in your Maxio 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.

Can I sync only some tables or columns?

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 Maxio’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 Maxio, 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?

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 Maxio 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 Maxio connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Maxio data

Recurring revenue

Use subscriptions and invoices to track MRR, expansion, and churn over time.

Billing reporting

Join invoices with transactions to reconcile billing.

Customer view

Use customers to measure lifetime value and repeat billing.

Coupon impact

Use coupons to measure how discounts affect revenue.

Use Maxio data in your AI and BI tools

Once Maxio 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 Maxio data.

Claude

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Power BI

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Data Studio

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

Tableau

The premium analytics standard, with native BigQuery integration. Setup guide →

Google Sheets

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Excel

Connect via Power Query’s BigQuery connector. Setup guide →

Metabase

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Maxio connector pricing and plan details.

Related connectors

• Chargebee: Sync Chargebee to BigQuery.
• ChartMogul: Sync ChartMogul to BigQuery.
• Fennoa: Sync Fennoa to BigQuery.
• Fortnox: Sync Fortnox to BigQuery.
• FreshBooks: Sync FreshBooks to BigQuery.
• PayPal Enterprise Payments: Sync PayPal Enterprise Payments to BigQuery.