> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# CloudHub Insights audit profile, Vortex IQ

> What the Vortex IQ CloudHub Insights health audit checks: CloudHub Operations

**[Nerve Centre KPIs](/nerve-centre/kpi-cards/cloudhub-insights) · [Audit Profile](/nerve-centre/kpi-cards/cloudhub-insights/audit) · [Sentiment Settings](/nerve-centre/kpi-cards/cloudhub-insights/sentiment)**

Audits multichannel operations health for CloudHub Insights - stock, despatch, listing, repricing and cross-channel revenue at risk - by running read-only T-SQL against the customer's 247Cxxxx database.

## What this audit checks

### Authentication & access

* TDS handshake succeeds at version 7.0 (server rejects 7.1+)
* Read-only login has SELECT on the configured database\_name (247Cxxxx)
* Validation query returns a row (SELECT TOP 1 CompanyName FROM CompanyDetails)

### Catalogue & inventory health

* Out-of-stock SKUs with open demand (MasterQuantity.AvailableQuantity `<=0`)
* Oversell risk - InfiniteQuantity = 1 with AvailableQuantity `<=0`
* SKUs without cost price (Inventory.CostPrice NULL or 0 - blocks margin)
* Stale inventory with stock on hand and no 30-day sales (masterinventory.Last30Day = 0)

### Order & fulfilment health

* Orders awaiting despatch in a non-dispatched OrderStage (OrderDetails Active = 1)
* Despatch backlog older than 48h (OrderStageChangeLog.CreatedOn)
* Despatch rate below threshold (dispatched orders / total via OrderStage.IsDispatched)
* Cancellation rate above expected band (cancelled OrderStage / total)

### Listings & catalogue accuracy

* Errored listings (ProductStatus.Status = 0) as a share of active SKUs
* Failed marketplace revisions (MarketPlaceListingDetails.RevisionResponse LIKE '%error%')
* SKUs without dimensions or weight breaking courier rating (Inventory Weight/Height/Length/Width NULL)

### Repricing & buybox

* Amazon buybox win rate below threshold (RepriceDailyReport.BuyboxOwner = 1 / total ASINs, 24h)
* Repricer coverage gap on active Amazon SKUs (RepricingInventory vs active Amazon SKUs)
* Overpriced SKUs losing the buybox (RepriceDailyReport.OverPricedCount)

### Cross-channel revenue at risk

* Out-of-stock SKUs still carrying active ad spend (cloudhub stockout JOIN amazon\_ads/google\_ads spend on sku/asin)
* Catalogue drift vs marketplace - price or title differs >20% (SalesLine.SKU JOIN shopify/bigcommerce product)
* Buybox lost on an ASIN that still has active Amazon ad spend (RepricerDaily JOIN amazon\_ads spend on asin)

## Data sources

Base URL: `mssql://{host}:{port}/{database_name}`

* `GET CompanyDetails` - Tenant identity + connection validation.
* `GET Report_SalesReport` - Revenue / margin / units (clean datetime + money).
* `GET OrderDetails` - Raw orders + stage; orderdate is varchar.
* `GET Invoice` - Order header, Prime/B2B flags, courier.
* `GET OrderStage` - IsDispatched flag for despatch / cancel rates.
* `GET OrderStageChangeLog` - Stage-change audit trail (backlog aging).
* `GET Inventory` - Cost price, dimensions, status per SKU.
* `GET MasterQuantity` - Live stock - stockout / backorder / oversell.
* `GET MarketPlaceListingDetails` - Listing + revision responses per marketplace.
* `GET ProductStatus` - Status = 0 marks an errored listing.
* `GET RepriceDailyReport` - Amazon buybox + repricer pressure.
* `GET Report_Products` - Pre-aggregated stock / PO snapshot.