Recurly predefined reports

The Recurly data source in Data Integration includes predefined reports. Each report contains a list of customizable fields (if any) and the schema mapping.

These reports follow a standardized format, so specific fields are locked, and you can only access them through the Custom reports feature.

Subscriptions

Field	Data Type	Dimension/Metric
account	Record	Dimension
activated_at	String	Dimension
active_invoice_id	String	Dimension
add_ons	String	Dimension
add_ons_total	Float	Metric
auto_renew	Boolean	Dimension
bank_account_authorized_at	String	Dimension
billing_info_id	String	Dimension
canceled_at	String	Dimension
collection_method	String	Dimension
coupon_redemptions	String	Dimension
created_at	String	Dimension
currency	String	Dimension
current_period_ends_at	String	Dimension
current_period_started_at	String	Dimension
current_term_ends_at	String	Dimension
current_term_started_at	String	Dimension
custom_fields	String	Dimension
customer_notes	String	Dimension
expiration_reason	String	Dimension
expires_at	String	Dimension
gateway_code	String	Dimension
id	String	Dimension
net_terms	Integer	Metric
object	String	Dimension
paused_at	String	Dimension
pending_change	Record	Dimension
plan	Record	Dimension
po_number	String	Dimension
quantity	Integer	Metric
remaining_billing_cycles	Integer	Metric
remaining_pause_cycles	Integer	Metric
renewal_billing_cycles	Integer	Metric
revenue_schedule_type	String	Dimension
shipping	Record	Dimension
state	String	Dimension
subtotal	Float	Metric
tax	Float	Metric
tax_inclusive	String	Dimension
tax_info	Record	Dimension
terms_and_conditions	String	Dimension
total	Float	Metric
total_billing_cycles	Integer	Metric
trial_ends_at	String	Dimension
trial_started_at	String	Dimension
unit_amount	Float	Metric
updated_at	String	Dimension
uuid	String	Dimension

Coupons

Field	Data Type	Dimension/Metric
applies_to_all_items	Boolean	Dimension
applies_to_all_plans	Boolean	Dimension
applies_to_non_plan_charges	Boolean	Dimension
code	String	Dimension
coupon_type	String	Dimension
created_at	String	Dimension
discount	Record	Dimension
duration	String	Dimension
expired_at	String	Dimension
free_trial_amount	Integer	Metric
free_trial_unit	String	Dimension
hosted_page_description	String	Dimension
id	String	Dimension
invoice_description	String	Dimension
items	Record	Dimension
max_redemptions	Integer	Metric
max_redemptions_per_account	Integer	Metric
name	String	Dimension
object	String	Dimension
plans	Record	Dimension
redeem_by	String	Dimension
redemption_resource	String	Dimension
state	String	Dimension
temporal_amount	Integer	Metric
temporal_unit	String	Dimension
unique_code_template	String	Dimension
unique_coupon_code	Record	Dimension
unique_coupon_codes_count	Integer	Metric
updated_at	String	Dimension

Credit payments

Field	Data Type	Dimension/Metric
account	Record	Dimension
action	String	Dimension
amount	Float	Metric
applied_to_invoice	Record	Dimension
created_at	String	Dimension
currency	String	Dimension
id	String	Dimension
object	String	Dimension
original_credit_payment_id	String	Dimension
original_invoice	Record	Dimension
refund_transaction	Record	Dimension
updated_at	String	Dimension
uuid	String	Dimension
voided_at	String	Dimension

Items

Field	Data Type	Dimension/Metric
accounting_code	String	Dimension
avalara_service_type	Integer	Metric
avalara_transaction_type	Integer	Metric
code	String	Dimension
created_at	String	Dimension
currencies	Record	Dimension
custom_fields	Record	Dimension
deleted_at	String	Dimension
description	String	Dimension
external_sku	String	Dimension
id	String	Dimension
name	String	Dimension
object	String	Dimension
revenue_schedule_type	String	Dimension
state	String	Dimension
tax_code	String	Dimension
tax_exempt	Boolean	Dimension
updated_at	String	Dimension

Line items

Field	Data Type	Dimension/Metric
account	Record	Dimension
accounting_code	String	Dimension
add_on_code	String	Dimension
add_on_id	String	Dimension
amount	Float	Metric
avalara_service_type	Integer	Metric
avalara_transaction_type	Integer	Metric
bill_for_account_id	String	Dimension
created_at	String	Dimension
credit_applied	Float	Metric
credit_reason_code	String	Dimension
currency	String	Dimension
description	String	Dimension
discount	Float	Metric
end_date	String	Dimension
external_sku	String	Dimension
id	String	Dimension
invoice_id	String	Dimension
invoice_number	String	Dimension
item_code	String	Dimension
item_id	String	Dimension
legacy_category	String	Dimension
object	String	Dimension
origin	String	Dimension
original_line_item_invoice_id	String	Dimension
plan_code	String	Dimension
plan_id	String	Dimension
previous_line_item_id	String	Dimension
product_code	String	Dimension
proration_rate	Float	Metric
quantity	Integer	Metric
refund	Boolean	Dimension
refunded_quantity	Integer	Metric
revenue_schedule_type	String	Dimension
shipping_address	Record	Dimension
start_date	String	Dimension
state	String	Dimension
subscription_id	String	Dimension
subtotal	Float	Metric
tax	Float	Metric
tax_code	String	Dimension
tax_exempt	Boolean	Dimension
tax_info	Record	Dimension
taxable	Boolean	Dimension
type	String	Dimension
unit_amount	Float	Metric
unit_amount_decimal	String	Dimension
updated_at	String	Dimension
uuid	String	Dimension

Plans

Field	Data Type	Dimension/Metric
accounting_code	String	Dimension
allow_any_item_on_subscriptions	Boolean	Dimension
auto_renew	Boolean	Dimension
code	String	Dimension
created_at	String	Dimension
currencies	Record	Dimension
deleted_at	String	Dimension
description	String	Dimension
dunning_campaign_id	String	Dimension
hosted_pages	Record	Dimension
id	String	Dimension
interval_length	Integer	Metric
interval_unit	String	Dimension
name	String	Dimension
object	String	Dimension
revenue_schedule_type	String	Dimension
setup_fee_accounting_code	String	Dimension
setup_fee_revenue_schedule_type	String	Dimension
state	String	Dimension
tax_code	String	Dimension
tax_exempt	Boolean	Dimension
total_billing_cycles	Integer	Metric
trial_length	Integer	Metric
trial_requires_billing_info	Boolean	Dimension
trial_unit	String	Dimension
updated_at	String	Dimension

Sites

Field	Data Type	Dimension/Metric
address	Record	Dimension
created_at	String	Dimension
deleted_at	String	Dimension
features	String	Dimension
id	String	Dimension
mode	String	Dimension
object	String	Dimension
public_api_key	String	Dimension
settings	Record	Dimension
subdomain	String	Dimension
updated_at	String	Dimension

Transactions

Field	Data Type	Dimension/Metric
account	Record	Dimension
amount	Float	Metric
avs_check	String	Dimension
backup_payment_method_used	Boolean	Dimension
billing_address	Record	Dimension
collected_at	String	Dimension
collection_method	String	Dimension
created_at	String	Dimension
currency	String	Dimension
customer_message	String	Dimension
customer_message_locale	String	Dimension
cvv_check	String	Dimension
gateway_approval_code	String	Dimension
gateway_message	String	Dimension
gateway_reference	String	Dimension
gateway_response_code	String	Dimension
gateway_response_time	Float	Metric
gateway_response_values	Record	Dimension
id	String	Dimension
invoice	Record	Dimension
ip_address_country	String	Dimension
ip_address_v4	String	Dimension
object	String	Dimension
origin	String	Dimension
original_transaction_id	String	Dimension
payment_gateway	Record	Dimension
payment_method	Record	Dimension
refunded	Boolean	Dimension
status	String	Dimension
status_code	String	Dimension
status_message	String	Dimension
subscription_ids	String	Dimension
success	Boolean	Dimension
type	String	Dimension
updated_at	String	Dimension
uuid	String	Dimension
voided_at	String	Dimension
voided_by_invoice	Record	Dimension

Accounts

Field	Data Type	Dimension/Metric
address	Record	Dimension
bill_to	String	Dimension
billing_info	Record	Dimension
cc_emails	String	Dimension
code	String	Dimension
company	String	Dimension
created_at	String	Dimension
custom_fields	Record	Dimension
deleted_at	String	Dimension
dunning_campaign_id	String	Dimension
email	String	Dimension
exemption_certificate	String	Dimension
first_name	String	Dimension
has_active_subscription	Boolean	Dimension
has_canceled_subscription	Boolean	Dimension
has_future_subscription	Boolean	Dimension
has_live_subscription	Boolean	Dimension
has_past_due_invoice	Boolean	Dimension
has_paused_subscription	Boolean	Dimension
hosted_login_token	String	Dimension
id	String	Dimension
invoice_template_id	String	Dimension
last_name	String	Dimension
object	String	Dimension
parent_account_id	String	Dimension
preferred_locale	String	Dimension
shipping_addresses	Record	Dimension
state	String	Dimension
tax_exempt	Boolean	Dimension
updated_at	String	Dimension
username	String	Dimension
vat_number	String	Dimension

Billing information

Field	Data Type	Dimension/Metric
account_id	String	Dimension
address	Record	Dimension
backup_payment_method	Boolean	Dimension
company	String	Dimension
created_at	String	Dimension
first_name	String	Dimension
fraud	Record	Dimension
id	String	Dimension
last_name	String	Dimension
object	String	Dimension
payment_method	Record	Dimension
primary_payment_method	Boolean	Dimension
updated_at	String	Dimension
updated_by	Record	Dimension
valid	Boolean	Dimension
vat_number	String	Dimension

Invoices

Field	Data Type	Dimension/Metric
account	Record	Dimension
address	Record	Dimension
balance	Float	Metric
billing_info_id	String	Dimension
closed_at	String	Dimension
collection_method	String	Dimension
created_at	String	Dimension
credit_payments	Record	Dimension
currency	String	Dimension
customer_notes	String	Dimension
discount	Float	Metric
due_at	String	Dimension
dunning_campaign_id	String	Dimension
has_more_line_items	Boolean	Dimension
id	String	Dimension
line_items	Record	Dimension
net_terms	Integer	Metric
number	String	Dimension
object	String	Dimension
origin	String	Dimension
paid	Float	Metric
po_number	String	Dimension
previous_invoice_id	String	Dimension
refundable_amount	Float	Metric
shipping_address	Record	Dimension
state	String	Dimension
subscription_ids	String	Dimension
subtotal	Float	Metric
tax	Float	Metric
tax_info	Record	Dimension
terms_and_conditions	String	Dimension
total	Float	Metric
transactions	Record	Dimension
type	String	Dimension
updated_at	String	Dimension
uuid	String	Dimension
vat_number	String	Dimension
vat_reverse_charge_notes	String	Dimension