-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDataset_Report.txt
More file actions
146 lines (131 loc) · 5.43 KB
/
Copy pathDataset_Report.txt
File metadata and controls
146 lines (131 loc) · 5.43 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
======================================================================
E-COMMERCE STORE — DATASET REPORT
Generated: June 2025 – December 2025
======================================================================
1. TABLE INVENTORY
--------------------------------------------------
category : 10 rows x 3 columns
seller : 20 rows x 3 columns
product : 60 rows x 8 columns
customer : 1,000 rows x 6 columns
address : 1,000 rows x 8 columns
cart : 800 rows x 5 columns
order_table : 700 rows x 6 columns
orderitem : 1,743 rows x 4 columns
payment : 700 rows x 5 columns
shipment : 490 rows x 9 columns
product_return : 70 rows x 9 columns
review : 209 rows x 5 columns
support_tickets : 175 rows x 11 columns
2. ORDER STATUS BREAKDOWN
--------------------------------------------------
Delivered : 420 (60.0%)
Cancelled : 140 (20.0%)
Returned : 70 (10.0%)
Pending : 70 (10.0%)
3. REVENUE SUMMARY
--------------------------------------------------
Total orders value : $674,798.90
Delivered revenue : $411,342.77
Avg order (Delivered) : $ 979.39
4. CATEGORY DISTRIBUTION (orders)
--------------------------------------------------
Electronics : 421.0 items | $288,945.79
Home & Kitchen : 440.0 items | $100,215.60
Footwear : 492.0 items | $ 59,150.08
Sports & Fitness : 420.0 items | $ 57,015.80
Beauty & Health : 471.0 items | $ 44,532.29
Automotive : 436.0 items | $ 43,875.64
Toys & Games : 462.0 items | $ 30,089.38
Clothing : 362.0 items | $ 25,246.38
Books : 459.0 items | $ 13,017.41
Food & Grocery : 447.0 items | $ 12,710.53
5. SELLER REVENUE SUMMARY
--------------------------------------------------
TechNova Ltd : $180,647.92
GadgetWorld GmbH : $108,297.87
HomeEssentials BV : $ 52,848.10
KitchenPro SpA : $ 47,367.50
FitZone Ltd : $ 46,342.81
StyleHub SAS : $ 42,886.86
GlowBeauty SAS : $ 38,729.64
DriveSmart LLC : $ 26,428.39
MegaStore Corp : $ 26,204.58
SoleKing Co : $ 24,377.53
6. PAYMENT METHOD DISTRIBUTION
--------------------------------------------------
Card : 184 (26.3%)
Cash on Delivery : 175 (25.0%)
Online : 173 (24.7%)
Wallet : 168 (24.0%)
7. DELIVERY PERFORMANCE BY COURIER
--------------------------------------------------
Courier Total OnTime Late AvgDays
-----------------------------------------------
Aramex 65 42 23 5.8d (65% on-time)
DHL 56 32 24 3.8d (57% on-time)
FedEx 67 39 28 3.5d (58% on-time)
GLS 71 43 28 5.1d (61% on-time)
Hermes 53 34 19 6.2d (64% on-time)
Royal Mail 60 38 22 4.5d (63% on-time)
UPS 56 40 16 4.6d (71% on-time)
USPS 62 35 27 5.0d (56% on-time)
8. RETURN & REFUND SUMMARY
--------------------------------------------------
Total returns : 70
Total refund amount : $21,821.72
Refund Completed : 46
Refund Pending : 19
Refund Rejected : 5
Top 5 return reasons:
Changed my mind : 12
Arrived too late : 9
Damaged packaging : 9
Item not as described : 8
Wrong item received : 7
9. SUPPORT TICKETS SUMMARY
--------------------------------------------------
Total tickets : 175
Closed : 98
In Progress : 46
Open : 31
SLA Breached Yes : 69
SLA Breached No : 106
Avg resolution hours : 58.6h
10. CUSTOMER AGE DISTRIBUTION
--------------------------------------------------
<25 : 88 (8.8%)
25-34 : 223 (22.3%)
35-44 : 229 (22.9%)
45-54 : 224 (22.4%)
55-64 : 211 (21.1%)
65+ : 25 (2.5%)
11. GEOGRAPHIC DISTRIBUTION (top 10 cities)
--------------------------------------------------
Lyon : 24
Manchester : 24
Ottawa : 22
Montreal : 21
Chicago : 21
Minneapolis : 21
Austin : 21
Jacksonville : 21
Vienna : 21
Vancouver : 21
12. REVIEW SUMMARY
--------------------------------------------------
Total reviews : 209
Average rating : 3.93 / 5.0
5-star: 76 (36.4%)
4-star: 72 (34.4%)
3-star: 40 (19.1%)
2-star: 12 (5.7%)
1-star: 9 (4.3%)
13. CART CONVERSION
--------------------------------------------------
Total carts : 800
Converted to orders : 700 (87.5%)
Abandoned carts : 100 (12.5%)
======================================================================
END OF REPORT
======================================================================