Methodology

How we construct a subscriber behavior report

Every engagement follows the same documented phases — from field definition through final briefing — so clients know what happens in each week and what they must prepare.

View report types
Precision instruments and annotated charts representing analytical methodology
  1. I

    Scoping and definitions

    Week 1 begins with a written scope document. We align on subscriber status definitions, churn categories, geographic roll-up levels, and excluded data fields. Billing, network planning, and legal stakeholders join a single call to prevent downstream disagreements.

    Output: signed scope, data field specification, encrypted transfer credentials.

  2. II

    Extract validation

    We reconcile row counts against your stated active base, verify plan ID coverage in the catalog export, and flag null rates in disconnect reason codes. Issues are returned within three business days with specific remediation requests — not vague "data quality problems."

    Output: validation memo with pass/fail checklist.

  3. III

    Cohort construction

    Activation cohorts, tenure bands, and plan tier groupings are built from agreed rules — not ad hoc slicing. Segment boundaries are capped to maintain commercial usability. ARPU bands merge until each holds at least five percent of active lines.

    Output: cohort definition appendix (internal working document).

  4. IV

    Analysis and chart draft

    Churn decomposition, usage intensity distributions, acquisition channel attribution, and migration matrices are produced with numbered chart references. Draft charts use the same visual standard as final deliverables so review comments map directly to finished pages.

    Output: annotated draft deck for client review session.

  5. V

    Review session

    A 90-minute session at our Seongnam office or via secure video. Clients may invite up to six attendees. We walk through findings, capture clarification requests, and confirm any scope adjustments before finalization.

    Output: marked-up draft with agreed revisions list.

  6. VI

    Final delivery and briefing

    Executive summary (two pages), full report PDF, appendix tables in spreadsheet format, and definition appendix. Final briefing covers board-ready talking points and known limitations stated explicitly.

    Output: final report package archived on encrypted media with 24-month retention per contract.

Chart numbering convention

Charts are numbered sequentially within each section (e.g., 3.2 for section three, chart two). Executive summary references use these numbers so board readers can locate supporting detail without page hunting. This convention is consistent across all report types.

Ask about methodology for your base