Mockup v0.1

Reports

leo@petdayz.com Super Admin

Sales by country (30d)

Gross order value, MY domestic courier vs SG/BN DHL Express

MY RM68kSG S$4.2kBN B$980
MY
RM68,140 ยท 612 orders ยท domestic courier
SG
S$4,240 ยท 38 orders ยท DHL Express
BN
B$980 ยท 9 orders ยท DHL Express
ID
Price book disabled โ€” no orders yet

Sales by channel (30d)

Share of revenue by acquisition channel, all countries combined

Retail 46%Subscription 31%Stockist link 12%Agent link 7%Wholesale 4%
๐Ÿ“ˆ Subscription share is trending up โ€” 31% of channel revenue this period vs 27% the previous 30 days.

Points economy (30d)

PetPoints issued, redeemed and expired across all earn rules

Issued
214,300 pts
Redeemed
96,400 pts
Expired
8,100 pts
Net change
+109,800 pts
Total liability
1.24M pts โ‰ˆ RM62,000
Breakage rate
22%
๐Ÿ’ก Liability is booked monthly at close; the expiry job runs on the 1st (12-month rolling expiry from the month points were earned).

Referral program cost (30d)

Level 1 payouts vs revenue attributed to referred orders

L1 issued
38,400 pts โ‰ˆ RM1,920
Attributed rev.
RM12,800
Cost ratio
15.0%
Flagged / blocked
3 accounts
Clawbacks
2 orders
โš–๏ธ L2 (10%) and L3 (5%) remain dormant โ€” network keeps counting, payouts switch on automatically once the KPDN AJL licence is granted.

Subscription cohorts

Renewal-charge retention by signup month โ€” % of cohort still charging successfully

CohortStartedM1M2M3M4
Mar 202664 subs100%91%84%79%
Apr 202658 subs100%89%82%โ€”
May 202671 subs100%90%โ€”โ€”
Jun 202684 subs100%โ€”โ€”โ€”
๐Ÿ” M1 is the signup month itself (always 100%); blank cells mean the cohort hasn't reached that renewal yet.

Top products (30d)

Best sellers by revenue, retail + subscription combined

ProductUnitsRevenue% subscription
Deep Sea Fish Oil
412RM29,48038%
Joint Care
298RM21,35044%
Furbulous
261RM16,82029%
Goat Milk
233RM12,64022%
Probiotic Powder
198RM10,73031%
๐Ÿพ Static preview โ€” the real admin is Laravel Filament v4 (light + dark mode); every card maps to a Filament resource.