This article describes the specifications of each Recurly dataset. To learn more about setting up a Recurly integration with Slemma, go here.
Each dataset contains the list of dimensions and measures, which are used to create charts. For some datasets, we’ve added chart templates.
Measures are numbers, or quantitative values. For example, number of tasks, profit, price, or number of days.
Dimensions are categories by which you group your measures, for example country, product category or company name.
Templates – instead of starting from scratch when building a chart, you can use a pre-built visualization. Simply click one of the templates from the list and it will be added to the dashboard filled with your data. You can then edit and customize this template like a usual chart created by you.
Here is the list of the datasets available for Recurly integration. Click the name of the dataset to get to its description:
Payments
This data source contains information about all of your transactions such as transaction amount by customer email and billing country.
- Status – The status of the transaction. Possible values: success, declined, void
- Account – The unique identifier of the account
- Account created – Date the account was initially created
- Invoice number – The number of invoice
- Invoice created – Date the invoice was initially created
- Country – The 2-letter billing country code
- City – The name of the billing city
- Currency – 3-letter currency for the transaction
- Date – Date the transaction was initially created
- Type – The action of the transaction. Possible values: purchase, verify or refund
- Payment method – The payment method. Possible values: credit_card, paypal, check, wire_transfer, money_order
- Is recurring – “True” if transaction is recurring
- Email – The email address of the account
- Is subscription – If source is subscription
- Plan – The name of the plan to which the customer should be subscribed
- Amount – Amount of the transaction
- Payments Count – Payments Count
- Amount Refunded over the last 30 days – View refunds issued in the given time period and how it is trending.
- Cumulative Gross Revenue over the last 30 days – Make sure that the financial health of your business is in great shape with this report on cumulative gross revenue for the time period of your choice.
- Failed Payments over the last 30 days – View the transactions that failed over the last 30 days.
- MoM Gross Revenue Growth Rate (last 6 months) – Shows the change in the value as a percentage of the previous month’s value over the last 6 months.
- Number of Payments by day of the week (last 30 days) – Shows the number of payments by day of the week over the last 30 days.
- Number of Payments by Locations – Track the number of payments your customers from different countries made over the last 30 days or during the period of your choice.
- Revenue by Country (last 30 days) – Find the sales driving locations for the selected time frame.
- Revenue by Plan (last 30 days) – Compare the revenue by plan over the last 30 days.
- Successful vs. Failed Payments over the last 30 days – Compare your amount of the success payments with amount of the failed payments over the last 30 days.
- Top 10 Countries by Revenue (last 30 days) – View your top ten countries by revenue over the last 30 days.
- Top 10 Customers by Revenue (last 30 days) – View your top ten contacts by number of subscription for the time period of your choice.
Subscription
This data source contains information about all the subscriptions generated on your customers. For each customer that has a subscription, you will find a row in this data source.
- State – The state of the subscription
- Plan – The name and code of plan
- Activated – Date when a subscription was activated
- Canceled – Date when a subscription was canceled
- Trial start – If the subscription has a trial, the beginning of that trial
- Trial end – If the subscription has a trial, the end of that trial
- Interval – One of day or month
- Subscription currency – Currency for the subscription
- Customer – The email address of the account
- Quantity – Optionally override the default quantity of 1
- Discount amount – The discount on the adjustment. Subscription->Invoice->Adjustment
- Subscriptions Count
- Discount Amount by Customer – Shows the discount amount by customer for the time period of your choice.
- Plans Breakout – Compare the number of subscriptions by plan for the time period of your choice.
- Subscriptions Created over the last 30 days – Track the new subscriptions over the last 30 days.
- Top 10 Customers by Number of Subscriptions – View your top ten contacts by number of subscription for the time period of your choice.