In short: Ad platforms and A/B testing tools report what happens in the first few days: clicks, signups, a first purchase. But the real value of a customer shows up months later, in your CRM, your billing system or your product. If you only measure the early numbers, you will back the wrong campaigns and ship the wrong variants. This article explains how to measure ads and experiments on lifetime value, retention and churn instead, and what it takes to build that data.
The problem with day-one metrics
Most marketing and testing tools are built around short windows. An ad platform counts a conversion a few days or weeks after a click. An experimentation tool declares a winner when a signup or checkout metric moves. Both are fast and convenient, and both can be misleading.
A few common examples:
- The cheapest signups are not the best customers. A campaign with the lowest cost per signup can bring users who cancel in the first month, while a more expensive campaign brings customers who stay for years.
- A winning A/B test can hurt the business. A variant that lifts signups with a stronger discount or a more aggressive promise may also increase cancellations, refunds or support costs.
- Lead quality is invisible. A campaign can generate plenty of leads while few of them ever turn into sales, and the ad platform never finds out.
The fix is not a better dashboard in the same tool. It is connecting the data that already exists in different systems.
The long-term metrics that matter
Which metrics you choose depends on the business, but these are the usual ones:
- Customer lifetime value (LTV): the revenue, or better the margin, a customer brings over their whole relationship with you. In practice you measure it over a fixed window, such as 6 or 12 months.
- Retention: how many customers are still active after 30, 90 or 365 days. Looking at it by cohort, meaning customers who joined at the same time or through the same campaign, shows how quality differs by source.
- Churn and cancellations: who leaves, when, and why. Downgrades and refunds belong here too.
- Revenue per customer over time: including renewals, upgrades and expansion.
- Payback period and LTV to acquisition cost: how long it takes for a customer to repay what you spent to win them.
Why it is hard: the data lives in different places
Following one customer from first click to long-term value crosses several systems. Each holds one piece of the story:
- Ad platforms know the campaign, the click and the spend.
- Web analytics and your site know the visit, the page and the signup.
- Your CRM knows whether a signup became a qualified lead and then a sale.
- Billing knows subscriptions, renewals, refunds and cancellations.
- Your product database knows how the customer actually uses what they bought.
- Your A/B testing tool knows which variant each person saw.
These systems use different IDs, report on different time scales and rarely talk to each other. Often some of them are legacy systems with no easy way to export data. That is why long-term metrics so often stay a spreadsheet exercise done once a quarter, or never.
How to build it
- Pick the outcome and the window. Decide what a “good customer” is (for example, active and paying after 90 days) and what you will optimise for. Agree on it with finance and marketing before anyone builds anything.
- Capture identifiers at the first touch. Save the ad click ID (such as gclid or twclid), the campaign parameters and, for tests, the experiment and variant, at the moment of signup. Pass them on to your CRM and billing system so they travel with the customer. Collect them with the right consent.
- Bring every source into one warehouse. Ads, analytics, CRM, billing, the product database and the testing tool all land in the same place, for example BigQuery. Raw, complete data matters here, which is one reason to avoid sampled exports. See how GA4 Parallel Tracking keeps the web data complete.
- Build one customer-level model. Join the sources on your identifiers so each customer has one history: the campaign that brought them, the variant they saw, when they became a lead, when they bought, and what they paid and cancelled since.
- Define the metrics once. LTV, retention and churn should be defined in one place, so every dashboard and every AI tool uses the same numbers. This is exactly what a semantic layer is for.
- Report on lasting results. Show every campaign and every experiment against LTV, retention and payback, next to the early metrics.
- Feed the results back. Send long-term outcomes back to the ad platforms as offline conversions, so their algorithms optimise for the customers you want and not only for signups.
Measuring ad performance on long-term outcomes
Once ads are joined to customers, you can compare campaigns on what their customers are actually worth. A simple illustration (invented numbers):
| Campaign | Cost per signup | 12-month retention | LTV : CAC |
|---|---|---|---|
| Campaign A | €12 | 22% | 1.8 |
| Campaign B | €19 | 61% | 4.6 |
| Campaign C | €15 | 38% | 2.7 |
On cost per signup, Campaign A looks best. On lifetime value, it is the weakest, and Campaign B, the most expensive per signup, is by far the best investment. You can only see this when ad, CRM and billing data sit together. Two practical tips:
- Use an early proxy while you wait. Long windows are slow. Find a number you can measure in 30 days, such as activation or first renewal, that predicts the 12-month outcome, and optimise on that.
- Compare by cohort, not by date. Judge each campaign’s customers from the day they joined, so a young campaign is not unfairly compared with an old one.
Measuring A/B test success on long-term outcomes
The same idea changes how you read experiments. To judge a test on lasting results:
- Keep the variant attached to the customer. Record the experiment and variant against the customer ID, so you can still ask months later how each group behaved.
- Add long-term readouts. Check the primary metric at the end of the test, and then follow the same groups at 30, 90 and 180 days for retention, cancellations and revenue.
- Use guardrail metrics. A test that lifts signups should not be called a win if guardrail metrics such as refunds, cancellations or support contacts get worse.
- Keep a long-term holdout when it matters. For big changes, keep a small group on the old experience, so you have a clean comparison over time.
- Check the basics. A mismatch in how many users each variant received (a sample ratio mismatch) can invalidate a result at any time horizon.
Common pitfalls
- Waiting too long to start. The data you do not capture now cannot be rebuilt later. Start storing identifiers today.
- Too small samples. The longer the window, the fewer customers reach it. Be honest about confidence, especially for small segments.
- Mismatched identities. People use different emails or devices. Plan how you will stitch them together, and be careful with privacy rules.
- Different definitions in different tools. If marketing and finance calculate LTV differently, nobody trusts either number.
- Legacy systems left out. Often the system with the key data, such as an older billing or ERP system, is the hardest to connect. It is usually still worth doing.
How we can help
This is the kind of work our custom data projects are for: integrations between any tools (including legacy systems), a joined-up customer model in your warehouse, attribution built on all your sources, and reporting on LTV, retention and churn. We also help with A/B testing programs so experiments are judged on lasting results.
If you would like to see how your ads and experiments look on long-term numbers, schedule a free consultation and tell us what you have today.
written by
Jason Dolan
Jason is an expert in digital analytics, data pipelines and data warehouses. Since 2009, he has helped numerous companies become more data-driven and gain full control over their data flows.
We love AI, but this article was written by one of our experts.
discussion
0 comments