Customer Analysis

See every customer's value, activity and segment - New, Loyal, Potential Lost, Lost, Winback - with each order's attribution, in ready-made BigQuery tables built from your All in One shop data.

Updated

Customer Analysis turns the order history of your shops into a picture of your customers. For every customer it calculates their lifetime revenue, number of orders, average order value and how long ago they last bought - and gives them a segment: New, Returning, Loyal, Potential Lost, Lost or Winback. It does the same for the moment a chosen number of days ago, so you see who moved where. Every order is joined with the marketing paths that led to it in Google Analytics 4.

The results are ready-made tables in your own BigQuery, a Looker Studio report template, and questions you can ask WitCloud MCP - and the segments can go straight to your ad platforms with Custom Audience.

Why it matters

Advertising keeps getting more expensive: the same budget brings fewer new customers every year. The two usual reactions both fail. Spending more does not double the sales, because the auctions only get denser. Cutting spend and focusing on existing customers stops the base from growing, and the same problem comes back a few months later - with fewer customers.

The way out is in a place most shops do not look: what happens to a customer after the first purchase. That is what tells you how much a new customer is really worth - and therefore how much you can pay to acquire one, so that acquisition pays off again.

Two levers, pulled together

  • Retention - know exactly which customers need attention and how to help them buy more and more often.
  • Acquisition - join what you know about customers with traffic and ad costs, so you know which customers are worth acquiring, through which channels and with which products.

See the customer, not just the transaction

Most reports answer one question: how much did we sell today? Customer Analysis answers the deeper ones: who buys from us, what happens after their first order, and what are they worth over time? In most shops the shape is the same - the largest group of customers bought once and brings the smallest share of revenue, while a small group of loyal customers brings a large part of it.

Two moves between segments matter more than any other:

  • From the first to the second purchase. One purchase can be chance; the second turns a buyer into a customer. One-time buyers are usually the largest and most underrated group in the base.
  • From returning to loyal. This is where it is decided whether a customer stays for years.

Because every customer is also described as they were a chosen number of days ago, you see these moves by name and size - how many moved up to your best customers, how many are at risk, how many left - instead of asking "are we losing customers?".

Act on it

  • Know which channels bring good customers. Each customer's first order carries its attribution, so you can compare channels by the customers they bring, not by the first sale.
  • Act before customers leave. Potential Lost shows valuable customers who have gone quiet for longer than usual - while there is still time to bring them back.
  • Send segments to your ad platforms. Custom Audience turns them into audience lists on Facebook, TikTok, Google Ads or Klaviyo that stay up to date by themselves.

More with WitCloud

Discover the next steps

Create a WitCloud account to read the full guide, including setup instructions, examples and practical tips.

Create an account

Already have an account? Sign in