Orders & Intelligence
Sales closed on WhatsApp (from order tags)
| Salesperson | Orders | Survived | Killed | Revenue | AOV | Customers | Top governorate |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Chat activity (all conversations)
Inbound messages by hour (Cairo)
| Salesperson | Replies sent | Share | Conversations | Median response | Avg response | Templates | Active days | Last active | Assigned | Closed |
|---|---|---|---|---|---|---|---|---|---|---|
| Analyzing conversations… first run takes ~1 minute. | ||||||||||
Building the picture…
From ad to delivered order
Which traffic actually converts
| Source | Orders | Survived | Killed | Revenue |
|---|
Every order classified by the referrer it actually arrived with. Click a row to see them.
Session view (Shopify analytics)
| Source | Sessions | Conversion |
|---|
Abandoned checkouts — recoverable
| Customer | Value | Items |
|---|
Orders per day
Revenue per day
Records — all time
Day by day
| Day | Weekday | Orders | Revenue | AOV | Items | Cancelled | vs prev day |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
| SKU | Risk | Product | Variant | Shopify | Odoo | Price | |
|---|---|---|---|---|---|---|---|
| Reading Shopify inventory, Odoo stock and the Meta catalog… this takes ~40s. | |||||||
Acquisition funnel — Meta ads to paid orders
Where the money comes from vs where it's spent
| Governorate | Orders | Revenue | AOV | Ad spend | ROAS | Clicks | Clicks / order | Revenue vs spend |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Order health — what happens after checkout
How customers pay
When customers order (Cairo)
Top customers
| Customer | Governorate | Orders | Spent |
|---|
Best-selling products
| Product | Qty | Revenue | Top governorate |
|---|
| Order | Date (Cairo) | Customer | Phone | City | Items | Total | Payment | Fulfillment | |
|---|---|---|---|---|---|---|---|---|---|
| Loading orders from Shopify… | |||||||||