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%
🚶 Walk-ins
🎯 Conv
💰 ABV
🔧 Fix First
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
—
🔎 Achievers & Bottlenecks
Which stores hit their MTD target, and for those that didn't — which KPI is the biggest drag on sales · click any column header to sort
🏪 Store-wise🗺 Market-wise
🎯
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
Compare by:MTD Ach%Proj CloseAvg ABVConversion%Wknd Uplift Needed₹/sq ftClick 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 Needed₹/sq ftClick RM card · then click store row to see detail ↓
RM Comparison — MTD Ach%
CM Performance
Cluster managers under each RM · click a CM to see their stores · sort by any column
Under RMAll CMs ranked
—
—
—
✕
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 · FY Overview
Year-to-date summary + month-wise sales vs target · 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
Month-wise Growth
Click a month row to see store-level breakdown
Month
TY Sales
LY Sales
Growth
TY Bills
LY Bills
Bill Gr.
TY ABV
ABV Gr.
TY Online
Online Gr.
TY Offline
Offline Gr.
Store-wise Growth
Top 5 growers · Bottom 5
All Stores
Sorted by growth % desc
Store
Sales TY
Sales LY
Sales Gr.
Bills Gr.
ABV Gr.
Online Gr.
Offline Gr.
Lagging KPI
Weekday patterns
Loading…
Window
The week, per trading day
Index 100 = an average day · last year is the same weekday, 364 days back
Weekend premium by store
What a weekend day earns against a weekday one · lowest first — these are the stores the weekend is not reaching
Period 1current
From
To
Period 2prior
From
To
Marketplace
Tran Type
Top N
All
Region
State
City / Market
Store Type
Store Mode
RM
Store Status
Store Name
Category
Product Type
Brand
Polish
Colour
Price Range
Size
Style
Item Name
Show Breakdown
Sales by Category — Month-over-Month %
Waiting for main query…
Region — % Diff
Store — % Diff
Attachment impulse
Which items ride along on someone else's bill, and which item is the reason the customer walked in. The first kind moves units per bill and average bill value; the second kind is what brings them through the door.
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
—
⏳ Loading weekly grid…
DimensionStore filter
Per-store weekly funnel · Bills · Walk-ins · Loss of Sale · Non-Engaged · Conv %
📅 Weekly Grid
FY26-27 · week-wise walk-in funnel per store
⏳ Loading drilldown…
Drill path—
⏳ Loading CEO report…
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 deep-dive · people · market · product · performance
📈Performance
Monthly trend
Sales
Monthly sales · ₹ Cr
ABV
Average bill value · ₹ per bill
UPT
Units per bill · basket depth
ASP
Average selling price · ₹ per unit
Month-by-month detail
Sales · Bills · ABV · Online · Offline · YoY % — click any month-row to copy
💰Unit Economics
Viability
Sales vs breakeven · occupancy cost · revenue per sq ft and per head
—
💔Loss of Sale
Why Walk-ins Left
Recorded reasons · this store only
—
Loss by Hour & Category
When the store is losing, and on what
—
🗺Market & Competition
Share of Centre
Kushals vs the brands tracked around it · like-for-like growth
—
Brands in this Centre
Sales, like-for-like growth and the offers each ran
—
Market Position
Where this store ranks within its market · FY YTD
—
👥People
Store Team
Staff on roll · designation · experience at Kushals · standard vs actual headcount
—
Field Coverage
Last visit by role · who comes, how often
—
🛡Ops & Risk
Operation Scorecard
Monthly audit score and zone · shrinkage · customer enrolment
—
Audit Findings
Every open clause with the auditor's observation · worst risk first
—
⚡Act This Week
Open Items
Highest-risk audit findings, oldest first · from the Retail Risk-Dashboard
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…
🗺️ Monthly Store Coverage
Stores no RM or CM walked into, month by month.
Basis🗓 Planned🚶 ActualByRMRegion—
📋 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.
Scope
MonthRole—
Cells = distinct days visited at that store in the selected scope (multiple in/out swipes on the same day collapse to one) · green = visited · red = skipped
⌛ Loading biometric data…
🎛
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.
—
—
—
—
—
—
—
—
—
—
—
—
🗄️ SQL Warehouse Coverage
Which months are actually loaded, day by day.
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 · several at once, comma or new line
Role
RM Name (from STORE MAPPING)
Pick the tabs this user can see
Access-management tab is admin-only and cannot be granted here. Ticked sub-tabs are hidden from this user.
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
📦 Inventory — stock against sell-through
Loading the stock snapshot…
Window
By category
Value at MRP · cover in days at the current rate of sale
By price band
Where the money sits, by MRP
Money asleep
Held in quantity, nothing sold in the window — ranked by value
Running thin
Selling well with under two weeks of cover left
Store by store
Sorted by stock value · click a column head to re-sort
📅 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)
Top meetings by total time
Meeting
Hours
Count
Avg
Top organizers whose meetings book you most
Organizer
Hours
Count
Top attendees people you spend the most time with
Person
Hours
Meetings
Range summary
✅ Data Adherence
Did the field update this month's sheets, and is what they typed usable — RM-wise
—
👤RM-wise adherence
By Regional Manager
Months filled vs months due · lowest first
🚩Issues to resolve
Open Items
Each row names the store, the owner and the fix
📅Monthly update check
Store × Month
Which stores filled which month · blank cells are the ask
