State Overview
Full network performance
Production by District
Revenue by District
12-Month Production & Revenue Trend
Revenue Channel Mix
District Performance Scorecard
RankedNetwork Health Score
Active BRCs + data completeness + engagement
District Intelligence
Select a district for full analytics
BRC Performance
Individual BRC rankings, scoring and analytics
Top Performers
Full BRC Scorecard
Aggregator Analytics
Procurement, profitability and network contribution
Leaderboard
AGG Full Report
Revenue vs Cost
BRC→AGG Stock Flow
Product Analytics
Revenue, sell-through and cross-district product intelligence
Product Performance Matrix
Revenue by District — Stacked
Top Products Monthly Trend
Stock Intelligence
Live stock snapshot — BRC, product and district view
Stock by Product
Stock by District
BRC-wise Stock Ledger
Trends & Forecasts
Monthly, weekly, cumulative and seasonal patterns
Monthly Production, Sales & Revenue
Revenue by Day of Week
Cumulative Revenue
Monthly P&L
Daily Activity Heatmap — Last 90 Days
Alerts & Actions
Auto-generated decision intelligence
Critical
Watch List
Highlights
Mandal Drilldown
Sub-district level performance ranking
Production by Mandal
Revenue by Mandal
Mandal Performance Table
Farmer Sales Analytics
Every farmer transaction — daily, weekly, monthly, custom
Farmers Served per BRC (Top 10)
Sales Channel Breakdown
Daily Revenue Trend
Top Farmers by Revenue
BRC Farmer Reach
All Farmer Transactions
Notify BRC Workers
Send instant in-app messages to field workers
Compose
AI WRITER — describe what you want to say
Select recipients above
Sent History
Loading…
BRC Health Score
0–100 composite score per BRC. Tap any card to drill down.
Stock Expiry Calendar
Batches expiring across all BRCs in next 90 days
Revenue Velocity
Week-on-week and month-on-month change per BRC & district
Network Revenue — Last 8 Weeks
BRC Velocity Ranking
Inactive BRC Watch List
BRCs with no activity — one-tap to notify
Seasonal Demand Patterns
Which products sell in which months — plan production ahead
Monthly Sales Volume by Product
Peak Months per Product
Farmer Reach by Mandal
Unique farmers served vs BRC count — find under-served mandals
Farmers per Mandal
AGG ↔ BRC Supply Chain
Who buys from whom — volume, revenue, concentration risk
Top Aggregator Buyers
Target vs Actual
Production and sales achievement per BRC
Achievement % by BRC
Credit & Dues Overview
Outstanding dues from farmers — district-wise exposure
Dues by District
Side-by-Side Comparison
Compare any two districts or BRCs head-to-head
Price Trend Analysis
Average unit price per product over time — are farmers getting better prices?
Avg Unit Price — Monthly
Stock Turn Rate
Avg days from production to sale per product per BRC
Avg Days to Sell by Product
Cohort Analysis
Do older BRCs outperform newer ones? Is onboarding working?
Performance by BRC Age Group
Field Report Generator
One-click printable PDF for review meetings
Report Configuration
WhatsApp / SMS Report
Send weekly summary to BRC workers via WhatsApp — no API needed
Message Builder
Broadcast to All BRCs in District
Opens WhatsApp links for each BRC one by one — use for weekly broadcasts
BRC Network Map — Andhra Pradesh
Legend
Stock Loss Tracker
Damaged, expired, stolen product — real money lost across network
Loss by Reason
Loss by District
BRC Individual Profile
Select District → Mandal → BRC to view complete history
🌱
Select a District to begin
District → Mandal → BRC → Full Profile
Set Targets
Set production & revenue targets per BRC — feeds into Target vs Actual
Bulk Set by District
Individual BRC Target
Current Targets
Smart Alerts
Inline action — see an alert, act on it immediately
Multi-Year Comparison
Year-over-year revenue, production and farmer growth
Annual Revenue Comparison
Production by Year
Farmer Reach by Year
District Officer Accountability
SPMU view — how well is each district managed?
District Performance Index
Training Need Identifier
Which BRCs need sales training vs technical training vs both
Production vs Sell-Through Quadrant
Farmer Loyalty Analysis
Repeat vs one-time buyers — strongest quality indicator
Repeat vs One-Time
Most Loyal Farmers
Data Quality Monitor
Flag missing GPS, blank farmer names, zero prices — data hygiene
Network Effect Visualizer
BRC-to-BRC transfers, hub BRCs, isolated BRCs
Transfer Network (BRC → BRC)
🏆 Hub BRCs
🔴 Isolated BRCs
Farmer Registry
Complete farmer database across all BRCs — duplicates, reach, history
Farmers per District
Farmer Directory
Product Management
Add, edit, delete products — changes sync to all BRC apps instantly
Product Catalogue
Changes sync instantly to all BRC apps
NABARD Report Template
Auto-populated report in NABARD / APRIGP format — one click print or export
to
Click Generate to create the report
App Usage Analytics
Disabled to reduce data costs
Page-view tracking has been disabled
App usage analytics generated the largest share of database writes (one record per page navigation across 2,000+ BRCs) without affecting Health Scores, Watch Lists, or "last active" tracking — those are based on actual production & sales activity, not page views. Disabling this saves significant storage and bandwidth as the network scales.
Visit Register
All visits across BRC network — officials, farmers, NABARD
Visits by Type
Visits Over Time
All Visit Records
Advanced Query Builder
Custom filters · turnover ranges · district/mandal · analytics · Excel export
Query Filters
DISTRICT
MANDAL
PRODUCT
DATE FROM
DATE TO
DATE PRESETS
REVENUE PRESET
MIN REVENUE (₹)
MAX REVENUE (₹)
MIN PRODUCTION (units)
MIN FARMERS REACHED
SORT BY
ACTIVITY STATUS
MIN SELL-THROUGH %
LIMIT RESULTS
SHOW:
Revenue by District
Product Revenue Mix
Monthly Revenue Trend
Results by District
Results by Product
BRC Results — 0 found
CUSTOM SQL QUERY
Custom Supabase Query
Write any Supabase JS query — results appear belowQUICK TEMPLATES
SUPABASE QUERY (JavaScript)
Available tables:
brc_users, sales, production, v_master_stock,
agg_users, agg_sales, agg_production, stock_loss,
credits, visits, targets, products,
v_brc_map, v_district_spatial
BRC Performance Quadrant
Revenue vs Sell-Through — identify Stars, Cash Cows, Rising Stars and Laggards
Revenue vs Sell-Through Scatter
Dot size = farmers reached · Colour = quadrant
Stars — High Revenue + High S/T
Cash Cows — High Revenue, Low S/T
Rising Stars — Low Revenue, High S/T
Laggards — Low Revenue + Low S/T
Revenue Forecasting
3-month projection using linear regression on historical Supabase data
12-Month History + 3-Month Forecast
Dashed line = forecast · Shaded = confidence band
Monthly Breakdown + Forecast
District Efficiency Index
Composite score: Revenue per BRC + Sell-Through + Farmer Reach
Efficiency Index by District
Component Breakdown
District Efficiency Ranking
Product Demand Heatmap
Which product sells in which district in which month
Revenue Heatmap — Product × District
Darker = higher revenue
Seasonal Pattern — Product × Month
Multi-Product BRC Analysis
Does product diversification increase revenue? BRCs selling 2+ products vs single product
Avg Revenue by Product Count
BRC Distribution by Product Count
S/T % by Product Count
Top Multi-Product BRCs
Geographic Demand Gaps
Mandals with zero sales in last 90 days — potential expansion zones
Underserved Mandals — No Sales in 90 Days
Active Mandals — Sales in Last 90 Days
Full Mandal Coverage Report
AI Analytics Assistant
Ask anything about your BRC network — powered by Claude + live Supabase data
Ask:
ESC
↑↓ Navigate
Enter Run
ESC Close
Ctrl+Space Open
0 selected
Smart Alert Rules
Auto-detect when metrics cross your thresholds
Active Alert Rules
Triggered History (last 7 days)
Revenue Treemap
Product × District revenue — size = revenue, click to drill down
Revenue Treemap
Target Achievement Radial
District target vs actual — circular progress rings
District Target Achievement
My Dashboard
Pin and arrange widgets — drag to reorder
Split Screen Comparison
Compare two districts, BRCs or time periods side by side
LEFT PANEL
RIGHT PANEL
Left
Right
Revenue Comparison — Month by Month