Subscription Renewal Reporting: Count Paid Customers Before Payment Attempts

Count a paid renewal from a successful collection, not an active-account label or a payment attempt. Follow the same customers from their due date to the review date, including cancellations and unpaid cases. That gives the campaign team a defensible renewal result before it raises the repeat-value assumption used to fund acquisition.

Fix the customer group before counting outcomes
First choose the unit: subscriptions or unique customers. A customer with two subscriptions can generate two renewals but remains one customer. Keep both views if needed, with their own denominators. The fictional example below uses one subscription per customer so its subscription and customer counts agree.
Fix the subscriptions scheduled to renew in the period, with their expected dates. Separate cancellations effective before payment becomes due from payments that become due and fail. Keep the cancellation request date too, so a later effective cancellation is not silently moved into an earlier group.
Our subscription price and billing guide checks the offer customers accept. This review starts later: did those customers reach renewal, remain due to pay and complete the expected payment? It should not quietly substitute an account’s “active” label for a collected renewal.
Build one customer record with several payment events
Keep one record for the renewal being reviewed and attach its payment attempts. A failed attempt followed by a successful retry is one paid renewal, not two customer outcomes. Here is a filled fictional record showing what another reviewer should be able to reconstruct:
Renewal: customer R017, one subscription, $40 due on 2 November.
First attempt: failed on the due date; no payment collected.
Retry: $40 collected on 3 November, with its payment reference.
Snapshot: paid at the 4 November review; one paid customer, two attempts.
Next action: no collection follow-up for this renewal; retain the linked records.
Reconcile a complete fictional renewal period
Suppose 100 subscriptions are originally scheduled to renew at $40 each. Eight cancellations take effect before renewal, leaving 92 customers due. Eighty pay on the first attempt, collecting $3,200. The other 12 fail that attempt. After the agreed follow-up, five of those customers pay another $200; seven remain unresolved.
The result is 85 paid renewals and $3,400 collected. The original 100 customers reconcile as 85 paid + eight cancelled before renewal + seven unresolved. If all 12 failed payments were retried once, there were 104 attempts: 92 initial attempts plus 12 retries. Those additional attempts did not add customers.
The 92 renewals due represent $3,680 under the fictional price. Collected cash is $280 short of that amount, matching seven unresolved payments at $40 each. Against the original $4,000 schedule, the $600 difference consists of $320 from pre-renewal cancellations and that $280 unpaid balance. Keep those reasons separate.
Label the percentage by its denominator
In that example, paid renewals are 85 out of 92 customers due, or about 92.4%. Paid customers are also 85% of the original 100 scheduled accounts. Both calculations can be useful, but they answer different questions. Calling either one simply “retention” without the definition hides the cancellations or the collection stage.
Keep failed attempts out of the customer denominator. A payment recovery can improve the collection result without adding a customer, and an unresolved payment should remain unresolved rather than being assumed recovered. Record refunds and later reversals consistently with the chosen reporting scope.
Connect renewals to contribution, not just subscription value
Do not multiply every active label by the subscription price and call the result recovered acquisition spend. Confirm the payment and the relevant delivery or service costs. In the fictional period, $3,400 is collected renewal cash before those costs; it is neither a statement of net profit nor proof that advertising has paid back.
Our repeat purchase cohort guide explains fair observation windows. Apply the same discipline here: recent renewal groups need enough time for the agreed collection review. Keep mature results and partially observed groups distinguishable.
Keep first-time subscription payments outside the renewal numerator. A campaign that acquires many new subscribers can raise total collections while older customers stop renewing. Show new acquisition and the renewal group separately before deciding that a larger overall payment total supports the retention assumption.
Choose the next action from the unresolved stage
For this example, report the $3,400 collected and keep $280 unresolved; do not increase the repeat-value assumption as though $4,000 arrived. Assign the seven open cases for collection review and examine the eight cancellations separately. Revisit the assumption when the agreed window closes and the applicable delivery costs are known.
Bring that defined customer group into the campaign review. Our Meta Ads management service can help connect acquisition decisions with observed renewals. A larger attempt count or more new subscribers is not, by itself, evidence that more of the due group renewed successfully.
Comments