Data Exports
Export subscription data for analysis, reporting, and integration
Export your subscription data for custom analysis, BI tools, and compliance needs.
Available Exports
Members
All member data with subscription status
Orders
Order history with line items and payments
Billing History
All billing attempts and outcomes
Store Credits
Credit transactions and balances
Subscriptions
Active and historical subscriptions
Accessing Exports
Navigate to Exports
Go to Subscribfy → Settings → Exports tab.
Select Export Type
Choose the data you want to export.
Configure Options
Set date range and filters.
Download
Click Export and wait for the file to generate.
Export Types
Members Export
All customer data with subscription information.
Columns included:
| Column | Description |
|---|---|
customer_id | Shopify customer ID |
email | Customer email |
first_name | First name |
last_name | Last name |
phone | Phone number |
membership_status | Active, Paused, Cancelled, None |
plan_name | Current plan name |
member_since | Date became member |
loyalty_points | Current points balance |
store_credit_balance | Current credit balance |
tier_name | Loyalty tier |
total_orders | Lifetime orders |
total_spent | Lifetime value |
last_order_date | Most recent order |
next_billing_date | Next charge date |
Orders Export
Complete order history.
Columns included:
| Column | Description |
|---|---|
order_id | Shopify order ID |
order_number | Order number |
customer_email | Customer email |
order_date | Order creation date |
order_type | First-time, Recurring, One-time |
subtotal | Order subtotal |
discount | Discount amount |
shipping | Shipping cost |
tax | Tax amount |
total | Order total |
payment_status | Paid, Pending, Refunded |
fulfillment_status | Fulfilled, Unfulfilled, Partial |
subscription_id | Associated subscription |
Billing History Export
All billing attempts and outcomes.
Columns included:
| Column | Description |
|---|---|
attempt_id | Billing attempt ID |
subscription_id | Subscription contract ID |
customer_email | Customer email |
attempt_date | Date/time of attempt |
amount | Charge amount |
status | Success, Failed, Pending |
error_code | Error code if failed |
error_message | Error description |
retry_count | Number of retries |
order_id | Created order ID (if success) |
Store Credits Export
Credit transactions and balances.
Columns included:
| Column | Description |
|---|---|
transaction_id | Transaction ID |
customer_email | Customer email |
transaction_date | Date of transaction |
type | Credit, Debit, Adjustment |
amount | Transaction amount |
balance_after | Balance after transaction |
source | Membership, Referral, Manual, Order |
notes | Transaction notes |
order_id | Associated order (if applicable) |
Subscriptions Export
All subscription contracts.
Columns included:
| Column | Description |
|---|---|
subscription_id | Contract ID |
customer_email | Customer email |
plan_name | Subscription plan |
status | Active, Paused, Cancelled |
created_date | Start date |
cancelled_date | End date (if applicable) |
cancel_reason | Cancellation reason |
billing_frequency | Billing interval |
price | Current price |
next_billing_date | Next charge date |
total_charges | Number of successful charges |
total_revenue | Total revenue from subscription |
Export Options
Date Range
Filter exports by date range:
| Option | Description |
|---|---|
| Last 7 days | Previous week |
| Last 30 days | Previous month |
| Last 90 days | Previous quarter |
| This month | Current month to date |
| Last month | Previous full month |
| Custom range | Select specific dates |
| All time | Complete history |
Filters
Additional filters available (varies by export type):
| Filter | Description |
|---|---|
| Status | Active, Cancelled, Paused |
| Plan | Specific membership plan |
| Payment status | Paid, Failed |
| Customer segment | VIP tier or custom segment |
Format
Export formats available:
| Format | Best For |
|---|---|
| CSV | Excel, Google Sheets, most tools |
| Excel (.xlsx) | Microsoft Excel with formatting |
Scheduled Exports
Set up recurring exports for regular reporting.
Configure Schedule
Choose frequency:
- Daily (sent each morning)
- Weekly (sent Monday morning)
- Monthly (sent 1st of month)
Set Recipients
Enter email addresses to receive the export.
Choose Format
Select CSV or Excel format.
Save Schedule
Exports will run automatically on schedule.
Scheduled exports include the previous period's data. Daily exports include yesterday's data, weekly includes last week, etc.
Analytics Export
Export data directly from Analytics tabs.
Membership Analytics
From Analytics > Membership, click Export to download:
- KPI summary
- Revenue by period
- Churn metrics
- Cohort data
Payment Recovery Analytics
From Analytics > Payment Recovery, export:
- Billing attempt history
- Error breakdown
- Dunning status
Chargeback Data
From Analytics > Chargeback Prevention, export:
- Alert history
- Dispute records
- Prevention metrics
Using Export Data
API Export Alternative
For automated data access, consider using the Subscribfy API instead of manual exports.
Advantages:
- Real-time data
- Automated sync
- Custom queries
- Webhook notifications
See Data Teams > API Reference for documentation.
Troubleshooting
Data Retention
| Data Type | Retention Period |
|---|---|
| Orders | Unlimited |
| Billing attempts | 2 years |
| Store credits | Unlimited |
| Activity logs | 1 year |
For compliance exports or extended data retention, contact support.
Was this page helpful?