Smart Executive Insights
$0.00
$0.00
0.00%
COGS Ratio: 0%
0
Avg Order Value: $0.00
$0.00
Net yield per unit--
$0.00 volume--
$0.00 volume--
Revenue & Profit Over Time
Monthly chronological sales trajectories
Sales Channel Split
Online vs. Offline distribution
Product vs. Region Matrix Heatmap
Cross-tabulation of volume intensity across geographic markets
Revenue by Product Line
Regional Revenue Distribution
Units Sold vs Unit Price Bubble
Bubble size = Total Revenue
Advanced Sales Analytics
Comparative revenue vs profit correlation trajectories.
Monthly Revenue & Profit Multi-Axis Comparison
Order Transactions Logs
Filter, search, sort and manage active sales records.
| Date | Region | Product | Channel | Revenue | Profit | Units | Unit Price | Action |
|---|
Customers & CRM Hub
Customer Lifetime Value (CLV) & RFM Segmentation Matrix.
128 Clients
High frequency & spend$14,820
Per registered entity14 Accounts
No activity > 60 days68.4%
Strong retention yieldCustomer Directory & Spending History
| Customer Name | Region | Segment | Total Orders | Lifetime Spend | Status |
|---|---|---|---|---|---|
| Acme Global Enterprise | North America | VIP Tier | 24 Orders | $142,500.00 | Active |
| Apex Retail Partners | Europe (West) | Champion | 18 Orders | $98,400.00 | Active |
| Nexus Logistics Asia | Asia Pacific | At-Risk | 6 Orders | $34,100.00 | Review |
Products & Inventory Management
SKU cost margins, reorder thresholds, and live stock triggers.
| SKU Code | Product Name | Category | Cost Price | Selling Price | Margin % | Stock Level |
|---|---|---|---|---|---|---|
| SKU-EL-101 | Pro Laptop Workstation | Electronics | $850.00 | $1,299.00 | 34.5% | 420 Units (In Stock) |
| SKU-CL-204 | Executive Suit Apparel | Clothing | $45.00 | $120.00 | 62.5% | 12 Units (Low Stock) |
| SKU-HG-309 | Ergonomic Office Chair | Home Goods | $110.00 | $249.00 | 55.8% | 185 Units (In Stock) |
Marketing & Campaign Attribution
Return on Ad Spend (ROAS) & Customer Acquisition Cost (CAC).
$28,500.00
Google, Meta, Email Ads4.2x ROAS
$4.20 revenue per $1 ad spend$42.80
Cost per acquiring buyerAd Channel Performance Breakdown
| Ad Channel | Ad Spend | Revenue Generated | Net ROAS | Efficiency Rating |
|---|---|---|---|---|
| Google Search Ads | $12,000.00 | $58,200.00 | 4.85x | High Yield |
| Meta (Facebook / Instagram) | $10,500.00 | $38,100.00 | 3.62x | Optimal |
| Email Newsletters | $6,000.00 | $23,400.00 | 3.90x | Optimal |
User Accounts & Access Control (RBAC)
Team permissions, security roles, and sales leaderboard.
Active User Directory & Permission Levels
| User Name | Role Level | Status | |
|---|---|---|---|
| Sarah Jenkins | s.jenkins@salesiq.io | Super Admin | Active |
| David Miller | d.miller@salesiq.io | Sales Manager | Active |
| Alex Rivera | a.rivera@salesiq.io | Analyst | Active |
Data Integration & Ingestion Pipeline
Upload CSV/Excel files, sync live Google Sheets, or connect Hostinger MySQL endpoints.
CSV / Excel Spreadsheet
Parse structured sales data instantly from local files.
Google Sheets CSV Live Sync
Sync real-time data from published CSV endpoint.
Hostinger MySQL Sync
Connect to Hostinger PHP Bridge endpoint (`get_sales.php`).
Active Dataset Stream Preview
| Date | Region | Product | Channel | Revenue | Profit | Units | Unit Price |
|---|
System Configurations
Manage dashboard parameters, currency formatting, and local storage state.
Currency Display Symbol
Select standard currency symbol for monetary metrics.
Persist Local Dataset
Store uploaded CSV data in browser LocalStorage across sessions.