Demented World
Ops system
DashboardOrdersCustomersProductsDropsConversion funnelWhatsAppCustomer satisfactionAdsFinancialsAI CEORules & formulasSettingsBrand OS
admin
Demented World · Ops

Daily digest

2026-06-29
Live · refreshes every 30s

01Action required · 2

EGP 27,060 frozen in dead stock (4 SKUs, 4 over 90 days)View →
Cancellation rate 50.3% — above 15% threshold (346/688 orders)

02Today

Revenue
EGP 0
no change
Orders
0
no change
New customers
0
no change
Meta spend
EGP 0
ROAS
—
AOV
—
Conversion
—
Clicks
0

03This weekvs last week

Revenue
EGP 0
flat
Orders
0
flat
AOV
—
flat
ROAS
—
flat
Cancel rate
—
flat
Return rate
—
flat
Daily revenue · last 14 days
2026-06-16today

04What's comingAll drops →

Next launch
MINIMALISM
2026-07-01 · in 2d · planned
Open drop →
#02MARKED in researchin 33d

05Lifetime · everything to datesince shop opened

Total orders
688
Successful
328
47.7% of all orders
Cancelled
346
50.3% of all orders
RTO
47
returned by courier
Returned items
1
EGP 900
Pending
4
not yet shipped/cancelled
Net revenue
EGP 264,256
gross EGP 264,256
COGS
EGP 70,870

06Channels · All time

TodayYesterday7d30dAll time
Meta ads
Spend
EGP 49,818
Revenue
EGP 291,539
ROAS
5.85×
Purchases
242
Meta's own attribution (post-view + post-click)
Direct / organic
Revenue
EGP 0
Purchases
86
Total revenue − Meta-attributed (organic + direct + email)

07System

Sheet read at
29/06/2026, 21:16:47
Shopify webhooks
real-time
Bosta sync
every 30 min · GitHub Actions
Meta Ads sync
every hour · GitHub Actions
Pixel rollup
daily at 03:00 UTC · GitHub Actions
Gross profit
EGP 193,386
73.2% margin
AOV
EGP 806
Customers
1,134
Repeat buyers
20
1.8% repeat rate
VIPs
4
3+ orders OR 3k+ EGP spend
SKUs (active)
25 / 25
Lifetime ad spend
EGP 49,818
Lifetime ROAS
5.85×
EGP 291,539 attributed
CAC
EGP 152
ad spend / successful orders