Case Study · eCommerce

A four-week reporting backlog, cleared by CXDATA.

Spotminders is a fast-growing D2C eCommerce brand with a quick-moving trading team and a reporting backlog it had no data function to clear. CXDATA stepped in as the analytics partner and built the whole data layer on Refyner – so trading questions got answered in days, not sprints.

At a glance

The engagement

Client
Spotminders – D2C eCommerce brand
Sector
High-growth eCommerce / DTC
Delivered by
CXDATA – managed analytics partner
Built on
Refyner – prep, scheduling & models
Warehouse
The brand's own Snowflake
Live in
Under 3 weeks, no in-house engineer

The starting point

Spotminders' trading team knew the questions that mattered – lifetime value by acquisition cohort, repurchase curves, RFM segments to drive retention campaigns, and blended CAC across Meta, Google and Amazon. What the business didn't have was a data function to answer them, or any appetite to stand up an engineering team to do it.

Reporting requests piled into a backlog that stretched three to four weeks, by which point the trading question that prompted them had moved on. CXDATA came in to own the data layer end to end – and chose to build it on Refyner rather than assemble a prep tool, a separate scheduler and the engineering time to run both.

What CXDATA built on Refyner

CXDATA connected Refyner to the Snowflake Spotminders already owned. The eCommerce model packs populated on connect – no rebuild from scratch – and CXDATA's analysts had the brand's core models live and scheduled within the first weeks.

  • Customer LTV & cohorts – lifetime value by acquisition cohort, channel and category, refreshed daily.
  • RFM segmentation – recency, frequency and monetary scoring feeding retention and win-back campaigns.
  • Repurchase & retention curves – time-to-second-order tracked across the catalogue.
  • Channel attribution & blended CAC – spend and orders reconciled across Meta, Google Ads and Amazon.
  • Contribution margin – revenue after ad spend, surfaced by channel and product.
  • Scheduled in the same place – every dataflow set to refresh on schedule, with run logs and monitoring CXDATA manages for the brand.
4 wk → same daymodel turnaround
0engineering tickets to ship a model
~50%lower everyday dataflow cost
What changed

Before and after.

 BeforeWith Refyner
Ship a new model3–4 week backlogDays, run by CXDATA
eCommerce modelsNone in placeBuilt in on connect
Data functionNo team, no engineerCXDATA, on Refyner
Where data runsScattered exportsPushdown on their Snowflake
The outcome
A four-week reporting backlog, cleared to same-day delivery. Spotminders got cohort LTV, RFM, repurchase and channel attribution live in weeks – run end-to-end by CXDATA on Refyner, with no in-house data engineer hired.

The same data layer – run for you, or by you.

CXDATA delivers it for brands on Refyner. Connect your Snowflake and you can run the same prep, scheduling and models yourself – this week.

Start free More case studies