Data exports

Recurly offers a variety of ways to export your data. This page will give you a high-level overview of how to retrieve exports, what each export does, and some tips on how to use them. If you're interested in learning about each export in detail, please see below.

Overview

Prerequisites

  • Users must have Analytics user role permission.

Exports overview

  • All of the exports listed in the below table are available through the admin console and the Recurly API.

  • Exports will use the site timezone (under Site Settings) rather than the users timezone when determining what data will be exported. Additionally, the days that are requested will be exported in their entirety rather than potentially having missing data for current day.

  • See New Versions for information about how changes to individual exports will create new versions of that export.

  • See Automated Exports for more information about access via the Recurly API.

  • See our Recurly Exports ERD:

Zoomable Image

  • Download Button Download the image

  • Download Button Download our complete export schema

Export NameExport Description
AccountsAccount-level information.
Account NotesAccount notes that have been created on accounts.
Accounts ReceivableAll unpaid invoices and associated aging of receivables.
AdjustmentsEach charge and credit adjustment, including tax information broken down by jurisdiction (country, state/province, county, city, special).
Adjustments - CouponsEach charge and credit adjustment broken out by discount per coupon redemption.

This export will only show on the Exports page if you have Multiple Coupons Per Account enabled under Coupon Settings.
Adjustments - TaxesThe Adjustments - Taxes export is for reporting on taxes calculated through Vertex and Avalara for Communications (AFC).
Billing InfoBilling information associated with accounts.
CouponsAll coupons that are set-up on the site.
Coupons - Bulk Unique CodesAll unique codes for a bulk coupon.
Coupon RedemptionsAll redemptions of coupons.
Credit PaymentsAll credit payments, encompassing the use of outstanding credit balances to pay invoices.
Invoices — Accounts ReceivableAll customers who have yet to settle their invoices and gives a detailed report on the aging of all unsettled receivables.
Invoices — ExternalAll external invoices that are generated for accounts with subscriptions created on third-party platforms such as the Apple App Store or Google Play Store.
Invoices — SummaryInvoice header information and summary totals.
Gift CardsAll purchased gift cards.
Invoices - Unused NumbersAll invoice numbers not used for generated invoices.
Items — Associated PlansAll plan add-ons created from a saved item in your Item Catalog.
Items — Associated SubscriptionsAll subscription add-ons created from a saved item in your Item Catalog.-
Revenue Recognition SchedulesA Revenue waterfall for your charges on a monthly basis.

This export will only show on the Exports page if the site has the Revenue Recognition feature enabled.
SubscriptionsYour customers' subscriptions to your plans.
Subscriptions Add-OnsAll the detailed information about all the subscription add-ons created within a specific timeframe.
Subscriptions Add-Ons — HistoryAll the changes made to a subscription add-on over time.
Subscriptions — ChurnedSubscriptions that have expired and are no longer active.
Subscriptions — ExternalAll the detailed information on external subscriptions stored on third-party platforms like the Apple App Store or Google Play Store.
Subscriptions — HistoryThe history of each subscription including all versions created following any change to a subscription.
Subscription — Usage RecordsUsage records logged for your customer's usage-based subscription add-ons.
Subscriptions — Ramp PricingAll data on each subscription operating under a ramp priced billing model.
TransactionsData sent to the payment gateway when processing a transaction.

Deprecated Exports

Export NameExport Description
Invoices (Deprecated)Note: this export is no longer actively maintained. It has now been replaced by two exports: Invoices - Summary and Adjustments

Once your site has the Credit Invoices feature enabled, this export will no longer be available.

Exporting data via the admin console

Exports can be generated through the admin console. When you generate an export, you can also select a date range for the information you want to receive. Once you request the export, the request will begin processing. You can view the status of your request on the export page. Once your request is completed you'll see a "Download" link that you can then click to get the export.

All exports default to using ZIP compression.

Examples: All accounts created in May

  1. Navigate to Analytics-> Exports.
  2. Change the date range to be May 1 - May 31st.
  3. Select Accounts and leave All chosen.
  4. Click Request Export

Example: All subscriptions that have expired

  1. Navigate to Analytics -> Exports.
  2. Leave the date range as All Time.
  3. Select Subscriptions - Churned.
  4. Click Request Export

Example: All coupons redeemed in July

  1. Navigate to Analytics -> Exports.
  2. Change the date range to be July 1 - July 31st
  3. Select Coupon Redemptions.
  4. Click Request Export.

Helpful tips: combining exports

Sometimes, the information you need will be split across more than one export. Excel will allow you to perform a join, and combine the exports. For instructions on combining exports, please see this video.