Site Logo

← All Managed Reports

Customers · Managed Reports

LTV by first order report

Lifetime value and repeat rate by first-order discount, product, channel, and landing page.

Retention-minded brands comparing which first orders lead to repeats. Lifetime value and repeat rate by first-order discount, product, channel, and landing page. Cohorts customers whose first Shopify order is in the synced history window. LTV and repeat rate only include orders inside that window. Landing page comes from the order customer journey. Open this Managed Report in SyncRange, then export the same data to Google Sheets, BigQuery or Excel when you want to own the destination.

Start free Explore the demo

No warehouse setup · Docs

What is on this dashboard

  • LTV and repeat rate by cohort
  • Discount code and first product
  • Channel and landing page
  • First-order customers in the history window

Sources

Shopify

Best for

Retention-minded brands comparing which first orders lead to repeats.

Interactive demo

Sample data · Change Group by to see the chart update

Create this report

Oct 1, 2026 – Oct 30, 2026

First-order customers

860

No prior period

LTV (synced window)

USD 148.50

No prior period

Repeat rate

28.4%

Repeat customers

244

No prior period

First-order revenue

USD 64,200.00

No prior period

LTV inside the synced history window. Sample data for preview only.

By discount code

Cohort Customers Repeat rate LTV Orders
WELCOME10 210 34.3% USD 168.40 310
(none) 480 22.9% USD 132.00 620
VIP15 90 44.4% USD 210.50 160

By first product

Cohort Customers Repeat rate LTV Orders
Classic Tee 240 33.3% USD 155.00 360
Starter Kit 180 38.9% USD 205.00 310
Gift Card 60 8.3% USD 58.00 68

By channel

Cohort Customers Repeat rate LTV Orders
web 520 30.8% USD 152.00 760
instagram 210 26.2% USD 138.00 290
pos 130 22.3% USD 142.00 180

By landing page

Cohort Customers Repeat rate LTV Orders
/collections/new 190 36.8% USD 175.00 290
/ 320 25.0% USD 128.00 420
/products/classic-tee 150 32.0% USD 162.00 230

How to set it up

Live in three steps

  1. 1

    Connect accounts

    Link Shopify under Apps. Reports reuse the same connections as exporters.

  2. 2

    Launch the template

    Open Reports, choose LTV by first order (Shopify), pick accounts, and set how far back to sync.

  3. 3

    Explore KPIs

    Browse cards, charts, and tables. Group trends by day, week, fortnight, or month.

Want this data in your own Sheet or warehouse?

Send it to Google Sheets, BigQuery or Excel on a schedule. Start with this report, then export the same Shopify data when you want to own it.

Export Shopify Google Sheets BigQuery Excel

Why this report

Finished dashboards, not raw exports

SyncRange stores the data and opens KPIs in the app. Skip creating a BigQuery project or spreadsheet destination for this report.

Template ready

Metrics and layout ship with the product. No blank canvas.

Scheduled syncs

Backfill once, then refresh on a schedule or Sync now.

Same connections

Uses the accounts you already connect for exporters.

More templates

Try other reports

New-customer CAC (Shopify + ads)

Shopify + ads

Ad spend divided by first-time Shopify customers, by week and channel.

View report →

Sales overview (Shopify)

Shopify

Net sales, orders, AOV, and channel mix for your Shopify store.

View report →

Sales overview (Amazon Seller)

Amazon Seller

Order total, orders, and AOV for Amazon Seller.

View report →

Sales overview (Etsy)

Etsy

Receipt totals, orders, and AOV for Etsy.

View report →

Browse the full report gallery

Ready to create LTV by first order (Shopify)?

Start free, connect Shopify, and launch this template from the in-app gallery.

Get started free Back to demo

Start syncing your ecommerce data in minutes Start free today. No credit card required.

Start free Install on Shopify