Overview
Store Info
Search and filter all scraped stores.
Store Map
View interactive map of store locations.
Store Insights
Analyze network growth and performance.
Peak Hours
Identify staffing needs based on transaction volume.
Inventory Health
Monitor days-to-stockout and critical items.
Sales Forecast
Predict future item demand dynamically.
Loading Store Data...
| Client ID | Name | DB Name | Server | City | State | Type | Status | Action |
|---|
Store Name
123 Main St, City, ST 12345
Client ID
--
Store Type
--
DB Name
--
Server
--
DB Engine
--
System Status
--
Exact Location
Analyzing Network Data...
Total Stores
--
0Avg Items / Store
--
Avg 30-Day Revenue
--
Network Growth (6-Month Trajectory)
Inventory Efficiency (Revenue vs Items)
Revenue by State Heatmap
Average Basket Value by Type
Store Distribution by State
Store Distribution by Type
30-Day Revenue Ranges
Top 10 Stores (by Revenue)
| Store Name | State | Type | Revenue | ABV |
|---|
Bottom 10 Stores (by Revenue)
| Store Name | State | Type | Revenue | ABV |
|---|
Client Growth Trends
Total Added
--
Total Churned
--
Net Growth
--
Loading Store Locations...
API Endpoint
/analytics/peak-hoursAnalyses transaction timestamps to identify peak and quiet hours, helping optimize staffing schedules.
Parameters
store_id |
string | Optional — Filter by store GUID |
days |
int | Lookback window in days (default: 30, max: 365) |
Example
curl "https://usp-lts.analytics.sypram.com/api/analytics/peak-hours?days=30&store_id=YOUR_STORE_GUID"
| Status | SKU | Item Name | Stock | Daily Sales | Days to Stockout |
|---|
API Endpoint
/analytics/inventory-healthCalculates estimated days until stockout by joining current inventory levels with average daily sales velocity from the last 30 days.
Parameters
store_id |
string | Required — Filter by store GUID |
limit |
int | Max results (default: 100, max: 1000) |
critical_threshold |
int | Days threshold for "critical" status (default: 7) |
Example
curl "https://usp-lts.analytics.sypram.com/api/analytics/inventory-health?store_id=YOUR_STORE_GUID&critical_threshold=7"
| Item A | Item B | Co-occurs | Support (%) |
|---|
API Endpoint
/analytics/market-basketFinds product associations by performing a self-join on transaction items grouped by transaction ID. Returns pairs of items that frequently appear in the same transaction.
Parameters
store_id |
string | Required — Store GUID (cross-join is too large without filter) |
min_support |
int | Minimum co-occurrence count (default: 5) |
limit |
int | Max results (default: 50, max: 500) |
Example
curl "https://usp-lts.analytics.sypram.com/api/analytics/market-basket?store_id=YOUR_STORE_GUID&min_support=5"
Card Volume
--
Transactions
--
Approval Rate
--
Decline Rate
--
Void Rate
--
Card Network Mix (by Volume)
Tender Mix (by Amount)
Recent Settlement Batches
| Batch ID | Txns | Amount | First Txn | Last Txn | Reconciled |
|---|
API Endpoints
/payments/{store_id}/card-mix · /tender-mix · /health · /batchesCard-processing analytics served from the ClickHouse warehouse: card-network volume mix, tender mix, approval/decline/void health, and settlement-batch reconciliation.
Parameters
store_id | path | Required — internal id or DB name |
days | int | Lookback window (default: 90, max: 1825) |
Example
curl "https://usp-lts.analytics.sypram.com/api/payments/STORE_1289/card-mix?days=90"
Total Customers
--
Active Customers
--
Identified Sales
--
Loyalty Members
--
Reward Txns
--
Points Issued
--
Points Redeemed
--
Loyalty is not configured for this store yet (beta rollout).
Top Customers (by Spend)
| # | Customer | Visits | Total Spend | Avg / Visit |
|---|
API Endpoints
/crm/{store_id}/summary · /loyalty · /top-customersCustomer base, identified-sales rate, loyalty points (beta), and the highest-spending customers — served from the ClickHouse warehouse.
Parameters
store_id | path | Required — internal id or DB name |
days | int | Lookback window (default: 90, max: 1825) |
limit | int | top-customers only (default: 20, max: 100) |
Example
curl "https://usp-lts.analytics.sypram.com/api/crm/STORE_1289/summary?days=90"
Store Percentile Ranks
--
| Metric | This Store | Peer Median | Percentile |
|---|
Fleet Leaderboard
| Rank | Store (DB Name) | Value |
|---|
API Endpoints
/benchmark/{store_id} · /benchmark/fleet · /benchmark/leaderboard/{metric}Cross-store competitive intelligence powered by
store_daily_metrics: percentile ranks vs. comparable stores and fleet leaderboards.
Parameters
store_id | path | Internal id or DB name (per-store ranks) |
metric | path | One of: avg_ticket, items_per_basket, gross_margin_pct, card_txn_pct, identified_pct, daily_revenue, daily_txns |
days | int | Lookback window (default: 30, max: 400) |
Example
curl "https://usp-lts.analytics.sypram.com/api/benchmark/STORE_1289?days=30"
API Endpoint
/forecast/weekly/{sku}Returns a 5-week Sun–Sat demand forecast for one or more SKUs using Meta's Prophet model. Supports batch requests with comma-separated SKU IDs.
Parameters
sku |
path | Required — Single SKU (e.g. 50000) or
comma-separated (e.g. 50000,77761) |
store_id |
string | Optional — Store GUID to scope the forecast |
force |
bool | Bypass cache and regenerate (default: false) |
Example
curl "https://usp-lts.analytics.sypram.com/api/forecast/weekly/50000?store_id=YOUR_STORE_GUID"
API Endpoint
/forecast/monthly/{sku}Returns a 3-month calendar demand forecast for one or more SKUs. Supports batch requests with comma-separated SKU IDs.
Parameters
sku |
path | Required — Single SKU (e.g. 50000) or
comma-separated (e.g. 50000,77761) |
store_id |
string | Optional — Store GUID to scope the forecast |
force |
bool | Bypass cache and regenerate (default: false) |
Example
curl "https://usp-lts.analytics.sypram.com/api/forecast/monthly/50000?store_id=YOUR_STORE_GUID"