Shopify LTV & Cohort Analyzer

Upload your Shopify Orders CSV to instantly analyze Customer Lifetime Value (LTV), repeat purchase behavior, monthly cohorts, and customer segments in 100% private client-side analytics.

100% Client-Side Private • Shopify Orders CSV

Upload your Shopify Orders Export

Instantly analyze LTV, repeat purchase rates, cohorts, and customer segments. No server upload required.

Drag & drop your Shopify Orders CSV

Export from Shopify Admin → Orders → Export (CSV)

OR

How this analyzer works

1

Upload Orders CSV or try sample data

Export your Shopify orders or test instantly with our pre-loaded D2C dataset.

2

Customer Deduplication & Math

Aggregates orders by email to calculate repeat rates, LTV windows, and cohort heatmaps.

3

Receive AI Retention Dashboard

Explore 12 interactive sections including RFM segments, purchase cycles, and prioritized growth actions.

Key Assumptions

1
Orders are deduplicated using customer email address.
2
First purchase date establishes the acquisition cohort month.
3
LTV calculations include subtotal price minus discounts across all completed orders.

How to use this tool

1

Export from Shopify

Shopify Admin → Orders → Export (select last 6–12 months as CSV).

2

Upload or test with sample data

Drop your file into the upload zone or click "Try with Sample Data".

3

Review insights & print report

Analyze your 30-365 day LTV curves and export a PDF for your marketing team.

Why this matters for referral

Planning is great, but real data is better. Referbro gives you actual attribution from day 1.

Learn about referral

Frequently Asked Questions

LTV is calculated by aggregating total net revenue generated per unique customer email over specific time horizons (30, 60, 90, 180, and 365 days after their first order).
Yes, 100% secure. The CSV is parsed entirely in your browser using local JavaScript. No customer emails, order values, or store data are ever uploaded to a server or stored.
Cohorts are grouped by the month of a customer's first purchase. The tool tracks how much incremental revenue and repeat order volume each monthly cohort generates over time.
Go to Shopify Admin → Orders → Export. Choose "Orders by date" (last 6 to 12 months recommended) and export as "CSV for Excel, Numbers, or other spreadsheet apps".
Customers are segmented automatically based on purchase frequency, total spend, and recency — including VIPs (top 10% spenders), Champions, At Risk customers, and Referral Candidates.

Ready for real data?

Planning is great, but real data is better.
Referbro gives you actual attribution from day 1.

Install on ShopifyBook a demo