Loading Fleet Overview...

Production Stores

--

demo / test / backup excluded

Active (60d)

--

-- of fleet

30-Day Network Revenue

--

Avg Revenue / Store

--

States Covered

--

DB Engines

--

Network Revenue Trend (6 Months)

Stores by Server

Store Distribution by State

Store Types

Fleet Activity

Top Performing Stores (30-Day Revenue)

#	Store Name	State	Type	Revenue	Avg Basket

Loading Store Data...

Showing 0 stores

Client ID	Name	DB Name	Server	City	State	Type	DB Version	Status	Action

Prev Page 1 Next

Back to Directory

Store Name

123 Main St, City, ST 12345

Client ID

--

Store Type

--

DB Name

--

Server

--

DB Engine

--

DB Version

--

System Status

--

View Store Analytics

Exact Location

Analyzing Network Data...

Total Stores

--

0

Avg 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...

Days Lookback

Store ID (Optional)

Update

API Endpoint

GET /analytics/peak-hours

Analyses 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"

Store ID *

Critical Threshold (Days)

Update

Status	SKU	Item Name	Stock	Daily Sales	Days to Stockout

API Endpoint

GET /analytics/inventory-health

Calculates 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"

Store ID *

Min Support

Update

Item A	Item B	Co-occurs	Support (%)

API Endpoint

GET /analytics/market-basket

Finds 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"

Store *

Days Lookback

Load

Select a store and click Load to view card-processing analytics.

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

GET /payments/{store_id}/card-mix · /tender-mix · /health · /batches

Card-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"

Store *

Days Lookback

Load

Select a store and click Load to view customer & loyalty analytics.

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

GET /crm/{store_id}/summary · /loyalty · /top-customers

Customer 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 (optional)

Days Lookback

Compare

Store Percentile Ranks

--

Metric	This Store	Peer Median	Percentile

Fleet Leaderboard

Daily Revenue Avg Ticket Items / Basket Gross Margin % Card Txn % Identified % Daily Txns

Rank	Store (DB Name)	Value

API Endpoints

GET /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"

Store *

SKU (Item ID) *

Forecast

API Endpoint

GET /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"

Store *

SKU (Item ID) *

Forecast

API Endpoint

GET /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"