Recurly: Account Overview

Description

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

Supported Data Sources

• Recurly

Columns

Type	Name	Description
STRING	account_id	Primary key for the account.
DATETIME	account_created_at	Timestamp of when the account entry was created.
STRING	account_city	City in the world the account is associated with.
STRING	account_code	The unique identifier of the account. This cannot be changed once the account is created. Provided during account creation.
STRING	account_company	The company related with the account.
STRING	account_country	Country in the world the account is associated with.
STRING	account_email	Email address associated with the account.
STRING	account_first_name	First name associated with the account.
BOOLEAN	account_is_tax_exempt	The tax status of the account. true exempts tax on the account, false applies tax on the account.
STRING	account_last_name	Last name associated with the account.
STRING	account_postal_code	Postal code in the world the account is associated with.
STRING	account_region	Region in the world the account is associated with (usually would be state if it was a U.S. account.)
STRING	account_state	Current state of the account.
STRING	account_username	A secondary value for the account.
INTEGER	total_transactions	Total amount of unique transactions issued to this account.
INTEGER	total_invoices	Total amount of unique invoices issued to this account.
DECIMAL	total_charges	Total amount of charges issued to this account.
DECIMAL	total_credits	Total amount of credits issued to this account.
DECIMAL	total_balance	Gross amount of all transactions made with this account.
DECIMAL	total_discounts	Total amount of discounts issued to this account.
DECIMAL	total_taxes	Total amount of taxes issued to this account.
INTEGER	total_charge_count	Total number of charges issued to this account.
INTEGER	total_credit_count	Total number of credits issued to this account.
INTEGER	transactions_this_month	All transactions on this account from this current calendar month.
INTEGER	invoices_this_month	All invoices on this account from this current calendar month.
DECIMAL	charges_this_month	All charges on this account from this current calendar month.
DECIMAL	credits_this_month	All credits on this account from this current calendar month.
DECIMAL	balance_this_month	Gross amount of all transactions made on this account from this current calendar month.
DECIMAL	discounts_this_month	Discounts issued on the account from this current calendar month.
DECIMAL	taxes_this_month	Taxes issued on the account from this current calendar month.
DATETIME	first_charge_date	Date the first charge on the account was issued.
DATETIME	most_recent_charge_date	Date the most recent charge on the account was issued.
DATETIME	first_invoice_date	Date the first invoice on the account was issued.
DATETIME	most_recent_invoice_date	Date the most recent invoice on the account was issued.
DATETIME	next_invoice_due_at	Date the most recent invoice on the account is due at.
DATETIME	first_transaction_date	Date first transaction occurred on the account.
DATETIME	most_recent_transaction_date	Date most recent transaction occurred on the account.