YTD Market Performance — click to drill into Markets tab
Monthly Sales vs Target
Target
Sales
Best
Worst
—
Month-wise Performance
Click any month to open Monthly view
Month
Target
Sales
Ach%
Bills
Avg ABV
Walkins Tgt
Walkins Act
Conv%
Market-wise · Target vs Achievement
YTD totals on the left · monthly Ach% on the right · scroll horizontally for the full year
🎯 Target Achievement Scoreboard · stores that hit target vs missed, month-wise
Achieved
Missed · hit-rate = achieved ÷ stores with a target booked that month
—
Month
✅ Achieved
❌ Missed
Stores
Hit-rate
Distribution
Month-wise Sales · Market → Store
Click any market row to expand its stores · sticky first column · sales in ₹ Cr/L
📈 LFL Stores
📆 LY Stores
🆕 NEW Stores
🗺 Market Insights
Key Insights
—
🗺 Market
🎯 EOM Projection Trend · when the projection got better or worse
≥ Target
80–100%
< 80% ·
Sat
Sun ·
Target
—
Daily Sales · bills · walk-ins inside bar
Sat
Sun
Weekday
—
📡 Latest Day Pulse
Benchmark indices for the most recent day with data
—
🏆 Top 20 Stores · by Revenue ▾
MTD sales ranked · target weightage = store target as % of network target
—
#
Store
Market
Sales
Target
Ach%
Tgt Wt%
Distribution
Market Daily Progression — cumulative sales by day · click any market to filter the Day-wise table below · weekends highlighted
Day-wise Store Performance
Weekend columns highlighted · click a row for store detail · sort by any day or total
Sales (big) · Bills · ABV🔄 LFL📆 LY🆕 NEW
🔍 Anomaly Insights
Statistically unusual store-day patterns · default = latest day · click a row to open store detail
—
🎯
AOP View — Annual Plan vs Actuals
Compares actual sales against the original AOP planned target from the AOP tab — not the rotational DSR target which keeps moving up as monthly deficits roll forward. The month-wise table below shows both side-by-side so you can see exactly how much each month's DSR target has rotated.
FY27 AOP Plan
—
—
— storesvs FY26 —
FY26 actual—
YTD AOP Plan
—
—
through ——
DSR rotational—
YTD Actuals
—
—
vs AOP plan—
Run-rate—
FY Projection
—
—
vs AOP plan—
Required RR—
Month-wise AOP vs Actuals
Network roll-up · plan, actuals, ach % and cumulative variance · click any month to jump to its DSR view
CohortAll🔄 LFL —📆 LY —🆕 NEW ——/—
Plan vs Actuals · Trend
Bars: monthly plan vs achievement · line: cumulative ach %
Quarterly Roll-up
Q1–Q4 AOP plan vs actuals
Store-wise AOP
All 125 stores × 12 months · click column header to sort · search / filter below
—
—
✕
Filter market:
Compare by:MTD Ach%Proj CloseAvg ABVConversion%Wknd Uplift NeededClick any card to see detail ↓
—
—
—
✕
Daily Trend (this market)
Format & Cohort Breakup
Segment
Stores
Sales
Ach%
Stores in this Market
Store
Type
Cohort
RM
MTD Sales
Target
Ach%
Proj%
Conv%
ABV
Daily Sales · bills inside bar
Sat
Sun
Weekday
· —
—
Market Comparison — MTD Ach%
🔍 Store-Day Anomalies
Unusual store-day patterns · baseline = store's own weekday/weekend average · click a row for store detail
—
🏆 Item Sales × Month
Top 50 items by total sales · each cell shows sales + qty · scope follows the market/store filter above
—
Loading…
All Stores
Sort on any column · click a row for detail
Store
Market
Type
Cohort
RM
MTD Sales
Target
Ach%
Proj%
ABV
Conv%
Status
Compare by:MTD Ach%Proj CloseAvg ABVConversion%Wknd Uplift NeededClick RM card · then click store row to see detail ↓
—
—
—
✕
Daily Trend (RM Total)
Store Achievement
All Stores — Click any row to see detail
Store
Market
Type
Cohort
MTD Sales
Target
Ach%
Proj%
Conv%
ABV
RM Comparison — MTD Ach%
RM · Target vs Achievement
Month-wise sales vs target across the FY · click a cell to see what's driving it
🔄 LFL📆 LY🆕 NEWShow:Ach %SalesTargetVariance
—
CohortAll🔄 LFL📆 LY🆕 NEW
3-Year YoY
Sales · Bills · ABV · UPT · ASP across the last 3 FYs with growth % between years
🏆 Growth Winners & Losers
The 5 markets pulling us up · The 5 dragging us down · click any row to drill
—
Monthly Sales — TY vs LY
Bars = TY/LY sales · Line = growth % · LY in tooltip
Market-wise Growth
YTD totals on the left · monthly YoY growth % on the right · scroll horizontally for the full year
Loss-of-sale entries are only trustworthy insofar as retail teams log a reason for people who leave. The capture rate below tells you how representative the "top reason" really is.
—
🔎 Is "Product Availability" really inventory? · sub-reason decomposition of the top loss category
Every sub-reason below names a specific attribute the customer asked for and we didn't have · aggregated across the current scope
—
Sub-reason mix
Category impact · where the gaps hurt
🔬 Top 20 Stores · Loss-of-Conversion Diagnosis
Where sales is short of target, what's driving it — traffic, conversion, or basket — and what customers said when they left
—
Category-wise Sales
🏆 Category Winners & Losers
The 5 categories growing fastest · The 5 declining most · click any row to filter the drill
—
Monthly Sales by Category
Stacked · all 12 months
Month × Breakdown Table
Sales + units per month
🏪 Store 360 — single-store FY journey
Pick a store and FY to see 12-month KPI trajectory · powered by SQL
12-Month Sales · TY vs LY
Bars = sales · Line = bills
ABV & Channel Mix
Bar = ABV · Stacked = Online vs Offline %
Month-by-month detail
Sales · Bills · ABV · Online · Offline · YoY % — click any month-row to copy
Store-channel pairs Paused or Inactive for a week or more — with reason
Zone Distribution
Outlets by zone
🛍 On Shopify · 👗 Missing on Myntra
Stores active on Shopify but not yet live on Myntra — quick-win activation list
—
Headcount · Store-wise
Available (working today) vs Approved (Standard Manpower) · sorted by gap
—
Store
Approved
Available
Gap
Headcount · Month-wise
FY flow: joiners, exits, end-of-month HC vs approved constant
—
Month
Joiners
Exits
Net
End HC
Approved
Gap
🧭 Team · RM & CM Network
Stores handled by each RM/CM, with local-vs-outstation split from STORE MAPPING.
📉 Attrition · RM-wise
Exits from the People sheet (HR Exit Entries) attributed to each RM via STORE MAPPING.
🗓️ Today's Beat
—
—
Loading today's beat…
📋 Ops Tracker —
Loading ops tracker…
📊 Audit Score
Store-wise audit performance · trend by month · breakdown by section
📊
Audit Score · Wire-up pending
Once you point this page at a sheet (DSR audit tab, separate Google Sheet, or xlsx), it will show: store-wise audit %, month-on-month trend, section-level breakdown (housekeeping / VM / staff / stock / SOP), and a watch-list of low-scoring stores. Click 📊 Audit Score again after the source is configured.
🎓 OJT — On-the-Job Training
Trainee progress · module completion · certification status
🎓
OJT · Wire-up pending
Once a source is provided, this page will show: active trainees, module-by-module completion, days-in-OJT per joiner, certification pass-rate, and a list of trainees stuck on a module beyond expected duration. Drill into individual trainees to see their full module log.
🎛
Ops Control
Operations control centre — store opening hours, SOP compliance, escalations, stock & packing status, and live incidents. Coming soon once data is wired in.
🎯 OKR / AOP Plan-Objective Tracker
Projects, team, and Org OKRs from the AOP tracker. Filter by your role, drill into your team's projects.
Viewing as:
🔗 Data Sources
Paste Google Sheet URLs and API key once — all sections read from here. Stored in your browser's local storage.
—
—
—
—
—
—
—
—
—
Setup: In Google Cloud Console → create API Key → enable Google Sheets API → restrict key to Sheets API. Share each sheet as "Anyone with the link can view".
FY—
Monthly Sales (SQL)
—
—
Online vs Offline
YTD split
Month-wise Performance
Sales/Bills/ABV from SQL · Target/Walk-ins from Sheet
Month
Target
Sales
Ach%
Bills
Avg ABV
Online
Offline
Walkins Tgt
Walkins Act
Conv%
Daily Sales
Selected month
Transaction Types
All tran_type codes (YTD)
Tran Type
Count
Sales
Store-wise (selected month)
Ranked by Sales
Store
Sales
Bills
Avg ABV
Online
Offline
🔐 Access Management
Add or remove users, assign admin / RM roles. Admins see every tab; RMs see DSR + Kushals with stores scoped to their name.
Email
Role
RM Name (from STORE MAPPING)
If email isn't in the list:
Email
Role
RM Scope
Actions
⏳ Loading…
🧪 SQL Schema Preview
Pick any retail table (tbl_sales*, tbl_store*, tbl_ecom*) to see its column headers and a sample of rows
—
—
Pick a table above to preview its schema + sample rows.
🏪
Kushals Store Network
Store footprint · state / type / city / hub analysis
—
Stores
—
States
—
Cities
—
Hubs / OS
Type
Hub/OS
State
Store Presence — by State · hover for city list
Stores1 → 25+·No presence
Stores by State → City breakdown
Count of Stores by Market
Count of Stores by Type
Count of Stores by Floor
📅 Year of Launch
(Financial Year)
Store Directory
—
—
—
✕
Daily Sales
Weekend vs Weekday
Store Metrics
📅 Calendar Insights ● loading
Primary Google Calendar · where my time goes · grouped by meeting / organizer / weekday
Month:
⚠️One-time consent needed. The visuals below show sample data — connect to see your own.
Total booked
–
events
Meeting time
–
vs solo blocks
Thinking time
–
unbooked working hours
Avg meeting
–
across all meetings
Recurring load
–
of meeting time
Busiest day
–
in the range
Hours by weekday when you're booked
Hours by time of day local hour of event start
Hours by category auto-grouped by title keywords
Category breakdown % of working-hours time
Category
Hours
Events
Daily occupancy occupied vs free time per weekday · 8h working day (10am–7pm minus lunch)
