Table of Contents
Reporting
NOTE: The reporting functionality described on this page is for new reporting functionality, not for the reporting currently available in the Foxy admin.
All timestamps in generated reports are for the store's configured timezone.
All
Reports Generated
Note that some of these reports may not be available when this functionality comes out of beta.
- Transactions
- Voided Transactions (deprecated; to be combined with Transactions)
- Payment Method Summary by Month
- Daily / Weekly / Monthly Summary
- Items (ie. Transaction Items aka Products)
- Summary by SKU by Month (where “SKU” is the
code
value on an item) - Subscription Forecast by SKU by Month (assuming no cancellations except for what already has an enddate, and no new subscriptions)
- Coupons Used
Explanation of Columns
Generally, the exported data matches what is available via the Foxy API. There are some columns that are new, however:
product_subtotal_one_off
: The subtotal (pre-discounts and coupons) of non-recurring products.product_subtotal_new_subscriptions
: The subtotal of subscription products starting in the time period.product_subtotal_renewing_subscriptions
: The subtotal of subscription products renewing in the time period.product_subtotal_future_subscriptions
: The subtotal of subscription products with a start date in the future.product_subtotal_new_mrr
: The new monthly recurring revenue. We do some math here to convert the frequency (if it's not1m
) to a monthly value. For instance, a1y
value will be divided by 12, while a30d
or4w
subscription will result in a monthly value using an average of 30.45 days per month.product_subtotal_cancelled_mrr
: The subtotal amount of subscriptions that were cancelled in the time period. Note that if you deactivate subscriptions via the admin or API (without setting an enddate), those won't be counted here.one_off_count
: The number of transactions that have non-recurring products. NOTE: A transaction can include a one-off item and a new subscription, so if you add up all the_count
values, you may get a number higher than the number of transactions you actually had.subscriptions_new_count
: The number of transactions with new subscriptions.subscriptions_renewed_count
: The number of transactions with subscriptions that renewed successfully. (If there was a payment error, that doesn't count as a transaction.)subscriptions_cancelled_count
: The number of subscriptions that cancelled. Note, as above, that setting a subscription to inactive without an enddate will result in the subscription not being counted here.
LTV (Lifetime Value) Summary
The LTV summary report is intended to help you understand how much an average customer is worth, which can be helpful in determining marketing budgets and ad spend. It includes the following columns:
customer_count
: The number of unique customers in the grouping.avg_transaction_count
: The number of transactions per customer. Note that this is a count of transactions, not a timeframe. For instance, if you offer subscriptions with different frequencies (monthly and annually, for instance), this value may be difficult to parse. If you'd like additional categorization (such as by subscription frequency), please let us know.avg_order_value
: The average of thetotal_order
value (which includes items, shipping, taxes, and discounts).avg_ltv
: The average value per customer (ie. the LTV, “lifetime value”).
And the following rows:
subscribers
: This includes any customers who have ever had a subscription. In other words, if a customer placed 2 non-subscription orders, then subscribed, then cancelled, they would count as a subscriber.oto
: “One-time order” customers have never had a subscription.all
: This is all customers (inclusive of the previous two rows).