Spillmark
Demo · made-up numbers
OverviewAlerts4Approvals
EExample Coffee Co.

Brands you can access

Example Coffee Co.
Data current · oldest 9h ago

When each source last synced

  • Amazon Seller Central3h ago

    Amazon fees are estimates until orders settle (about 14 days).

  • Amazon Ads5h ago

    Amazon Ads attributes purchases up to 7 days after a click, so the last week can still rise.

  • Amazon Attribution9h ago

    Amazon Attribution keeps adding purchases to each day for 14 days.

  • Meta Ads2h ago

    Meta revises the last few days of results as delayed conversions arrive.

  • Shopify54m ago
Manage connections →
DemoGet started

Cohorts

Do sample buyers come back for a full bag, and what is a customer worth?

Loading cohorts…
OverviewAttributionNeeds Amazon's written approval to combine Amazon Ads and Meta data (Amazon Ads policy 4.9).TestsProductsCohortsInventoryAlerts4ApprovalsReportsConnectionsSettings

Cohorts follow each customer from their first order, so the date range above only changes CAC in LTV:CAC. LTV here is the same number the Overview uses; change its window in Settings.

90-day LTV · Shopify
$19.42
1,100 customers · 28% of LTV:CAC
90-day LTV · Amazon (estimate)
$19.46
From aggregate repeat purchases · 72% of LTV:CAC
90-day LTV · sample first
$10.10
777 customers
90-day LTV · full bag first
$41.84
323 customers
LTV:CAC
3.23:1

Above target: room to spend more· target 2.5–3.0:1

LTV curve

Contribution per customer, before ad spend, by days since their first order

Sample firstFull bag first90-day LTV
$0$12.50$25.00$37.50$50.00
Sample first, first 1 days: $1.70 per customer (1,032 customers)Sample first, first 7 days: $4.00 per customer (1,018 customers)Sample first, first 14 days: $5.38 per customer (991 customers)Sample first, first 30 days: $7.38 per customer (966 customers)Sample first, first 45 days: $8.72 per customer (930 customers)Sample first, first 60 days: $9.64 per customer (888 customers)Sample first, first 90 days: $10.10 per customer (777 customers)Sample first, first 120 days: $10.79 per customer (684 customers)Sample first, first 150 days: $10.86 per customer (593 customers)Sample first, first 180 days: $10.92 per customer (504 customers)Full bag first, first 1 days: $31.90 per customer (392 customers)Full bag first, first 7 days: $33.61 per customer (384 customers)Full bag first, first 14 days: $34.93 per customer (384 customers)Full bag first, first 30 days: $36.79 per customer (374 customers)Full bag first, first 45 days: $39.15 per customer (372 customers)Full bag first, first 60 days: $40.06 per customer (362 customers)Full bag first, first 90 days: $41.84 per customer (323 customers)Full bag first, first 120 days: $43.22 per customer (292 customers)Full bag first, first 150 days: $44.37 per customer (262 customers)Full bag first, first 180 days: $45.40 per customer (228 customers)
Day 130d60d90d120d150d180d
Show as table
First N daysSample firstFull bag first
1$1.70 (1,032)$31.90 (392)
7$4.00 (1,018)$33.61 (384)
14$5.38 (991)$34.93 (384)
30$7.38 (966)$36.79 (374)
45$8.72 (930)$39.15 (372)
60$9.64 (888)$40.06 (362)
90$10.10 (777)$41.84 (323)
120$10.79 (684)$43.22 (292)
150$10.86 (593)$44.37 (262)
180$10.92 (504)$45.40 (228)

Each point counts only customers at least that many days past their first order, from the year before. Points with fewer than 20 customers are left out.

Cohorts by first purchase month

Shopify customers, split by whether their first order was a sample

Shopify cohorts by first purchase month
First orderStarted withCustomersNext full bag ≤30dNext full bag ≤60dNext full bag ≤90dOrders / customerContribution / customer
Oct 2026Sample first70Too newToo newToo new1.2$7.35
Full bag first41Too newToo newToo new1.2$36.45
Sep 2026Sample first8121.6%Too newToo new1.2$8.96
Full bag first274.8%Too newToo new1.1$39.43
Aug 2026Sample first11117.1%24.0%Too new1.3$11.26
Full bag first4316.3%29.7%Too new1.4$42.40
Jul 2026Sample first9811.2%19.4%16.9%1.3$10.60
Full bag first2814.3%17.9%23.1%1.3$40.10
Jun 2026Sample first9219.6%25.0%26.1%1.3$11.54
Full bag first3122.6%32.3%35.5%1.5$44.40
May 2026Sample first917.7%14.3%16.5%1.2$9.63
Full bag first3713.5%21.6%21.6%1.4$41.00
Apr 2026Sample first9823.5%26.5%28.6%1.3$11.66
Full bag first3611.1%16.7%16.7%1.3$37.65
Mar 2026Sample first8517.6%20.0%21.2%1.3$10.30
Full bag first4012.5%30.0%35.0%1.5$52.79
Feb 2026Sample first7424.3%28.4%28.4%1.4$15.09
Full bag first3321.2%33.3%33.3%1.5$49.87
Jan 2026Sample first9611.5%14.6%15.6%1.2$8.48
Full bag first2313.0%17.4%17.4%1.3$48.33
Dec 2025Sample first5527.3%29.1%29.1%1.4$13.52
Full bag first229.1%9.1%13.6%1.1$37.16
Nov 2025Sample first7913.9%17.7%19.0%1.2$10.13
Full bag first2611.5%23.1%23.1%1.3$41.49
Last 12 monthsSample first1,03017.2%21.5%22.0%1.3$10.64
Last 12 monthsFull bag first38714.1%24.0%25.2%1.3$42.68

Next full bag: a sample buyer's first full bag, or a full-bag buyer's second. A cell counts only customers at least that many days past their first order; numbers with a clock are still filling in.

Amazon repeat purchases

Brand Analytics, last 13 published weeks · Jul 26 – Oct 24

Aggregate only — no customer-level data
Amazon repeat purchases by product
ProductCustomersRepeat customersRepeat rateRepeat revenue
Cold Brew Original 2 lbB0EXMORG0282816620.0%$10,792
Cold Brew Mocha 2 lbB0EXMMOC024698718.6%$6,065
Cold Brew Sample (3 servings)B0EXMSMP0173912.3%$61.22
All products1,37026219.1%$16,919
Weekly repeat rateAmazon shares no customer-level data, so these can't be split into cohorts or matched to Shopify customers. Customers are summed across weekly reports; Amazon's LTV estimate uses the quarterly report instead, where each customer counts once.