Date Daily Active Users Overall Orders Return Orders Net Orders New Installs

1/7/2022 63668 11065 3520 6656 10507

2/7/2022 60673 13161 3482 9241 17970
3/7/2022 62619 10299 1540 8506 11334
4/7/2022 59544 11262 2805 7787 14398
5/7/2022 60947 11618 4953 5683 16841
6/7/2022 63399 11750 3905 7285 17378
7/7/2022 61731 13703 4590 8747 15315
8/7/2022 62594 13210 2787 9442 15760
9/7/2022 64609 12196 4768 7082 13858
10/7/2022 62567 10398 4672 5622 16635
11/7/2022 63887 10153 3558 5775 18166
12/7/2022 59382 10952 4739 5234 14713
13/7/2022 62064 10628 3072 7278 10194
14/7/2022 119369 11554 1023 9721 13197
15/7/2022 58861 12736 4017 8450 19893
16/7/2022 65349 11951 4917 6253 15770
17/7/2022 71719 11947 4220 7229 12853
18/7/2022 68847 10411 4456 5131 14868
19/7/2022 67522 13174 1500 11079 14877
20/7/2022 65477 13550 4955 7814 19845
21/7/2022 72826 12016 2351 9039 18804
22/7/2022 75717 11682 4184 7185 10528
23/7/2022 70681 13851 1446 11587 19566
24/7/2022 69884 10184 2024 7350 14878
25/7/2022 72244 11068 4632 5755 11482
26/7/2022 71794 12178 4890 6491 14470
27/7/2022 74809 13663 4695 8509 17716
28/7/2022 77088 11702 4181 6614 10039
29/7/2022 79567 10281 3698 5931 14251
30/7/2022 82736 11266 4784 5510 14553
31/7/2022 70968 10138 2016 7451 18888
1/8/2022 79745 10571 4373 5566 15126
2/8/2022 75541 13421 1755 11512 17189
3/8/2022 81459 10447 3268 6586 12784
4/8/2022 90445 13637 4198 9245 12493
5/8/2022 88931 13914 4423 8517 10736
6/8/2022 47192 12933 4693 7684 10932
7/8/2022 92992 13721 1526 11686 14254
8/8/2022 118108 10392 2983 6580 14604
9/8/2022 96968 13803 2898 10447 16929
10/8/2022 97326 12313 3756 7720 16334
11/8/2022 109181 13203 4151 8676 14590
12/8/2022 121857 13935 2883 10861 11601
13/8/2022 117447 12338 1235 10780 16840
14/8/2022 106310 11461 3931 7320 11623
15/8/2022 113606 13164 3237 9117 16761
16/8/2022 96239 11899 2966 8520 18304
17/8/2022 100596 13940 3706 9491 13608
18/8/2022 90462 11674 4967 5829 14237
19/8/2022 98176 13428 2211 10872 18375
20/8/2022 98694 10611 3007 7112 11526
21/8/2022 75923 10712 3841 6567 12370
22/8/2022 72391 10708 1306 8917 19694
23/8/2022 67170 13113 3849 8308 10311
24/8/2022 69241 11014 4692 5866 19701
25/8/2022 81528 12377 4128 7887 11853
26/8/2022 89838 13752 1873 11102 16861
27/8/2022 67394 11440 1486 9194 17810
28/8/2022 78095 11020 1698 9128 11019
29/8/2022 71262 11935 3152 8376 17210
30/8/2022 67138 11987 2793 8586 16736
31/8/2022 73534 11751 3149 7861 18355
1/9/2022 69446 10081 1642 7656 11048
2/9/2022 68385 11602 2124 8687 17146
3/9/2022 70013 11052 1888 8612 19027
4/9/2022 66626 10403 1920 8327 13129
5/9/2022 66624 13605 2549 10073 13704
6/9/2022 66236 12818 4239 7808 18778
7/9/2022 63927 13182 4069 8427 16596
8/9/2022 69764 10844 3676 6814 18405
9/9/2022 57199 11132 3570 6888 10029
10/9/2022 56442 11157 1282 9041 18966
11/9/2022 55892 11667 4789 6637 11075
12/9/2022 56642 12268 3357 8109 11892
13/9/2022 52460 13300 1490 11681 16728
14/9/2022 72635 12625 1053 11302 18003
15/9/2022 67818 10734 4503 6059 19146
16/9/2022 59046 10052 1688 7827 12506
17/9/2022 55944 12673 2308 9645 13284
18/9/2022 57418 10825 2425 7985 13290
19/9/2022 55687 11088 1997 8620 18821
20/9/2022 53794 13958 2657 10697 10431
21/9/2022 69177 12388 3031 8461 14677
22/9/2022 71080 10153 2024 7204 16599
23/9/2022 57330 13433 3479 9803 16408
24/9/2022 52755 13878 1060 12036 15897
25/9/2022 52392 12513 2172 9381 13441
26/9/2022 53082 10094 3813 6069 19055
27/9/2022 53493 10738 3892 5897 13336
28/9/2022 63026 13283 2323 10591 16590
29/9/2022 75666 11821 3319 7812 17496
30/9/2022 71240 13723 4286 8909 10124
1/10/2022 75382 12158 2360 8914 16086
2/10/2022 82143 10593 4788 5487 18535
3/10/2022 70146 10464 2228 7815 13182
4/10/2022 76720 13898 3454 9800 19584
5/10/2022 75640 12217 2652 9026 16387
6/10/2022 80242 11106 3299 7323 18642
7/10/2022 79086 10260 4536 5237 15489
8/10/2022 66181 11225 3250 7127 13952
9/10/2022 62801 10726 2089 8453 15261
10/10/2022 62505 10395 3681 6057 11060
11/10/2022 58307 13638 4435 8861 10925
12/10/2022 56263 12835 3476 8422 11274
13/10/2022 63426 10486 4062 5972 16933
14/10/2022 65472 10807 4789 5399 11977
15/10/2022 71546 12642 1780 10327 18122
16/10/2022 72989 13016 3816 8823 18758
17/10/2022 82266 13656 2101 10905 12242
18/10/2022 92438 13543 3600 9080 11372
19/10/2022 74661 11346 2807 7876 16847
20/10/2022 91055 13866 1473 12242 12990
21/10/2022 86334 12857 2128 9794 12469
22/10/2022 82194 13995 4921 8333 12001
23/10/2022 102207 10638 2400 7318 12534
24/10/2022 91555 13588 4559 8779 12417
25/10/2022 90350 11376 4612 6282 17559
26/10/2022 111470 13321 1772 10582 11625
27/10/2022 104954 10862 1717 8641 19665
28/10/2022 96496 10960 1269 9510 10655
29/10/2022 126368 11618 1291 9519 17810
30/10/2022 105318 13724 1570 11632 16097
31/10/2022 89544 12144 3653 8186 18391
1/11/2022 72957 11360 2800 7761 17869
2/11/2022 98123 13535 1616 11114 11910
3/11/2022 83004 10386 4611 4882 11015
4/11/2022 74532 12552 3520 8638 12249
5/11/2022 75713 10697 1762 8400 18984
6/11/2022 73773 11538 1547 9403 15082
7/11/2022 72543 13893 3750 9788 13684
8/11/2022 71695 11653 2808 8138 10061
9/11/2022 70385 10958 2732 7381 19382
10/11/2022 69756 12517 2253 10161 18442
11/11/2022 72002 12185 4044 7503 13546
12/11/2022 69418 11577 4499 6821 18636
13/11/2022 63266 12481 3701 8531 14813
14/11/2022 62414 13070 1460 10733 10089
15/11/2022 61606 12701 4807 7300 14801
16/11/2022 67529 13550 2100 11243 10229
17/11/2022 69726 12333 2927 8658 17055
18/11/2022 70876 12446 3361 8514 14555
19/11/2022 79068 11641 4975 6470 16161
20/11/2022 91463 13671 2053 11128 18118
Conv % (order/DAU) AOV (sales/order) Net Sales Nav SignUp% Profile SignUp% Sign Up Rate
17.38% 105.16 1163614 0.86 3.02 20.68
21.69% 86.42 1137265 1.51 2.97 18.92
16.45% 103.55 1066627 1.61 2.30 23.09
18.91% 107.70 1212632 1.24 2.94 17.59
19.06% 97.27 1129922 1.51 2.61 22.51
18.53% 97.84 1149437 1.02 2.99 24.39
22.20% 79.77 1093155 0.86 2.65 24.17
21.10% 84.22 1112345 1.60 2.80 18.06
18.88% 81.65 995978 1.43 2.84 18.20
16.62% 100.87 1048921 1.12 2.37 23.18
15.89% 104.16 1057401 1.64 2.71 15.74
18.44% 94.95 1039679 1.25 2.98 19.07
17.12% 109.01 1158232 1.51 4.52 19.02
9.68% 115.84 1338518 1.59 4.40 24.78
21.64% 101.44 1292135 1.65 4.76 23.16
18.29% 112.14 1340356 2.66 5.34 15.75
16.66% 110.15 1316077 1.95 4.64 22.96
15.12% 115.91 1206539 1.69 6.31 23.37
19.51% 90.59 1193327 2.03 5.28 18.09
20.69% 94.06 1274270 2.09 5.37 16.31
16.50% 107.05 1286339 2.49 5.90 17.39
15.43% 133.28 1557125 1.62 5.64 15.43
19.60% 90.03 1247241 2.05 5.65 17.84
14.57% 128.92 1312716 2.55 6.24 23.66
15.32% 126.15 1396221 1.46 6.02 15.06
16.96% 111.36 1355894 2.46 5.65 23.00
18.26% 107.77 1472127 2.41 5.64 20.35
15.18% 126.25 1477421 2.19 6.25 22.26
12.92% 162.16 1667052 2.44 5.53 16.82
13.62% 179.43 2021936 2.29 5.75 23.37
14.29% 162.26 1645554 2.27 5.60 22.15
13.26% 193.90 2050381 1.78 5.51 18.62
17.77% 162.51 2181519 2.55 5.38 20.48
12.82% 209.46 2187411 2.09 5.52 19.84
15.08% 178.29 2431710 2.02 5.61 18.76
15.65% 164.50 2289442 2.55 5.35 16.13
27.41% 172.04 2225411 2.31 5.52 16.15
14.76% 176.27 2419414 2.51 5.32 19.92
8.80% 293.80 3053659 2.20 6.20 14.15
14.23% 188.84 2605715 2.10 5.59 20.10
12.65% 212.79 2619864 2.49 5.84 24.18
12.09% 247.64 3268805 2.19 5.92 16.25
11.44% 247.18 3445773 2.11 5.94 24.15
10.51% 259.76 3206354 1.61 5.55 24.71
10.78% 232.39 2663290 2.67 5.52 25.24
11.59% 189.36 2493314 1.92 6.11 26.84
12.36% 178.80 2126856 2.87 6.34 27.73
13.86% 142.18 1982423 2.52 6.05 30.56
12.90% 154.79 1806321 2.36 6.26 27.35
13.68% 141.90 1905751 2.21 6.36 26.60
10.75% 146.54 1554779 2.40 5.14 35.50
14.11% 119.92 1284644 1.22 3.46 25.89
14.79% 112.94 1209153 1.43 3.02 25.65
19.52% 87.97 1153363 1.18 2.52 25.96
15.91% 105.16 1158523 1.51 2.95 27.30
15.18% 111.93 1385260 0.93 3.11 25.11
15.31% 86.90 1195303 0.89 3.18 30.66
16.97% 102.43 1171515 1.24 2.48 30.53
14.11% 99.77 1099349 0.97 2.14 31.74
16.75% 106.28 1268543 1.13 2.34 35.08
17.85% 98.44 1179739 0.65 3.19 21.69
15.98% 135.48 1591951 1.24 3.01 37.82
14.52% 156.61 1579188 1.29 2.65 22.73
16.97% 123.93 1438149 1.66 2.88 31.75
15.79% 104.63 1156637 0.83 3.00 28.42
15.61% 126.10 1311431 1.60 2.94 25.28
20.42% 97.68 1328854 1.78 3.59 25.97
19.35% 90.88 1164800 0.83 3.04 20.17
20.62% 92.47 1218975 0.69 3.12 12.91
15.54% 102.95 1116133 1.30 3.83 14.35
19.46% 106.06 1180559 1.67 3.12 15.55
19.77% 119.17 1329728 0.77 3.27 10.12
20.87% 97.17 1133477 0.87 3.20 12.75
21.66% 96.85 1188244 1.37 3.83 12.07
25.35% 95.94 1275804 1.20 3.06 10.07
17.38% 123.54 1559588 1.72 2.97 15.14
15.83% 165.89 1780950 1.23 3.09 18.59
17.02% 129.31 1299485 1.62 2.81 10.31
22.65% 82.20 1041631 1.12 3.41 13.73
18.85% 100.54 1088135 1.07 2.99 12.17
19.91% 88.03 976009 0.98 3.65 11.26
25.95% 58.87 821839 1.82 3.47 17.54
17.91% 101.89 1262432 2.05 4.23 15.46
14.28% 141.95 1440852 1.40 4.07 12.50
23.43% 76.24 1024035 1.35 3.75 10.11
26.31% 72.79 1010319 1.82 3.51 9.98
23.88% 80.64 1008904 1.24 3.45 8.12
19.02% 115.27 1163754 1.09 2.74 9.68
20.07% 98.46 1057063 1.95 3.98 11.62
21.08% 100.63 1336976 1.19 3.49 17.50
15.62% 119.96 1417753 1.46 3.54 10.20
19.26% 100.19 1374631 1.02 3.84 10.09
16.13% 115.98 1410157 1.21 3.52 16.40
12.90% 152.36 1614472 1.18 2.79 18.16
14.92% 166.52 1742794 1.75 3.09 14.82
18.12% 116.09 1613878 1.46 3.20 11.65
16.15% 143.20 1749258 1.81 3.43 10.63
13.84% 191.74 2129388 1.36 3.10 14.65
12.97% 183.57 1882995 1.05 2.95 12.35
16.96% 128.62 1443630 1.80 2.77 11.80
17.08% 141.02 1512615 1.44 2.83 11.20
16.63% 134.86 1401798 0.92 2.93 10.13
23.39% 98.93 1349159 1.24 2.79 10.34
22.81% 127.13 1631532 2.09 4.97 14.83
16.53% 164.05 1719941 2.26 4.92 12.27
16.51% 190.71 2061436 1.89 6.12 15.97
17.67% 160.40 2027756 2.50 5.83 10.01
17.83% 160.24 2085310 2.39 5.80 9.91
16.60% 151.50 2068891 2.30 6.17 8.96
14.65% 176.01 2383524 2.84 6.17 10.44
15.20% 183.00 2076795 2.43 7.00 7.72
15.23% 175.34 2431596 2.09 5.67 12.23
14.89% 162.22 2085391 2.07 5.41 8.52
17.03% 151.31 2117929 2.53 6.05 7.15
10.41% 212.91 2265281 2.43 5.30 8.62
14.84% 193.66 2631202 2.36 5.17 8.63
12.59% 226.83 2580185 2.63 4.71 7.68
11.95% 204.39 2722548 2.14 5.65 11.20
10.35% 282.52 3068975 2.26 5.60 14.61
11.36% 226.38 2481596 2.03 5.38 14.57
9.19% 368.22 4276260 2.58 5.45 8.54
13.03% 250.19 3433404 2.60 5.25 17.15
13.56% 143.03 1736695 2.12 2.44 18.02
15.57% 164.27 1865983 2.30 3.89 15.14
13.79% 123.15 1666370 1.81 2.99 19.46
12.51% 150.80 1565863 1.31 2.67 16.44
16.84% 121.48 1524746 1.25 3.01 15.92
14.13% 158.45 1695146 1.41 3.11 15.80
15.64% 143.55 1656249 1.32 3.05 15.42
19.15% 99.46 1381723 1.26 2.80 18.70
16.25% 138.73 1616290 1.28 2.97 18.49
15.57% 148.19 1623984 1.37 2.57 17.68
17.94% 118.32 1480672 1.18 2.53 17.74
16.92% 127.25 1550273 1.60 2.48 15.38
16.68% 146.29 1693919 1.06 3.10 19.53
19.73% 104.70 1306927 1.63 2.92 16.82
20.94% 112.05 1464472 1.30 2.60 17.85
20.62% 95.24 1209891 1.10 2.65 19.72
20.07% 101.10 1370184 1.58 2.90 19.60
17.69% 101.33 1249890 1.63 2.81 15.59
17.56% 149.81 1864571 1.03 2.70 17.03
14.72% 261.05 3038275 1.98 3.20 15.63
14.95% 202.02 2762349 1.85 6.30 18.04
#DIV/0!
 In case any legacy data is needed, please feel free to
make assumptions
Provide while
a view for the answering the questions.
month-on-month average for
1 Specify
each the same
weekday, inany
for the3solution
relevantset.
sales data metrices,
What is the total expected forecast for Nov closure?
2 without
You are using
asked Pivot
by a Tables.
stake-holder if there are any
Feel free to use any predictive technique on Excel to
fluctuations
determine [Link] the Sign-Up Rate and what insights you
3
get from
Are therethe
anytrend of the same. How would
discrepencies/anomalies in theyou answer
data? If
4 that?
yes, how would you fix or clean up the same?
5 What insights can you draw from the overall dataset?