Good morning

Collections by month

Full + part payments received · stacked by branch · ₹ lakh

Renewals due

Package ends within 30 days, or already expired but still active

Needs attention

Cardio behind pace for the week (180-min target, pro-rated by day), no PT session in 14 days, or expired package

Coaches

Active clients · sessions this week / last 30 days · cardio adherence · renewals due 15d · clients with no PT in 14d

Renewal pipeline

Memberships ending each month ahead · bar = value at stake · this is when cash can come in

Renewal queue

Ending in the next 60 days or already overdue · not renewed yet · call 45 days before expiry

At-risk clients

Churn-risk score from sessions, cardio, expiry, dues and InBody gap · work the High band every Monday

Dues ageing

Outstanding on current packages, by time since the last payment

Coach scorecard

Renewal % of their expiring clients (last 6 months) — the 60% weight in the compensation policy · sessions and load

Retention

Packages that ended each month · renewed = a later package exists for the same client

Client flow

Joined (first package) vs left (status set to Inactive) per month

Members & sessions

Current month = official Active (KPI & MD Dashboard) · history from package records · joins/left match the MD Dashboard register

Weekly cardio

Last 12 weeks (Mon–Sun) · share of active clients reaching 180 min · total minutes logged

PT sessions

Last 12 weeks · sessions closed by coaches · solo and couple

Sales snapshot

Inquiries per month · won / lost / still open · conversion = won ÷ (won + lost)

Open leads

Not yet won or lost · by next follow-up date

Dues outstanding

Package cost − payments received against the same package dates · current packages only

No PT session in 30+ days

Active clients with no closed session in the last 30 days, or never
Data mirrors the Google Sheets every 5 minutes · every number is defined once in Postgres views · FBD Fitness, Jaipur