Skip to content
Book a demoStart free
Connectors

Younium connector

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

Younium connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Younium 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 Younium subscription data into BigQuery with Kaivo to analyse subscriptions, invoices, and recurring revenue.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Younium connector

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

Field Description
Secret Key
The Secret Key shown alongside the Client ID when you create the Younium personal token. Copy it immediately — it is only shown once.

|

When you set up the connector, you provide:

Field Description
Client ID
The Client ID of your Younium API credentials. Generate a client token under your Younium profile → Privacy & Security → Personal Tokens. A dedicated integration user is recommended.

| | Legal Entity |

The Younium legal entity (ID or name) to pull data from. Sent as the ‘legal-entity’ request header.

|

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

account (46 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_number STRING The unique identifier for the account.
account_type STRING The type of the account.
accounts_receivable STRING The total accounts receivable amount.
acv__amount FLOAT64 ACV amount.
acv__base_currency_amount FLOAT64 ACV amount in base currency.
acv__base_currency_code STRING Base currency code for ACV.
acv__currency_code STRING Currency code for ACV.
cmrr__amount FLOAT64 CMRR amount.
cmrr__base_currency_amount FLOAT64 CMRR amount in base currency.
cmrr__base_currency_code STRING Base currency code for CMRR.
cmrr__currency_code STRING Currency code for CMRR.
created STRING Date and time when the account was created.
currency_code STRING Currency code used for transactions.
default_delivery_address__country STRING Country of the default delivery address.
default_delivery_address__id STRING Unique identifier for the default delivery address.
default_invoice_address__city STRING City of the default invoice address.
default_invoice_address__country STRING Country of the default invoice address.
default_invoice_address__description STRING Description of the default invoice address.
default_invoice_address__id STRING Unique identifier for the default invoice address.
default_invoice_address__street STRING Street of the default invoice address.
default_invoice_address__zip STRING ZIP or postal code of the default invoice address.
default_payment_term STRING Default payment term for the account.
emrr__amount FLOAT64 EMRR amount.
emrr__base_currency_amount FLOAT64 EMRR amount in base currency.
emrr__base_currency_code STRING Base currency code for EMRR.
emrr__currency_code STRING Currency code for EMRR.
id STRING Unique identifier for the account.
inactive BOOL Indicates if the account is inactive.
invoice_delivery_method STRING Preferred method of delivery for invoices.
invoice_template_id STRING Unique identifier for the invoice template used.
modified STRING Date and time when the account was last modified.
name STRING Name of the account.
one_time_fees__amount FLOAT64 One-time fees amount.
one_time_fees__base_currency_amount FLOAT64 One-time fees amount in base currency.
one_time_fees__base_currency_code STRING Base currency code for one-time fees.
one_time_fees__currency_code STRING Currency code for one-time fees.
organization_number STRING The organization number associated with the account.
our_reference STRING Our reference for the account.
tax_registration_number STRING Tax registration number for the account.
tax_template STRING Tax template applied to the account.
tcv__amount FLOAT64 TCV amount.
tcv__base_currency_amount FLOAT64 TCV amount in base currency.
tcv__base_currency_code STRING Base currency code for TCV.
tcv__currency_code STRING Currency code for TCV.
_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.
city STRING City of the address.
country STRING Country of the address.
description STRING Description of the address.
id STRING Unique identifier for the address.
street STRING Street of the address.
zip STRING ZIP or postal code of the address.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
booking (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_category STRING Category of the account
acv__amount FLOAT64 ACV amount
acv__amount_in_base_currency FLOAT64 ACV amount in base currency
booking_type STRING Type of booking
change_type STRING Type of change
classification__chart_color STRING Color for classification in a chart
classification__classification_type STRING Type of classification
classification__description STRING Classification description
classification__is_system_classification BOOL Flag indicating if the classification is a system classification
classification__name STRING Classification name
cmrr__amount FLOAT64 CMRR amount
cmrr__amount_in_base_currency FLOAT64 CMRR amount in base currency
created STRING Date of creation
effective_date STRING Effective date of the booking
emrr__amount FLOAT64 EMRR amount
emrr__amount_in_base_currency FLOAT64 EMRR amount in base currency
fmrr__amount FLOAT64 FMRR amount
fmrr__amount_in_base_currency FLOAT64 FMRR amount in base currency
id STRING Unique identifier for the booking
modified STRING Date of modification
one_time_fees__amount FLOAT64 One-time fees amount
one_time_fees__amount_in_base_currency FLOAT64 One-time fees amount in base currency
order__id STRING Order ID
order__order_number STRING Order number
tcv__amount FLOAT64 TCV amount
tcv__amount_in_base_currency FLOAT64 TCV amount in base currency
_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.
acv__amount FLOAT64 ACV amount
acv__base_currency_amount FLOAT64 ACV amount in base currency
acv__base_currency_code STRING Base currency code for ACV
acv__currency_code STRING Currency code for ACV
acv__currency_conversion_date STRING Date of currency conversion for ACV
charge__charge_number STRING Charge number
charge__description STRING Charge description
charge__id STRING Charge ID
charge__name STRING Charge name
cmrr__amount FLOAT64 CMRR amount
cmrr__base_currency_amount FLOAT64 CMRR amount in base currency
cmrr__base_currency_code STRING Base currency code for CMRR
cmrr__currency_code STRING Currency code for CMRR
cmrr__currency_conversion_date STRING Date of currency conversion for CMRR
created STRING Date of creation
emrr__amount FLOAT64 EMRR amount
emrr__base_currency_amount FLOAT64 EMRR amount in base currency
emrr__base_currency_code STRING Base currency code for EMRR
emrr__currency_code STRING Currency code for EMRR
emrr__currency_conversion_date STRING Date of currency conversion for EMRR
fmrr__amount FLOAT64 FMRR amount
fmrr__base_currency_amount FLOAT64 FMRR amount in base currency
fmrr__base_currency_code STRING Base currency code for FMRR
fmrr__currency_code STRING Currency code for FMRR
fmrr__currency_conversion_date STRING Date of currency conversion for FMRR
modified STRING Date of modification
one_time_fees__amount FLOAT64 One-time fees amount
one_time_fees__base_currency_amount FLOAT64 One-time fees amount in base currency
one_time_fees__base_currency_code STRING Base currency code for one-time fees
one_time_fees__currency_code STRING Currency code for one-time fees
one_time_fees__currency_conversion_date STRING Date of currency conversion for one-time fees
tcv__amount FLOAT64 TCV amount
tcv__base_currency_amount FLOAT64 TCV amount in base currency
tcv__base_currency_code STRING Base currency code for TCV
tcv__currency_code STRING Currency code for TCV
tcv__currency_conversion_date STRING Date of currency conversion for TCV
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoice (69 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier for the invoice
invoice_number STRING Unique invoice number
status STRING Current status of the invoice
created STRING Timestamp for when the invoice was created
invoice_delivery_method STRING Delivery method for sending the invoice
modified STRING Timestamp for when the invoice was last modified
account__name STRING Name of the account
account__account_number STRING The account number
account__id STRING Unique identifier for the account
account__external_erp_id STRING External ERP ID for the account
account__external_crm_id STRING External CRM ID for the account
notes STRING Additional notes or comments related to the invoice
invoice_date STRING Date when the invoice was issued
due_date STRING Due date for the invoice payment
days_past_due FLOAT64 Number of days past due for the invoice payment
nr_of_reminders FLOAT64 Number of reminders sent for the invoice
payment_term__id STRING Unique identifier for the payment term
payment_term__days FLOAT64 Number of days for the payment term
payment_term__name STRING Name of the payment term
currency STRING Currency used in the invoice
subtotal FLOAT64 Subtotal amount of the invoice
tax FLOAT64 Total tax amount for the invoice
total_amount FLOAT64 Total amount of the invoice including tax
total_rounding_amount FLOAT64 Rounded amount in the total calculation
settled_amount FLOAT64 Amount that has been settled for the invoice
balanced_amount FLOAT64 The total balanced amount in the invoice
tax_included BOOL Flag to indicate if tax is included in the total amount
invoice_address__id STRING Unique identifier for the invoice address
invoice_address__description STRING Additional description for the invoice address
invoice_address__name STRING Name associated with the invoice address
invoice_address__street STRING Street address in the invoice address
invoice_address__street2 STRING Additional street details in the invoice address
invoice_address__city STRING City in the invoice address
invoice_address__county STRING County in the invoice address
invoice_address__state STRING State in the invoice address
invoice_address__zip STRING Zip code in the invoice address
invoice_address__country STRING Country in the invoice address
delivery_address__id STRING Unique identifier for the delivery address
delivery_address__description STRING Additional description for the delivery address
delivery_address__name STRING Name associated with the delivery address
delivery_address__street STRING Street address in the delivery address
delivery_address__street2 STRING Additional street details in the delivery address
delivery_address__city STRING City in the delivery address
delivery_address__county STRING County in the delivery address
delivery_address__state STRING State in the delivery address
delivery_address__zip STRING Zip code in the delivery address
delivery_address__country STRING Country in the delivery address
invoice_batch_id STRING Identifier for the batch of invoices
your_reference STRING Reference provided by the buyer
our_reference STRING Reference provided by the company
your_order_number STRING Order number specified by the buyer
buyer_reference STRING Reference information provided by the buyer
invoice_type STRING Type of the invoice
send_method STRING Method used for sending the invoice
exchange_rate FLOAT64 Exchange rate used in the invoice
settled_notes STRING Notes related to the settled amount
invoice_template_id STRING Identifier for the invoice template used
disable_automatic_invoice_reminder BOOL Flag to indicate if automatic invoice reminders are disabled
online_payment_link STRING Link for online payment of the invoice
accounts_receivable__id STRING Unique identifier for the accounts receivable
accounts_receivable__code STRING Code for the accounts receivable
accounts_receivable__name STRING Name of the accounts receivable
accounts_receivable__description STRING Description of the accounts receivable
accounts_receivable__external_erp_id STRING External ERP ID for the accounts receivable
accounts_receivable__external_crm_id STRING External CRM ID for the accounts receivable
external_erp_id STRING External ERP ID for the invoice
external_crm_id STRING External CRM ID for the invoice
_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 Unique identifier for the line item
invoice_line_number FLOAT64 Line number in the invoice for the item
product_number STRING Product number for the line item
product_name STRING Name of the product for the line item
charge_description STRING Description of the charge for the line item
charge_number STRING Charge number for the line item
quantity FLOAT64 Quantity of the product in the line item
unit_of_measure__id STRING Unique identifier for the unit of measure
unit_of_measure__unit_code STRING Code representing the unit of measure
unit_of_measure__name STRING Name of the unit of measure
unit_of_measure__display_name STRING Display name of the unit of measure
price FLOAT64 Price of the line item
subtotal FLOAT64 Subtotal amount for the line item
total FLOAT64 Total amount for the line item
tax FLOAT64 Tax amount for the line item
service_period_start_date STRING Start date of the service period for the line item
service_period_end_date STRING End date of the service period for the line item
notes STRING Additional notes for the line item
order_charge_id STRING Identifier for the order charge related to the line item
order_id STRING Identifier for the order related to the line item
account_id STRING Unique identifier for the account associated with the line item
accounts_receivable__id STRING Unique identifier for the accounts receivable
accounts_receivable__code STRING Code for the accounts receivable
accounts_receivable__name STRING Name of the accounts receivable
accounts_receivable__description STRING Description of the accounts receivable
accounts_receivable__external_erp_id STRING External ERP ID for the accounts receivable
accounts_receivable__external_crm_id STRING External CRM ID for the accounts receivable
deferred_revenue__id STRING Unique identifier for the deferred revenue
deferred_revenue__code STRING Code for the deferred revenue
deferred_revenue__name STRING Name of the deferred revenue
deferred_revenue__description STRING Description of the deferred revenue
deferred_revenue__external_erp_id STRING External ERP ID for the deferred revenue
deferred_revenue__external_crm_id STRING External CRM ID for the deferred revenue
recognized_revenue__id STRING Unique identifier for the recognized revenue
recognized_revenue__code STRING Code for the recognized revenue
recognized_revenue__name STRING Name of the recognized revenue
recognized_revenue__description STRING Description of the recognized revenue
recognized_revenue__external_erp_id STRING External ERP ID for the recognized revenue
recognized_revenue__external_crm_id STRING External CRM ID for the recognized revenue
external_erp_id STRING External ERP ID for the line item
external_crm_id STRING External CRM ID for the line item
tax_category_name STRING Name of the tax category
tax_rate FLOAT64 Tax rate applied to the line item
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The unique identifier for the product.
product_number STRING The unique number associated with the product.
name STRING The name of the product.
created STRING The date when the product was created.
modified STRING The date when the product was last modified.
product_type STRING The type of product.
category STRING The category the product belongs to.
activation_date STRING The date when the product is activated.
end_of_new_sales_date STRING The end date for new sales of the product.
end_of_renewal_date STRING The end date for product renewals.
end_of_life_date STRING The end of life date for the product.
is_framework_product BOOL Indicates if the product is a framework product.
external_erp_id STRING The ID from an external ERP system.
external_crm_id STRING The ID from an external CRM system.
_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 The unique identifier for the charge plan.
charge_plan_number STRING The number associated with the charge plan.
name STRING The name of the charge plan.
effective_start_date STRING The date when the charge plan becomes effective.
end_of_new_sales_date STRING The end date for new sales of the charge plan.
effective_end_date STRING The date when the charge plan is no longer effective.
_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 The unique identifier for the charge.
charge_number STRING The number associated with the charge.
name STRING The name of the charge.
model STRING The model associated with the charge.
charge_type STRING The type of charge.
unit_code STRING The unit code for the charge.
default_quantity FLOAT64 The default quantity for the charge.
price_period STRING The period for pricing.
usage_rating STRING The rating for usage.
create_invoice_lines_per_tier BOOL Whether to create invoice lines per tier.
billing_day STRING The day of the month when billing occurs.
specific_billing_day FLOAT64 A specific day for billing.
billing_period STRING The period for billing.
period_alignment STRING The alignment of the billing period.
billing_timing STRING The timing of billing.
tax_template STRING The tax template used for the charge.
tax_included BOOL Indicates if tax is included in the charge.
external_erp_id STRING The ID from an external ERP system.
external_crm_id STRING The ID from an external CRM system.
deferred_revenue_account STRING The account used for deferred revenue.
recognized_revenue_account STRING The account used for recognized revenue.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: product__charge_plans__charges__price_details

Section titled “Subtable: product__charge_plans__charges__price_details”
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.
currency STRING The currency for pricing.
price FLOAT64 The price for the quantity range.
tier FLOAT64 The tier level for pricing.
description STRING A description of the price details.
from_quantity FLOAT64 The minimum quantity for the price tier.
to_quantity FLOAT64 The maximum quantity for the price tier.
price_base STRING The base price for the tier.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscription (95 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier for the subscription
order_number STRING Order number associated with the subscription
created STRING Date of subscription creation
modified STRING Date of the last modification to the subscription
order_billing_period STRING Billing period for the order
set_order_billing_period BOOL Setup billing period for the order
version FLOAT64 Version of the data
is_last_version BOOL Flag indicating if the subscription is the last version
status STRING Status of the subscription
description STRING Description of the subscription
remarks STRING Additional remarks or notes
effective_start_date STRING Effective start date of the subscription
effective_end_date STRING Effective end date of the subscription
cancellation_date STRING Date of subscription cancellation
effective_change_date STRING Effective date of subscription change
order_date STRING Date of the order
notice_period_date STRING Date when notice period starts
last_renewal_date STRING Date of the last renewal
notice_period FLOAT64 Notice period for subscription cancellation
term FLOAT64 Term of the subscription
renewal_term FLOAT64 Renewal term for the subscription
is_auto_renewed BOOL Flag indicating if the subscription is set to auto-renew
order_type STRING Type of the order
term_type STRING Type of the subscription term
order_payment_method STRING Payment method used for the order
invoice_separatly BOOL Flag indicating if the subscription is invoiced separately
your_reference STRING Reference provided by user
our_reference STRING Our reference for the subscription
your_order_number STRING Order number specified by user
invoice_address__id STRING Unique identifier for the address
invoice_address__description STRING Description of invoice address
invoice_address__name STRING Name of the invoice address
invoice_address__street STRING Street of invoice address
invoice_address__street2 STRING Additional street information
invoice_address__city STRING City of invoice address
invoice_address__county STRING County of invoice address
invoice_address__state STRING State of invoice address
invoice_address__zip STRING Zip code of invoice address
invoice_address__country STRING Country of invoice address
delivery_address__id STRING Unique identifier for the address
delivery_address__description STRING Description of delivery address
delivery_address__name STRING Name of the delivery address
delivery_address__street STRING Street of delivery address
delivery_address__street2 STRING Additional street information
delivery_address__city STRING City of delivery address
delivery_address__county STRING County of delivery address
delivery_address__state STRING State of delivery address
delivery_address__zip STRING Zip code of delivery address
delivery_address__country STRING Country of delivery address
invoice_batch_group__id STRING Unique identifier for the invoice batch group
invoice_batch_group__code STRING Code of the invoice batch group
invoice_batch_group__description STRING Description of the invoice batch group
payment_term STRING Payment term for the subscription
use_account_invoice_batch_group BOOL Flag indicating if account invoice batch group is used
account__name STRING Name of the account
account__account_number STRING Unique identifier for the account
account__id STRING Unique identifier for the account
account__external_erp_id STRING External ERP system ID associated with the account
account__external_crm_id STRING External CRM system ID associated with the account
invoice_account__name STRING Name of the invoice account
invoice_account__account_number STRING Account number linked to the invoice
invoice_account__id STRING Unique identifier for the invoice account
invoice_account__external_erp_id STRING External ERP system ID associated with the invoice account
invoice_account__external_crm_id STRING External CRM system ID associated with the invoice account
currency STRING Currency used for the subscription
external_erp_id STRING External ERP system ID associated with the subscription
external_crm_id STRING External CRM system ID associated with the subscription
currency_code_to_use_when_invoice STRING Currency code used for invoicing
cmrr__amount FLOAT64 Amount of Committed Monthly Recurring Revenue
cmrr__currency_code STRING Currency code
cmrr__currency_conversion_date STRING Date of currency conversion
cmrr__base_currency_amount FLOAT64 Amount in base currency
cmrr__base_currency_code STRING Base currency code
acv__amount FLOAT64 Amount of Annual Contract Value
acv__currency_code STRING Currency code
acv__currency_conversion_date STRING Date of currency conversion
acv__base_currency_amount FLOAT64 Amount in base currency
acv__base_currency_code STRING Base currency code
emrr__amount FLOAT64 Amount of Estimated Monthly Recurring Revenue
emrr__currency_code STRING Currency code
emrr__currency_conversion_date STRING Date of currency conversion
emrr__base_currency_amount FLOAT64 Amount in base currency
emrr__base_currency_code STRING Base currency code
one_time_fees__amount FLOAT64 Total amount of one-time fees
one_time_fees__currency_code STRING Currency code
one_time_fees__currency_conversion_date STRING Date of currency conversion
one_time_fees__base_currency_amount FLOAT64 Amount in base currency
one_time_fees__base_currency_code STRING Base currency code
tcv__amount FLOAT64 Total Contract Value amount
tcv__currency_code STRING Currency code
tcv__currency_conversion_date STRING Date of currency conversion
tcv__base_currency_amount FLOAT64 Amount in base currency
tcv__base_currency_code STRING Base currency code
_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 Unique identifier for the product
product_number STRING Number of the product
charge_plan_id STRING ID of the charge plan
charge_plan_name STRING Name of the charge plan
charge_plan_number STRING Number of the charge plan
product_line_number FLOAT64 Line number for the product
name STRING Name of the product
external_erp_id STRING External ERP system ID associated with the product
external_crm_id STRING External CRM system ID associated with the product
cmrr__amount FLOAT64 Amount of Committed Monthly Recurring Revenue
cmrr__currency_code STRING Currency code
cmrr__currency_conversion_date STRING Date of currency conversion
cmrr__base_currency_amount FLOAT64 Amount in base currency
cmrr__base_currency_code STRING Base currency code
acv__amount FLOAT64 Amount of Annual Contract Value
acv__currency_code STRING Currency code
acv__currency_conversion_date STRING Date of currency conversion
acv__base_currency_amount FLOAT64 Amount in base currency
acv__base_currency_code STRING Base currency code
emrr__amount FLOAT64 Amount of Estimated Monthly Recurring Revenue
emrr__currency_code STRING Currency code
emrr__currency_conversion_date STRING Date of currency conversion
emrr__base_currency_amount FLOAT64 Amount in base currency
emrr__base_currency_code STRING Base currency code
one_time_fees__amount FLOAT64 Total amount of one-time fees
one_time_fees__currency_code STRING Currency code
one_time_fees__currency_conversion_date STRING Date of currency conversion
one_time_fees__base_currency_amount FLOAT64 Amount in base currency
one_time_fees__base_currency_code STRING Base currency code
tcv__amount FLOAT64 Total Contract Value amount
tcv__currency_code STRING Currency code
tcv__currency_conversion_date STRING Date of currency conversion
tcv__base_currency_amount FLOAT64 Amount in base currency
tcv__base_currency_code STRING Base currency code
_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 Unique identifier for the charge
charge_number STRING Number of the charge
version FLOAT64 Version of the charge
is_last_version BOOL Flag indicating if the charge is the last version
name STRING Name of the charge
charge_type STRING Type of charge
price_model STRING Pricing model for the charge
effective_start_date STRING Effective start date of the charge
effective_end_date STRING Effective end date of the charge
quantity FLOAT64 Quantity of the charge
unit_code STRING Unit code for the charge
start_on STRING Start date for the charge
end_on STRING End date for the charge
charged_through_date STRING Date charges are accounted for
last_renewal_date STRING Date of the last renewal
last_price_adjustment_date STRING Date of the last price adjustment
price_period STRING Pricing period for the charge
usage_rating STRING Usage rating for the charge
revenue_recognition_rule STRING Rule for revenue recognition
billing_day STRING Billing day for the charge
specific_billing_day FLOAT64 Specific billing day for the charge
billing_period STRING Billing period for the charge
billing_timing STRING Billing timing for the charge
period_alignment STRING Period alignment for the charge
tax_template STRING Tax template applied to the charge
tax_included BOOL Flag indicating if tax is included in the charge
create_invoice_lines_per_tier BOOL Flag indicating if invoice lines are created per tier
estimated_usage FLOAT64 Estimated usage for the charge
estimated_quantity FLOAT64 Estimated quantity for the charge
remarks STRING Remarks or notes for the charge
accounts_receivable_account STRING Account for accounts receivable
deferred_revenue_account STRING Account for deferred revenue
recognized_revenue_account STRING Account for recognized revenue
change_state STRING Change state for the charge
display_price FLOAT64 Price displayed for the charge
recurring_monthly_amount FLOAT64 Recurring monthly amount for the charge
recurring_monthly_amount_base FLOAT64 Base recurring monthly amount for the charge
external_erp_id STRING External ERP system ID associated with the charge
external_crm_id STRING External CRM system ID associated with the charge
cmrr__amount FLOAT64 Amount of Committed Monthly Recurring Revenue
cmrr__currency_code STRING Currency code
cmrr__currency_conversion_date STRING Date of currency conversion
cmrr__base_currency_amount FLOAT64 Amount in base currency
cmrr__base_currency_code STRING Base currency code
acv__amount FLOAT64 Amount of Annual Contract Value
acv__currency_code STRING Currency code
acv__currency_conversion_date STRING Date of currency conversion
acv__base_currency_amount FLOAT64 Amount in base currency
acv__base_currency_code STRING Base currency code
tcv__amount FLOAT64 Total Contract Value amount
tcv__currency_code STRING Currency code
tcv__currency_conversion_date STRING Date of currency conversion
tcv__base_currency_amount FLOAT64 Amount in base currency
tcv__base_currency_code STRING Base currency code
emrr__amount FLOAT64 Amount of Estimated Monthly Recurring Revenue
emrr__currency_code STRING Currency code
emrr__currency_conversion_date STRING Date of currency conversion
emrr__base_currency_amount FLOAT64 Amount in base currency
emrr__base_currency_code STRING Base currency code
one_time_fees__amount FLOAT64 Total amount of one-time fees
one_time_fees__currency_code STRING Currency code
one_time_fees__currency_conversion_date STRING Date of currency conversion
one_time_fees__base_currency_amount FLOAT64 Amount in base currency
one_time_fees__base_currency_code STRING Base currency code
order_product_id STRING Product ID linked to the order
order_id STRING Order ID linked to the charge
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription__products__charges__price_details

Section titled “Subtable: subscription__products__charges__price_details”
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.
tier FLOAT64 Pricing tier of the charge
price FLOAT64 Price of the charge
list_price FLOAT64 List price of the charge
description STRING Description of the price
from_quantity FLOAT64 Quantity from which the price applies
to_quantity FLOAT64 Quantity up to which the price applies
price_base STRING Base price of the charge
line_discount_percent FLOAT64 Percentage of line discount
line_discount_amount FLOAT64 Amount of line discount
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription__products__charges__features

Section titled “Subtable: subscription__products__charges__features”
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.
code STRING Feature code
description STRING Description of the feature
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription__products__charges__order_discounts

Section titled “Subtable: subscription__products__charges__order_discounts”
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.
order_discount_id STRING Discount ID linked to the order
charge_id STRING Charge ID linked to the order
_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 Unique identifier for the milestone
order_id STRING Order ID linked to the milestone
name STRING Name of the milestone
description STRING Description of the milestone
milestone_date STRING Date of the milestone
planned_date STRING Planned date for the milestone
_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 Unique identifier for the discount
order_id STRING Order ID linked to the discount
start_on STRING Start date for the discount
end_on STRING End date for the discount
start_date STRING Start date of the discount
end_date STRING End date of the discount
percent FLOAT64 Percentage of the discount
discount_type STRING Type of discount applied to the order
on_specific_charges BOOL Flag indicating if the discount is applied to specific charges
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription__order_discounts__order_product_charges

Section titled “Subtable: subscription__order_discounts__order_product_charges”
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.
order_discount_id STRING Discount ID linked to the order
charge_id STRING Charge ID linked to the order
_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 Younium 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 Younium?

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

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

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

Use subscription and invoice to track recurring revenue and churn over time.

Join invoice with account to reconcile billing and outstanding balances.

Use product to see which products drive revenue.

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