Recurly Predefined Reports
  • 5 Minutes to read
  • Dark
    Light
  • PDF

Recurly Predefined Reports

  • Dark
    Light
  • PDF

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?