Put a Wilson interval beside a small retention estimate

Analysis

By Isaac Turner, Measurement Editor2 min read

View author profile
Editorial collage hero: measurement-lab-retention-wilson-interval

A retention percentage hides how much information produced it. A reproducible synthetic example with editable inputs and explicit limits.

A retention percentage hides how much information produced it. This lab adds a two-sided Wilson interval to a binomial proportion using a fixed 1.96 normal quantile. The interval is a statistical teaching aid, not a benchmark and not a substitute for checking how the cohort was sampled.

Define the calculation before using it

Count one eligible return outcome per independent install and preserve the total sample. The score-interval formula adjusts the centre and width using the sample size, observed proportion and squared quantile. The supplied artifact shows the arithmetic rather than rounding a small cohort to a confident whole percentage. For clustered or dependent observations, this model is not the correct uncertainty calculation.

Work through the synthetic example

In the synthetic example, 20 of 100 eligible installs return, giving a 20% point estimate. The displayed lower and upper bounds are approximately 13.34% and 28.88%. They describe uncertainty under the binomial model, not the probability that a future campaign will land in the interval. The sensitivity view changes the denominator while preserving the entered return count.

Reference table
OutputWorked-example result
Point estimate %20.0000
Wilson lower %13.3366
Wilson upper %28.8831

Use the artifact and preserve its assumptions

Open the editable calculator to change the inputs and inspect the sensitivity view. The CSV records synthetic inputs and expected outputs; the JSON fixture keeps the equations available for reproduction. These calculations have been checked against the stated example. No measured campaign data is included.

The sensitivity rows vary only n by 20% below and above the entered value. They are scenarios, not confidence limits or a forecast distribution. A row outside the model’s constraints is labelled rather than turned into a plausible-looking result. Save the chosen inputs with the decision so another reader can distinguish a changed assumption from a changed formula.

Evidence and limits

NIST discusses confidence intervals for a binomial proportion and cautions about approximation with small samples. Our worksheet states its assumptions; a descriptive rate or count contrast alone does not establish statistical certainty. See Confidence intervals for a proportion, especially “Confidence intervals; small-sample exact intervals”.

Use a pre-specified analysis plan for comparisons or repeated monitoring. Overlapping or non-overlapping intervals alone are not a complete test of the difference between two campaign treatments.

Background: UA metrics explained: CPI, ROAS, LTV and payback and Reading an MMP dashboard without fooling yourself. These existing articles provide context; the present calculation does not verify every archived claim.

Featured

Related posts

Using predicted LTV in bids: disclosure checklist for the UA team

measurement

media buying

·

1 min read

Using predicted LTV in bids: disclosure checklist for the UA team

Blended ROAS targets that hide channel failure in F2P portfolios

measurement

media buying

·

1 min read

Blended ROAS targets that hide channel failure in F2P portfolios

Web-shop LTV with VAT-inclusive prices versus store net proceeds (labelled synthetic)

measurement

media buying

·

2 min read

Web-shop LTV with VAT-inclusive prices versus store net proceeds (labelled synthetic)

View-through attribution windows on F2P rewarded and interstitial traffic

measurement

media buying

·

1 min read

View-through attribution windows on F2P rewarded and interstitial traffic

More from the Measurement desk

Airbridge adds Amazon Ads as an app measurement channel

measurement

·

2 min read

Airbridge adds Amazon Ads as an app measurement channel

When to freeze a cohort for payback review (and when not to)

measurement

·

2 min read

When to freeze a cohort for payback review (and when not to)

Web-shop purchaser quality vs store IAP purchaser quality

measurement

·

1 min read

Web-shop purchaser quality vs store IAP purchaser quality

Web-shop attributed revenue in MMP vs payment-provider settlements

measurement

·

1 min read

Web-shop attributed revenue in MMP vs payment-provider settlements