Lifecycle segmentation assigns relationships to explicit acquisition, activation, repeat and lapse stages. Use customer and order exports to compare stage revenue and follow-up purchasing without confusing conversion, retention and reactivation.
Lifecycle segmentation assigns relationships to explicit stages based on observed activity. Freeze the stages at a reporting date, then compare revenue and subsequent purchasing within those groups. Separate prospect conversion, active-customer retention and reactivation so the denominator matches the decision.
A US industrial supplier uses a customer and prospect list together with completed-order history. It wants to see where relationships stall and which stages produce subsequent sales. The stage rules use purchase milestones rather than an account manager's general impression.
| Stage | Rule at the snapshot date | Follow-up question |
|---|---|---|
| Acquisition | No completed orders to date | Does the prospect place a first order? |
| Activated | Exactly 1 completed order and last purchase within 60 days | Does the customer purchase again? |
| Repeat | At least 2 completed orders and last purchase within 60 days | Does repeat buying continue? |
| Lapsed | Previously purchased; last purchase more than 60 days ago | Does the customer return? |
The inactivity limit is the supplier's chosen rule for this example, not a benchmark. Check the buying cadence before adopting it. An annual replenishment account needs a different interpretation from a customer expected to order regularly throughout a month.
Lifecycle stages can move in either direction. A repeat customer may lapse and later return. Store the snapshot label alongside its date so a later stage change does not rewrite the earlier population.
Use RFM analysis for purchase-ranking scores. The broader behavioral segmentation guide covers activity patterns beyond stage progression, while B2B customer segmentation covers commercial account grouping.
Start with one row per relationship and a stable ID shared with the order export. Keep prospects who have not purchased; otherwise there is no acquisition population. Consolidate completed-order lines into orders, remove cancellations and validate dates before counting activity.
Use an Orders sheet with relationship ID in A, completed-order date in B and net order revenue in C. Revenue includes the chosen treatment of credits and returns. A credit memo adjusts revenue rather than becoming an additional completed purchase.
Set these parameter cells:
Params!B1: =DATE(2026,8,31)
Params!B2: =DATE(2026,9,1)
Params!B3: =DATE(2026,9,30)
The snapshot is August 31, 2026. September is the follow-up period. On Customers, use A for relationship ID, B for historical completed-order count, C for latest completed purchase through the snapshot, D for days since purchase, E for stage, F for September orders, G for September revenue and H for a September buyer flag.
Historical count in B2 uses the complete order history through the snapshot:
=COUNTIFS(Orders!$A$2:$A$50000,A2,Orders!$B$2:$B$50000,"<"&Params!$B$1+1)
Google's COUNTIFS documentation explains counting rows against multiple conditions. Keep the criteria ranges the same size and extend them together for a larger export. A recently started export cannot establish lifetime counts; obtain the earlier history or use a clearly labeled observed-history definition.
Take column C from the historical customer activity export, with no date later than the snapshot. Calculate D2 and E2:
=IF(C2="","",INT(Params!$B$1)-INT(C2))
=IF(B2=0,"Acquisition",IF(C2="","Review",IF(D2>60,"Lapsed",IF(B2=1,"Activated","Repeat"))))
A purchased relationship with a missing latest-purchase date becomes Review. Resolve those records before publishing stage comparisons. A zero count with a populated purchase date is also a contradiction to investigate.
Calculate September order count in F2, revenue in G2 and buyer flag in H2:
=COUNTIFS(Orders!$A$2:$A$50000,A2,Orders!$B$2:$B$50000,">="&Params!$B$2,Orders!$B$2:$B$50000,"<"&Params!$B$3+1)
=SUMIFS(Orders!$C$2:$C$50000,Orders!$A$2:$A$50000,A2,Orders!$B$2:$B$50000,">="&Params!$B$2,Orders!$B$2:$B$50000,"<"&Params!$B$3+1)
=IF(F2>0,1,0)
Google's SUMIFS documentation specifies conditional sums where all supplied criteria are met. The customer and date conditions must match the count calculation. Do not reassign the August stage using September purchases.
| ID | Historical orders B | Latest purchase C | Days D | August stage E | September orders F | September revenue G (USD) | Buyer H |
|---|---|---|---|---|---|---|---|
| C1 | 0 | None | Acquisition | 1 | 400 | 1 | |
| C2 | 0 | None | Acquisition | 0 | 0 | 0 | |
| C3 | 1 | August 21, 2026 | 10 | Activated | 1 | 600 | 1 |
| C4 | 1 | August 11, 2026 | 20 | Activated | 0 | 0 | 0 |
| C5 | 5 | August 26, 2026 | 5 | Repeat | 2 | 1,500 | 1 |
| C6 | 3 | August 6, 2026 | 25 | Repeat | 1 | 900 | 1 |
| C7 | 4 | June 1, 2026 | 91 | Lapsed | 1 | 500 | 1 |
| C8 | 2 | April 1, 2026 | 152 | Lapsed | 0 | 0 | 0 |
The displayed None entries represent empty date cells. These rows are fictional and illustrate the method. C1 remains in the baseline acquisition group for September reporting even after its first purchase; its next snapshot can show activation.
List stages in J2:J5. Put relationship counts in K, buyer counts in L, order counts in M, revenue in N and purchase rate in O:
=COUNTIFS($E$2:$E$9,J2)
=SUMIFS($H$2:$H$9,$E$2:$E$9,J2)
=SUMIFS($F$2:$F$9,$E$2:$E$9,J2)
=SUMIFS($G$2:$G$9,$E$2:$E$9,J2)
=IF(K2=0,"",L2/K2)
| Baseline stage | Relationships | September buyers | September orders | Revenue (USD) | September purchase rate |
|---|---|---|---|---|---|
| Acquisition | 2 | 1 | 1 | 400 | 50.0% |
| Activated | 2 | 1 | 1 | 600 | 50.0% |
| Repeat | 2 | 2 | 3 | 2,400 | 100.0% |
| Lapsed | 2 | 1 | 1 | 500 | 50.0% |
| Total | 8 | 5 | 6 | 3,900 | 62.5% |
Percentages are rounded to one decimal place. The total purchase rate is 5 / 8 = 62.5%. That figure includes acquisition and reactivation, so it is not active-customer retention.
Active-customer retention in this purchase-based definition uses Activated and Repeat customers at baseline: (1 + 2) / (2 + 2) = 75.0%. The exact formula is:
=(SUMIFS($H$2:$H$9,$E$2:$E$9,"Activated")+SUMIFS($H$2:$H$9,$E$2:$E$9,"Repeat"))/(COUNTIFS($E$2:$E$9,"Activated")+COUNTIFS($E$2:$E$9,"Repeat"))
Prospect conversion and lapsed reactivation are each 1 / 2 = 50.0%. Keep these measures separate from contractual renewal rates. The loyalty segmentation workflow answers a related question about explicitly defined repeat-purchase statuses.
The checks are direct: stage populations sum to 8, buyers to 5 and orders to 6. Revenue reconciles as 400 + 600 + 2,400 + 500 = $3,900 and must tie to the September order export for the same population.
Sales owns acquisition follow-up. The account team checks whether newly activated customers need help completing their next purchase, reviews service for repeat buyers and investigates lapse. Finance owns revenue reconciliation; the business owner approves stage rules and changes to them.
Covirage is not affiliated with Google.
Bring your relationship list, supplied stage definitions and dated order export. Covirage maps the columns, its tools compute and check the stage figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See renewal watch for the supporting relationship review use case.
A practical purchase-based framework uses acquisition before a first completed order, activation after that first order, repeat after further orders and lapse after a defined inactivity limit. Your business must document its own milestones and timing rather than assume universal stage boundaries.
Lifecycle stages describe progression through relationship milestones under explicit rules. RFM scores rank recency, frequency and monetary activity. A customer can retain the same lifecycle stage while its RFM ranking changes, so keep the two labels separate.
Use the population defined by the retention question. For active-customer retention, freeze customers active at the start and measure later purchasing among them. Report prospects as conversion and previously lapsed customers as reactivation so different relationship outcomes remain clear.