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

Showing 0 stores

Client ID	Name	DB Name	Server	City	State	Type	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

--

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"