⬆️ ⬇️

Habrostatistika, part 2 - refutation with graphs

Yesterday I published an article on the topic of when it is better to publish in the Internet. Since then, my spider has collected statistics for the entire 2015, and the picture has changed a bit. I also built several graphs, and the whole picture became clearer. Caution traffic!



First, we look at the statistics separately for each day:



Designations on the graphs are as follows:

  1. Quantity - the number of articles published at this time.
  2. Comments - average number of comments left
  3. Views - the average number of views scored
  4. Rate - the average typed rating




Monday looks like this:

')





Tuesday:







Wednesday:







Thursday:







Friday:







Saturday:







Sunday:







And finally, the most delicious is the hodgepodge of the whole week:







We have to admit that the statistics obtained somewhat contradicts the opinion that I expressed in the first article . Indeed, as some commentators mentioned, it is best to publish on Saturday and Sunday at 5 am, when competition with your article is minimal.



Or not?



And let's look at the samples by the resulting peaks:

For a start - 6 am Saturday.



SELECT * FROM posts WHERE WEEKDAY(created)+1=6 AND HOUR(created)=6 


Result:

idcreatedratecommentsviews
2555092015-04-11 06:28:005010474000
2505572015-02-14 06:21:006nineteen23,000
2383632014-09-27 06:14:00632956000
2335332014-08-16 06:08:00499552,000
2287512014-07-05 06:58:00827038,000
2231492014-05-17 06:32:001348970,000




Then - on Sunday at 6 in the morning.

 SELECT * FROM posts WHERE WEEKDAY(created)+1=7 AND HOUR(created)=6 


idcreatedratecommentsviews
2762492016-01-31 06:05:00732152,000
2690052015-10-18 06:03:00342519,000
2566172015-04-26 06:14:005611674000
2537112015-03-22 06:56:00thirty2539,000
2467852015-01-04 06:42:00122113169,000
2383792014-09-28 06:28:00203328,000
2320092014-08-03 06:00:00242051,000




Like this. It is pretty obvious that single posts make our statistics. And, although I can’t help but admit that the time of publication still has some influence - it is not worth even thinking about it.



And watching charts is very dangerous. Graphics give false illusions of understanding and incorrect premises. Therefore, it is vitally important to understand what data and for what reason lie under your graphs. Otherwise, everything you build and do will be approximately
such a foundation.


Source: https://habr.com/ru/post/279769/



All Articles