Zuora: Account Overview

Description

• Each record represents an account enriched with metrics about their associated transactions.

Supported Data Sources

• Zuora

Columns

Type	Name	Description
STRING	account_id	Primary key for the account.
DATETIME	account_created_at	Creation date for the account.
STRING	account_name	Account name as displayed in Zuora.
STRING	account_number	Unique account number assigned to the account.
DECIMAL	account_credit_balance	Total credit balance for the account.
DECIMAL	account_zuora_calculated_mrr	The amount of tabulated MRR as calculated by Zuora internally.
STRING	account_status	Status of the account in the system.
BOOLEAN	is_auto_pay	Indicates if future payments are automatically collected when they're due during a Payment Run.
STRING	account_country	The country of the contact's address associated with the account.
STRING	account_city	The city of the contact's address associated with the account.
STRING	account_email	The business email address of the contact associated with the account.
STRING	account_first_name	The first name of the contact associated with the account.
STRING	account_last_name	The last name of the contact associated with the account.
STRING	account_postal_code	The postal code of the contact's address associated with the account.
STRING	account_state	The state of the contact's address associated with the account.
INTEGER	account_active_months	The number of months the account has been active, rounded to days.
DATETIME	first_charge_processed_at	Time at which the first charge on the account is processed.
BOOLEAN	is_currently_subscribed	Does the account have a current active subscription associated with it?
BOOLEAN	is_new_customer	Was this account created in the past 30 days?
INTEGER	invoice_item_count	All invoice items ever associated with this account.
INTEGER	invoice_count	All invoices ever associated with this account.s
INTEGER	active_subscription_count	Subscriptions currently active in this account.
INTEGER	total_subscription_count	All subscriptions ever created with this account.
INTEGER	total_invoice_amount	Total amount of all invoices associated with this account.
INTEGER	total_invoice_amount_home_currency	Total amount of all invoices in the home currency associated with this account.
INTEGER	total_taxes	Total taxes associated with this account.
INTEGER	total_discounts	Total discounts associated with this account.
INTEGER	total_amount_paid	Total amount of invoices paid associated with this account.
INTEGER	total_amount_not_paid	Total amount of invoices unpaid associated with this account.
INTEGER	total_amount_past_due	Total amount of past due invoices associated with this account.
INTEGER	total_refunds	Total amount of refunds associated with this account.
INTEGER	total_average_invoice_value	Total average value of the invoice associated with this account.
INTEGER	total_units_per_invoice	Total units per invoice associated with this account.
INTEGER	monthly_average_subscription_count	Average number of subscriptions per month for this account.
INTEGER	monthly_average_invoice_amount	Average invoice amount per month for this account.
INTEGER	monthly_average_invoice_amount_home_currency	Average invoice amount in the home currency per month for this account.
INTEGER	monthly_average_taxes	Average taxes per month for this account.
INTEGER	monthly_average_discounts	Average discounts per month for this account.
INTEGER	monthly_average_amount_paid	Average paid amount per month for this account.
INTEGER	monthly_average_amount_not_paid	Average unpaid amount per month for this account.
INTEGER	monthly_average_amount_past_due	Average past due amount per month for this account.
INTEGER	monthly_average_refunds	Average refunds per month for this account.