All data as at End of May 2023
Area |
Count |
Highlights |
177 |
Records: 20,773,274; Highest Records Table: Job Line: 2,428,967 records |
|
Table Occurrences |
1432 |
combined with base tables, this results in total tables of 1,609 |
Relationships |
1156 |
|
913 |
Approximately 138 are denoted as being for mobile devices |
|
Scripts |
3570 |
BIZLOG_companyAPIInt_shopify_get_Orders_ suppressui) Is the longest script with 737 active steps of code Mean average is 23 steps |
583 |
15 Inactive 356 external accounts for cport |
|
303 |
149 are user custom level (rest system level) Most populated custom lists are location related with 188 values Mean average is 11 values |
|
Database Size |
20GB |
This is the strokeone filemaker size |
Container Size |
7TB |
This is the contents of the filemaker containers which are stored outside the filemaker server on an external RAID The filepath to the RAID and the folder structure within it are defined within strokeone |
Month / Year |
2019 |
2020 |
2021 |
2022 |
2023 |
Grand Total |
Jan |
117 |
174 |
190 |
170 |
162 |
813 |
Feb |
176 |
222 |
189 |
168 |
134 |
889 |
Mar |
133 |
114 |
222 |
192 |
167 |
828 |
Apr |
180 |
15 |
170 |
192 |
149 |
706 |
May |
129 |
22 |
216 |
163 |
206 |
736 |
Jun |
208 |
82 |
191 |
184 |
16 |
681 |
Jul |
219 |
126 |
215 |
155 |
|
715 |
Aug |
266 |
69 |
250 |
203 |
|
788 |
Sep |
249 |
107 |
208 |
176 |
|
940 |
Oct |
274 |
204 |
209 |
176 |
|
1,088 |
Nov |
240 |
218 |
210 |
189 |
|
1,077 |
Dec |
97 |
112 |
103 |
81 |
|
503 |
Grand Total |
2,288 |
1,465 |
2,373 |
2,049 |
834 |
9,790 |
Enquiry to Job Conversion Rates
Month/year |
2019 |
2020 |
2021 |
2022 |
2023 |
Jan |
0% |
8% |
50% |
54% |
59% |
Feb |
0% |
29% |
54% |
64% |
60% |
Mar |
0% |
27% |
59% |
63% |
54% |
Apr |
0% |
93% |
59% |
61% |
53% |
May |
0% |
14% |
65% |
55% |
46% |
Jun |
0% |
0% |
58% |
62% |
19% |
Jul |
0% |
0% |
61% |
70% |
|
Aug |
0% |
0% |
57% |
56% |
|
Sep |
0% |
1% |
60% |
63% |
|
Oct |
3% |
25% |
67% |
60% |
|
Nov |
1% |
58% |
61% |
67% |
|
Dec |
1% |
57% |
50% |
63% |
|
Average |
0% |
26% |
58% |
61% |
49% |
| Row Labels | 2020 |
2021 |
2022 |
2023 |
Grand Total |
Jan |
231 |
494 |
426 |
418 |
1569 |
Feb |
210 |
421 |
399 |
415 |
1445 |
Mar |
59 |
509 |
512 |
477 |
1557 |
Apr |
15 |
369 |
454 |
480 |
1318 |
May |
27 |
415 |
340 |
603 |
1385 |
Jun |
154 |
462 |
383 |
50 |
1050 |
Jul |
209 |
536 |
342 |
|
1087 |
Aug |
87 |
631 |
445 |
|
1163 |
Sep |
149 |
487 |
447 |
|
1083 |
Oct |
453 |
507 |
473 |
|
1433 |
Nov |
485 |
499 |
436 |
|
1420 |
Dec |
268 |
297 |
159 |
|
724 |
| Grand Total | 2347 |
5627 |
4816 |
2443 |
15280 |
Year |
Fulfilment |
Job |
Webstore |
Cport |
Grand Total |
2019 |
1602 |
18965 |
1454 |
3152 |
25174 |
2020 |
737 |
10055 |
2730 |
1131 |
14654 |
2021 |
642 |
13263 |
9141 |
1042 |
24089 |
2022 |
787 |
12011 |
7585 |
2691 |
23074 |
to 5/2023 |
375 |
5321 |
2356 |
1465 |
9518 |
Grand Total |
4150 |
59650 |
23267 |
9481 |
96552 |
Expand to see breakdowns by Month
Year |
Screen Print |
DTG |
Embroidery |
Heat Press |
Other Processes |
Grand Total |
2019 |
20,120 |
12,513 |
8,945 |
485 |
11,339 |
53,402 |
2020 |
9,238 |
23,787 |
6,439 |
313 |
8,686 |
48,463 |
2021 |
12,011 |
30,549 |
8,791 |
676 |
16,694 |
68,721 |
2022 |
14,115 |
24,072 |
9,195 |
772 |
14,687 |
62,841 |
2023 |
6,924 |
6,453 |
3,889 |
420 |
6,388 |
24,074 |
Grand Total |
62,408 |
97,375 |
37,259 |
2,666 |
57,794 |
257,502 |
Size / Mesh count |
In Use |
Std 10 |
8 |
Std 49 |
1241 |
std 62 |
1468 |
std 90 |
503 |
Std 120 |
1183 |
std 120S |
246 |
Back Neck 49 |
68 |
Back Neck 62 |
402 |
Back Neck |
12 |
|
5,131 |
Metric |
Value |
Locations In use |
148 |
Sets Stored |
961 |
Total stencils for sets |
3049 |
Actual stencils stored |
3012 |
Partial sets |
30 |
Mean stencils per set |
3 |
Max stencils in set |
15 |
Row Labels |
2019 |
2020 |
2021 |
2022 |
2023 |
Jan |
1,377 |
1,133 |
1,078 |
1,053 |
1,172 |
Feb |
1,654 |
1,538 |
992 |
1,179 |
1,167 |
Mar |
1,496 |
924 |
1,363 |
1,360 |
1,375 |
Apr |
1,516 |
186 |
1,338 |
1,327 |
1,151 |
May |
2,052 |
370 |
1,227 |
1,560 |
1,570 |
Jun |
1,998 |
867 |
1,581 |
1,358 |
120 |
Jul |
2,024 |
1,146 |
1,155 |
1,300 |
|
Aug |
1,643 |
984 |
1,373 |
1,350 |
|
Sep |
1,662 |
1,097 |
1,776 |
1,439 |
|
Oct |
1,991 |
1,200 |
1,492 |
1,380 |
|
Nov |
1,988 |
1,516 |
1,766 |
1,534 |
|
Dec |
1,144 |
1,386 |
1,177 |
908 |
|
Grand Total |
20,545 |
12,347 |
16,318 |
15,748 |
6,555 |
Type |
2019 |
2020 |
2021 |
2022 |
2023 |
Blank Garment |
16,021 |
10,206 |
13,466 |
11,860 |
4,740 |
Printed Garment |
2,730 |
871 |
869 |
2,128 |
1,039 |
Consumable |
702 |
349 |
384 |
467 |
219 |
Peripheral |
439 |
312 |
407 |
506 |
169 |
Digitisation/Subbed Art |
|
148 |
248 |
273 |
142 |
Returns |
|
22 |
532 |
4 |
1 |
Purchased Screen Ink |
146 |
99 |
124 |
107 |
64 |
Maintenance Materials |
101 |
123 |
92 |
130 |
49 |
Support Item |
164 |
39 |
26 |
93 |
42 |
Embroidery thread |
58 |
48 |
68 |
64 |
10 |
Cleaning Supplies |
44 |
45 |
66 |
34 |
37 |
General Item |
5 |
29 |
22 |
38 |
24 |
Digitisation |
77 |
30 |
|
|
|
Blank Screen |
43 |
12 |
6 |
31 |
13 |
Merchandise |
8 |
6 |
7 |
11 |
1 |
ink |
1 |
4 |
1 |
2 |
1 |
(blank) |
4 |
|
|
|
|
Printed Screen |
|
2 |
|
|
1 |
Mixed Screen Ink |
2 |
|
|
|
|
Stationery |
|
|
|
|
2 |
IT |
|
2 |
|
|
|
Screen Frame |
|
|
|
|
1 |
Grand Total |
20,545 |
12,347 |
16,318 |
15,748 |
6,555 |
Type / Year |
2019 |
2020 |
2021 |
2022 |
2023 |
Blank Garment |
3,203,774 |
1,403,724 |
2,107,168 |
2,716,271 |
1,290,764 |
Printed Garment |
2,557,809 |
333,434 |
357,441 |
1,531,096 |
927,337 |
Peripheral |
1,418,230 |
572,753 |
1,574,221 |
1,282,559 |
399,496 |
Consumable |
210,462 |
222,737 |
462,923 |
183,044 |
105,079 |
Merchandise |
115,266 |
6,103 |
3,124 |
909 |
125 |
Support Item |
91,375 |
15,135 |
1,437 |
1,224 |
312 |
Purchased Screen Ink |
3,821 |
1,155 |
1,632 |
3,242 |
1,453 |
General Item |
564 |
270 |
5,602 |
3,319 |
1,053 |
Blank Screen |
3,340 |
873 |
257 |
2,866 |
1,054 |
ink |
8 |
7,224 |
1 |
6 |
6 |
Cleaning Supplies |
2,642 |
701 |
1,973 |
566 |
512 |
Maintenance Materials |
458 |
467 |
535 |
1,726 |
447 |
Returns |
|
21 |
778 |
1,622 |
300 |
Embroidery thread |
396 |
1,050 |
355 |
326 |
47 |
Digitisation/Subbed Art |
|
157 |
258 |
331 |
159 |
Printed Screen |
|
151 |
|
|
144 |
Screen Frame |
|
|
|
|
200 |
(blank) |
158 |
|
|
|
|
Digitisation |
105 |
33 |
|
|
|
Stationery |
|
|
|
|
48 |
Mixed Screen Ink |
41 |
|
|
|
|
IT |
|
4 |
|
|
|
Grand Total |
7,608,449 |
2,565,992 |
4,517,705 |
5,729,107 |
2,728,536 |
Year |
Cport |
Webstores |
Print & Decoration Business |
Grand Total |
2019 |
6155 |
4705 |
13244 |
24,105 |
2020 |
1705 |
27881 |
6880 |
36,468 |
2021 |
1171 |
47694 |
8757 |
57,622 |
2022 |
2879 |
47877 |
7817 |
58,578 |
to 5/2023 |
1443 |
9356 |
3262 |
14,061 |
Expand to see breakdowns by Month
Year |
Job |
Webstore |
Storage Charge |
Fulfilment |
Webstores |
PO Charge |
Handling Charges |
Grand Total |
2019 |
19,220 |
832 |
609 |
591 |
70 |
224 |
|
21,546 |
2020 |
9,947 |
698 |
513 |
167 |
188 |
77 |
|
11,590 |
2021 |
13,321 |
1,016 |
458 |
151 |
196 |
12 |
14 |
15,168 |
2022 |
12,539 |
1,036 |
470 |
304 |
26 |
1 |
71 |
14,447 |
2023 |
5,205 |
352 |
219 |
234 |
11 |
1 |
16 |
6,038 |
Grand Total |
60,232 |
3,934 |
2,269 |
1,447 |
491 |
315 |
101 |
68,789 |
Invoice Records: By Invoiced Amount
Year / Type |
Job |
Webstores |
Storage Charge |
Fulfilment |
Handling Charges |
PO Charge |
Grand Total |
2019 |
£ 9,429,202.99 |
£ 128,646.27 |
£ 256,234.09 |
£ 96,066.29 |
|
£ 26,376.00 |
£ 9,936,525.64 |
2020 |
£ 4,671,987.03 |
£ 256,790.90 |
£ 214,092.56 |
£ 33,179.63 |
|
£ 5,282.60 |
£ 5,181,332.72 |
2021 |
£ 6,097,981.03 |
£ 542,578.03 |
£ 160,070.98 |
£ 27,403.98 |
£ 955.00 |
£ 1,260.00 |
£ 6,830,249.02 |
2022 |
£ 11,438,350.10 |
£ 539,374.34 |
£ 162,653.21 |
£ 98,386.53 |
£ 14,119.48 |
£ 125.00 |
£ 12,253,008.66 |
2023 |
£ 4,327,665.99 |
£ 116,734.26 |
£ 115,335.30 |
£ 53,708.23 |
£ 8,748.35 |
£ 231.25 |
£ 4,622,423.38 |
Grand Total |
£ 35,965,187.14 |
£ 1,584,123.80 |
£ 908,386.14 |
£ 308,744.66 |
£ 23,822.83 |
£ 33,274.85 |
£ 38,823,539.42 |
Item Type |
Count of items with Zero Balance |
Count of items with Non Zero Balance |
Grand Total |
Printed Garment |
507,383 |
21,711 |
529,094 |
Blank Garment |
105,537 |
7,709 |
113,246 |
Peripheral |
5,256 |
1,951 |
7,207 |
Mixed Screen Ink |
3,399 |
2 |
3,401 |
Consumable |
576 |
698 |
1,274 |
Support Item |
786 |
152 |
938 |
Maintenance Materials |
635 |
48 |
683 |
Embroidery thread |
88 |
459 |
547 |
Purchased Screen Ink |
124 |
126 |
250 |
Merchandise |
102 |
108 |
210 |
ink |
106 |
|
106 |
Cleaning Supplies |
44 |
56 |
100 |
General Item |
74 |
17 |
91 |
(blank) |
55 |
1 |
56 |
Blank Screen |
8 |
16 |
24 |
Bundle |
11 |
6 |
17 |
Stationery |
4 |
6 |
10 |
Screen Frame |
2 |
3 |
5 |
Digitisation/Subbed Art |
2 |
|
2 |
Plastisol |
1 |
|
1 |
Don't Get Cocky T Shirt |
1 |
|
1 |
Grand Total |
624,194 |
33,069 |
657,263 |
Metric |
Records with zero or below balance |
Records with Positive balance |
Grand Total |
Location Records |
2,714 |
37,879 |
40,593 |
Locations |
116 |
4,198 |
4,314 |
SKU |
2,645 |
33,365 |
36,311 |