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

Recurly Predefined Reports

  • Dark
    Light
  • PDF

Article summary

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

FieldData TypeDimension/Metric
accountRecordDimension
activated_atStringDimension
active_invoice_idStringDimension
add_onsStringDimension
add_ons_totalFloatMetric
auto_renewBooleanDimension
bank_account_authorized_atStringDimension
billing_info_idStringDimension
canceled_atStringDimension
collection_methodStringDimension
coupon_redemptionsStringDimension
created_atStringDimension
currencyStringDimension
current_period_ends_atStringDimension
current_period_started_atStringDimension
current_term_ends_atStringDimension
current_term_started_atStringDimension
custom_fieldsStringDimension
customer_notesStringDimension
expiration_reasonStringDimension
expires_atStringDimension
gateway_codeStringDimension
idStringDimension
net_termsIntegerMetric
objectStringDimension
paused_atStringDimension
pending_changeRecordDimension
planRecordDimension
po_numberStringDimension
quantityIntegerMetric
remaining_billing_cyclesIntegerMetric
remaining_pause_cyclesIntegerMetric
renewal_billing_cyclesIntegerMetric
revenue_schedule_typeStringDimension
shippingRecordDimension
stateStringDimension
subtotalFloatMetric
taxFloatMetric
tax_inclusiveStringDimension
tax_infoRecordDimension
terms_and_conditionsStringDimension
totalFloatMetric
total_billing_cyclesIntegerMetric
trial_ends_atStringDimension
trial_started_atStringDimension
unit_amountFloatMetric
updated_atStringDimension
uuidStringDimension

Coupons

FieldData TypeDimension/Metric
applies_to_all_itemsBooleanDimension
applies_to_all_plansBooleanDimension
applies_to_non_plan_chargesBooleanDimension
codeStringDimension
coupon_typeStringDimension
created_atStringDimension
discountRecordDimension
durationStringDimension
expired_atStringDimension
free_trial_amountIntegerMetric
free_trial_unitStringDimension
hosted_page_descriptionStringDimension
idStringDimension
invoice_descriptionStringDimension
itemsRecordDimension
max_redemptionsIntegerMetric
max_redemptions_per_accountIntegerMetric
nameStringDimension
objectStringDimension
plansRecordDimension
redeem_byStringDimension
redemption_resourceStringDimension
stateStringDimension
temporal_amountIntegerMetric
temporal_unitStringDimension
unique_code_templateStringDimension
unique_coupon_codeRecordDimension
unique_coupon_codes_countIntegerMetric
updated_atStringDimension

Credit Payments

FieldData TypeDimension/Metric
accountRecordDimension
actionStringDimension
amountFloatMetric
applied_to_invoiceRecordDimension
created_atStringDimension
currencyStringDimension
idStringDimension
objectStringDimension
original_credit_payment_idStringDimension
original_invoiceRecordDimension
refund_transactionRecordDimension
updated_atStringDimension
uuidStringDimension
voided_atStringDimension

Items

FieldData TypeDimension/Metric
accounting_codeStringDimension
avalara_service_typeIntegerMetric
avalara_transaction_typeIntegerMetric
codeStringDimension
created_atStringDimension
currenciesRecordDimension
custom_fieldsRecordDimension
deleted_atStringDimension
descriptionStringDimension
external_skuStringDimension
idStringDimension
nameStringDimension
objectStringDimension
revenue_schedule_typeStringDimension
stateStringDimension
tax_codeStringDimension
tax_exemptBooleanDimension
updated_atStringDimension

Line Items

FieldData TypeDimension/Metric
accountRecordDimension
accounting_codeStringDimension
add_on_codeStringDimension
add_on_idStringDimension
amountFloatMetric
avalara_service_typeIntegerMetric
avalara_transaction_typeIntegerMetric
bill_for_account_idStringDimension
created_atStringDimension
credit_appliedFloatMetric
credit_reason_codeStringDimension
currencyStringDimension
descriptionStringDimension
discountFloatMetric
end_dateStringDimension
external_skuStringDimension
idStringDimension
invoice_idStringDimension
invoice_numberStringDimension
item_codeStringDimension
item_idStringDimension
legacy_categoryStringDimension
objectStringDimension
originStringDimension
original_line_item_invoice_idStringDimension
plan_codeStringDimension
plan_idStringDimension
previous_line_item_idStringDimension
product_codeStringDimension
proration_rateFloatMetric
quantityIntegerMetric
refundBooleanDimension
refunded_quantityIntegerMetric
revenue_schedule_typeStringDimension
shipping_addressRecordDimension
start_dateStringDimension
stateStringDimension
subscription_idStringDimension
subtotalFloatMetric
taxFloatMetric
tax_codeStringDimension
tax_exemptBooleanDimension
tax_infoRecordDimension
taxableBooleanDimension
typeStringDimension
unit_amountFloatMetric
unit_amount_decimalStringDimension
updated_atStringDimension
uuidStringDimension

Plans

FieldData TypeDimension/Metric
accounting_codeStringDimension
allow_any_item_on_subscriptionsBooleanDimension
auto_renewBooleanDimension
codeStringDimension
created_atStringDimension
currenciesRecordDimension
deleted_atStringDimension
descriptionStringDimension
dunning_campaign_idStringDimension
hosted_pagesRecordDimension
idStringDimension
interval_lengthIntegerMetric
interval_unitStringDimension
nameStringDimension
objectStringDimension
revenue_schedule_typeStringDimension
setup_fee_accounting_codeStringDimension
setup_fee_revenue_schedule_typeStringDimension
stateStringDimension
tax_codeStringDimension
tax_exemptBooleanDimension
total_billing_cyclesIntegerMetric
trial_lengthIntegerMetric
trial_requires_billing_infoBooleanDimension
trial_unitStringDimension
updated_atStringDimension

Sites

FieldData TypeDimension/Metric
addressRecordDimension
created_atStringDimension
deleted_atStringDimension
featuresStringDimension
idStringDimension
modeStringDimension
objectStringDimension
public_api_keyStringDimension
settingsRecordDimension
subdomainStringDimension
updated_atStringDimension

Transactions

FieldData TypeDimension/Metric
accountRecordDimension
amountFloatMetric
avs_checkStringDimension
backup_payment_method_usedBooleanDimension
billing_addressRecordDimension
collected_atStringDimension
collection_methodStringDimension
created_atStringDimension
currencyStringDimension
customer_messageStringDimension
customer_message_localeStringDimension
cvv_checkStringDimension
gateway_approval_codeStringDimension
gateway_messageStringDimension
gateway_referenceStringDimension
gateway_response_codeStringDimension
gateway_response_timeFloatMetric
gateway_response_valuesRecordDimension
idStringDimension
invoiceRecordDimension
ip_address_countryStringDimension
ip_address_v4StringDimension
objectStringDimension
originStringDimension
original_transaction_idStringDimension
payment_gatewayRecordDimension
payment_methodRecordDimension
refundedBooleanDimension
statusStringDimension
status_codeStringDimension
status_messageStringDimension
subscription_idsStringDimension
successBooleanDimension
typeStringDimension
updated_atStringDimension
uuidStringDimension
voided_atStringDimension
voided_by_invoiceRecordDimension

Accounts

FieldData TypeDimension/Metric
addressRecordDimension
bill_toStringDimension
billing_infoRecordDimension
cc_emailsStringDimension
codeStringDimension
companyStringDimension
created_atStringDimension
custom_fieldsRecordDimension
deleted_atStringDimension
dunning_campaign_idStringDimension
emailStringDimension
exemption_certificateStringDimension
first_nameStringDimension
has_active_subscriptionBooleanDimension
has_canceled_subscriptionBooleanDimension
has_future_subscriptionBooleanDimension
has_live_subscriptionBooleanDimension
has_past_due_invoiceBooleanDimension
has_paused_subscriptionBooleanDimension
hosted_login_tokenStringDimension
idStringDimension
invoice_template_idStringDimension
last_nameStringDimension
objectStringDimension
parent_account_idStringDimension
preferred_localeStringDimension
shipping_addressesRecordDimension
stateStringDimension
tax_exemptBooleanDimension
updated_atStringDimension
usernameStringDimension
vat_numberStringDimension

Billing Information

FieldData TypeDimension/Metric
account_idStringDimension
addressRecordDimension
backup_payment_methodBooleanDimension
companyStringDimension
created_atStringDimension
first_nameStringDimension
fraudRecordDimension
idStringDimension
last_nameStringDimension
objectStringDimension
payment_methodRecordDimension
primary_payment_methodBooleanDimension
updated_atStringDimension
updated_byRecordDimension
validBooleanDimension
vat_numberStringDimension

Invoices

FieldData TypeDimension/Metric
accountRecordDimension
addressRecordDimension
balanceFloatMetric
billing_info_idStringDimension
closed_atStringDimension
collection_methodStringDimension
created_atStringDimension
credit_paymentsRecordDimension
currencyStringDimension
customer_notesStringDimension
discountFloatMetric
due_atStringDimension
dunning_campaign_idStringDimension
has_more_line_itemsBooleanDimension
idStringDimension
line_itemsRecordDimension
net_termsIntegerMetric
numberStringDimension
objectStringDimension
originStringDimension
paidFloatMetric
po_numberStringDimension
previous_invoice_idStringDimension
refundable_amountFloatMetric
shipping_addressRecordDimension
stateStringDimension
subscription_idsStringDimension
subtotalFloatMetric
taxFloatMetric
tax_infoRecordDimension
terms_and_conditionsStringDimension
totalFloatMetric
transactionsRecordDimension
typeStringDimension
updated_atStringDimension
uuidStringDimension
vat_numberStringDimension
vat_reverse_charge_notesStringDimension

Was this article helpful?