Bitcointalk Mobile Browser presented by IRLBTC™

>> (p.1)

Author

Topic: Impression counts for ads over years (Statistics) (Read 1012 times)

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Impression counts for ads over years (Statistics)

December 31, 2019, 07:44:39 AM
Last edit: January 03, 2020, 08:30:06 AM by tranthidung

Merited by dbshck (8), hatshepsut93 (1), bitserve (1)

The forum celebrated its 10^th anniversary weeks ago, and today I am going to give you the statistics on four indicators of the forum ads.

Updates will be made in new posts, each 6-months.

ABSTRACT

The all-time-highs for four indicators: Daily total impressions (374975, in 2018), Daily total impressions from logged-in users (101513, in 2019), Daily unique IPs from logged-out users (39292, in 2018), Daily unique logged-in users (3386, in 2017) (Details)
There are 270 rounds in total (from 4/4/2012 to 22/12/2019), but I used only 269 rounds for the analysis (round 74 is missing or data-error).
Statistics for period of each round: median (10 days); min (3.5 days); max (24.4 days).
There are three periods, in which 4 indicators changed dramatically: 2012- 2013; 2014 - 2016; and 2017 - 2019.
With the period 2012 - 2013 as a reference group, we have the increasing-times of each indicators for the rest two periods as follow (Details):
- Daily total impressions: 2014 - 2016 (5.9-fold), 2017 - 2019 (15.6-fold).
- Daily total impressions from logged-in users: 2014 - 2016 (3-fold), 2017 - 2019 (13-fold).
- Daily unique IPs from logged-out users: 2014 - 2016 (2.8-fold), 2017 - 2019 (5-fold).
- Daily unique logged-in users: 2014 - 2016 (2.6-fold), 2017 - 2019 (7.1-fold).
Each month (in median), there are about 11300 new accounts registered.

Data:

Ads stats: https://bitcointalk.org/adrotate.php?adstats
BTC close price: https://coinmarketcap.com/currencies/bitcoin/historical-data/
Number of monthly registered accounts: Assumed monthly statistics on registered accounts of bitcointalk.org (2009-2019)

Time-series plots:
I added BTC close price to these plots, but I used its close price * 10 or 20 (see the note below each plots) in order to have better visual presentation on plots.
A reminder for you: these red vertical lines are days on which the merit system kicked-off (24/1/2018), and the enhanced merit system activated (17/9/2018).

For all 4 indicators + monthly registered accounts:

Then, I splited them into 2 parts, with each set of 2 indicators presented in the same plots.

Statistics:
There are 270 rounds of ads from 4/4/2012 (round 27) to 22/12/2019 (round 293). I decided to drop round 26 (incomplete) and round 74 (likely missing or error data). So, finally, we have 269 rounds in total.

How long each round usually lasts? 10 days in median. Min and max are 3.5 and 24.4 days, respectively.

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
period | 269.0 10.4 2.9 10.0 8.5 11.1 3.5 24.4
----------------------------------------------------------------------------------------------

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
mimpressions | 269.0 163724.4 125747.3 123331.1 61236.5 264177.8 6058.1 526107.3
mliuser_im~s | 269.0 38475.7 35797.1 21049.6 14376.6 58683.1 1795.2 143663.0
muniqueip | 269.0 17928.8 17796.4 11877.3 8981.7 19462.9 1731.5 116833.1
muniqueliu~s | 269.0 2374.3 2251.7 1606.4 1051.9 2566.0 281.3 11121.2
regacc | 123.0 21856.6 33196.9 11318.0 2661.0 24213.0 3.0 238433.0
----------------------------------------------------------------------------------------------

The plots show that there are some different periods, in which stats changed dramatically. From that findings, I categorised the period into three parts:

Code:

period_grp | Freq. Percent Cum.
------------+-----------------------------------
2012 - 2013 | 78 29.00 29.00
2014 - 2016 | 91 33.83 62.83
2017 - 2019 | 100 37.17 100.00
------------+-----------------------------------
Total | 269 100.00

Now, let's see how stats for each indicator changed over years.

1. Daily total impressions

Code:

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 35142.8 26478.3 20509.0 15828.5 50788.7 6058.1 120381.3
2014 - 2016 | 91.0 121493.1 18637.8 120237.0 110620.4 130868.0 40761.9 162669.1
2017 - 2019 | 100.0 302448.6 88542.9 319896.9 244191.7 369530.6 86717.0 526107.3
------------+--------------------------------------------------------------------------------
Total | 269.0 163724.4 125747.3 123331.1 61236.5 264177.8 6058.1 526107.3
---------------------------------------------------------------------------------------------

2. Daily total impressions from logged-in users

Code:

Summary for variables: mliuser_impressions
by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 10974.5 8437.0 5754.0 3981.5 18638.2 1795.2 37228.7
2014 - 2016 | 91.0 24499.6 14013.9 17464.6 14943.6 32439.4 9094.0 69853.3
2017 - 2019 | 100.0 72644.9 35780.9 75361.7 39101.4 103218.2 10015.6 143663.0
------------+--------------------------------------------------------------------------------
Total | 269.0 38475.7 35797.1 21049.6 14376.6 58683.1 1795.2 143663.0
---------------------------------------------------------------------------------------------

3. Daily unique IPs from logged-out users

Code:

Summary for variables: muniqueip
by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 7434.3 6670.0 4068.8 2936.7 9382.3 1731.5 34218.2
2014 - 2016 | 91.0 12836.3 5091.3 11228.5 9972.1 14889.6 5615.3 28277.0
2017 - 2019 | 100.0 30748.5 22860.0 20178.0 15412.5 42938.8 8474.1 116833.1
------------+--------------------------------------------------------------------------------
Total | 269.0 17928.8 17796.4 11877.3 8981.7 19462.9 1731.5 116833.1
---------------------------------------------------------------------------------------------

4. Daily unique logged-in users

Code:

Summary for variables: muniqueliusers
by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 858.7 608.4 456.4 390.8 1407.4 281.3 2509.7
2014 - 2016 | 91.0 1656.1 717.5 1470.4 1203.0 1962.7 716.1 3811.6
2017 - 2019 | 100.0 4210.0 2698.4 3249.7 2003.6 6213.5 1235.9 11121.2
------------+--------------------------------------------------------------------------------
Total | 269.0 2374.3 2251.7 1606.4 1051.9 2566.0 281.3 11121.2
---------------------------------------------------------------------------------------------

They are raw statistics, but you can see that all indicators have stats increased exponentially (2 to 4.3 times) over years, between three periods (2012 - 2013, 2014 - 2016, and 2017 - 2019). As always, for an overview, I would like to look at the medians (p50), not means.

My idea to create my thread came from this one: [Chart] Bitcointalk statistics on impression counts for ads for a quite some time (months) ago. Honestly I was too lazy to do it but now I made it and hope that my thread adds some additional details, and expands the thread of Coin-1 a little bit.

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

▄▄██▀███▀███▄▄
▄████░░▀░▄█████▄
▄█████░█▄▀█░█████▄
███████▀░▄░░██████
▐███████▄███▄██████▌
███████████████████
███████████████████
███████████████████
▐█████████████████▌
▀███████████████▀
▀█████████████▀
███████████████
▄████████████████████▄

████
██
██
██
██
██
██
██
██
██
██
██
████

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

Blitzboy

Hero Member

Offline

Activity: 1344
Merit: 565

Leading Crypto Sports Betting & Casino Platform

Re: Impression counts for ads over years (Statistics)

December 31, 2019, 07:52:02 AM

I know your work is useful for the community, but I'm curious, what exactly is it working for? Is it information for businesses to come here, see the details and decide to hire ads? If I get it wrong, please give me the answer, I see many similar posts of you here

..^Stake.com..

▄████████████████████████████████████▄ ██ ▄▄▄▄▄▄▄▄▄▄ ▄▄▄▄▄▄▄▄▄▄ ██ ▄████▄ ██ ▀▀▀▀▀▀▀▀▀▀ ██████████ ▀▀▀▀▀▀▀▀▀▀ ██ ██████ ██ ██████████ ██ ██ ██████████ ██ ▀██▀ ██ ██ ██ ██████ ██ ██ ██ ██ ██ ██ ██████ ██ █████ ███ ██████ ██ ████▄ ██ ██ █████ ███ ████ ████ █████ ███ ████████ ██ ████ ████ ██████████ ████ ████ ████▀ ██ ██████████ ▄▄▄▄▄▄▄▄▄▄ ██████████ ██ ██ ▀▀▀▀▀▀▀▀▀▀ ██ ▀█████████▀ ▄████████████▄ ▀█████████▀ ▄▄▄▄▄▄▄▄▄▄▄▄███ ██ ██ ███▄▄▄▄▄▄▄▄▄▄▄▄ ██████████████████████████████████████████

Play
Smarter

▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄ █ ▄▀▄ █▀▀█▀▄▄ █ █▀█ █ ▐ ▐▌ █ ▄██▄ █ ▌ █ █ ▄██████▄ █ ▌ ▐▌ █ ██████████ █ ▐ █ █ ▐██████████▌ █ ▐ ▐▌ █ ▀▀██████▀▀ █ ▌ █ █ ▄▄▄██▄▄▄ █ ▌▐▌ █ █▐ █ █ █▐▐▌ █ █▐█ ▀▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀█

Leading Crypto Sports Betting
&&&&& Casino Platform

▄▄█████████▄▄ ▄██▀▀▀▀█████▀▀▀▀██▄ ▄█▀ ▐█▌ ▀█▄ ██ ▐█▌ ██ ████▄ ▄█████▄ ▄████ ████████▄███████████▄████████ ███▀ █████████████ ▀███ ██ ███████████ ██ ▀█▄ █████████ ▄█▀ ▀█▄ ▄██▀▀▀▀▀▀▀██▄ ▄▄▄█▀ ▀███████ ███████▀ ▀█████▄ ▄█████▀ ▀▀▀███▄▄▄███▀▀▀

..^{PLAY NOW}..

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

December 31, 2019, 07:52:21 AM

Converted dataset:
* Stats are means of all slots in each rounds.

Code:

. list round mimpressions mliuser_impressions muniqueip muniqueliusers, abb(30)

   +-------------------------------------------------------------------------+
   | round mimpressions mliuser_impressions muniqueip muniqueliusers |
   |-------------------------------------------------------------------------|
  1. | 27 10396.15 3607.76 1916.57 293.34 |
  2. | 28 9327.17 3482.07 1910.51 291.33 |
  3. | 29 10140.64 3324.5 1936.89 281.31 |
  4. | 30 10825.75 3340.91 2008.36 304.85 |
  5. | 31 10017.87 3544.83 2029.62 304.41 |
   |-------------------------------------------------------------------------|
  6. | 32 12076.05 3981.47 2704.15 328.28 |
  7. | 33 11542.58 3838.12 2168.8 324.34 |
  8. | 34 12433.63 3840.39 2450.02 328.13 |
  9. | 35 11329.86 3879.17 2113.89 332.21 |
10. | 36 14666.46 4280.32 2230.75 337.85 |
   |-------------------------------------------------------------------------|
11. | 37 14850.75 4951.34 2272.89 307.78 |
12. | 38 14695.52 4627.15 2307.02 358.06 |
13. | 39 14196.71 4506.88 2231.86 324.53 |
14. | 40 16064.9 4518.68 2754.97 328.18 |
15. | 41 14792.36 4583 2829.13 346.71 |
   |-------------------------------------------------------------------------|
16. | 42 16165.22 5352.38 2743.43 362.37 |
17. | 43 16295.73 5277.55 2906.71 393.46 |
18. | 44 16207.14 4609.32 2936.67 367.43 |
19. | 45 20716.63 7213.18 3671.68 453.64 |
20. | 46 20563.31 7068.85 3551.15 451 |
   |-------------------------------------------------------------------------|
21. | 47 19035.63 6371.32 3564.73 436.84 |
22. | 48 20454.73 6812.13 3925.71 470.14 |
23. | 49 17991.77 5735.89 3402.14 441.93 |
24. | 50 20337.76 5640.11 3365.37 434.02 |
25. | 51 17815.61 5409.98 3390.65 408.46 |
   |-------------------------------------------------------------------------|
26. | 52 6058.073 1795.2 1731.457 348.27 |
27. | 53 16587.74 4216.55 3610.8 573.33 |
28. | 54 16548.53 4314.92 3351.47 436.19 |
29. | 55 15694.12 3803.23 3179.16 436.46 |
30. | 56 14084.4 3386.01 3148.49 397.88 |
   |-------------------------------------------------------------------------|
31. | 57 14897.69 3447.26 3253.61 411.99 |
32. | 58 16300 3677.55 3387.34 424.49 |
33. | 59 18029.75 4316.92 3761.98 456.22 |
34. | 60 16667.5 3965 4014.4 450.64 |
35. | 61 15969.57 3930.26 3915.45 420.34 |
   |-------------------------------------------------------------------------|
36. | 62 14623.54 3469.21 3241.83 408.56 |
37. | 63 15828.52 2798.63 2868.86 355.09 |
38. | 64 19114.82 3128.87 3222.25 390.78 |
39. | 65 18842.03 3928.5 4253.5 416.17 |
40. | 66 18206.87 4446.34 3839.29 456.63 |
   |-------------------------------------------------------------------------|
41. | 67 20130.95 5182.08 4123.23 465.33 |
42. | 68 21284.1 5113.28 4392.51 399.44 |
43. | 69 20933.36 4972.05 4444.95 394.35 |
44. | 70 22315.17 5772.17 5110.03 499.14 |
45. | 71 26966.28 6945.22 5569.49 598.73 |
   |-------------------------------------------------------------------------|
46. | 72 36384.69 9049.06 7418.74 715.28 |
47. | 73 36374 8633.24 7652.79 758.43 |
48. | 75 63297.95 14973.29 17017.29 1156.62 |
49. | 76 96069.47 20083.79 24558.49 1615.48 |
50. | 77 73012.48 19771.29 18643.45 1511.16 |
   |-------------------------------------------------------------------------|
51. | 78 64985.74 19692.11 14673.1 1656.7 |
52. | 79 67227.58 23913.91 13918.63 1581.31 |
53. | 80 67077.76 28176.62 12626.57 1678.32 |
54. | 81 59370.51 23886.62 11615.14 1635.54 |
55. | 82 56211.67 21901.3 11923.18 1639.61 |
   |-------------------------------------------------------------------------|
56. | 83 58152.08 23082.32 11620.51 2509.68 |
57. | 84 52437.75 21049.61 10528.52 1551.88 |
58. | 85 43849.17 20546.61 9870.15 1689.05 |
59. | 86 50788.66 19997.83 10211.88 1578.9 |
60. | 87 52870.88 19105.06 9382.34 1444.1 |
   |-------------------------------------------------------------------------|
61. | 88 48941.07 17920.62 8693.01 1371.31 |
62. | 89 47392.84 18210.32 8745.56 1286.69 |
63. | 90 44569.15 17932.71 8876.8 1392.73 |
64. | 91 48274.6 18944.45 8981.67 1301.85 |
65. | 92 49972.16 18491.47 9316.25 1433.77 |
   |-------------------------------------------------------------------------|
66. | 93 49814.09 19154.5 9253.43 1440.28 |
67. | 94 48752.04 18638.16 8981.9 1384.23 |
68. | 95 48101.89 18092.44 8759.78 1407.36 |
69. | 96 54504.56 21274.66 8506.02 1304.46 |
70. | 97 42908.79 12112.66 6320.05 775.32 |
   |-------------------------------------------------------------------------|
71. | 98 54876.27 13672.54 9089.29 958.8 |
72. | 99 49506.06 14915.62 10380.83 1056.76 |
73. | 100 64020.66 18604.5 13707.2 1299.34 |
74. | 101 82053.77 24077.28 19767.71 1622.27 |
75. | 102 111627.1 27074.75 30121.49 1985.26 |
   |-------------------------------------------------------------------------|
76. | 103 120381.3 26686.47 34218.23 2135.82 |
77. | 104 61236.46 16708.63 19692.48 1971.38 |
78. | 105 114074.9 37228.74 23062.74 2381.57 |
79. | 106 130248.2 46259.9 26271.68 2913.16 |
80. | 107 116613.3 43553.71 23889.91 2802.56 |
   |-------------------------------------------------------------------------|
81. | 108 130868 49589.68 27148.62 3226.39 |
82. | 109 139058.3 54396.15 26759.18 3237.56 |
83. | 110 139108.8 52377.86 28056.06 3618.43 |
84. | 111 136637.7 52623.01 27165.78 3601.96 |
85. | 112 161643.4 62128.49 28277.02 3811.62 |
   |-------------------------------------------------------------------------|
86. | 113 161728.8 69853.28 23844.28 3395.09 |
87. | 114 147629.4 65030.97 20372.99 3105.5 |
88. | 115 126627.2 55810.72 19011.89 2737.18 |
89. | 116 112479.1 38519.34 15961.08 2290.46 |
90. | 117 110430 32439.37 15901.74 1872.39 |
   |-------------------------------------------------------------------------|
91. | 118 121486.5 38062.67 14990.38 1953.21 |
92. | 119 118725.5 38974.36 15018.76 2316.55 |
93. | 120 137454.3 44638.31 16550.29 2366.4 |
94. | 121 131806.7 42386.35 16299.87 2206.86 |
95. | 122 129479.8 41699.36 17113.16 2515.35 |
   |-------------------------------------------------------------------------|
96. | 123 120696.5 40018.67 14889.64 2194.56 |
97. | 124 135314.3 38958.39 15734.9 2358.95 |
98. | 125 152765.8 37786.87 15645.72 2264.28 |
99. | 126 160564.3 37808.64 15824.18 2083.25 |
100. | 127 147388.1 34364.11 14079.21 1962.65 |
   |-------------------------------------------------------------------------|
101. | 128 157491.2 36339.47 14461.51 2050.7 |
102. | 129 162669.1 30337.78 15724.32 1884.46 |
103. | 130 161975.4 31243.81 14573.09 1906.91 |
104. | 131 147166.5 29864.38 15067.33 1733.99 |
105. | 132 135172.1 27277.18 14084.56 1745.9 |
   |-------------------------------------------------------------------------|
106. | 133 131753.4 23564.31 12605.09 1758.33 |
107. | 134 128383.3 23693.82 12151.24 1555.67 |
108. | 135 129741.4 22990.06 11685.81 1318.91 |
109. | 136 124662.3 21118.32 11142.02 1311.8 |
110. | 137 122142.8 19526.88 10460.19 1286.62 |
   |-------------------------------------------------------------------------|
111. | 138 124876.6 20099.66 11120.51 1337.24 |
112. | 139 120742.7 17464.57 9942.37 2205.81 |
113. | 140 111835.7 24755.51 11797.05 1415.05 |
114. | 141 40761.88 9093.98 5615.32 886.35 |
115. | 142 97221.18 18171.97 9972.141 1051.92 |
   |-------------------------------------------------------------------------|
116. | 143 132697.3 20188.15 10935.69 1444.37 |
117. | 144 132716.3 20790.19 10619.58 1527.4 |
118. | 145 145381 19757.93 9820.77 1177.87 |
119. | 146 145249.5 18919.34 9170 1252.94 |
120. | 147 123331.1 20603.46 9146.15 1080.79 |
   |-------------------------------------------------------------------------|
121. | 148 126740.7 18554.71 8286.47 897.27 |
122. | 149 87466.23 12275.86 6681.34 1011.45 |
123. | 149.5 109871.8 13888.85 11568.68 2198.78 |
124. | 150 110968.8 13372.98 7685.43 743.5 |
125. | 151 112167.5 13752.41 7504.42 819.19 |
   |-------------------------------------------------------------------------|
126. | 152 106363.5 14012.39 8468.66 1010.56 |
127. | 153 103017.5 13393.28 7755.94 873.83 |
128. | 154 111646.5 14138.29 7762.23 883.03 |
129. | 155 118249.4 14441.79 7490.34 959.05 |
130. | 156 112985.4 14376.57 7294.27 847.7 |
   |-------------------------------------------------------------------------|
131. | 157 114930.1 13219.1 6920.8 726.19 |
132. | 158 116444.9 13927.3 8007.74 743.35 |
133. | 159 110046 12316.04 9266.58 929.27 |
134. | 160 98248.79 12665.5 8554.91 716.09 |
135. | 161 108026.3 12868.57 9660.5 740.41 |
   |-------------------------------------------------------------------------|
136. | 162 120237 15477.06 10624.03 846.2 |
137. | 163 117220.3 15011.64 10060.33 914.62 |
138. | 164 122911.8 15641.31 10379.95 1041.95 |
139. | 165 104238.3 15603.23 10426.96 1096.96 |
140. | 166 105539 15628.03 11284.46 1342.19 |
   |-------------------------------------------------------------------------|
141. | 167 110085.2 16262.36 9938.21 1291.91 |
142. | 168 110620.4 16862.07 10008.43 1357.23 |
143. | 169 101689.7 16663.9 10303.82 1472.26 |
144. | 170 99180.14 15168.35 10350.57 1426.08 |
145. | 171 103872.3 14443.57 10620.94 1408.75 |
   |-------------------------------------------------------------------------|
146. | 172 102438.4 17082.37 10352.2 1420.61 |
147. | 173 109991.7 18101.85 10503 1328.73 |
148. | 174 127533.4 18900.05 13274.88 1672.16 |
149. | 175 123635 19960.94 12210.46 1374.4 |
150. | 176 118887.2 16802.19 11877.3 1710.89 |
   |-------------------------------------------------------------------------|
151. | 177 112984.2 16098.36 10525.58 1491.69 |
152. | 178 125313.1 14943.63 9795.98 1530.64 |
153. | 179 128049.6 15049.24 10253.72 1400.85 |
154. | 180 118997.1 15106.11 11228.47 1666.79 |
155. | 181 111764 14747.32 11349.65 1565.22 |
   |-------------------------------------------------------------------------|
156. | 182 115268 16773.77 10624.55 1427.3 |
157. | 183 123113.7 28292.58 10480.75 1405.35 |
158. | 184 113827.7 13553.08 9934.51 1323.7 |
159. | 185 107646.2 13338.18 10414.77 1474.03 |
160. | 186 97576.23 13396.87 10027.89 1385.2 |
   |-------------------------------------------------------------------------|
161. | 187 104300.2 14133.81 10767.64 1470.44 |
162. | 188 111111.4 14726.37 11758.52 1551.52 |
163. | 189 96311.53 15489.41 11308.85 1202.99 |
164. | 190 124919 16953.85 11768.45 1307.89 |
165. | 191 121026.2 16467.96 12330.31 1516.78 |
   |-------------------------------------------------------------------------|
166. | 192 119123.6 15071.75 12719.88 1515.43 |
167. | 193 113481.8 15574.8 12670.26 1822.03 |
168. | 194 119518.6 15607.62 12138.82 1457.47 |
169. | 195 121562.8 16248.43 13983.03 1616.85 |
170. | 196 119880.8 16172.66 13428.56 1582 |
   |-------------------------------------------------------------------------|
171. | 197 124087.6 17678.33 14303.09 1606.44 |
172. | 198 134646.9 19650.49 15422.5 1709.3 |
173. | 199 144489.3 19333.02 15099.32 1610.67 |
174. | 200 86717.01 10015.55 11145.92 1401.785 |
175. | 201 164139.5 19462.43 17532.81 1888.02 |
   |-------------------------------------------------------------------------|
176. | 202 153114.8 20839.38 18161.05 1817.45 |
177. | 203 149551.7 19931.19 17024.18 1748.66 |
178. | 204 150756.3 25852.33 18175.38 1974.74 |
179. | 205 152086.5 26705.68 17841.71 2098.77 |
180. | 206 153313 22900.15 19551.52 2234.77 |
   |-------------------------------------------------------------------------|
181. | 207 165989.5 24180.18 22795.35 2286.81 |
182. | 208 170968.7 24441.83 26642.05 2416.75 |
183. | 209 190589.3 26649.17 34105.28 2896.55 |
184. | 210 210983.7 29783.82 38206.55 3197.91 |
185. | 211 209633.8 31533.68 43444.91 3224.79 |
   |-------------------------------------------------------------------------|
186. | 212 200669.3 31302.43 43084.6 3274.63 |
187. | 213 185648.6 29196.76 39170.05 3474.82 |
188. | 214 203014.5 31611.89 38305.14 3579.74 |
189. | 215 222843.5 34887.28 37696.27 3630.49 |
190. | 216 226129.4 37899.3 39412.24 3296.75 |
   |-------------------------------------------------------------------------|
191. | 217 240297.4 37901.2 43376.75 3968.85 |
192. | 218 258580.9 40301.65 48536.11 4183.75 |
193. | 219 249940.4 43371.47 50186.57 4633.08 |
194. | 220 257036.2 42450.4 42782.84 4076.34 |
195. | 221 267682.7 49909.51 42792.97 4993.68 |
   |-------------------------------------------------------------------------|
196. | 222 261592.6 49414.35 43622.66 5008.1 |
197. | 223 264177.8 57244.71 46540.47 5437.65 |
198. | 224 303197.1 57818.07 62941.86 6582.47 |
199. | 225 314465.1 65211.05 54905.86 5731.15 |
200. | 226 327698.7 66672.67 63412.23 7623.04 |
   |-------------------------------------------------------------------------|
201. | 227 337132.3 64189.38 65493.77 6462.21 |
202. | 228 353303.3 67031.66 88037.62 8332.92 |
203. | 229 375048.2 65931.84 99364.53 8207.67 |
204. | 230 384012.2 64416.77 91401.26 8084.18 |
205. | 231 440217.4 78991.86 116833.1 9920.479 |
   |-------------------------------------------------------------------------|
206. | 232 444917.9 83608.33 100088.1 10147.65 |
207. | 233 400508 85624.48 84119.49 10058.35 |
208. | 234 400906.1 80080.25 68905.79 8819.27 |
209. | 235 350520.7 78158.12 61031.71 8386.37 |
210. | 236 369802.9 81887.58 60038.04 9113.96 |
   |-------------------------------------------------------------------------|
211. | 237 347646.9 81321.59 50331.32 8142.42 |
212. | 238 271974.4 78709.44 46175.32 8809.23 |
213. | 239 375000.2 83559.04 48208 8321.98 |
214. | 240 355274.3 74244.97 42710.33 7027.27 |
215. | 241 377917.7 69888.03 46783.2 8075.64 |
   |-------------------------------------------------------------------------|
216. | 242 394545.6 72300.14 45303.34 8495.01 |
217. | 243 405402.8 78227.44 31219.92 8482.39 |
218. | 244 374949.6 69086.28 29777.1 8101.86 |
219. | 245 374077.2 64213.39 28880.03 8348.24 |
220. | 246 526107.3 85532.73 37797.65 11121.24 |
   |-------------------------------------------------------------------------|
221. | 247 392151.2 57107.84 24900.56 7211.37 |
222. | 248 353164 56496.2 25883.25 7081.23 |
223. | 249 363392.1 59189.3 27214.98 6879.67 |
224. | 250 401658.4 62557.86 29479.02 5964.86 |
225. | 251 384710.1 90854.92 24060.85 5699.79 |
   |-------------------------------------------------------------------------|
226. | 252 369258.3 109407.1 20206.56 5373.21 |
227. | 253 389426.3 119507.9 20460.26 5471.21 |
228. | 254 341095.7 83504.26 20181.55 4779.87 |
229. | 255 366577.6 103295.5 20407.67 4357.64 |
230. | 256 410160.6 141941.6 22609.81 4270.39 |
   |-------------------------------------------------------------------------|
231. | 257 395102.4 143663 20174.47 4621.92 |
232. | 258 405572.8 140677.6 19293.15 4436.01 |
233. | 259 393714.6 142440.5 18401.69 4003.18 |
234. | 260 373496 128386.2 17865.4 3827.52 |
235. | 261 361926.6 124601.1 16983.81 3473.51 |
   |-------------------------------------------------------------------------|
236. | 262 340213.3 120962.3 15238.28 3086.08 |
237. | 263 364137.6 106266.5 16958.74 2675.04 |
238. | 264 343686.1 118686.5 16610.11 2905.1 |
239. | 265 368792.6 99783.42 17614.41 2902.07 |
240. | 266 301084.5 84122.09 19462.91 2566 |
   |-------------------------------------------------------------------------|
241. | 267 248086 44463.62 16248.2 2466.69 |
242. | 268 341440.1 90938.14 16435.15 2315.68 |
243. | 269 295101.9 90434.84 15402.42 2304.16 |
244. | 270 307412.2 93506.88 15779.48 2247.73 |
245. | 271 336184.8 100595.3 15849.19 2246.18 |
   |-------------------------------------------------------------------------|
246. | 272 359970.9 103140.9 17268.29 2239.04 |
247. | 273 337873.1 100488.5 16592.09 2176.95 |
248. | 274 336661.1 106726 18052.01 2137.72 |
249. | 275 343342.7 106282 15780.76 2179.83 |
250. | 276 409292.1 112939 17446.72 2354.02 |
   |-------------------------------------------------------------------------|
251. | 277 423117.3 114442 13825.97 2111.12 |
252. | 278 325328.6 111911 12801.78 1930.99 |
253. | 279 340701.6 124806.3 13964.51 2048.44 |
254. | 280 305277.3 102429.3 13209.62 1921.22 |
255. | 281 337179.8 103565.1 13320.96 2032.47 |
   |-------------------------------------------------------------------------|
256. | 282 313884.7 122089.8 11121.37 1766.48 |
257. | 283 300250.2 107787.2 11451.39 1752.57 |
258. | 284 297896.1 109534.8 10743.18 1690.39 |
259. | 285 290406.9 107004.4 11825.32 1621.13 |
260. | 286 311072.3 116003.5 11383.78 1580.78 |
   |-------------------------------------------------------------------------|
261. | 287 256432.3 76478.43 10261.56 1511.07 |
262. | 288 307255.1 112470.2 10875.12 1531.82 |
263. | 289 229093.8 17903.98 9715.57 1433.98 |
264. | 290 275764.8 84456.51 10600.02 1455.32 |
265. | 291 292228.8 92419.04 11177.19 1443.64 |
   |-------------------------------------------------------------------------|
266. | 291.3 255976.3 64461.38 9557.34 1337.13 |
267. | 291.6 280417.4 58683.05 9979.15 1368.19 |
268. | 292 225950.9 25770.32 9553.12 1327.45 |
269. | 293 218751.8 31976.96 8474.109 1235.89 |
   +-------------------------------------------------------------------------+

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

December 31, 2019, 08:27:32 AM

Dataset for start-, end-date, and period of each rounds

The variable period is calculated by the formula:

(end - start) 86400.
86400 is total seconds per day.

Code:

+----------------------------------------+
   | round start end period |
   |----------------------------------------|
  1. | 27 04apr2012 11apr2012 7.1 |
  2. | 28 11apr2012 19apr2012 7.3 |
  3. | 29 19apr2012 26apr2012 7.7 |
  4. | 30 26apr2012 03may2012 7 |
  5. | 31 03may2012 10may2012 7.1 |
   |----------------------------------------|
  6. | 32 10may2012 17may2012 7 |
  7. | 33 17may2012 24may2012 7 |
  8. | 34 24may2012 31may2012 7 |
  9. | 35 31may2012 07jun2012 7 |
10. | 36 07jun2012 15jun2012 7.1 |
   |----------------------------------------|
11. | 37 15jun2012 23jun2012 8.9 |
12. | 38 23jun2012 01jul2012 7.1 |
13. | 39 01jul2012 09jul2012 8.2 |
14. | 40 09jul2012 16jul2012 7.6 |
15. | 41 16jul2012 24jul2012 7.2 |
   |----------------------------------------|
16. | 42 24jul2012 31jul2012 7 |
17. | 43 31jul2012 07aug2012 7 |
18. | 44 07aug2012 14aug2012 7.9 |
19. | 45 14aug2012 22aug2012 7.2 |
20. | 46 22aug2012 29aug2012 7.1 |
   |----------------------------------------|
21. | 47 29aug2012 05sep2012 7.4 |
22. | 48 05sep2012 12sep2012 7 |
23. | 49 12sep2012 20sep2012 7.4 |
24. | 50 20sep2012 27sep2012 7.6 |
25. | 51 27sep2012 06oct2012 8.5 |
   |----------------------------------------|
26. | 52 06oct2012 13oct2012 7.5 |
27. | 53 13oct2012 18oct2012 4.8 |
28. | 54 18oct2012 26oct2012 7.6 |
29. | 55 26oct2012 02nov2012 7.1 |
30. | 56 02nov2012 09nov2012 7.5 |
   |----------------------------------------|
31. | 57 09nov2012 16nov2012 7.1 |
32. | 58 16nov2012 23nov2012 7.2 |
33. | 59 23nov2012 01dec2012 7.3 |
34. | 60 01dec2012 08dec2012 7.2 |
35. | 61 08dec2012 16dec2012 7.6 |
   |----------------------------------------|
36. | 62 16dec2012 23dec2012 7.3 |
37. | 63 23dec2012 31dec2012 7.8 |
38. | 64 31dec2012 07jan2013 7.2 |
39. | 65 07jan2013 14jan2013 7.5 |
40. | 66 14jan2013 21jan2013 7.1 |
   |----------------------------------------|
41. | 67 21jan2013 29jan2013 7.9 |
42. | 68 29jan2013 07feb2013 9.1 |
43. | 69 07feb2013 17feb2013 9.2 |
44. | 70 17feb2013 25feb2013 8.7 |
45. | 71 25feb2013 05mar2013 8.1 |
   |----------------------------------------|
46. | 72 05mar2013 13mar2013 7.8 |
47. | 73 13mar2013 21mar2013 7.6 |
48. | 74 21mar2013 28mar2013 7 |
49. | 75 28mar2013 05apr2013 7.8 |
50. | 76 05apr2013 12apr2013 7.2 |
   |----------------------------------------|
51. | 77 12apr2013 21apr2013 8.8 |
52. | 78 21apr2013 28apr2013 7.5 |
53. | 79 28apr2013 07may2013 9 |
54. | 80 07may2013 17may2013 9.5 |
55. | 81 17may2013 25may2013 8 |
   |----------------------------------------|
56. | 82 25may2013 02jun2013 7.9 |
57. | 83 02jun2013 11jun2013 9 |
58. | 84 11jun2013 19jun2013 8.1 |
59. | 85 19jun2013 26jun2013 7.1 |
60. | 86 26jun2013 03jul2013 7.8 |
   |----------------------------------------|
61. | 87 03jul2013 12jul2013 8.3 |
62. | 88 12jul2013 20jul2013 8.5 |
63. | 89 20jul2013 30jul2013 9.3 |
64. | 90 30jul2013 07aug2013 8.1 |
65. | 91 07aug2013 16aug2013 9.1 |
   |----------------------------------------|
66. | 92 16aug2013 24aug2013 7.8 |
67. | 93 24aug2013 01sep2013 8.1 |
68. | 94 01sep2013 09sep2013 8.7 |
69. | 95 09sep2013 18sep2013 8.1 |
70. | 96 18sep2013 26sep2013 8.9 |
   |----------------------------------------|
71. | 97 26sep2013 12oct2013 15.7 |
72. | 98 12oct2013 22oct2013 9.5 |
73. | 99 22oct2013 01nov2013 9.9 |
74. | 100 01nov2013 11nov2013 10 |
75. | 101 11nov2013 21nov2013 10 |
   |----------------------------------------|
76. | 102 21nov2013 02dec2013 11.1 |
77. | 103 02dec2013 11dec2013 9.1 |
78. | 104 11dec2013 21dec2013 10.5 |
79. | 105 21dec2013 01jan2014 10.5 |
80. | 106 01jan2014 10jan2014 9 |
   |----------------------------------------|
81. | 107 10jan2014 20jan2014 9.8 |
82. | 108 20jan2014 29jan2014 9.3 |
83. | 109 29jan2014 08feb2014 9.8 |
84. | 110 08feb2014 16feb2014 8.5 |
85. | 111 16feb2014 25feb2014 8.4 |
   |----------------------------------------|
86. | 112 25feb2014 05mar2014 8 |
87. | 113 05mar2014 15mar2014 10 |
88. | 114 15mar2014 25mar2014 10.2 |
89. | 115 25mar2014 05apr2014 10.9 |
90. | 116 05apr2014 17apr2014 12 |
   |----------------------------------------|
91. | 117 17apr2014 28apr2014 11 |
92. | 118 28apr2014 10may2014 11.9 |
93. | 119 10may2014 19may2014 9.8 |
94. | 120 19may2014 30may2014 10.1 |
95. | 121 30may2014 10jun2014 11.1 |
   |----------------------------------------|
96. | 122 10jun2014 19jun2014 9 |
97. | 123 19jun2014 30jun2014 11 |
98. | 124 30jun2014 10jul2014 10 |
99. | 125 10jul2014 20jul2014 10 |
100. | 126 20jul2014 31jul2014 11 |
   |----------------------------------------|
101. | 127 31jul2014 12aug2014 11.9 |
102. | 128 12aug2014 23aug2014 11.2 |
103. | 129 23aug2014 04sep2014 11.9 |
104. | 130 04sep2014 16sep2014 11.8 |
105. | 131 16sep2014 29sep2014 13.1 |
   |----------------------------------------|
106. | 132 29sep2014 11oct2014 12 |
107. | 133 11oct2014 21oct2014 10 |
108. | 134 21oct2014 30oct2014 9.8 |
109. | 135 30oct2014 12nov2014 13 |
110. | 136 12nov2014 26nov2014 13.2 |
   |----------------------------------------|
111. | 137 26nov2014 09dec2014 13 |
112. | 138 09dec2014 22dec2014 12.8 |
113. | 139 22dec2014 02jan2015 11.2 |
114. | 140 02jan2015 15jan2015 13 |
115. | 141 15jan2015 30jan2015 15.1 |
   |----------------------------------------|
116. | 142 30jan2015 17feb2015 17.9 |
117. | 143 17feb2015 28feb2015 11 |
118. | 144 28feb2015 10mar2015 10 |
119. | 145 10mar2015 25mar2015 15.1 |
120. | 146 25mar2015 07apr2015 12.9 |
   |----------------------------------------|
121. | 147 07apr2015 22apr2015 15.7 |
122. | 148 22apr2015 12may2015 19.8 |
123. | 149 12may2015 25may2015 13 |
124. | 149.5 25may2015 29may2015 3.5 |
125. | 150 29may2015 18jun2015 20.1 |
   |----------------------------------------|
126. | 151 18jun2015 06jul2015 18.5 |
127. | 152 06jul2015 20jul2015 14.1 |
128. | 153 20jul2015 06aug2015 16.4 |
129. | 154 06aug2015 22aug2015 16.6 |
130. | 155 22aug2015 06sep2015 14.4 |
   |----------------------------------------|
131. | 156 06sep2015 23sep2015 17 |
132. | 157 23sep2015 13oct2015 20.8 |
133. | 158 13oct2015 05nov2015 22.3 |
134. | 159 05nov2015 20nov2015 15.6 |
135. | 160 20nov2015 15dec2015 24.4 |
   |----------------------------------------|
136. | 161 15dec2015 07jan2016 23.5 |
137. | 162 07jan2016 29jan2016 22.2 |
138. | 163 29jan2016 18feb2016 19.1 |
139. | 164 18feb2016 04mar2016 15.6 |
140. | 165 04mar2016 18mar2016 14 |
   |----------------------------------------|
141. | 166 18mar2016 28mar2016 10 |
142. | 167 28mar2016 08apr2016 11.1 |
143. | 168 08apr2016 19apr2016 10.3 |
144. | 169 19apr2016 28apr2016 9.1 |
145. | 170 28apr2016 07may2016 8.9 |
   |----------------------------------------|
146. | 171 07may2016 16may2016 9 |
147. | 172 16may2016 25may2016 9.5 |
148. | 173 25may2016 06jun2016 11.7 |
149. | 174 06jun2016 15jun2016 8.8 |
150. | 175 15jun2016 27jun2016 12.5 |
   |----------------------------------------|
151. | 176 27jun2016 05jul2016 8.2 |
152. | 177 05jul2016 15jul2016 9.8 |
153. | 178 15jul2016 24jul2016 8.4 |
154. | 179 24jul2016 03aug2016 9.9 |
155. | 180 03aug2016 11aug2016 8.4 |
   |----------------------------------------|
156. | 181 11aug2016 19aug2016 8.1 |
157. | 182 19aug2016 29aug2016 9.5 |
158. | 183 29aug2016 08sep2016 10.5 |
159. | 184 08sep2016 19sep2016 11.1 |
160. | 185 19sep2016 28sep2016 9.1 |
   |----------------------------------------|
161. | 186 28sep2016 08oct2016 9.9 |
162. | 187 08oct2016 18oct2016 9.4 |
163. | 188 18oct2016 26oct2016 8.8 |
164. | 189 26oct2016 10nov2016 14.2 |
165. | 190 10nov2016 22nov2016 12.6 |
   |----------------------------------------|
166. | 191 22nov2016 02dec2016 10.1 |
167. | 192 02dec2016 12dec2016 9.7 |
168. | 193 12dec2016 19dec2016 7.3 |
169. | 194 19dec2016 30dec2016 11 |
170. | 195 30dec2016 09jan2017 9.9 |
   |----------------------------------------|
171. | 196 09jan2017 19jan2017 10.1 |
172. | 197 19jan2017 30jan2017 10.2 |
173. | 198 30jan2017 09feb2017 10 |
174. | 199 09feb2017 19feb2017 10.9 |
175. | 200 19feb2017 02mar2017 10.9 |
   |----------------------------------------|
176. | 201 02mar2017 11mar2017 9.1 |
177. | 202 11mar2017 22mar2017 11 |
178. | 203 22mar2017 03apr2017 11.8 |
179. | 204 03apr2017 13apr2017 10 |
180. | 205 13apr2017 23apr2017 9.4 |
   |----------------------------------------|
181. | 206 23apr2017 02may2017 9.6 |
182. | 207 02may2017 13may2017 10.4 |
183. | 208 13may2017 23may2017 10.5 |
184. | 209 23may2017 01jun2017 9.2 |
185. | 210 01jun2017 10jun2017 9 |
   |----------------------------------------|
186. | 211 10jun2017 20jun2017 9.9 |
187. | 212 20jun2017 30jun2017 10 |
188. | 213 30jun2017 09jul2017 8.9 |
189. | 214 09jul2017 18jul2017 9.1 |
190. | 215 18jul2017 28jul2017 9.4 |
   |----------------------------------------|
191. | 216 28jul2017 09aug2017 12.7 |
192. | 217 09aug2017 19aug2017 9.9 |
193. | 218 19aug2017 29aug2017 9.9 |
194. | 219 29aug2017 07sep2017 9.2 |
195. | 220 07sep2017 18sep2017 11 |
   |----------------------------------------|
196. | 221 18sep2017 27sep2017 8.2 |
197. | 222 27sep2017 06oct2017 9.9 |
198. | 223 06oct2017 17oct2017 10.8 |
199. | 224 17oct2017 26oct2017 9.1 |
200. | 225 26oct2017 09nov2017 13.2 |
   |----------------------------------------|
201. | 226 09nov2017 17nov2017 8.6 |
202. | 227 17nov2017 30nov2017 12.7 |
203. | 228 30nov2017 09dec2017 9.5 |
204. | 229 09dec2017 20dec2017 11 |
205. | 230 20dec2017 31dec2017 11 |
   |----------------------------------------|
206. | 231 31dec2017 11jan2018 11 |
207. | 232 11jan2018 23jan2018 11.4 |
208. | 233 23jan2018 02feb2018 10.6 |
209. | 234 02feb2018 14feb2018 12 |
210. | 235 14feb2018 27feb2018 12.4 |
   |----------------------------------------|
211. | 236 27feb2018 09mar2018 10.7 |
212. | 237 09mar2018 21mar2018 11.9 |
213. | 238 21mar2018 31mar2018 10 |
214. | 239 31mar2018 11apr2018 11 |
215. | 240 11apr2018 25apr2018 14 |
   |----------------------------------------|
216. | 241 25apr2018 06may2018 10.3 |
217. | 242 06may2018 16may2018 10.2 |
218. | 243 16may2018 26may2018 10.7 |
219. | 244 26may2018 06jun2018 10.8 |
220. | 245 06jun2018 16jun2018 10 |
   |----------------------------------------|
221. | 246 19jun2018 27jun2018 7.2 |
222. | 247 27jun2018 08jul2018 11.1 |
223. | 248 08jul2018 18jul2018 10.7 |
224. | 249 18jul2018 29jul2018 10.3 |
225. | 250 29jul2018 11aug2018 13 |
   |----------------------------------------|
226. | 251 11aug2018 22aug2018 11.7 |
227. | 252 22aug2018 03sep2018 12 |
228. | 253 03sep2018 14sep2018 11 |
229. | 254 14sep2018 26sep2018 12.3 |
230. | 255 26sep2018 09oct2018 12.1 |
   |----------------------------------------|
231. | 256 09oct2018 21oct2018 12.4 |
232. | 257 21oct2018 31oct2018 10 |
233. | 258 31oct2018 10nov2018 10.1 |
234. | 259 10nov2018 21nov2018 11.2 |
235. | 260 21nov2018 01dec2018 9.9 |
   |----------------------------------------|
236. | 261 01dec2018 11dec2018 10.3 |
237. | 262 11dec2018 22dec2018 10.6 |
238. | 263 22dec2018 04jan2019 12.2 |
239. | 264 04jan2019 14jan2019 10.8 |
240. | 265 14jan2019 24jan2019 10 |
   |----------------------------------------|
241. | 266 24jan2019 04feb2019 11 |
242. | 267 04feb2019 15feb2019 11.1 |
243. | 268 15feb2019 27feb2019 11.9 |
244. | 269 27feb2019 10mar2019 10.3 |
245. | 270 10mar2019 20mar2019 10.5 |
   |----------------------------------------|
246. | 271 20mar2019 30mar2019 10.2 |
247. | 272 30mar2019 10apr2019 11.1 |
248. | 273 10apr2019 21apr2019 10.2 |
249. | 274 21apr2019 01may2019 10.7 |
250. | 275 01may2019 12may2019 10.2 |
   |----------------------------------------|
251. | 276 12may2019 22may2019 10.6 |
252. | 277 22may2019 03jun2019 12 |
253. | 278 03jun2019 15jun2019 11.5 |
254. | 279 15jun2019 26jun2019 11.7 |
255. | 280 26jun2019 09jul2019 12.3 |
   |----------------------------------------|
256. | 281 09jul2019 19jul2019 10.5 |
257. | 282 19jul2019 31jul2019 11.9 |
258. | 283 31jul2019 11aug2019 11.1 |
259. | 284 11aug2019 22aug2019 10.9 |
260. | 285 22aug2019 02sep2019 11.2 |
   |----------------------------------------|
261. | 286 02sep2019 13sep2019 11.1 |
262. | 287 13sep2019 24sep2019 11.1 |
263. | 288 24sep2019 05oct2019 10.9 |
264. | 289 05oct2019 16oct2019 11.1 |
265. | 290 16oct2019 27oct2019 10.7 |
   |----------------------------------------|
266. | 291 27oct2019 07nov2019 11 |
267. | 291.3 07nov2019 18nov2019 10.9 |
268. | 291.6 18nov2019 29nov2019 11.2 |
269. | 292 29nov2019 10dec2019 11.1 |
270. | 293 10dec2019 22dec2019 11.1 |
   +----------------------------------------+

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

January 01, 2020, 01:25:38 AM
Last edit: January 01, 2020, 03:04:35 AM by tranthidung

OP udated with the Abstract section, and I also included the statistics for number of monthly registered accounts. Plot updated as well.

It has been shown in these time-series plots in OP, but if you did not recognize it, you can see it in details below with the statistics of each indicator over years (2012 - 2019).

As always, I used the medians (p50), not means. Now, let's look at their all time highs, in medians.

1. Daily total impressions
Its all time high is 374975, in 2018, not in 2017.

Code:

Summary for variables: mimpressions
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 15088.0 3447.1 15761.3 12433.6 16667.5 6058.1 20716.6
   2013 | 40.0 54194.9 24673.3 50380.4 43379.0 63659.3 18206.9 120381.3
   2014 | 34.0 135750.9 15362.2 131780.0 124662.3 147388.1 110430.0 162669.1
   2015 | 23.0 112016.0 21012.5 111835.7 106363.5 123331.1 40761.9 145381.0
   2016 | 34.0 113646.3 9029.7 113654.8 105539.0 121026.2 96311.5 128049.6
   2017 | 36.0 226489.9 84789.8 210308.7 153213.9 265930.3 86717.0 440217.4
   2018 | 32.0 380478.4 39909.4 374974.9 362659.3 397805.2 271974.4 526107.3
   2019 | 32.0 309872.3 47800.9 307333.6 285412.2 339287.3 218751.8 423117.3
---------+--------------------------------------------------------------------------------
   Total | 269.0 163724.4 125747.3 123331.1 61236.5 264177.8 6058.1 526107.3
------------------------------------------------------------------------------------------

2. Daily total impressions from logged-in users
Its all time high is 101513, in 2019, not in 2017.

Code:

Summary for variables: mliuser_impressions
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 4369.7 1183.9 4099.0 3544.8 4951.3 1795.2 7213.2
   2013 | 40.0 17249.1 7505.0 18621.3 12892.6 21162.1 3928.5 37228.7
   2014 | 34.0 38847.1 13445.2 38291.0 29864.4 46259.9 17464.6 69853.3
   2015 | 23.0 15629.7 3771.0 14012.4 13219.1 18919.3 9094.0 24755.5
   2016 | 34.0 16152.4 2577.8 15605.4 15011.6 16773.8 13338.2 28292.6
   2017 | 36.0 38080.1 18477.7 31572.8 23540.2 53577.1 10015.6 78991.9
   2018 | 32.0 92415.7 27127.3 83531.6 73272.6 114457.5 56496.2 143663.0
   2019 | 32.0 91759.4 28270.0 101512.3 84289.3 110722.9 17904.0 124806.3
---------+--------------------------------------------------------------------------------
   Total | 269.0 38475.7 35797.1 21049.6 14376.6 58683.1 1795.2 143663.0
------------------------------------------------------------------------------------------

3. Daily unique IPs from logged-out users
Its all time high is 39292, in 2018, not in 2017.

Code:

Summary for variables: muniqueip
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 2895.0 668.8 2921.7 2231.9 3390.6 1731.5 4014.4
   2013 | 40.0 11746.7 6947.0 9349.3 8079.4 13812.9 3839.3 34218.2
   2014 | 34.0 17406.6 5582.9 15729.6 14084.6 20373.0 9942.4 28277.0
   2015 | 23.0 8695.0 1598.2 8468.7 7504.4 9820.8 5615.3 11797.0
   2016 | 34.0 11067.6 1061.3 10622.5 10350.6 11768.5 9796.0 13983.0
   2017 | 36.0 41688.3 25824.5 39291.1 18168.2 49361.3 11145.9 116833.1
   2018 | 32.0 35677.8 20870.3 28047.5 20194.1 46479.3 15238.3 100088.1
   2019 | 32.0 13512.0 3099.7 13265.3 10809.1 16341.7 8474.1 19462.9
---------+--------------------------------------------------------------------------------
   Total | 269.0 17928.8 17796.4 11877.3 8981.7 19462.9 1731.5 116833.1
------------------------------------------------------------------------------------------

4. Daily unique logged-in users
Its all time high is 3386, in 2017.

Code:

Summary for variables: muniqueliusers
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 382.1 64.4 379.1 328.2 436.2 281.3 573.3
   2013 | 40.0 1311.5 543.4 1400.0 867.1 1628.9 394.4 2509.7
   2014 | 34.0 2321.5 705.2 2206.3 1872.4 2802.6 1286.6 3811.6
   2015 | 23.0 1040.7 345.2 929.3 819.2 1177.9 716.1 2198.8
   2016 | 34.0 1407.0 208.0 1423.3 1328.7 1516.8 846.2 1822.0
   2017 | 36.0 4005.5 2302.2 3385.8 2036.8 5222.9 1401.8 9920.5
   2018 | 32.0 6708.2 2293.6 7054.3 4529.0 8434.4 2675.0 11121.2
   2019 | 32.0 1941.9 456.5 1981.7 1521.4 2247.0 1235.9 2905.1
---------+--------------------------------------------------------------------------------
   Total | 269.0 2374.3 2251.7 1606.4 1051.9 2566.0 281.3 11121.2
------------------------------------------------------------------------------------------

Comparisons between three periods, with the period 2012-2013 used as a reference group.

______________________________________	____________________________	_____________	_____________
Indicators	Reference group ^{(2012 - 2013)}	2014 - 2016 *	2017 - 2019 *
______________________________________	____________________________	_____________	_____________
Daily total impressions	20509	120237 (5.9)	319897 (15.6)
Daily total impressions from logged-in users	5754	17465 (3)	75362 (13)
Daily unique IPs from logged-out users	4069	11229 (2.8 )	20178 (5)
Daily unique logged-in users	457	1471 (2.6)	3250 (7.1)
______________________________________	____________________________	_____________	_____________

* Values (Increasing-fold).

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

bitserve

Legendary

Offline

Activity: 1974
Merit: 1630

Self made HODLER ✓

Re: Impression counts for ads over years (Statistics)

January 01, 2020, 03:44:03 AM

Nice!

Didn't knew about https://bitcointalk.org/adrotate.php?adstats

Would it be possible to see a graph with ONLY "unique logged in users" vs price (no need to multiply or maybe just 5x) for additional clarity?

I think that could be very interesting even if very correlated as expected.

Thanks!

P.S.: Also maybe a zoom in the period Q4 2017-Q1 2018

19VBmRQVqrtNTGiwngZutwREagcKxJgVZM

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

January 01, 2020, 04:03:10 AM
Last edit: January 01, 2020, 04:36:54 AM by tranthidung

Quote from: bitserve on January 01, 2020, 03:44:03 AM

Would it be possible to see a graph with ONLY "unique logged in users" vs price (no need to multiply or maybe just 5x) for additional clarity?

I made this one, using the real close price of BTC, without any multiplier.

I have not seen it minutes ago, so I will give you that one later. Got trouble with connections in several minutes. Cheesy

Quote

P.S.: Also maybe a zoom in the period Q4 2017-Q1 2018

A quick reminder for you:

The BTC price here is the close price of it in some specific days, on which I took data of monthly new registered accounts, as you can see in the thread - Assumed monthly statistics on registered accounts of bitcointalk.org (2009-2019). Consequently, it is not a completely true time-series plot of BTC-price.

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

UserU

Hero Member

Offline

Activity: 2492
Merit: 552

I passively earned over $300 @ tinyurl.com/PIA10

Re: Impression counts for ads over years (Statistics)

January 01, 2020, 08:30:50 AM

Looks like the 2017 spike really gave a massive boost. And its just one spot per page. Imagine another one near the bottom, surely the stats are gonna be more interesting.

.
.^{500 CASINO}._██

▄▀

▄

▄

.
THE HOTTEST CRYPTO
CASINO & SPORTSBOOK

▄▄▄████████████ ▄▄▄███████████████████ ▐█████████████████████ █████████████████████ ▐███████████████████ ▐███████████████████ ███████████████████ ██████▀█████▀██████ ▐████████▀█████████ ▐███████████████████ ███████████████████ ▐███████████████████ ▀██████▀▀▀▀▀▀ ▀▀▀█

▄▄▄▀▀▀▀▀▀▀▄▄▄ ▄▄▀▀▄ ▄ ▀ ▀ ▀ ▄ ▄▀▀▄▄ ▄▀▄ ▀ ▀ ▄▀▄ █ ▄ ▄ █ █ ▄ █████ ▄███▄ ▄███▄ ▄ █ █ ▄ ██▄▄ ██ ██ ██ ██ ▄ █ █ ▄ ▀▀▀██ ██ ██ ██ ██ ▄ █ █ ▄ ▄▄ ██ ██ ██ ██ ██ ▄ █ █ ▄ ▀███▀ ▀███▀ ▀███▀ ▄ █ █ ▄ ▄ █ ▀▄ ▀ ▄ ▄ ▀ ▄▀ ▀▀▄▄ ▀ ▄ ▄ ▄ ▄ ▀ ▄▄▀▀ ▀▀▀▄▄▄▄▄▄▄▀▀▀

█▄▄▄██████████▄▄▄ ███████████▀██▀▀██▄▄ ███████████████████▄ █████████████████████ ████▄████▄███████▄███ █████████████████████ ████▀████▀███████▀███ █████████████████████ ███████████████████▀ ███████████▄██▄▄██▀▀ ▀▀▀██████████▀▀▀

► ORIGINALS

► SLOTS

► LIVE GAMES

► SPORTSBOOK

▄

▄

▀▄

.
_██..^{PLAY NOW}..

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

January 01, 2020, 09:34:07 AM

Quote from: UserU on January 01, 2020, 08:30:50 AM

Looks like the 2017 spike really gave a massive boost. And its just one spot per page. Imagine another one near the bottom, surely the stats are gonna be more interesting.

It's partially wrong. You did not read my posts thoroughly, in that post or in Abstract section of OP.

Among 4 indicators: Daily total impressions, Daily total impressions from logged-in users, Daily unique IPs from logged-out users, Daily unique logged-in users. Only the last one (Daily unique logged-in users) reached its all time high back in 2017. For the rest three, their all-time-highs reached in 2018 or 2019.

See:

Quote from: tranthidung on December 31, 2019, 07:44:39 AM

The all-time-highs for four indicators: Daily total impressions (374975, in 2018), Daily total impressions from logged-in users (101513, in 2019), Daily unique IPs from logged-out users (39292, in 2018), Daily unique logged-in users (3386, in 2017)

Details over years are there: https://bt.irlbtc.com/view/5213807.msg53490321#msg53490321

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

bitserve

Legendary

Offline

Activity: 1974
Merit: 1630

Self made HODLER ✓

Re: Impression counts for ads over years (Statistics)

January 02, 2020, 12:19:31 AM

#10

It's surprising how perfectly correlated both price and logged-in users were during 2017 (I guess that's how FOMO does look like) and 2018, and how the correlation got broken for most 2019. In fact it is the 2019 stats that are surprising with that continuous downtrend even during the $14K peak which only shows an almost unnoticeable correlation.

19VBmRQVqrtNTGiwngZutwREagcKxJgVZM

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

January 02, 2020, 01:19:08 AM
Last edit: January 02, 2020, 09:04:49 AM by tranthidung

#11

Quote from: bitserve on January 02, 2020, 12:19:31 AM

In that post, I gave you the comparisons in medians between three periods, with the reference group is the period from 2012 to 2013.
For your interest, I give you the comparisons (in medians) between three years, 2017 to 2019, with the year of 2017 is the reference group.

______________________________________	_____________________	_____________	_____________
Indicators	Reference group ⁽²⁰¹⁷⁾	2018*	2019 *
______________________________________	_____________________	_____________	_____________
Daily total impressions	210309	374975 (78.3)	307334 (46.1)
Daily total impressions from logged-in users	31573	83532 (164.6)	101513 (221.5)
Daily unique IPs from logged-out users	39292	28048 (-28.6 )	13266 (-66.2)
Daily unique logged-in users	3386	7055 (108.4)	1982 (-71.9)
______________________________________	______________________	_____________	_____________

* Values are percentages.

There is one significant change with data dump from admin, since the round 243 - that happened in the mid of May 2018. I guess this is another reason why the figures for that indicator (the third one) fell dramatically last two years.

For the rest three indicators, there are some possibly ways to make data interpretation, with at least three major causes:

The merit system (kicked-off on 24/1/2018): with it, people only stopped or reduced their rates of creating new accounts. Only newbie accounts affected at that time, massively because they can not rank up to the Member rank to wear signatures, but Junior members still were allowed to wear signatures, so users at that rank likely kept using their accounts till the September of 2018.
The enhanced merit system (kicked-off on 16/9/2018): On that day, Junior members who have not self-earned a single merit will be demoted/ deranked to Newbies. I guess that day is the start of decreasing in so many stats (Monthly new registered accounts, and some stats for ads. Shitposters were no longer to be allowed to wear signature and they nearly were unable to earn a single merit to rank up back to Jr. Members. There are compromises with merits on that day and several days after. Look at the spike in September 2018 in the time-series plot below.
The wave of bans in April and May 2019: This time, lots of accounts (from Legendary to Newbies banned - mostly permanently banned due to plagiarism, for the 'called' plagiabot created by unknown user. *

* Since 04/01/2019, when LoyceV created that topic ({List} Banned users) and start the scrap data on banned and nuked users, we have:

Quote from: tranthidung on December 30, 2019, 02:31:27 AM

Total Autobanned users: 141377
Total Nuked users: 61625

Quote

Note that starting in this round, "Unique IPs" was changed to "Unique IPs from logged-out users", probably resulting in lower numbers for this stat.

History of bitcointalk.org's rank system
One year anniversary of enhanced merit system
Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)
A wave of bans: 400 yesterday, 300 the day before. What changed?

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

April 03, 2020, 05:15:25 AM
Last edit: April 03, 2020, 01:54:49 PM by tranthidung

#12

ABSTRACT

Observed rounds: 278.
Converted datasets: get there and there.
Period of each round: about 10.1 days (in medians - p50). See details
From these time-series plots and statistics presented below, I have a feeling that recent wash-out in March of 2020 has decreasing effects on figures of all 4 indicators. If we compare all indicators between two years (2019 and 2020 - an imcomplete year with only 7 rounds observed as of writing).

It has been shown in these time-series plots in OP, but if you did not recognize it, you can see it in details below with the statistics of each indicator over years (2012 - 2020). The year of 2020 is an imcomplete one, with only 7 rounds have been finished so far, the last finish round is #301.

As always, I used the medians (p50), not means. Now, let's look at their all time highs, in medians (p50).

An overview, for whole period (from 2012 to 2020) for all 4 indicators.

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
mimpressions | 277.0 165158.9 124211.2 124876.6 64020.7 258580.9 6058.1 526107.3
mliuser_im~s | 277.0 38091.3 35354.1 21274.7 14443.6 57244.7 1795.2 143663.0
muniqueip | 277.0 17662.1 17605.1 11758.5 8759.8 19011.9 1731.5 116833.1
muniqueliu~s | 277.0 2340.0 2227.8 1578.9 1070.7 2509.7 281.3 11121.2
----------------------------------------------------------------------------------------------

1. Daily total impressions
Its all time high is 374975, in 2018, not in 2017.

Code:

Summary for variables: mimpressions
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 15088.0 3447.1 15761.3 12433.6 16667.5 6058.1 20716.6
   2013 | 40.0 54194.9 24673.3 50380.4 43379.0 63659.3 18206.9 120381.3
   2014 | 34.0 135750.9 15362.2 131780.0 124662.3 147388.1 110430.0 162669.1
   2015 | 23.0 112016.0 21012.5 111835.7 106363.5 123331.1 40761.9 145381.0
   2016 | 34.0 113646.3 9029.7 113654.8 105539.0 121026.2 96311.5 128049.6
   2017 | 36.0 226489.9 84789.8 210308.7 153213.9 265930.3 86717.0 440217.4
   2018 | 32.0 380478.4 39909.4 374974.9 362659.3 397805.2 271974.4 526107.3
   2019 | 33.0 307677.2 48708.6 307255.1 280417.4 337873.1 218751.8 423117.3
   2020 | 7.0 209958.8 10762.8 209625.4 203026.7 215169.0 195923.4 229033.4
---------+--------------------------------------------------------------------------------
   Total | 277.0 165158.9 124211.2 124876.6 64020.7 258580.9 6058.1 526107.3
------------------------------------------------------------------------------------------

2. Daily total impressions from logged-in users
Its all time high is 100595, in 2019, not in 2017.

Code:

Summary for variables: mliuser_impressions
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 4369.7 1183.9 4099.0 3544.8 4951.3 1795.2 7213.2
   2013 | 40.0 17249.1 7505.0 18621.3 12892.6 21162.1 3928.5 37228.7
   2014 | 34.0 38847.1 13445.2 38291.0 29864.4 46259.9 17464.6 69853.3
   2015 | 23.0 15629.7 3771.0 14012.4 13219.1 18919.3 9094.0 24755.5
   2016 | 34.0 16152.4 2577.8 15605.4 15011.6 16773.8 13338.2 28292.6
   2017 | 36.0 38080.1 18477.7 31572.8 23540.2 53577.1 10015.6 78991.9
   2018 | 32.0 92415.7 27127.3 83531.6 73272.6 114457.5 56496.2 143663.0
   2019 | 33.0 89981.7 29639.5 100595.3 84122.1 109534.8 17904.0 124806.3
   2020 | 7.0 24032.9 4147.7 24988.8 20445.8 27793.8 17183.0 28053.4
---------+--------------------------------------------------------------------------------
   Total | 277.0 38091.3 35354.1 21274.7 14443.6 57244.7 1795.2 143663.0
------------------------------------------------------------------------------------------

3. Daily unique IPs from logged-out users
Its all time high is 39292, in 2018, not in 2017.

Code:

Summary for variables: muniqueip
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 2895.0 668.8 2921.7 2231.9 3390.6 1731.5 4014.4
   2013 | 40.0 11746.7 6947.0 9349.3 8079.4 13812.9 3839.3 34218.2
   2014 | 34.0 17406.6 5582.9 15729.6 14084.6 20373.0 9942.4 28277.0
   2015 | 23.0 8695.0 1598.2 8468.7 7504.4 9820.8 5615.3 11797.0
   2016 | 34.0 11067.6 1061.3 10622.5 10350.6 11768.5 9796.0 13983.0
   2017 | 36.0 41688.3 25824.5 39291.1 18168.2 49361.3 11145.9 116833.1
   2018 | 32.0 35677.8 20870.3 28047.5 20194.1 46479.3 15238.3 100088.1
   2019 | 33.0 13356.0 3179.7 13209.6 10743.2 16248.2 8366.1 19462.9
   2020 | 7.0 8744.5 693.4 8974.8 7950.0 9367.3 7842.2 9594.0
---------+--------------------------------------------------------------------------------
   Total | 277.0 17662.1 17605.1 11758.5 8759.8 19011.9 1731.5 116833.1
------------------------------------------------------------------------------------------

4. Daily unique logged-in users
Its all time high is 7054, in 2018.

Code:

Summary for variables: muniqueliusers
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 382.1 64.4 379.1 328.2 436.2 281.3 573.3
   2013 | 40.0 1311.5 543.4 1400.0 867.1 1628.9 394.4 2509.7
   2014 | 34.0 2321.5 705.2 2206.3 1872.4 2802.6 1286.6 3811.6
   2015 | 23.0 1040.7 345.2 929.3 819.2 1177.9 716.1 2198.8
   2016 | 34.0 1407.0 208.0 1423.3 1328.7 1516.8 846.2 1822.0
   2017 | 36.0 4005.5 2302.2 3385.8 2036.8 5222.9 1401.8 9920.5
   2018 | 32.0 6708.2 2293.6 7054.3 4529.0 8434.4 2675.0 11121.2
   2019 | 33.0 1919.8 466.9 1931.0 1511.1 2246.2 1212.2 2905.1
   2020 | 7.0 1183.1 69.0 1194.4 1118.5 1241.0 1070.7 1271.3
---------+--------------------------------------------------------------------------------
   Total | 277.0 2340.0 2227.8 1578.9 1070.7 2509.7 281.3 11121.2
------------------------------------------------------------------------------------------

Comparisons between three periods, with the period 2012-2013 used as a reference group.

______________________________________	____________________________	_____________	_____________	_____________
Indicators	Reference group ^{(2012 - 2013)}	2014 - 2016 *	2017 - 2019 *	2020 *
______________________________________	____________________________	_____________	_____________	_____________
Daily total impressions	20509	120237 (5.9)	314465 (14.3)	209626 (9.2)
Daily total impressions from logged-in users	5754	17465 (3)	74245 (11.9)	24989 (3.3)
Daily unique IPs from logged-out users	4069	11229 (2.8 )	20175 (4)	8975 (1.2)
Daily unique logged-in users	457	1471 (2.6)	3225 (6.1)	1195 (1.6)
______________________________________	____________________________	_____________	_____________	_____________

* Values (Increasing-fold).

Raw results over periods:

Code:

Summary for variables: mimpressions
   by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 35142.8 26478.3 20509.0 15828.5 50788.7 6058.1 120381.3
2014 - 2016 | 91.0 121493.1 18637.8 120237.0 110620.4 130868.0 40761.9 162669.1
2017 - 2019 | 101.0 301804.9 88336.3 314465.1 240297.4 369258.3 86717.0 526107.3
   2020 | 7.0 209958.8 10762.8 209625.4 203026.7 215169.0 195923.4 229033.4
------------+--------------------------------------------------------------------------------
   Total | 277.0 165158.9 124211.2 124876.6 64020.7 258580.9 6058.1 526107.3
---------------------------------------------------------------------------------------------

Code:

Summary for variables: mliuser_impressions
   by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 10974.5 8437.0 5754.0 3981.5 18638.2 1795.2 37228.7
2014 - 2016 | 91.0 24499.6 14013.9 17464.6 14943.6 32439.4 9094.0 69853.3
2017 - 2019 | 101.0 72253.3 35818.4 74245.0 37901.2 103140.9 10015.6 143663.0
   2020 | 7.0 24032.9 4147.7 24988.8 20445.8 27793.8 17183.0 28053.4
------------+--------------------------------------------------------------------------------
   Total | 277.0 38091.3 35354.1 21274.7 14443.6 57244.7 1795.2 143663.0
---------------------------------------------------------------------------------------------

Code:

Summary for variables: muniqueip
   by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 7434.3 6670.0 4068.8 2936.7 9382.3 1731.5 34218.2
2014 - 2016 | 91.0 12836.3 5091.3 11228.5 9972.1 14889.6 5615.3 28277.0
2017 - 2019 | 101.0 30526.9 22854.2 20174.5 15402.4 42793.0 8366.1 116833.1
   2020 | 7.0 8744.5 693.4 8974.8 7950.0 9367.3 7842.2 9594.0
------------+--------------------------------------------------------------------------------
   Total | 277.0 17662.1 17605.1 11758.5 8759.8 19011.9 1731.5 116833.1
---------------------------------------------------------------------------------------------

Code:

Summary for variables: muniqueliusers
   by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 858.7 608.4 456.4 390.8 1407.4 281.3 2509.7
2014 - 2016 | 91.0 1656.1 717.5 1470.4 1203.0 1962.7 716.1 3811.6
2017 - 2019 | 101.0 4180.3 2701.4 3224.8 1974.7 5964.9 1212.2 11121.2
   2020 | 7.0 1183.1 69.0 1194.4 1118.5 1241.0 1070.7 1271.3
------------+--------------------------------------------------------------------------------
   Total | 277.0 2340.0 2227.8 1578.9 1070.7 2509.7 281.3 11121.2
---------------------------------------------------------------------------------------------

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

April 03, 2020, 07:59:25 AM

#13

Converted dataset:
* Stats are means of all slots in each rounds.

Code:

+-------------------------------------------------------------------------+
| round mimpressions mliuser_impressions muniqueip muniqueliusers |
|-------------------------------------------------------------------------|
1. | 301 203026.7 24988.82 7842.22 1070.74 |
2. | 300 195923.4 17183 7950.04 1118.5 |
3. | 299 203249.8 20445.78 8369.57 1194.39 |
4. | 298 209625.4 22563.06 9367.34 1204.85 |
5. | 297 213683.6 27793.76 8974.82 1180.94 |
|-------------------------------------------------------------------------|
6. | 296 215169 27202.68 9113.68 1271.35 |
7. | 295 229033.4 28053.44 9594.02 1241.04 |
8. | 294 237433.3 33095.78 8366.11 1212.24 |
9. | 293 218751.8 31976.96 8474.109 1235.89 |
10. | 292 225950.9 25770.32 9553.12 1327.45 |
|-------------------------------------------------------------------------|
11. | 291.6 280417.4 58683.05 9979.15 1368.19 |
12. | 291.3 255976.3 64461.38 9557.34 1337.13 |
13. | 291 292228.8 92419.04 11177.19 1443.64 |
14. | 290 275764.8 84456.51 10600.02 1455.32 |
15. | 289 229093.8 17903.98 9715.57 1433.98 |
|-------------------------------------------------------------------------|
16. | 288 307255.1 112470.2 10875.12 1531.82 |
17. | 287 256432.3 76478.43 10261.56 1511.07 |
18. | 286 311072.3 116003.5 11383.78 1580.78 |
19. | 285 290406.9 107004.4 11825.32 1621.13 |
20. | 284 297896.1 109534.8 10743.18 1690.39 |
|-------------------------------------------------------------------------|
21. | 283 300250.2 107787.2 11451.39 1752.57 |
22. | 282 313884.7 122089.8 11121.37 1766.48 |
23. | 281 337179.8 103565.1 13320.96 2032.47 |
24. | 280 305277.3 102429.3 13209.62 1921.22 |
25. | 279 340701.6 124806.3 13964.51 2048.44 |
|-------------------------------------------------------------------------|
26. | 278 325328.6 111911 12801.78 1930.99 |
27. | 277 423117.3 114442 13825.97 2111.12 |
28. | 276 409292.1 112939 17446.72 2354.02 |
29. | 275 343342.7 106282 15780.76 2179.83 |
30. | 274 336661.1 106726 18052.01 2137.72 |
|-------------------------------------------------------------------------|
31. | 273 337873.1 100488.5 16592.09 2176.95 |
32. | 272 359970.9 103140.9 17268.29 2239.04 |
33. | 271 336184.8 100595.3 15849.19 2246.18 |
34. | 270 307412.2 93506.88 15779.48 2247.73 |
35. | 269 295101.9 90434.84 15402.42 2304.16 |
|-------------------------------------------------------------------------|
36. | 268 341440.1 90938.14 16435.15 2315.68 |
37. | 267 248086 44463.62 16248.2 2466.69 |
38. | 266 301084.5 84122.09 19462.91 2566 |
39. | 265 368792.6 99783.42 17614.41 2902.07 |
40. | 264 343686.1 118686.5 16610.11 2905.1 |
|-------------------------------------------------------------------------|
41. | 263 364137.6 106266.5 16958.74 2675.04 |
42. | 262 340213.3 120962.3 15238.28 3086.08 |
43. | 261 361926.6 124601.1 16983.81 3473.51 |
44. | 260 373496 128386.2 17865.4 3827.52 |
45. | 259 393714.6 142440.5 18401.69 4003.18 |
|-------------------------------------------------------------------------|
46. | 258 405572.8 140677.6 19293.15 4436.01 |
47. | 257 395102.4 143663 20174.47 4621.92 |
48. | 256 410160.6 141941.6 22609.81 4270.39 |
49. | 255 366577.6 103295.5 20407.67 4357.64 |
50. | 254 341095.7 83504.26 20181.55 4779.87 |
|-------------------------------------------------------------------------|
51. | 253 389426.3 119507.9 20460.26 5471.21 |
52. | 252 369258.3 109407.1 20206.56 5373.21 |
53. | 251 384710.1 90854.92 24060.85 5699.79 |
54. | 250 401658.4 62557.86 29479.02 5964.86 |
55. | 249 363392.1 59189.3 27214.98 6879.67 |
|-------------------------------------------------------------------------|
56. | 248 353164 56496.2 25883.25 7081.23 |
57. | 247 392151.2 57107.84 24900.56 7211.37 |
58. | 246 526107.3 85532.73 37797.65 11121.24 |
59. | 245 374077.2 64213.39 28880.03 8348.24 |
60. | 244 374949.6 69086.28 29777.1 8101.86 |
|-------------------------------------------------------------------------|
61. | 243 405402.8 78227.44 31219.92 8482.39 |
62. | 242 394545.6 72300.14 45303.34 8495.01 |
63. | 241 377917.7 69888.03 46783.2 8075.64 |
64. | 240 355274.3 74244.97 42710.33 7027.27 |
65. | 239 375000.2 83559.04 48208 8321.98 |
|-------------------------------------------------------------------------|
66. | 238 271974.4 78709.44 46175.32 8809.23 |
67. | 237 347646.9 81321.59 50331.32 8142.42 |
68. | 236 369802.9 81887.58 60038.04 9113.96 |
69. | 235 350520.7 78158.12 61031.71 8386.37 |
70. | 234 400906.1 80080.25 68905.79 8819.27 |
|-------------------------------------------------------------------------|
71. | 233 400508 85624.48 84119.49 10058.35 |
72. | 232 444917.9 83608.33 100088.1 10147.65 |
73. | 231 440217.4 78991.86 116833.1 9920.479 |
74. | 230 384012.2 64416.77 91401.26 8084.18 |
75. | 229 375048.2 65931.84 99364.53 8207.67 |
|-------------------------------------------------------------------------|
76. | 228 353303.3 67031.66 88037.62 8332.92 |
77. | 227 337132.3 64189.38 65493.77 6462.21 |
78. | 226 327698.7 66672.67 63412.23 7623.04 |
79. | 225 314465.1 65211.05 54905.86 5731.15 |
80. | 224 303197.1 57818.07 62941.86 6582.47 |
|-------------------------------------------------------------------------|
81. | 223 264177.8 57244.71 46540.47 5437.65 |
82. | 222 261592.6 49414.35 43622.66 5008.1 |
83. | 221 267682.7 49909.51 42792.97 4993.68 |
84. | 220 257036.2 42450.4 42782.84 4076.34 |
85. | 219 249940.4 43371.47 50186.57 4633.08 |
|-------------------------------------------------------------------------|
86. | 218 258580.9 40301.65 48536.11 4183.75 |
87. | 217 240297.4 37901.2 43376.75 3968.85 |
88. | 216 226129.4 37899.3 39412.24 3296.75 |
89. | 215 222843.5 34887.28 37696.27 3630.49 |
90. | 214 203014.5 31611.89 38305.14 3579.74 |
|-------------------------------------------------------------------------|
91. | 213 185648.6 29196.76 39170.05 3474.82 |
92. | 212 200669.3 31302.43 43084.6 3274.63 |
93. | 211 209633.8 31533.68 43444.91 3224.79 |
94. | 210 210983.7 29783.82 38206.55 3197.91 |
95. | 209 190589.3 26649.17 34105.28 2896.55 |
|-------------------------------------------------------------------------|
96. | 208 170968.7 24441.83 26642.05 2416.75 |
97. | 207 165989.5 24180.18 22795.35 2286.81 |
98. | 206 153313 22900.15 19551.52 2234.77 |
99. | 205 152086.5 26705.68 17841.71 2098.77 |
100. | 204 150756.3 25852.33 18175.38 1974.74 |
|-------------------------------------------------------------------------|
101. | 203 149551.7 19931.19 17024.18 1748.66 |
102. | 202 153114.8 20839.38 18161.05 1817.45 |
103. | 201 164139.5 19462.43 17532.81 1888.02 |
104. | 200 86717.01 10015.55 11145.92 1401.785 |
105. | 199 144489.3 19333.02 15099.32 1610.67 |
|-------------------------------------------------------------------------|
106. | 198 134646.9 19650.49 15422.5 1709.3 |
107. | 197 124087.6 17678.33 14303.09 1606.44 |
108. | 196 119880.8 16172.66 13428.56 1582 |
109. | 195 121562.8 16248.43 13983.03 1616.85 |
110. | 194 119518.6 15607.62 12138.82 1457.47 |
|-------------------------------------------------------------------------|
111. | 193 113481.8 15574.8 12670.26 1822.03 |
112. | 192 119123.6 15071.75 12719.88 1515.43 |
113. | 191 121026.2 16467.96 12330.31 1516.78 |
114. | 190 124919 16953.85 11768.45 1307.89 |
115. | 189 96311.53 15489.41 11308.85 1202.99 |
|-------------------------------------------------------------------------|
116. | 188 111111.4 14726.37 11758.52 1551.52 |
117. | 187 104300.2 14133.81 10767.64 1470.44 |
118. | 186 97576.23 13396.87 10027.89 1385.2 |
119. | 185 107646.2 13338.18 10414.77 1474.03 |
120. | 184 113827.7 13553.08 9934.51 1323.7 |
|-------------------------------------------------------------------------|
121. | 183 123113.7 28292.58 10480.75 1405.35 |
122. | 182 115268 16773.77 10624.55 1427.3 |
123. | 181 111764 14747.32 11349.65 1565.22 |
124. | 180 118997.1 15106.11 11228.47 1666.79 |
125. | 179 128049.6 15049.24 10253.72 1400.85 |
|-------------------------------------------------------------------------|
126. | 178 125313.1 14943.63 9795.98 1530.64 |
127. | 177 112984.2 16098.36 10525.58 1491.69 |
128. | 176 118887.2 16802.19 11877.3 1710.89 |
129. | 175 123635 19960.94 12210.46 1374.4 |
130. | 174 127533.4 18900.05 13274.88 1672.16 |
|-------------------------------------------------------------------------|
131. | 173 109991.7 18101.85 10503 1328.73 |
132. | 172 102438.4 17082.37 10352.2 1420.61 |
133. | 171 103872.3 14443.57 10620.94 1408.75 |
134. | 170 99180.14 15168.35 10350.57 1426.08 |
135. | 169 101689.7 16663.9 10303.82 1472.26 |
|-------------------------------------------------------------------------|
136. | 168 110620.4 16862.07 10008.43 1357.23 |
137. | 167 110085.2 16262.36 9938.21 1291.91 |
138. | 166 105539 15628.03 11284.46 1342.19 |
139. | 165 104238.3 15603.23 10426.96 1096.96 |
140. | 164 122911.8 15641.31 10379.95 1041.95 |
|-------------------------------------------------------------------------|
141. | 163 117220.3 15011.64 10060.33 914.62 |
142. | 162 120237 15477.06 10624.03 846.2 |
143. | 161 108026.3 12868.57 9660.5 740.41 |
144. | 160 98248.79 12665.5 8554.91 716.09 |
145. | 159 110046 12316.04 9266.58 929.27 |
|-------------------------------------------------------------------------|
146. | 158 116444.9 13927.3 8007.74 743.35 |
147. | 157 114930.1 13219.1 6920.8 726.19 |
148. | 156 112985.4 14376.57 7294.27 847.7 |
149. | 155 118249.4 14441.79 7490.34 959.05 |
150. | 154 111646.5 14138.29 7762.23 883.03 |
|-------------------------------------------------------------------------|
151. | 153 103017.5 13393.28 7755.94 873.83 |
152. | 152 106363.5 14012.39 8468.66 1010.56 |
153. | 151 112167.5 13752.41 7504.42 819.19 |
154. | 150 110968.8 13372.98 7685.43 743.5 |
155. | 149.5 109871.8 13888.85 11568.68 2198.78 |
|-------------------------------------------------------------------------|
156. | 149 87466.23 12275.86 6681.34 1011.45 |
157. | 148 126740.7 18554.71 8286.47 897.27 |
158. | 147 123331.1 20603.46 9146.15 1080.79 |
159. | 146 145249.5 18919.34 9170 1252.94 |
160. | 145 145381 19757.93 9820.77 1177.87 |
|-------------------------------------------------------------------------|
161. | 144 132716.3 20790.19 10619.58 1527.4 |
162. | 143 132697.3 20188.15 10935.69 1444.37 |
163. | 142 97221.18 18171.97 9972.141 1051.92 |
164. | 141 40761.88 9093.98 5615.32 886.35 |
165. | 140 111835.7 24755.51 11797.05 1415.05 |
|-------------------------------------------------------------------------|
166. | 139 120742.7 17464.57 9942.37 2205.81 |
167. | 138 124876.6 20099.66 11120.51 1337.24 |
168. | 137 122142.8 19526.88 10460.19 1286.62 |
169. | 136 124662.3 21118.32 11142.02 1311.8 |
170. | 135 129741.4 22990.06 11685.81 1318.91 |
|-------------------------------------------------------------------------|
171. | 134 128383.3 23693.82 12151.24 1555.67 |
172. | 133 131753.4 23564.31 12605.09 1758.33 |
173. | 132 135172.1 27277.18 14084.56 1745.9 |
174. | 131 147166.5 29864.38 15067.33 1733.99 |
175. | 130 161975.4 31243.81 14573.09 1906.91 |
|-------------------------------------------------------------------------|
176. | 129 162669.1 30337.78 15724.32 1884.46 |
177. | 128 157491.2 36339.47 14461.51 2050.7 |
178. | 127 147388.1 34364.11 14079.21 1962.65 |
179. | 126 160564.3 37808.64 15824.18 2083.25 |
180. | 125 152765.8 37786.87 15645.72 2264.28 |
|-------------------------------------------------------------------------|
181. | 124 135314.3 38958.39 15734.9 2358.95 |
182. | 123 120696.5 40018.67 14889.64 2194.56 |
183. | 122 129479.8 41699.36 17113.16 2515.35 |
184. | 121 131806.7 42386.35 16299.87 2206.86 |
185. | 120 137454.3 44638.31 16550.29 2366.4 |
|-------------------------------------------------------------------------|
186. | 119 118725.5 38974.36 15018.76 2316.55 |
187. | 118 121486.5 38062.67 14990.38 1953.21 |
188. | 117 110430 32439.37 15901.74 1872.39 |
189. | 116 112479.1 38519.34 15961.08 2290.46 |
190. | 115 126627.2 55810.72 19011.89 2737.18 |
|-------------------------------------------------------------------------|
191. | 114 147629.4 65030.97 20372.99 3105.5 |
192. | 113 161728.8 69853.28 23844.28 3395.09 |
193. | 112 161643.4 62128.49 28277.02 3811.62 |
194. | 111 136637.7 52623.01 27165.78 3601.96 |
195. | 110 139108.8 52377.86 28056.06 3618.43 |
|-------------------------------------------------------------------------|
196. | 109 139058.3 54396.15 26759.18 3237.56 |
197. | 108 130868 49589.68 27148.62 3226.39 |
198. | 107 116613.3 43553.71 23889.91 2802.56 |
199. | 106 130248.2 46259.9 26271.68 2913.16 |
200. | 105 114074.9 37228.74 23062.74 2381.57 |
|-------------------------------------------------------------------------|
201. | 104 61236.46 16708.63 19692.48 1971.38 |
202. | 103 120381.3 26686.47 34218.23 2135.82 |
203. | 102 111627.1 27074.75 30121.49 1985.26 |
204. | 101 82053.77 24077.28 19767.71 1622.27 |
205. | 100 64020.66 18604.5 13707.2 1299.34 |
|-------------------------------------------------------------------------|
206. | 99 49506.06 14915.62 10380.83 1056.76 |
207. | 98 54876.27 13672.54 9089.29 958.8 |
208. | 97 42908.79 12112.66 6320.05 775.32 |
209. | 96 54504.56 21274.66 8506.02 1304.46 |
210. | 95 48101.89 18092.44 8759.78 1407.36 |
|-------------------------------------------------------------------------|
211. | 94 48752.04 18638.16 8981.9 1384.23 |
212. | 93 49814.09 19154.5 9253.43 1440.28 |
213. | 92 49972.16 18491.47 9316.25 1433.77 |
214. | 91 48274.6 18944.45 8981.67 1301.85 |
215. | 90 44569.15 17932.71 8876.8 1392.73 |
|-------------------------------------------------------------------------|
216. | 89 47392.84 18210.32 8745.56 1286.69 |
217. | 88 48941.07 17920.62 8693.01 1371.31 |
218. | 87 52870.88 19105.06 9382.34 1444.1 |
219. | 86 50788.66 19997.83 10211.88 1578.9 |
220. | 85 43849.17 20546.61 9870.15 1689.05 |
|-------------------------------------------------------------------------|
221. | 84 52437.75 21049.61 10528.52 1551.88 |
222. | 83 58152.08 23082.32 11620.51 2509.68 |
223. | 82 56211.67 21901.3 11923.18 1639.61 |
224. | 81 59370.51 23886.62 11615.14 1635.54 |
225. | 80 67077.76 28176.62 12626.57 1678.32 |
|-------------------------------------------------------------------------|
226. | 79 67227.58 23913.91 13918.63 1581.31 |
227. | 78 64985.74 19692.11 14673.1 1656.7 |
228. | 77 73012.48 19771.29 18643.45 1511.16 |
229. | 76 96069.47 20083.79 24558.49 1615.48 |
230. | 75 63297.95 14973.29 17017.29 1156.62 |
|-------------------------------------------------------------------------|
231. | 73 36374 8633.24 7652.79 758.43 |
232. | 72 36384.69 9049.06 7418.74 715.28 |
233. | 71 26966.28 6945.22 5569.49 598.73 |
234. | 70 22315.17 5772.17 5110.03 499.14 |
235. | 69 20933.36 4972.05 4444.95 394.35 |
|-------------------------------------------------------------------------|
236. | 68 21284.1 5113.28 4392.51 399.44 |
237. | 67 20130.95 5182.08 4123.23 465.33 |
238. | 66 18206.87 4446.34 3839.29 456.63 |
239. | 65 18842.03 3928.5 4253.5 416.17 |
240. | 64 19114.82 3128.87 3222.25 390.78 |
|-------------------------------------------------------------------------|
241. | 63 15828.52 2798.63 2868.86 355.09 |
242. | 62 14623.54 3469.21 3241.83 408.56 |
243. | 61 15969.57 3930.26 3915.45 420.34 |
244. | 60 16667.5 3965 4014.4 450.64 |
245. | 59 18029.75 4316.92 3761.98 456.22 |
|-------------------------------------------------------------------------|
246. | 58 16300 3677.55 3387.34 424.49 |
247. | 57 14897.69 3447.26 3253.61 411.99 |
248. | 56 14084.4 3386.01 3148.49 397.88 |
249. | 55 15694.12 3803.23 3179.16 436.46 |
250. | 54 16548.53 4314.92 3351.47 436.19 |
|-------------------------------------------------------------------------|
251. | 53 16587.74 4216.55 3610.8 573.33 |
252. | 52 6058.073 1795.2 1731.457 348.27 |
253. | 51 17815.61 5409.98 3390.65 408.46 |
254. | 50 20337.76 5640.11 3365.37 434.02 |
255. | 49 17991.77 5735.89 3402.14 441.93 |
|-------------------------------------------------------------------------|
256. | 48 20454.73 6812.13 3925.71 470.14 |
257. | 47 19035.63 6371.32 3564.73 436.84 |
258. | 46 20563.31 7068.85 3551.15 451 |
259. | 45 20716.63 7213.18 3671.68 453.64 |
260. | 44 16207.14 4609.32 2936.67 367.43 |
|-------------------------------------------------------------------------|
261. | 43 16295.73 5277.55 2906.71 393.46 |
262. | 42 16165.22 5352.38 2743.43 362.37 |
263. | 41 14792.36 4583 2829.13 346.71 |
264. | 40 16064.9 4518.68 2754.97 328.18 |
265. | 39 14196.71 4506.88 2231.86 324.53 |
|-------------------------------------------------------------------------|
266. | 38 14695.52 4627.15 2307.02 358.06 |
267. | 37 14850.75 4951.34 2272.89 307.78 |
268. | 36 14666.46 4280.32 2230.75 337.85 |
269. | 35 11329.86 3879.17 2113.89 332.21 |
270. | 34 12433.63 3840.39 2450.02 328.13 |
|-------------------------------------------------------------------------|
271. | 33 11542.58 3838.12 2168.8 324.34 |
272. | 32 12076.05 3981.47 2704.15 328.28 |
273. | 31 10017.87 3544.83 2029.62 304.41 |
274. | 30 10825.75 3340.91 2008.36 304.85 |
275. | 29 10140.64 3324.5 1936.89 281.31 |
|-------------------------------------------------------------------------|
276. | 28 9327.17 3482.07 1910.51 291.33 |
277. | 27 10396.15 3607.76 1916.57 293.34 |
+-------------------------------------------------------------------------+

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

April 03, 2020, 08:05:00 AM

#14

Dataset for start-, end-date, and period of each rounds

The variable period is calculated by the formula:

(end - start) 86400.
86400 is total seconds per day.

Code:

+----------------------------------------+
   | round start end period |
   |----------------------------------------|
  1. | 301 08mar2020 18mar2020 10.8 |
  2. | 300 26feb2020 08mar2020 11 |
  3. | 299 15feb2020 26feb2020 11 |
  4. | 298 03feb2020 15feb2020 11.3 |
  5. | 297 23jan2020 03feb2020 11 |
   |----------------------------------------|
  6. | 296 12jan2020 23jan2020 11 |
  7. | 295 01jan2020 12jan2020 10.9 |
  8. | 294 22dec2019 01jan2020 10.8 |
  9. | 293 10dec2019 22dec2019 11.1 |
10. | 292 29nov2019 10dec2019 11.1 |
   |----------------------------------------|
11. | 291.6 18nov2019 29nov2019 11.2 |
12. | 291.3 07nov2019 18nov2019 10.9 |
13. | 291 27oct2019 07nov2019 11 |
14. | 290 16oct2019 27oct2019 10.7 |
15. | 289 05oct2019 16oct2019 11.1 |
   |----------------------------------------|
16. | 288 24sep2019 05oct2019 10.9 |
17. | 287 13sep2019 24sep2019 11.1 |
18. | 286 02sep2019 13sep2019 11.1 |
19. | 285 22aug2019 02sep2019 11.2 |
20. | 284 11aug2019 22aug2019 10.9 |
   |----------------------------------------|
21. | 283 31jul2019 11aug2019 11.1 |
22. | 282 19jul2019 31jul2019 11.9 |
23. | 281 09jul2019 19jul2019 10.5 |
24. | 280 26jun2019 09jul2019 12.3 |
25. | 279 15jun2019 26jun2019 11.7 |
   |----------------------------------------|
26. | 278 03jun2019 15jun2019 11.5 |
27. | 277 22may2019 03jun2019 12 |
28. | 276 12may2019 22may2019 10.6 |
29. | 275 01may2019 12may2019 10.2 |
30. | 274 21apr2019 01may2019 10.7 |
   |----------------------------------------|
31. | 273 10apr2019 21apr2019 10.2 |
32. | 272 30mar2019 10apr2019 11.1 |
33. | 271 20mar2019 30mar2019 10.2 |
34. | 270 10mar2019 20mar2019 10.5 |
35. | 269 27feb2019 10mar2019 10.3 |
   |----------------------------------------|
36. | 268 15feb2019 27feb2019 11.9 |
37. | 267 04feb2019 15feb2019 11.1 |
38. | 266 24jan2019 04feb2019 11 |
39. | 265 14jan2019 24jan2019 10 |
40. | 264 04jan2019 14jan2019 10.8 |
   |----------------------------------------|
41. | 263 22dec2018 04jan2019 12.2 |
42. | 262 11dec2018 22dec2018 10.6 |
43. | 261 01dec2018 11dec2018 10.3 |
44. | 260 21nov2018 01dec2018 9.9 |
45. | 259 10nov2018 21nov2018 11.2 |
   |----------------------------------------|
46. | 258 31oct2018 10nov2018 10.1 |
47. | 257 21oct2018 31oct2018 10 |
48. | 256 09oct2018 21oct2018 12.4 |
49. | 255 26sep2018 09oct2018 12.1 |
50. | 254 14sep2018 26sep2018 12.3 |
   |----------------------------------------|
51. | 253 03sep2018 14sep2018 11 |
52. | 252 22aug2018 03sep2018 12 |
53. | 251 11aug2018 22aug2018 11.7 |
54. | 250 29jul2018 11aug2018 13 |
55. | 249 18jul2018 29jul2018 10.3 |
   |----------------------------------------|
56. | 248 08jul2018 18jul2018 10.7 |
57. | 247 27jun2018 08jul2018 11.1 |
58. | 246 19jun2018 27jun2018 7.2 |
59. | 245 06jun2018 16jun2018 10 |
60. | 244 26may2018 06jun2018 10.8 |
   |----------------------------------------|
61. | 243 16may2018 26may2018 10.7 |
62. | 242 06may2018 16may2018 10.2 |
63. | 241 25apr2018 06may2018 10.3 |
64. | 240 11apr2018 25apr2018 14 |
65. | 239 31mar2018 11apr2018 11 |
   |----------------------------------------|
66. | 238 21mar2018 31mar2018 10 |
67. | 237 09mar2018 21mar2018 11.9 |
68. | 236 27feb2018 09mar2018 10.7 |
69. | 235 14feb2018 27feb2018 12.4 |
70. | 234 02feb2018 14feb2018 12 |
   |----------------------------------------|
71. | 233 23jan2018 02feb2018 10.6 |
72. | 232 11jan2018 23jan2018 11.4 |
73. | 231 31dec2017 11jan2018 11 |
74. | 230 20dec2017 31dec2017 11 |
75. | 229 09dec2017 20dec2017 11 |
   |----------------------------------------|
76. | 228 30nov2017 09dec2017 9.5 |
77. | 227 17nov2017 30nov2017 12.7 |
78. | 226 09nov2017 17nov2017 8.6 |
79. | 225 26oct2017 09nov2017 13.2 |
80. | 224 17oct2017 26oct2017 9.1 |
   |----------------------------------------|
81. | 223 06oct2017 17oct2017 10.8 |
82. | 222 27sep2017 06oct2017 9.9 |
83. | 221 18sep2017 27sep2017 8.2 |
84. | 220 07sep2017 18sep2017 11 |
85. | 219 29aug2017 07sep2017 9.2 |
   |----------------------------------------|
86. | 218 19aug2017 29aug2017 9.9 |
87. | 217 09aug2017 19aug2017 9.9 |
88. | 216 28jul2017 09aug2017 12.7 |
89. | 215 18jul2017 28jul2017 9.4 |
90. | 214 09jul2017 18jul2017 9.1 |
   |----------------------------------------|
91. | 213 30jun2017 09jul2017 8.9 |
92. | 212 20jun2017 30jun2017 10 |
93. | 211 10jun2017 20jun2017 9.9 |
94. | 210 01jun2017 10jun2017 9 |
95. | 209 23may2017 01jun2017 9.2 |
   |----------------------------------------|
96. | 208 13may2017 23may2017 10.5 |
97. | 207 02may2017 13may2017 10.4 |
98. | 206 23apr2017 02may2017 9.6 |
99. | 205 13apr2017 23apr2017 9.4 |
100. | 204 03apr2017 13apr2017 10 |
   |----------------------------------------|
101. | 203 22mar2017 03apr2017 11.8 |
102. | 202 11mar2017 22mar2017 11 |
103. | 201 02mar2017 11mar2017 9.1 |
104. | 200 19feb2017 02mar2017 10.9 |
105. | 199 09feb2017 19feb2017 10.9 |
   |----------------------------------------|
106. | 198 30jan2017 09feb2017 10 |
107. | 197 19jan2017 30jan2017 10.2 |
108. | 196 09jan2017 19jan2017 10.1 |
109. | 195 30dec2016 09jan2017 9.9 |
110. | 194 19dec2016 30dec2016 11 |
   |----------------------------------------|
111. | 193 12dec2016 19dec2016 7.3 |
112. | 192 02dec2016 12dec2016 9.7 |
113. | 191 22nov2016 02dec2016 10.1 |
114. | 190 10nov2016 22nov2016 12.6 |
115. | 189 26oct2016 10nov2016 14.2 |
   |----------------------------------------|
116. | 188 18oct2016 26oct2016 8.8 |
117. | 187 08oct2016 18oct2016 9.4 |
118. | 186 28sep2016 08oct2016 9.9 |
119. | 185 19sep2016 28sep2016 9.1 |
120. | 184 08sep2016 19sep2016 11.1 |
   |----------------------------------------|
121. | 183 29aug2016 08sep2016 10.5 |
122. | 182 19aug2016 29aug2016 9.5 |
123. | 181 11aug2016 19aug2016 8.1 |
124. | 180 03aug2016 11aug2016 8.4 |
125. | 179 24jul2016 03aug2016 9.9 |
   |----------------------------------------|
126. | 178 15jul2016 24jul2016 8.4 |
127. | 177 05jul2016 15jul2016 9.8 |
128. | 176 27jun2016 05jul2016 8.2 |
129. | 175 15jun2016 27jun2016 12.5 |
130. | 174 06jun2016 15jun2016 8.8 |
   |----------------------------------------|
131. | 173 25may2016 06jun2016 11.7 |
132. | 172 16may2016 25may2016 9.5 |
133. | 171 07may2016 16may2016 9 |
134. | 170 28apr2016 07may2016 8.9 |
135. | 169 19apr2016 28apr2016 9.1 |
   |----------------------------------------|
136. | 168 08apr2016 19apr2016 10.3 |
137. | 167 28mar2016 08apr2016 11.1 |
138. | 166 18mar2016 28mar2016 10 |
139. | 165 04mar2016 18mar2016 14 |
140. | 164 18feb2016 04mar2016 15.6 |
   |----------------------------------------|
141. | 163 29jan2016 18feb2016 19.1 |
142. | 162 07jan2016 29jan2016 22.2 |
143. | 161 15dec2015 07jan2016 23.5 |
144. | 160 20nov2015 15dec2015 24.4 |
145. | 159 05nov2015 20nov2015 15.6 |
   |----------------------------------------|
146. | 158 13oct2015 05nov2015 22.3 |
147. | 157 23sep2015 13oct2015 20.8 |
148. | 156 06sep2015 23sep2015 17 |
149. | 155 22aug2015 06sep2015 14.4 |
150. | 154 06aug2015 22aug2015 16.6 |
   |----------------------------------------|
151. | 153 20jul2015 06aug2015 16.4 |
152. | 152 06jul2015 20jul2015 14.1 |
153. | 151 18jun2015 06jul2015 18.5 |
154. | 150 29may2015 18jun2015 20.1 |
155. | 149.5 25may2015 29may2015 3.5 |
   |----------------------------------------|
156. | 149 12may2015 25may2015 13 |
157. | 148 22apr2015 12may2015 19.8 |
158. | 147 07apr2015 22apr2015 15.7 |
159. | 146 25mar2015 07apr2015 12.9 |
160. | 145 10mar2015 25mar2015 15.1 |
   |----------------------------------------|
161. | 144 28feb2015 10mar2015 10 |
162. | 143 17feb2015 28feb2015 11 |
163. | 142 30jan2015 17feb2015 17.9 |
164. | 141 15jan2015 30jan2015 15.1 |
165. | 140 02jan2015 15jan2015 13 |
   |----------------------------------------|
166. | 139 22dec2014 02jan2015 11.2 |
167. | 138 09dec2014 22dec2014 12.8 |
168. | 137 26nov2014 09dec2014 13 |
169. | 136 12nov2014 26nov2014 13.2 |
170. | 135 30oct2014 12nov2014 13 |
   |----------------------------------------|
171. | 134 21oct2014 30oct2014 9.8 |
172. | 133 11oct2014 21oct2014 10 |
173. | 132 29sep2014 11oct2014 12 |
174. | 131 16sep2014 29sep2014 13.1 |
175. | 130 04sep2014 16sep2014 11.8 |
   |----------------------------------------|
176. | 129 23aug2014 04sep2014 11.9 |
177. | 128 12aug2014 23aug2014 11.2 |
178. | 127 31jul2014 12aug2014 11.9 |
179. | 126 20jul2014 31jul2014 11 |
180. | 125 10jul2014 20jul2014 10 |
   |----------------------------------------|
181. | 124 30jun2014 10jul2014 10 |
182. | 123 19jun2014 30jun2014 11 |
183. | 122 10jun2014 19jun2014 9 |
184. | 121 30may2014 10jun2014 11.1 |
185. | 120 19may2014 30may2014 10.1 |
   |----------------------------------------|
186. | 119 10may2014 19may2014 9.8 |
187. | 118 28apr2014 10may2014 11.9 |
188. | 117 17apr2014 28apr2014 11 |
189. | 116 05apr2014 17apr2014 12 |
190. | 115 25mar2014 05apr2014 10.9 |
   |----------------------------------------|
191. | 114 15mar2014 25mar2014 10.2 |
192. | 113 05mar2014 15mar2014 10 |
193. | 112 25feb2014 05mar2014 8 |
194. | 111 16feb2014 25feb2014 8.4 |
195. | 110 08feb2014 16feb2014 8.5 |
   |----------------------------------------|
196. | 109 29jan2014 08feb2014 9.8 |
197. | 108 20jan2014 29jan2014 9.3 |
198. | 107 10jan2014 20jan2014 9.8 |
199. | 106 01jan2014 10jan2014 9 |
200. | 105 21dec2013 01jan2014 10.5 |
   |----------------------------------------|
201. | 104 11dec2013 21dec2013 10.5 |
202. | 103 02dec2013 11dec2013 9.1 |
203. | 102 21nov2013 02dec2013 11.1 |
204. | 101 11nov2013 21nov2013 10 |
205. | 100 01nov2013 11nov2013 10 |
   |----------------------------------------|
206. | 99 22oct2013 01nov2013 9.9 |
207. | 98 12oct2013 22oct2013 9.5 |
208. | 97 26sep2013 12oct2013 15.7 |
209. | 96 18sep2013 26sep2013 8.9 |
210. | 95 09sep2013 18sep2013 8.1 |
   |----------------------------------------|
211. | 94 01sep2013 09sep2013 8.7 |
212. | 93 24aug2013 01sep2013 8.1 |
213. | 92 16aug2013 24aug2013 7.8 |
214. | 91 07aug2013 16aug2013 9.1 |
215. | 90 30jul2013 07aug2013 8.1 |
   |----------------------------------------|
216. | 89 20jul2013 30jul2013 9.3 |
217. | 88 12jul2013 20jul2013 8.5 |
218. | 87 03jul2013 12jul2013 8.3 |
219. | 86 26jun2013 03jul2013 7.8 |
220. | 85 19jun2013 26jun2013 7.1 |
   |----------------------------------------|
221. | 84 11jun2013 19jun2013 8.1 |
222. | 83 02jun2013 11jun2013 9 |
223. | 82 25may2013 02jun2013 7.9 |
224. | 81 17may2013 25may2013 8 |
225. | 80 07may2013 17may2013 9.5 |
   |----------------------------------------|
226. | 79 28apr2013 07may2013 9 |
227. | 78 21apr2013 28apr2013 7.5 |
228. | 77 12apr2013 21apr2013 8.8 |
229. | 76 05apr2013 12apr2013 7.2 |
230. | 75 28mar2013 05apr2013 7.8 |
   |----------------------------------------|
231. | 74 21mar2013 28mar2013 7 |
232. | 73 13mar2013 21mar2013 7.6 |
233. | 72 05mar2013 13mar2013 7.8 |
234. | 71 25feb2013 05mar2013 8.1 |
235. | 70 17feb2013 25feb2013 8.7 |
   |----------------------------------------|
236. | 69 07feb2013 17feb2013 9.2 |
237. | 68 29jan2013 07feb2013 9.1 |
238. | 67 21jan2013 29jan2013 7.9 |
239. | 66 14jan2013 21jan2013 7.1 |
240. | 65 07jan2013 14jan2013 7.5 |
   |----------------------------------------|
241. | 64 31dec2012 07jan2013 7.2 |
242. | 63 23dec2012 31dec2012 7.8 |
243. | 62 16dec2012 23dec2012 7.3 |
244. | 61 08dec2012 16dec2012 7.6 |
245. | 60 01dec2012 08dec2012 7.2 |
   |----------------------------------------|
246. | 59 23nov2012 01dec2012 7.3 |
247. | 58 16nov2012 23nov2012 7.2 |
248. | 57 09nov2012 16nov2012 7.1 |
249. | 56 02nov2012 09nov2012 7.5 |
250. | 55 26oct2012 02nov2012 7.1 |
   |----------------------------------------|
251. | 54 18oct2012 26oct2012 7.6 |
252. | 53 13oct2012 18oct2012 4.8 |
253. | 52 06oct2012 13oct2012 7.5 |
254. | 51 27sep2012 06oct2012 8.5 |
255. | 50 20sep2012 27sep2012 7.6 |
   |----------------------------------------|
256. | 49 12sep2012 20sep2012 7.4 |
257. | 48 05sep2012 12sep2012 7 |
258. | 47 29aug2012 05sep2012 7.4 |
259. | 46 22aug2012 29aug2012 7.1 |
260. | 45 14aug2012 22aug2012 7.2 |
   |----------------------------------------|
261. | 44 07aug2012 14aug2012 7.9 |
262. | 43 31jul2012 07aug2012 7 |
263. | 42 24jul2012 31jul2012 7 |
264. | 41 16jul2012 24jul2012 7.2 |
265. | 40 09jul2012 16jul2012 7.6 |
   |----------------------------------------|
266. | 39 01jul2012 09jul2012 8.2 |
267. | 38 23jun2012 01jul2012 7.1 |
268. | 37 15jun2012 23jun2012 8.9 |
269. | 36 07jun2012 15jun2012 7.1 |
270. | 35 31may2012 07jun2012 7 |
   |----------------------------------------|
271. | 34 24may2012 31may2012 7 |
272. | 33 17may2012 24may2012 7 |
273. | 32 10may2012 17may2012 7 |
274. | 31 03may2012 10may2012 7.1 |
275. | 30 26apr2012 03may2012 7 |
   |----------------------------------------|
276. | 29 19apr2012 26apr2012 7.7 |
277. | 28 11apr2012 19apr2012 7.3 |
278. | 27 04apr2012 11apr2012 7.1 |
   +----------------------------------------+

How long each round usually lasts? 10.1 days in median (p50). Min and max are 3.5 and 24.4 days, respectively.

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
period | 278.0 10.4 2.9 10.1 8.6 11.1 3.5 24.4
----------------------------------------------------------------------------------------------

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

July 08, 2020, 02:59:19 PM

#15

Converted dataset:

Rounds: 27 - 310
* Stats are means of all slots in each rounds.

Code:

+-------------------------------------------------------------------------+
| round mimpressions mliuser_impressions muniqueip muniqueliusers |
|-------------------------------------------------------------------------|
1. | 310 308796.3 58125.28 6781.04 983.79 |
2. | 309 225717.2 19445.78 7591.09 1002.04 |
3. | 308 261943.6 30290.44 7590.96 1064.6 |
4. | 307 309910.8 23898.55 9355.56 1079.15 |
5. | 306 237258.7 23016.51 9275.43 1121.65 |
|-------------------------------------------------------------------------|
6. | 305 292501.5 48145.99 8249.66 1081.66 |
7. | 304 262434.5 34199.44 8119.05 1066.01 |
8. | 303 261516.8 46547.33 7357.83 1014.31 |
9. | 302 215599.3 28979.17 8064.43 984.03 |
10. | 301 203026.7 24988.82 7842.22 1070.74 |
|-------------------------------------------------------------------------|
11. | 300 195923.4 17183 7950.04 1118.5 |
12. | 299 203249.8 20445.78 8369.57 1194.39 |
13. | 298 209625.4 22563.06 9367.34 1204.85 |
14. | 297 213683.6 27793.76 8974.82 1180.94 |
15. | 296 215169 27202.68 9113.68 1271.35 |
|-------------------------------------------------------------------------|
16. | 295 229033.4 28053.44 9594.02 1241.04 |
17. | 294 237433.3 33095.78 8366.11 1212.24 |
18. | 293 218751.8 31976.96 8474.109 1235.89 |
19. | 292 225950.9 25770.32 9553.12 1327.45 |
20. | 291.6 280417.4 58683.05 9979.15 1368.19 |
|-------------------------------------------------------------------------|
21. | 291.3 255976.3 64461.38 9557.34 1337.13 |
22. | 291 292228.8 92419.04 11177.19 1443.64 |
23. | 290 275764.8 84456.51 10600.02 1455.32 |
24. | 289 229093.8 17903.98 9715.57 1433.98 |
25. | 288 307255.1 112470.2 10875.12 1531.82 |
|-------------------------------------------------------------------------|
26. | 287 256432.3 76478.43 10261.56 1511.07 |
27. | 286 311072.3 116003.5 11383.78 1580.78 |
28. | 285 290406.9 107004.4 11825.32 1621.13 |
29. | 284 297896.1 109534.8 10743.18 1690.39 |
30. | 283 300250.2 107787.2 11451.39 1752.57 |
|-------------------------------------------------------------------------|
31. | 282 313884.7 122089.8 11121.37 1766.48 |
32. | 281 337179.8 103565.1 13320.96 2032.47 |
33. | 280 305277.3 102429.3 13209.62 1921.22 |
34. | 279 340701.6 124806.3 13964.51 2048.44 |
35. | 278 325328.6 111911 12801.78 1930.99 |
|-------------------------------------------------------------------------|
36. | 277 423117.3 114442 13825.97 2111.12 |
37. | 276 409292.1 112939 17446.72 2354.02 |
38. | 275 343342.7 106282 15780.76 2179.83 |
39. | 274 336661.1 106726 18052.01 2137.72 |
40. | 273 337873.1 100488.5 16592.09 2176.95 |
|-------------------------------------------------------------------------|
41. | 272 359970.9 103140.9 17268.29 2239.04 |
42. | 271 336184.8 100595.3 15849.19 2246.18 |
43. | 270 307412.2 93506.88 15779.48 2247.73 |
44. | 269 295101.9 90434.84 15402.42 2304.16 |
45. | 268 341440.1 90938.14 16435.15 2315.68 |
|-------------------------------------------------------------------------|
46. | 267 248086 44463.62 16248.2 2466.69 |
47. | 266 301084.5 84122.09 19462.91 2566 |
48. | 265 368792.6 99783.42 17614.41 2902.07 |
49. | 264 343686.1 118686.5 16610.11 2905.1 |
50. | 263 364137.6 106266.5 16958.74 2675.04 |
|-------------------------------------------------------------------------|
51. | 262 340213.3 120962.3 15238.28 3086.08 |
52. | 261 361926.6 124601.1 16983.81 3473.51 |
53. | 260 373496 128386.2 17865.4 3827.52 |
54. | 259 393714.6 142440.5 18401.69 4003.18 |
55. | 258 405572.8 140677.6 19293.15 4436.01 |
|-------------------------------------------------------------------------|
56. | 257 395102.4 143663 20174.47 4621.92 |
57. | 256 410160.6 141941.6 22609.81 4270.39 |
58. | 255 366577.6 103295.5 20407.67 4357.64 |
59. | 254 341095.7 83504.26 20181.55 4779.87 |
60. | 253 389426.3 119507.9 20460.26 5471.21 |
|-------------------------------------------------------------------------|
61. | 252 369258.3 109407.1 20206.56 5373.21 |
62. | 251 384710.1 90854.92 24060.85 5699.79 |
63. | 250 401658.4 62557.86 29479.02 5964.86 |
64. | 249 363392.1 59189.3 27214.98 6879.67 |
65. | 248 353164 56496.2 25883.25 7081.23 |
|-------------------------------------------------------------------------|
66. | 247 392151.2 57107.84 24900.56 7211.37 |
67. | 246 526107.3 85532.73 37797.65 11121.24 |
68. | 245 374077.2 64213.39 28880.03 8348.24 |
69. | 244 374949.6 69086.28 29777.1 8101.86 |
70. | 243 405402.8 78227.44 31219.92 8482.39 |
|-------------------------------------------------------------------------|
71. | 242 394545.6 72300.14 45303.34 8495.01 |
72. | 241 377917.7 69888.03 46783.2 8075.64 |
73. | 240 355274.3 74244.97 42710.33 7027.27 |
74. | 239 375000.2 83559.04 48208 8321.98 |
75. | 238 271974.4 78709.44 46175.32 8809.23 |
|-------------------------------------------------------------------------|
76. | 237 347646.9 81321.59 50331.32 8142.42 |
77. | 236 369802.9 81887.58 60038.04 9113.96 |
78. | 235 350520.7 78158.12 61031.71 8386.37 |
79. | 234 400906.1 80080.25 68905.79 8819.27 |
80. | 233 400508 85624.48 84119.49 10058.35 |
|-------------------------------------------------------------------------|
81. | 232 444917.9 83608.33 100088.1 10147.65 |
82. | 231 440217.4 78991.86 116833.1 9920.479 |
83. | 230 384012.2 64416.77 91401.26 8084.18 |
84. | 229 375048.2 65931.84 99364.53 8207.67 |
85. | 228 353303.3 67031.66 88037.62 8332.92 |
|-------------------------------------------------------------------------|
86. | 227 337132.3 64189.38 65493.77 6462.21 |
87. | 226 327698.7 66672.67 63412.23 7623.04 |
88. | 225 314465.1 65211.05 54905.86 5731.15 |
89. | 224 303197.1 57818.07 62941.86 6582.47 |
90. | 223 264177.8 57244.71 46540.47 5437.65 |
|-------------------------------------------------------------------------|
91. | 222 261592.6 49414.35 43622.66 5008.1 |
92. | 221 267682.7 49909.51 42792.97 4993.68 |
93. | 220 257036.2 42450.4 42782.84 4076.34 |
94. | 219 249940.4 43371.47 50186.57 4633.08 |
95. | 218 258580.9 40301.65 48536.11 4183.75 |
|-------------------------------------------------------------------------|
96. | 217 240297.4 37901.2 43376.75 3968.85 |
97. | 216 226129.4 37899.3 39412.24 3296.75 |
98. | 215 222843.5 34887.28 37696.27 3630.49 |
99. | 214 203014.5 31611.89 38305.14 3579.74 |
100. | 213 185648.6 29196.76 39170.05 3474.82 |
|-------------------------------------------------------------------------|
101. | 212 200669.3 31302.43 43084.6 3274.63 |
102. | 211 209633.8 31533.68 43444.91 3224.79 |
103. | 210 210983.7 29783.82 38206.55 3197.91 |
104. | 209 190589.3 26649.17 34105.28 2896.55 |
105. | 208 170968.7 24441.83 26642.05 2416.75 |
|-------------------------------------------------------------------------|
106. | 207 165989.5 24180.18 22795.35 2286.81 |
107. | 206 153313 22900.15 19551.52 2234.77 |
108. | 205 152086.5 26705.68 17841.71 2098.77 |
109. | 204 150756.3 25852.33 18175.38 1974.74 |
110. | 203 149551.7 19931.19 17024.18 1748.66 |
|-------------------------------------------------------------------------|
111. | 202 153114.8 20839.38 18161.05 1817.45 |
112. | 201 164139.5 19462.43 17532.81 1888.02 |
113. | 200 86717.01 10015.55 11145.92 1401.785 |
114. | 199 144489.3 19333.02 15099.32 1610.67 |
115. | 198 134646.9 19650.49 15422.5 1709.3 |
|-------------------------------------------------------------------------|
116. | 197 124087.6 17678.33 14303.09 1606.44 |
117. | 196 119880.8 16172.66 13428.56 1582 |
118. | 195 121562.8 16248.43 13983.03 1616.85 |
119. | 194 119518.6 15607.62 12138.82 1457.47 |
120. | 193 113481.8 15574.8 12670.26 1822.03 |
|-------------------------------------------------------------------------|
121. | 192 119123.6 15071.75 12719.88 1515.43 |
122. | 191 121026.2 16467.96 12330.31 1516.78 |
123. | 190 124919 16953.85 11768.45 1307.89 |
124. | 189 96311.53 15489.41 11308.85 1202.99 |
125. | 188 111111.4 14726.37 11758.52 1551.52 |
|-------------------------------------------------------------------------|
126. | 187 104300.2 14133.81 10767.64 1470.44 |
127. | 186 97576.23 13396.87 10027.89 1385.2 |
128. | 185 107646.2 13338.18 10414.77 1474.03 |
129. | 184 113827.7 13553.08 9934.51 1323.7 |
130. | 183 123113.7 28292.58 10480.75 1405.35 |
|-------------------------------------------------------------------------|
131. | 182 115268 16773.77 10624.55 1427.3 |
132. | 181 111764 14747.32 11349.65 1565.22 |
133. | 180 118997.1 15106.11 11228.47 1666.79 |
134. | 179 128049.6 15049.24 10253.72 1400.85 |
135. | 178 125313.1 14943.63 9795.98 1530.64 |
|-------------------------------------------------------------------------|
136. | 177 112984.2 16098.36 10525.58 1491.69 |
137. | 176 118887.2 16802.19 11877.3 1710.89 |
138. | 175 123635 19960.94 12210.46 1374.4 |
139. | 174 127533.4 18900.05 13274.88 1672.16 |
140. | 173 109991.7 18101.85 10503 1328.73 |
|-------------------------------------------------------------------------|
141. | 172 102438.4 17082.37 10352.2 1420.61 |
142. | 171 103872.3 14443.57 10620.94 1408.75 |
143. | 170 99180.14 15168.35 10350.57 1426.08 |
144. | 169 101689.7 16663.9 10303.82 1472.26 |
145. | 168 110620.4 16862.07 10008.43 1357.23 |
|-------------------------------------------------------------------------|
146. | 167 110085.2 16262.36 9938.21 1291.91 |
147. | 166 105539 15628.03 11284.46 1342.19 |
148. | 165 104238.3 15603.23 10426.96 1096.96 |
149. | 164 122911.8 15641.31 10379.95 1041.95 |
150. | 163 117220.3 15011.64 10060.33 914.62 |
|-------------------------------------------------------------------------|
151. | 162 120237 15477.06 10624.03 846.2 |
152. | 161 108026.3 12868.57 9660.5 740.41 |
153. | 160 98248.79 12665.5 8554.91 716.09 |
154. | 159 110046 12316.04 9266.58 929.27 |
155. | 158 116444.9 13927.3 8007.74 743.35 |
|-------------------------------------------------------------------------|
156. | 157 114930.1 13219.1 6920.8 726.19 |
157. | 156 112985.4 14376.57 7294.27 847.7 |
158. | 155 118249.4 14441.79 7490.34 959.05 |
159. | 154 111646.5 14138.29 7762.23 883.03 |
160. | 153 103017.5 13393.28 7755.94 873.83 |
|-------------------------------------------------------------------------|
161. | 152 106363.5 14012.39 8468.66 1010.56 |
162. | 151 112167.5 13752.41 7504.42 819.19 |
163. | 150 110968.8 13372.98 7685.43 743.5 |
164. | 149.5 109871.8 13888.85 11568.68 2198.78 |
165. | 149 87466.23 12275.86 6681.34 1011.45 |
|-------------------------------------------------------------------------|
166. | 148 126740.7 18554.71 8286.47 897.27 |
167. | 147 123331.1 20603.46 9146.15 1080.79 |
168. | 146 145249.5 18919.34 9170 1252.94 |
169. | 145 145381 19757.93 9820.77 1177.87 |
170. | 144 132716.3 20790.19 10619.58 1527.4 |
|-------------------------------------------------------------------------|
171. | 143 132697.3 20188.15 10935.69 1444.37 |
172. | 142 97221.18 18171.97 9972.141 1051.92 |
173. | 141 40761.88 9093.98 5615.32 886.35 |
174. | 140 111835.7 24755.51 11797.05 1415.05 |
175. | 139 120742.7 17464.57 9942.37 2205.81 |
|-------------------------------------------------------------------------|
176. | 138 124876.6 20099.66 11120.51 1337.24 |
177. | 137 122142.8 19526.88 10460.19 1286.62 |
178. | 136 124662.3 21118.32 11142.02 1311.8 |
179. | 135 129741.4 22990.06 11685.81 1318.91 |
180. | 134 128383.3 23693.82 12151.24 1555.67 |
|-------------------------------------------------------------------------|
181. | 133 131753.4 23564.31 12605.09 1758.33 |
182. | 132 135172.1 27277.18 14084.56 1745.9 |
183. | 131 147166.5 29864.38 15067.33 1733.99 |
184. | 130 161975.4 31243.81 14573.09 1906.91 |
185. | 129 162669.1 30337.78 15724.32 1884.46 |
|-------------------------------------------------------------------------|
186. | 128 157491.2 36339.47 14461.51 2050.7 |
187. | 127 147388.1 34364.11 14079.21 1962.65 |
188. | 126 160564.3 37808.64 15824.18 2083.25 |
189. | 125 152765.8 37786.87 15645.72 2264.28 |
190. | 124 135314.3 38958.39 15734.9 2358.95 |
|-------------------------------------------------------------------------|
191. | 123 120696.5 40018.67 14889.64 2194.56 |
192. | 122 129479.8 41699.36 17113.16 2515.35 |
193. | 121 131806.7 42386.35 16299.87 2206.86 |
194. | 120 137454.3 44638.31 16550.29 2366.4 |
195. | 119 118725.5 38974.36 15018.76 2316.55 |
|-------------------------------------------------------------------------|
196. | 118 121486.5 38062.67 14990.38 1953.21 |
197. | 117 110430 32439.37 15901.74 1872.39 |
198. | 116 112479.1 38519.34 15961.08 2290.46 |
199. | 115 126627.2 55810.72 19011.89 2737.18 |
200. | 114 147629.4 65030.97 20372.99 3105.5 |
|-------------------------------------------------------------------------|
201. | 113 161728.8 69853.28 23844.28 3395.09 |
202. | 112 161643.4 62128.49 28277.02 3811.62 |
203. | 111 136637.7 52623.01 27165.78 3601.96 |
204. | 110 139108.8 52377.86 28056.06 3618.43 |
205. | 109 139058.3 54396.15 26759.18 3237.56 |
|-------------------------------------------------------------------------|
206. | 108 130868 49589.68 27148.62 3226.39 |
207. | 107 116613.3 43553.71 23889.91 2802.56 |
208. | 106 130248.2 46259.9 26271.68 2913.16 |
209. | 105 114074.9 37228.74 23062.74 2381.57 |
210. | 104 61236.46 16708.63 19692.48 1971.38 |
|-------------------------------------------------------------------------|
211. | 103 120381.3 26686.47 34218.23 2135.82 |
212. | 102 111627.1 27074.75 30121.49 1985.26 |
213. | 101 82053.77 24077.28 19767.71 1622.27 |
214. | 100 64020.66 18604.5 13707.2 1299.34 |
215. | 99 49506.06 14915.62 10380.83 1056.76 |
|-------------------------------------------------------------------------|
216. | 98 54876.27 13672.54 9089.29 958.8 |
217. | 97 42908.79 12112.66 6320.05 775.32 |
218. | 96 54504.56 21274.66 8506.02 1304.46 |
219. | 95 48101.89 18092.44 8759.78 1407.36 |
220. | 94 48752.04 18638.16 8981.9 1384.23 |
|-------------------------------------------------------------------------|
221. | 93 49814.09 19154.5 9253.43 1440.28 |
222. | 92 49972.16 18491.47 9316.25 1433.77 |
223. | 91 48274.6 18944.45 8981.67 1301.85 |
224. | 90 44569.15 17932.71 8876.8 1392.73 |
225. | 89 47392.84 18210.32 8745.56 1286.69 |
|-------------------------------------------------------------------------|
226. | 88 48941.07 17920.62 8693.01 1371.31 |
227. | 87 52870.88 19105.06 9382.34 1444.1 |
228. | 86 50788.66 19997.83 10211.88 1578.9 |
229. | 85 43849.17 20546.61 9870.15 1689.05 |
230. | 84 52437.75 21049.61 10528.52 1551.88 |
|-------------------------------------------------------------------------|
231. | 83 58152.08 23082.32 11620.51 2509.68 |
232. | 82 56211.67 21901.3 11923.18 1639.61 |
233. | 81 59370.51 23886.62 11615.14 1635.54 |
234. | 80 67077.76 28176.62 12626.57 1678.32 |
235. | 79 67227.58 23913.91 13918.63 1581.31 |
|-------------------------------------------------------------------------|
236. | 78 64985.74 19692.11 14673.1 1656.7 |
237. | 77 73012.48 19771.29 18643.45 1511.16 |
238. | 76 96069.47 20083.79 24558.49 1615.48 |
239. | 75 63297.95 14973.29 17017.29 1156.62 |
240. | 74 0 0 0 0 |
|-------------------------------------------------------------------------|
241. | 73 36374 8633.24 7652.79 758.43 |
242. | 72 36384.69 9049.06 7418.74 715.28 |
243. | 71 26966.28 6945.22 5569.49 598.73 |
244. | 70 22315.17 5772.17 5110.03 499.14 |
245. | 69 20933.36 4972.05 4444.95 394.35 |
|-------------------------------------------------------------------------|
246. | 68 21284.1 5113.28 4392.51 399.44 |
247. | 67 20130.95 5182.08 4123.23 465.33 |
248. | 66 18206.87 4446.34 3839.29 456.63 |
249. | 65 18842.03 3928.5 4253.5 416.17 |
250. | 64 19114.82 3128.87 3222.25 390.78 |
|-------------------------------------------------------------------------|
251. | 63 15828.52 2798.63 2868.86 355.09 |
252. | 62 14623.54 3469.21 3241.83 408.56 |
253. | 61 15969.57 3930.26 3915.45 420.34 |
254. | 60 16667.5 3965 4014.4 450.64 |
255. | 59 18029.75 4316.92 3761.98 456.22 |
|-------------------------------------------------------------------------|
256. | 58 16300 3677.55 3387.34 424.49 |
257. | 57 14897.69 3447.26 3253.61 411.99 |
258. | 56 14084.4 3386.01 3148.49 397.88 |
259. | 55 15694.12 3803.23 3179.16 436.46 |
260. | 54 16548.53 4314.92 3351.47 436.19 |
|-------------------------------------------------------------------------|
261. | 53 16587.74 4216.55 3610.8 573.33 |
262. | 52 6058.073 1795.2 1731.457 348.27 |
263. | 51 17815.61 5409.98 3390.65 408.46 |
264. | 50 20337.76 5640.11 3365.37 434.02 |
265. | 49 17991.77 5735.89 3402.14 441.93 |
|-------------------------------------------------------------------------|
266. | 48 20454.73 6812.13 3925.71 470.14 |
267. | 47 19035.63 6371.32 3564.73 436.84 |
268. | 46 20563.31 7068.85 3551.15 451 |
269. | 45 20716.63 7213.18 3671.68 453.64 |
270. | 44 16207.14 4609.32 2936.67 367.43 |
|-------------------------------------------------------------------------|
271. | 43 16295.73 5277.55 2906.71 393.46 |
272. | 42 16165.22 5352.38 2743.43 362.37 |
273. | 41 14792.36 4583 2829.13 346.71 |
274. | 40 16064.9 4518.68 2754.97 328.18 |
275. | 39 14196.71 4506.88 2231.86 324.53 |
|-------------------------------------------------------------------------|
276. | 38 14695.52 4627.15 2307.02 358.06 |
277. | 37 14850.75 4951.34 2272.89 307.78 |
278. | 36 14666.46 4280.32 2230.75 337.85 |
279. | 35 11329.86 3879.17 2113.89 332.21 |
280. | 34 12433.63 3840.39 2450.02 328.13 |
|-------------------------------------------------------------------------|
281. | 33 11542.58 3838.12 2168.8 324.34 |
282. | 32 12076.05 3981.47 2704.15 328.28 |
283. | 31 10017.87 3544.83 2029.62 304.41 |
284. | 30 10825.75 3340.91 2008.36 304.85 |
285. | 29 10140.64 3324.5 1936.89 281.31 |
|-------------------------------------------------------------------------|
286. | 28 9327.17 3482.07 1910.51 291.33 |
287. | 27 10396.15 3607.76 1916.57 293.34 |
+-------------------------------------------------------------------------+

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

July 08, 2020, 03:01:22 PM

#16

Dataset for start-, end-date, and period of each rounds

The variable period is calculated by the formula:

(end - start) 86400.
86400 is total seconds per day.

Code:

+----------------------------------------+
| round start end period |
|----------------------------------------|
1. | 310 14jun2020 25jun2020 11 |
2. | 309 03jun2020 14jun2020 11.1 |
3. | 308 23may2020 03jun2020 10.8 |
4. | 307 12may2020 23may2020 10.8 |
5. | 306 01may2020 12may2020 10.8 |
|----------------------------------------|
6. | 305 20apr2020 01may2020 11.1 |
7. | 304 09apr2020 20apr2020 11.2 |
8. | 303 29mar2020 09apr2020 10.9 |
9. | 302 18mar2020 29mar2020 11 |
10. | 301 08mar2020 18mar2020 10.8 |
|----------------------------------------|
11. | 300 26feb2020 08mar2020 11 |
12. | 299 15feb2020 26feb2020 11 |
13. | 298 03feb2020 15feb2020 11.3 |
14. | 297 23jan2020 03feb2020 11 |
15. | 296 12jan2020 23jan2020 11 |
|----------------------------------------|
16. | 295 01jan2020 12jan2020 10.9 |
17. | 294 22dec2019 01jan2020 10.8 |
18. | 293 10dec2019 22dec2019 11.1 |
19. | 292 29nov2019 10dec2019 11.1 |
20. | 291.6 18nov2019 29nov2019 11.2 |
|----------------------------------------|
21. | 291.3 07nov2019 18nov2019 10.9 |
22. | 291 27oct2019 07nov2019 11 |
23. | 290 16oct2019 27oct2019 10.7 |
24. | 289 05oct2019 16oct2019 11.1 |
25. | 288 24sep2019 05oct2019 10.9 |
|----------------------------------------|
26. | 287 13sep2019 24sep2019 11.1 |
27. | 286 02sep2019 13sep2019 11.1 |
28. | 285 22aug2019 02sep2019 11.2 |
29. | 284 11aug2019 22aug2019 10.9 |
30. | 283 31jul2019 11aug2019 11.1 |
|----------------------------------------|
31. | 282 19jul2019 31jul2019 11.9 |
32. | 281 09jul2019 19jul2019 10.5 |
33. | 280 26jun2019 09jul2019 12.3 |
34. | 279 15jun2019 26jun2019 11.7 |
35. | 278 03jun2019 15jun2019 11.5 |
|----------------------------------------|
36. | 277 22may2019 03jun2019 12 |
37. | 276 12may2019 22may2019 10.6 |
38. | 275 01may2019 12may2019 10.2 |
39. | 274 21apr2019 01may2019 10.7 |
40. | 273 10apr2019 21apr2019 10.2 |
|----------------------------------------|
41. | 272 30mar2019 10apr2019 11.1 |
42. | 271 20mar2019 30mar2019 10.2 |
43. | 270 10mar2019 20mar2019 10.5 |
44. | 269 27feb2019 10mar2019 10.3 |
45. | 268 15feb2019 27feb2019 11.9 |
|----------------------------------------|
46. | 267 04feb2019 15feb2019 11.1 |
47. | 266 24jan2019 04feb2019 11 |
48. | 265 14jan2019 24jan2019 10 |
49. | 264 04jan2019 14jan2019 10.8 |
50. | 263 22dec2018 04jan2019 12.2 |
|----------------------------------------|
51. | 262 11dec2018 22dec2018 10.6 |
52. | 261 01dec2018 11dec2018 10.3 |
53. | 260 21nov2018 01dec2018 9.9 |
54. | 259 10nov2018 21nov2018 11.2 |
55. | 258 31oct2018 10nov2018 10.1 |
|----------------------------------------|
56. | 257 21oct2018 31oct2018 10 |
57. | 256 09oct2018 21oct2018 12.4 |
58. | 255 26sep2018 09oct2018 12.1 |
59. | 254 14sep2018 26sep2018 12.3 |
60. | 253 03sep2018 14sep2018 11 |
|----------------------------------------|
61. | 252 22aug2018 03sep2018 12 |
62. | 251 11aug2018 22aug2018 11.7 |
63. | 250 29jul2018 11aug2018 13 |
64. | 249 18jul2018 29jul2018 10.3 |
65. | 248 08jul2018 18jul2018 10.7 |
|----------------------------------------|
66. | 247 27jun2018 08jul2018 11.1 |
67. | 246 19jun2018 27jun2018 7.2 |
68. | 245 06jun2018 16jun2018 10 |
69. | 244 26may2018 06jun2018 10.8 |
70. | 243 16may2018 26may2018 10.7 |
|----------------------------------------|
71. | 242 06may2018 16may2018 10.2 |
72. | 241 25apr2018 06may2018 10.3 |
73. | 240 11apr2018 25apr2018 14 |
74. | 239 31mar2018 11apr2018 11 |
75. | 238 21mar2018 31mar2018 10 |
|----------------------------------------|
76. | 237 09mar2018 21mar2018 11.9 |
77. | 236 27feb2018 09mar2018 10.7 |
78. | 235 14feb2018 27feb2018 12.4 |
79. | 234 02feb2018 14feb2018 12 |
80. | 233 23jan2018 02feb2018 10.6 |
|----------------------------------------|
81. | 232 11jan2018 23jan2018 11.4 |
82. | 231 31dec2017 11jan2018 11 |
83. | 230 20dec2017 31dec2017 11 |
84. | 229 09dec2017 20dec2017 11 |
85. | 228 30nov2017 09dec2017 9.5 |
|----------------------------------------|
86. | 227 17nov2017 30nov2017 12.7 |
87. | 226 09nov2017 17nov2017 8.6 |
88. | 225 26oct2017 09nov2017 13.2 |
89. | 224 17oct2017 26oct2017 9.1 |
90. | 223 06oct2017 17oct2017 10.8 |
|----------------------------------------|
91. | 222 27sep2017 06oct2017 9.9 |
92. | 221 18sep2017 27sep2017 8.2 |
93. | 220 07sep2017 18sep2017 11 |
94. | 219 29aug2017 07sep2017 9.2 |
95. | 218 19aug2017 29aug2017 9.9 |
|----------------------------------------|
96. | 217 09aug2017 19aug2017 9.9 |
97. | 216 28jul2017 09aug2017 12.7 |
98. | 215 18jul2017 28jul2017 9.4 |
99. | 214 09jul2017 18jul2017 9.1 |
100. | 213 30jun2017 09jul2017 8.9 |
|----------------------------------------|
101. | 212 20jun2017 30jun2017 10 |
102. | 211 10jun2017 20jun2017 9.9 |
103. | 210 01jun2017 10jun2017 9 |
104. | 209 23may2017 01jun2017 9.2 |
105. | 208 13may2017 23may2017 10.5 |
|----------------------------------------|
106. | 207 02may2017 13may2017 10.4 |
107. | 206 23apr2017 02may2017 9.6 |
108. | 205 13apr2017 23apr2017 9.4 |
109. | 204 03apr2017 13apr2017 10 |
110. | 203 22mar2017 03apr2017 11.8 |
|----------------------------------------|
111. | 202 11mar2017 22mar2017 11 |
112. | 201 02mar2017 11mar2017 9.1 |
113. | 200 19feb2017 02mar2017 10.9 |
114. | 199 09feb2017 19feb2017 10.9 |
115. | 198 30jan2017 09feb2017 10 |
|----------------------------------------|
116. | 197 19jan2017 30jan2017 10.2 |
117. | 196 09jan2017 19jan2017 10.1 |
118. | 195 30dec2016 09jan2017 9.9 |
119. | 194 19dec2016 30dec2016 11 |
120. | 193 12dec2016 19dec2016 7.3 |
|----------------------------------------|
121. | 192 02dec2016 12dec2016 9.7 |
122. | 191 22nov2016 02dec2016 10.1 |
123. | 190 10nov2016 22nov2016 12.6 |
124. | 189 26oct2016 10nov2016 14.2 |
125. | 188 18oct2016 26oct2016 8.8 |
|----------------------------------------|
126. | 187 08oct2016 18oct2016 9.4 |
127. | 186 28sep2016 08oct2016 9.9 |
128. | 185 19sep2016 28sep2016 9.1 |
129. | 184 08sep2016 19sep2016 11.1 |
130. | 183 29aug2016 08sep2016 10.5 |
|----------------------------------------|
131. | 182 19aug2016 29aug2016 9.5 |
132. | 181 11aug2016 19aug2016 8.1 |
133. | 180 03aug2016 11aug2016 8.4 |
134. | 179 24jul2016 03aug2016 9.9 |
135. | 178 15jul2016 24jul2016 8.4 |
|----------------------------------------|
136. | 177 05jul2016 15jul2016 9.8 |
137. | 176 27jun2016 05jul2016 8.2 |
138. | 175 15jun2016 27jun2016 12.5 |
139. | 174 06jun2016 15jun2016 8.8 |
140. | 173 25may2016 06jun2016 11.7 |
|----------------------------------------|
141. | 172 16may2016 25may2016 9.5 |
142. | 171 07may2016 16may2016 9 |
143. | 170 28apr2016 07may2016 8.9 |
144. | 169 19apr2016 28apr2016 9.1 |
145. | 168 08apr2016 19apr2016 10.3 |
|----------------------------------------|
146. | 167 28mar2016 08apr2016 11.1 |
147. | 166 18mar2016 28mar2016 10 |
148. | 165 04mar2016 18mar2016 14 |
149. | 164 18feb2016 04mar2016 15.6 |
150. | 163 29jan2016 18feb2016 19.1 |
|----------------------------------------|
151. | 162 07jan2016 29jan2016 22.2 |
152. | 161 15dec2015 07jan2016 23.5 |
153. | 160 20nov2015 15dec2015 24.4 |
154. | 159 05nov2015 20nov2015 15.6 |
155. | 158 13oct2015 05nov2015 22.3 |
|----------------------------------------|
156. | 157 23sep2015 13oct2015 20.8 |
157. | 156 06sep2015 23sep2015 17 |
158. | 155 22aug2015 06sep2015 14.4 |
159. | 154 06aug2015 22aug2015 16.6 |
160. | 153 20jul2015 06aug2015 16.4 |
|----------------------------------------|
161. | 152 06jul2015 20jul2015 14.1 |
162. | 151 18jun2015 06jul2015 18.5 |
163. | 150 29may2015 18jun2015 20.1 |
164. | 149.5 25may2015 29may2015 3.5 |
165. | 149 12may2015 25may2015 13 |
|----------------------------------------|
166. | 148 22apr2015 12may2015 19.8 |
167. | 147 07apr2015 22apr2015 15.7 |
168. | 146 25mar2015 07apr2015 12.9 |
169. | 145 10mar2015 25mar2015 15.1 |
170. | 144 28feb2015 10mar2015 10 |
|----------------------------------------|
171. | 143 17feb2015 28feb2015 11 |
172. | 142 30jan2015 17feb2015 17.9 |
173. | 141 15jan2015 30jan2015 15.1 |
174. | 140 02jan2015 15jan2015 13 |
175. | 139 22dec2014 02jan2015 11.2 |
|----------------------------------------|
176. | 138 09dec2014 22dec2014 12.8 |
177. | 137 26nov2014 09dec2014 13 |
178. | 136 12nov2014 26nov2014 13.2 |
179. | 135 30oct2014 12nov2014 13 |
180. | 134 21oct2014 30oct2014 9.8 |
|----------------------------------------|
181. | 133 11oct2014 21oct2014 10 |
182. | 132 29sep2014 11oct2014 12 |
183. | 131 16sep2014 29sep2014 13.1 |
184. | 130 04sep2014 16sep2014 11.8 |
185. | 129 23aug2014 04sep2014 11.9 |
|----------------------------------------|
186. | 128 12aug2014 23aug2014 11.2 |
187. | 127 31jul2014 12aug2014 11.9 |
188. | 126 20jul2014 31jul2014 11 |
189. | 125 10jul2014 20jul2014 10 |
190. | 124 30jun2014 10jul2014 10 |
|----------------------------------------|
191. | 123 19jun2014 30jun2014 11 |
192. | 122 10jun2014 19jun2014 9 |
193. | 121 30may2014 10jun2014 11.1 |
194. | 120 19may2014 30may2014 10.1 |
195. | 119 10may2014 19may2014 9.8 |
|----------------------------------------|
196. | 118 28apr2014 10may2014 11.9 |
197. | 117 17apr2014 28apr2014 11 |
198. | 116 05apr2014 17apr2014 12 |
199. | 115 25mar2014 05apr2014 10.9 |
200. | 114 15mar2014 25mar2014 10.2 |
|----------------------------------------|
201. | 113 05mar2014 15mar2014 10 |
202. | 112 25feb2014 05mar2014 8 |
203. | 111 16feb2014 25feb2014 8.4 |
204. | 110 08feb2014 16feb2014 8.5 |
205. | 109 29jan2014 08feb2014 9.8 |
|----------------------------------------|
206. | 108 20jan2014 29jan2014 9.3 |
207. | 107 10jan2014 20jan2014 9.8 |
208. | 106 01jan2014 10jan2014 9 |
209. | 105 21dec2013 01jan2014 10.5 |
210. | 104 11dec2013 21dec2013 10.5 |
|----------------------------------------|
211. | 103 02dec2013 11dec2013 9.1 |
212. | 102 21nov2013 02dec2013 11.1 |
213. | 101 11nov2013 21nov2013 10 |
214. | 100 01nov2013 11nov2013 10 |
215. | 99 22oct2013 01nov2013 9.9 |
|----------------------------------------|
216. | 98 12oct2013 22oct2013 9.5 |
217. | 97 26sep2013 12oct2013 15.7 |
218. | 96 18sep2013 26sep2013 8.9 |
219. | 95 09sep2013 18sep2013 8.1 |
220. | 94 01sep2013 09sep2013 8.7 |
|----------------------------------------|
221. | 93 24aug2013 01sep2013 8.1 |
222. | 92 16aug2013 24aug2013 7.8 |
223. | 91 07aug2013 16aug2013 9.1 |
224. | 90 30jul2013 07aug2013 8.1 |
225. | 89 20jul2013 30jul2013 9.3 |
|----------------------------------------|
226. | 88 12jul2013 20jul2013 8.5 |
227. | 87 03jul2013 12jul2013 8.3 |
228. | 86 26jun2013 03jul2013 7.8 |
229. | 85 19jun2013 26jun2013 7.1 |
230. | 84 11jun2013 19jun2013 8.1 |
|----------------------------------------|
231. | 83 02jun2013 11jun2013 9 |
232. | 82 25may2013 02jun2013 7.9 |
233. | 81 17may2013 25may2013 8 |
234. | 80 07may2013 17may2013 9.5 |
235. | 79 28apr2013 07may2013 9 |
|----------------------------------------|
236. | 78 21apr2013 28apr2013 7.5 |
237. | 77 12apr2013 21apr2013 8.8 |
238. | 76 05apr2013 12apr2013 7.2 |
239. | 75 28mar2013 05apr2013 7.8 |
240. | 74 21mar2013 28mar2013 7 |
|----------------------------------------|
241. | 73 13mar2013 21mar2013 7.6 |
242. | 72 05mar2013 13mar2013 7.8 |
243. | 71 25feb2013 05mar2013 8.1 |
244. | 70 17feb2013 25feb2013 8.7 |
245. | 69 07feb2013 17feb2013 9.2 |
|----------------------------------------|
246. | 68 29jan2013 07feb2013 9.1 |
247. | 67 21jan2013 29jan2013 7.9 |
248. | 66 14jan2013 21jan2013 7.1 |
249. | 65 07jan2013 14jan2013 7.5 |
250. | 64 31dec2012 07jan2013 7.2 |
|----------------------------------------|
251. | 63 23dec2012 31dec2012 7.8 |
252. | 62 16dec2012 23dec2012 7.3 |
253. | 61 08dec2012 16dec2012 7.6 |
254. | 60 01dec2012 08dec2012 7.2 |
255. | 59 23nov2012 01dec2012 7.3 |
|----------------------------------------|
256. | 58 16nov2012 23nov2012 7.2 |
257. | 57 09nov2012 16nov2012 7.1 |
258. | 56 02nov2012 09nov2012 7.5 |
259. | 55 26oct2012 02nov2012 7.1 |
260. | 54 18oct2012 26oct2012 7.6 |
|----------------------------------------|
261. | 53 13oct2012 18oct2012 4.8 |
262. | 52 06oct2012 13oct2012 7.5 |
263. | 51 27sep2012 06oct2012 8.5 |
264. | 50 20sep2012 27sep2012 7.6 |
265. | 49 12sep2012 20sep2012 7.4 |
|----------------------------------------|
266. | 48 05sep2012 12sep2012 7 |
267. | 47 29aug2012 05sep2012 7.4 |
268. | 46 22aug2012 29aug2012 7.1 |
269. | 45 14aug2012 22aug2012 7.2 |
270. | 44 07aug2012 14aug2012 7.9 |
|----------------------------------------|
271. | 43 31jul2012 07aug2012 7 |
272. | 42 24jul2012 31jul2012 7 |
273. | 41 16jul2012 24jul2012 7.2 |
274. | 40 09jul2012 16jul2012 7.6 |
275. | 39 01jul2012 09jul2012 8.2 |
|----------------------------------------|
276. | 38 23jun2012 01jul2012 7.1 |
277. | 37 15jun2012 23jun2012 8.9 |
278. | 36 07jun2012 15jun2012 7.1 |
279. | 35 31may2012 07jun2012 7 |
280. | 34 24may2012 31may2012 7 |
|----------------------------------------|
281. | 33 17may2012 24may2012 7 |
282. | 32 10may2012 17may2012 7 |
283. | 31 03may2012 10may2012 7.1 |
284. | 30 26apr2012 03may2012 7 |
285. | 29 19apr2012 26apr2012 7.7 |
|----------------------------------------|
286. | 28 11apr2012 19apr2012 7.3 |
287. | 27 04apr2012 11apr2012 7.1 |
+----------------------------------------+

How long each round usually lasts? 10.2 days in median (p50). Min and max are 3.5 and 24.4 days, respectively.

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
period | 287.0 10.5 2.9 10.2 8.7 11.1 3.5 24.4
----------------------------------------------------------------------------------------------

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

notocactus (OP)

Legendary

Offline

Activity: 2716
Merit: 4563

Glory to Ukraine!

Re: Impression counts for ads over years (Statistics)

July 08, 2020, 03:16:34 PM
Last edit: July 08, 2020, 03:30:12 PM by tranthidung

#17

ABSTRACT

Observed rounds: 287.
Converted datasets: get there and there.
Period of each round: about 10.2 days (in medians - p50). See details
From these time-series plots and statistics presented below, I have a feeling that recent wash-out in March of 2020 has decreasing effects on figures of all 4 indicators. If we compare all indicators between two years (2019 and 2020 - an imcomplete year with only 16 rounds observed as of writing).

It has been shown in these time-series plots in OP, but if you did not recognize it, you can see it in details below with the statistics of each indicator over years (2012 - 2020). The year of 2020 is an imcomplete one, with only 16 rounds have been finished so far, the last finish round is #310.

As always, I used the medians (p50), not means. Now, let's look at their all time highs, in medians (p50).

An overview, for whole period (from 2012 to 2020) for all 4 indicators.

Code:

variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
mimpressions | 33.0 307677.2 48708.6 307255.1 280417.4 337873.1 218751.8 423117.3
mliuser_im~s | 33.0 89981.7 29639.5 100595.3 84122.1 109534.8 17904.0 124806.3
muniqueip | 33.0 13356.0 3179.7 13209.6 10743.2 16248.2 8366.1 19462.9
muniqueliu~s | 33.0 1919.8 466.9 1931.0 1511.1 2246.2 1212.2 2905.1
----------------------------------------------------------------------------------------------

1. Daily total impressions
Its all time high is 374975, in 2018, not in 2017.

Code:

Summary for variables: mimpressions
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 15088.0 3447.1 15761.3 12433.6 16667.5 6058.1 20716.6
   2013 | 40.0 54194.9 24673.3 50380.4 43379.0 63659.3 18206.9 120381.3
   2014 | 34.0 135750.9 15362.2 131780.0 124662.3 147388.1 110430.0 162669.1
   2015 | 23.0 112016.0 21012.5 111835.7 106363.5 123331.1 40761.9 145381.0
   2016 | 34.0 113646.3 9029.7 113654.8 105539.0 121026.2 96311.5 128049.6
   2017 | 36.0 226489.9 84789.8 210308.7 153213.9 265930.3 86717.0 440217.4
   2018 | 32.0 380478.4 39909.4 374974.9 362659.3 397805.2 271974.4 526107.3
   2019 | 33.0 307677.2 48708.6 307255.1 280417.4 337873.1 218751.8 423117.3
   2020 | 16.0 240336.9 37984.3 227375.3 211654.5 262189.1 195923.4 309910.8
---------+--------------------------------------------------------------------------------
   Total | 286.0 168268.2 123583.9 127137.0 67077.8 262434.5 6058.1 526107.3
------------------------------------------------------------------------------------------

2. Daily total impressions from logged-in users
Its all time high is 100595, in 2019, not in 2017.

Code:

Summary for variables: mliuser_impressions
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 4369.7 1183.9 4099.0 3544.8 4951.3 1795.2 7213.2
   2013 | 40.0 17249.1 7505.0 18621.3 12892.6 21162.1 3928.5 37228.7
   2014 | 34.0 38847.1 13445.2 38291.0 29864.4 46259.9 17464.6 69853.3
   2015 | 23.0 15629.7 3771.0 14012.4 13219.1 18919.3 9094.0 24755.5
   2016 | 34.0 16152.4 2577.8 15605.4 15011.6 16773.8 13338.2 28292.6
   2017 | 36.0 38080.1 18477.7 31572.8 23540.2 53577.1 10015.6 78991.9
   2018 | 32.0 92415.7 27127.3 83531.6 73272.6 114457.5 56496.2 143663.0
   2019 | 33.0 89981.7 29639.5 100595.3 84122.1 109534.8 17904.0 124806.3
   2020 | 16.0 30054.9 11438.8 27498.2 22789.8 32244.9 17183.0 58125.3
---------+--------------------------------------------------------------------------------
   Total | 286.0 37985.8 34867.3 22945.1 14747.3 57107.8 1795.2 143663.0
------------------------------------------------------------------------------------------

3. Daily unique IPs from logged-out users
Its all time high is 39292, in 2018, not in 2017.

Code:

Summary for variables: muniqueip
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 2895.0 668.8 2921.7 2231.9 3390.6 1731.5 4014.4
   2013 | 40.0 11746.7 6947.0 9349.3 8079.4 13812.9 3839.3 34218.2
   2014 | 34.0 17406.6 5582.9 15729.6 14084.6 20373.0 9942.4 28277.0
   2015 | 23.0 8695.0 1598.2 8468.7 7504.4 9820.8 5615.3 11797.0
   2016 | 34.0 11067.6 1061.3 10622.5 10350.6 11768.5 9796.0 13983.0
   2017 | 36.0 41688.3 25824.5 39291.1 18168.2 49361.3 11145.9 116833.1
   2018 | 32.0 35677.8 20870.3 28047.5 20194.1 46479.3 15238.3 100088.1
   2019 | 33.0 13356.0 3179.7 13209.6 10743.2 16248.2 8366.1 19462.9
   2020 | 16.0 8349.8 840.0 8184.4 7716.7 9194.6 6781.0 9594.0
---------+--------------------------------------------------------------------------------
   Total | 286.0 17359.4 17407.0 11510.0 8474.1 18401.7 1731.5 116833.1
------------------------------------------------------------------------------------------

4. Daily unique logged-in users
Its all time high is 7054, in 2018.

Code:

Summary for variables: muniqueliusers
   by categories of: year (Year)

   year | N mean sd p50 p25 p75 min max
---------+--------------------------------------------------------------------------------
   2012 | 38.0 382.1 64.4 379.1 328.2 436.2 281.3 573.3
   2013 | 40.0 1311.5 543.4 1400.0 867.1 1628.9 394.4 2509.7
   2014 | 34.0 2321.5 705.2 2206.3 1872.4 2802.6 1286.6 3811.6
   2015 | 23.0 1040.7 345.2 929.3 819.2 1177.9 716.1 2198.8
   2016 | 34.0 1407.0 208.0 1423.3 1328.7 1516.8 846.2 1822.0
   2017 | 36.0 4005.5 2302.2 3385.8 2036.8 5222.9 1401.8 9920.5
   2018 | 32.0 6708.2 2293.6 7054.3 4529.0 8434.4 2675.0 11121.2
   2019 | 33.0 1919.8 466.9 1931.0 1511.1 2246.2 1212.2 2905.1
   2020 | 16.0 1104.9 90.9 1080.4 1039.5 1187.7 983.8 1271.3
---------+--------------------------------------------------------------------------------
   Total | 286.0 2299.2 2204.0 1541.7 1051.9 2416.8 281.3 11121.2
------------------------------------------------------------------------------------------

Comparisons between three periods, with the period 2012-2013 used as a reference group.

______________________________________	____________________________	_____________	_____________	_____________
Indicators	Reference group ^{(2012 - 2013)}	2014 - 2016 *	2017 - 2019 *	2020 *
______________________________________	____________________________	_____________	_____________	_____________
Daily total impressions	20509	120237 (5.9)	314465 (14.3)	227376 (10.09)
Daily total impressions from logged-in users	5754	17465 (3)	74245 (11.9)	27499 (3.78)
Daily unique IPs from logged-out users	4069	11229 (2.8 )	20175 (4)	8185 (1.01)
Daily unique logged-in users	457	1471 (2.6)	3225 (6.1)	1081 (1.37)
______________________________________	____________________________	_____________	_____________	_____________

* Values (Increasing-fold).

Raw results over periods:

Code:

Summary for variables: mimpressions
   by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 35142.8 26478.3 20509.0 15828.5 50788.7 6058.1 120381.3
2014 - 2016 | 91.0 121493.1 18637.8 120237.0 110620.4 130868.0 40761.9 162669.1
2017 - 2019 | 101.0 301804.9 88336.3 314465.1 240297.4 369258.3 86717.0 526107.3
   2020 | 16.0 240336.9 37984.3 227375.3 211654.5 262189.1 195923.4 309910.8
------------+--------------------------------------------------------------------------------
   Total | 286.0 168268.2 123583.9 127137.0 67077.8 262434.5 6058.1 526107.3
---------------------------------------------------------------------------------------------

Code:

Summary for variables: mliuser_impressions
   by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 10974.5 8437.0 5754.0 3981.5 18638.2 1795.2 37228.7
2014 - 2016 | 91.0 24499.6 14013.9 17464.6 14943.6 32439.4 9094.0 69853.3
2017 - 2019 | 101.0 72253.3 35818.4 74245.0 37901.2 103140.9 10015.6 143663.0
   2020 | 16.0 30054.9 11438.8 27498.2 22789.8 32244.9 17183.0 58125.3
------------+--------------------------------------------------------------------------------
   Total | 286.0 37985.8 34867.3 22945.1 14747.3 57107.8 1795.2 143663.0
---------------------------------------------------------------------------------------------

Code:

Summary for variables: muniqueip
   by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 7434.3 6670.0 4068.8 2936.7 9382.3 1731.5 34218.2
2014 - 2016 | 91.0 12836.3 5091.3 11228.5 9972.1 14889.6 5615.3 28277.0
2017 - 2019 | 101.0 30526.9 22854.2 20174.5 15402.4 42793.0 8366.1 116833.1
   2020 | 16.0 8349.8 840.0 8184.4 7716.7 9194.6 6781.0 9594.0
------------+--------------------------------------------------------------------------------
   Total | 286.0 17359.4 17407.0 11510.0 8474.1 18401.7 1731.5 116833.1
---------------------------------------------------------------------------------------------

Code:

Summary for variables: muniqueliusers
   by categories of: period_grp

period_grp | N mean sd p50 p25 p75 min max
------------+--------------------------------------------------------------------------------
2012 - 2013 | 78.0 858.7 608.4 456.4 390.8 1407.4 281.3 2509.7
2014 - 2016 | 91.0 1656.1 717.5 1470.4 1203.0 1962.7 716.1 3811.6
2017 - 2019 | 101.0 4180.3 2701.4 3224.8 1974.7 5964.9 1212.2 11121.2
   2020 | 16.0 1104.9 90.9 1080.4 1039.5 1187.7 983.8 1271.3
------------+--------------------------------------------------------------------------------
   Total | 286.0 2299.2 2204.0 1541.7 1051.9 2416.8 281.3 11121.2
---------------------------------------------------------------------------------------------

.
MΞTAWIN

^{THE FIRST WEB3 CASINO}

████
██
██
██
██
██
██
██
██
██
██
██
████

.^PLAY NOW.

Pages: [1]

Page 1

Viewing Page: 1