Recurly Predefined Reports

5 Minutes to read

Print
Share
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Predefined Reports

The Recurly datasource in Rivery comes with the below predefined reports. Each report will have a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

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

Was this article helpful?

What's Next

Recurly Walkthrough

Table of contents

Predefined Reports
Subscriptions
Coupons
Credit Payments
Items
Line Items
Plans
Sites
Transactions
Accounts
Billing Information
Invoices