ZooChat 2018 stats

Simon Hampel said:
Users who received the most likes on their content in 2018

  1. (2,579 likes received) Chlidonias
  2. (2,392 likes received) lintworm
  3. (1,987 likes received) TeaLovingDave
  4. (1,261 likes received) ThylacineAlive
  5. (1,213 likes received) Zoofan15
  6. (1,061 likes received) FunkyGibbon
  7. (930 likes received) LaughingDove
  8. (843 likes received) birdsandbats
  9. (811 likes received) vogelcommando
  10. (757 likes received) sooty mangabey
  11. (752 likes received) snowleopard
  12. (746 likes received) Simon Hampel
  13. (738 likes received) Arizona Docent
  14. (703 likes received) pachyderm pro
  15. (692 likes received) CGSwans
  16. (659 likes received) gentle lemur
  17. (658 likes received) Vision
  18. (634 likes received) Kakapo
  19. (615 likes received) Batto
  20. (611 likes received) ZooBinh
  21. (528 likes received) jayjds2
  22. (483 likes received) Terry Thomas
  23. (477 likes received) Brum
  24. (475 likes received) DesertRhino150
  25. (464 likes received) Maguari
  26. (453 likes received) Jambo
  27. (440 likes received) TZFan
  28. (386 likes received) TigerValley98
  29. (381 likes received) Shorts
  30. (372 likes received) Moebelle
  31. (369 likes received) Nisha
  32. (360 likes received) Pertinax
  33. (348 likes received) MKE Zoo guy
  34. (346 likes received) nczoofan
  35. (338 likes received) Tim May
  36. (330 likes received) DavidBrown
  37. (329 likes received) TZDugong
  38. (329 likes received) WhistlingKite24
  39. (327 likes received) Echobeast
  40. (326 likes received) Swampy
  41. (321 likes received) Crowthorne
  42. (321 likes received) akasha
  43. (319 likes received) littleRedPanda
  44. (313 likes received) TinoPup
  45. (312 likes received) TheWalrus
  46. (307 likes received) pipaluk
  47. (304 likes received) Mr. Zootycoon
  48. (300 likes received) Milwaukee Man
  49. (300 likes received) Coelacanth18
  50. (283 likes received) Kifaru Bwana

Note that there is a natural correlation between post count and like count - so the users with the most posts will usually end up close to the top of the like count list as well.

We will investigate which users have the highest likes-to-post ratio in some later stats.
Click to expand...
It's so odd that I received 600+ likes, especially on some of my earlier posts :p!
 
Simon Hampel said:
Users who received/gave the most likes in 2018 - content type breakdown

Charts showing same data as above - but broken down by content type in a stacked chart (ie content types are added together in the chart).

View attachment 380174


View attachment 380175


Now this is interesting - I figured there would be a high percentage of likes for media uploads, turns out there are hardly any.

Looking at the page layout for media items - the like link is rather small and out of the way:

View attachment 380176

I'll have to put that on the TODO list for the site upgrade to make the like button more prominent on media.
Click to expand...
Thanks for using my picture in the explanation!
 
I'm genuinely surprised media doesn't make up a much more significant portion of my likes received. There have been many days where I've come home to up to 40+ likes on various media content of mine, usually from the same two or three members.

~Thylo
 
ThylacineAlive said:
I'm genuinely surprised media doesn't make up a much more significant portion of my likes received. There have been many days where I've come home to up to 40+ likes on various media content of mine, usually from the same two or three members.

~Thylo
Click to expand...
I think its because it isn't from the members who gave the most likes.
 
ThylacineAlive said:
I'm genuinely surprised media doesn't make up a much more significant portion of my likes received. There have been many days where I've come home to up to 40+ likes on various media content of mine, usually from the same two or three members.
Click to expand...

I was looking at the likes to media and I know I've handed out a tonne in the past twelve months yet they don't make a dent on my likes given out graph?

Incidentally, I think I may be one of the afore-mentioned members who you received multiple likes from as I just tend to binge the Media section nowadays.
 
Great Argus said:
Will say, much respect to Simon for compiling all these stats and then typing them out for all of us to see! Imagine that takes a good amount of time!
Click to expand...

No typing for the lists - that's all computer generated.

I write an SQL query to get the data out of the database, copy and paste it in to Google Spreadsheets, then write formulas in the spreadsheet to generate the code required to generate a list of items (with links and everything else included) to paste into a forum post.

It actually doesn't take much time at all - once I've written the queries (that takes quite a bit of time).

Formatting the charts to display nicely also takes a bit of time - but each year it gets quicker, since it's usually just a few minor improvements over the previous year's chart.
 
ThylacineAlive said:
I'm genuinely surprised media doesn't make up a much more significant portion of my likes received. There have been many days where I've come home to up to 40+ likes on various media content of mine, usually from the same two or three members.

~Thylo
Click to expand...

It does seem a bit odd.

I will double check - there may be a bug in my database queries.

EDIT: ooooh - yes, very big bug. Doesn't seem to be counting media likes at all:

@ThylacineAlive likes received:
  • post: 1017
  • comment: 253
  • media: 2813
Sorry, will fix and repost stats!
 
ThylacineAlive said:
I'm genuinely surprised media doesn't make up a much more significant portion of my likes received. There have been many days where I've come home to up to 40+ likes on various media content of mine, usually from the same two or three members.

~Thylo
Click to expand...

Your 2813 media likes made rather a large difference to the overall result! :oops:
 
Brum said:
I was looking at the likes to media and I know I've handed out a tonne in the past twelve months yet they don't make a dent on my likes given out graph?
Click to expand...

There seems to be less than 200 media likes for the year from you.

I should qualify the data in this chart by explaining that it only counts likes given in 2018 on content that was created in 2018 - so if you've been liking older posts or photos, then it won't count for these stats.

I'll be doing longer term stats for the anniversary stats each October (I haven't finished the 15th birthday anniversary stats yet!).
 
Users with the highest like rate in 2018 - posts only

This is a weighted ratio of likes:posts and only considers the top 10% of posters.

  1. (13.4 like rate) - (2.3 likes per post) - {693 likes from 295 posts} - @sooty mangabey
  2. (12.1 like rate) - (1.7 likes per post) - {2,281 likes from 1,362 posts} - @lintworm
  3. (11.9 like rate) - (2.1 likes per post) - {611 likes from 292 posts} - @Batto
  4. (11.7 like rate) - (2.0 likes per post) - {644 likes from 316 posts} - @Vision
  5. (11.6 like rate) - (1.9 likes per post) - {907 likes from 481 posts} - @LaughingDove
  6. (10.1 like rate) - (1.7 likes per post) - {575 likes from 332 posts} - @snowleopard
  7. (9.4 like rate) - (1.8 likes per post) - {344 likes from 193 posts} - @MKE Zoo guy
  8. (9.3 like rate) - (1.6 likes per post) - {471 likes from 288 posts} - @DesertRhino150
  9. (8.6 like rate) - (1.6 likes per post) - {367 likes from 232 posts} - @Maguari
  10. (8.6 like rate) - (1.5 likes per post) - {449 likes from 297 posts} - @jayjds2
  11. (8.4 like rate) - (1.5 likes per post) - {375 likes from 244 posts} - @Shorts
  12. (8.1 like rate) - (1.4 likes per post) - {482 likes from 347 posts} - @gentle lemur
  13. (7.7 like rate) - (1.4 likes per post) - {321 likes from 225 posts} - @nczoofan
  14. (7.7 like rate) - (1.4 likes per post) - {369 likes from 267 posts} - @Nisha
  15. (7.7 like rate) - (1.0 likes per post) - {1,883 likes from 1,837 posts} - @TeaLovingDave
  16. (7.6 like rate) - (1.4 likes per post) - {278 likes from 192 posts} - @WhistlingKite24
  17. (7.5 like rate) - (1.2 likes per post) - {692 likes from 584 posts} - @CGSwans
  18. (7.5 like rate) - (1.4 likes per post) - {327 likes from 240 posts} - @Echobeast
  19. (7.4 like rate) - (1.4 likes per post) - {321 likes from 237 posts} - @Tim May
  20. (7.1 like rate) - (1.3 likes per post) - {292 likes from 222 posts} - @Milwaukee Man
  21. (7.0 like rate) - (1.1 likes per post) - {657 likes from 598 posts} - @pachyderm pro
  22. (7.0 like rate) - (1.3 likes per post) - {321 likes from 253 posts} - @akasha
  23. (6.9 like rate) - (0.9 likes per post) - {2,374 likes from 2,737 posts} - @Chlidonias
  24. (6.7 like rate) - (1.2 likes per post) - {322 likes from 268 posts} - @Moebelle
  25. (6.6 like rate) - (1.0 likes per post) - {1,009 likes from 1,059 posts} - @ThylacineAlive
  26. (6.6 like rate) - (1.2 likes per post) - {303 likes from 256 posts} - @Mr. Zootycoon
  27. (6.5 like rate) - (1.2 likes per post) - {294 likes from 252 posts} - @Coelacanth18
  28. (5.9 like rate) - (0.8 likes per post) - {1,213 likes from 1,516 posts} - @Zoofan15
  29. (5.8 like rate) - (1.1 likes per post) - {221 likes from 202 posts} - @migdog
  30. (5.8 like rate) - (1.1 likes per post) - {204 likes from 184 posts} - @Swampy
  31. (5.6 like rate) - (1.0 likes per post) - {286 likes from 288 posts} - @DavidBrown
  32. (5.4 like rate) - (0.9 likes per post) - {450 likes from 524 posts} - @Brum
  33. (5.4 like rate) - (0.8 likes per post) - {745 likes from 954 posts} - @Simon Hampel
  34. (5.2 like rate) - (1.0 likes per post) - {190 likes from 190 posts} - @Quincey
  35. (5.2 like rate) - (0.7 likes per post) - {975 likes from 1,345 posts} - @FunkyGibbon
  36. (5.2 like rate) - (0.8 likes per post) - {436 likes from 525 posts} - @TZFan
  37. (4.9 like rate) - (0.9 likes per post) - {234 likes from 265 posts} - @ShonenJake13
  38. (4.8 like rate) - (0.7 likes per post) - {739 likes from 1,077 posts} - @vogelcommando
  39. (4.7 like rate) - (0.8 likes per post) - {386 likes from 509 posts} - @Jambo
  40. (4.5 like rate) - (0.8 likes per post) - {229 likes from 286 posts} - @geomorph
  41. (4.4 like rate) - (0.6 likes per post) - {600 likes from 936 posts} - @Arizona Docent
  42. (4.1 like rate) - (0.8 likes per post) - {152 likes from 193 posts} - @CDavies98
  43. (4.1 like rate) - (0.8 likes per post) - {154 likes from 198 posts} - @Gigit
  44. (4.1 like rate) - (0.7 likes per post) - {232 likes from 328 posts} - @bongorob
  45. (4.1 like rate) - (0.8 likes per post) - {162 likes from 213 posts} - @EsserWarrior
  46. (4.0 like rate) - (0.7 likes per post) - {262 likes from 391 posts} - @TheEthiopianWolf03
  47. (4.0 like rate) - (0.6 likes per post) - {381 likes from 612 posts} - @TigerValley98
  48. (4.0 like rate) - (0.7 likes per post) - {170 likes from 234 posts} - @Ned
  49. (3.9 like rate) - (0.8 likes per post) - {141 likes from 187 posts} - @Jurek7
  50. (3.9 like rate) - (0.6 likes per post) - {283 likes from 440 posts} - @TinoPup

Calculating an ordinary likes:posts ratio is heavily skewed by people who post relatively infrequently. It's easier to get lots of likes from a few posts than it is to get lots of likes from a lot of posts.

For example, in 2018 @Batto got 611 likes from only 292 posts - while @lintworm got 2,281 likes from 1,362 posts.

A simple ratio would have Batto at 2.1 likes per post but lintworm at only 1.7 likes per post - even though lintworm got nearly 4x as many likes as Batto did.

So, we weight the ratio to reward people with higher post counts to try and give more meaningful ranking of who got the most likes for the posts they made.

This is calculated using the formula: [likes * LN(posts) / posts], which effectively gives greater weight to users who have made more posts and minimises the impact of infrequent posters who drop "clangers" (controversial posts which are more likely to get a reaction) and thus get a disproportionately high amount of likes.
 
Last edited:
Users with the highest like rate in 2018 - media uploads only

This is a weighted ratio of likes:uploads and only considers the top 10% of uploaders.

  1. (9.6 like rate) - (1.3 likes per upload) - {2,102 likes from 1,609 uploads} - @Giant Eland
  2. (8.6 like rate) - (1.4 likes per upload) - {628 likes from 444 uploads} - @devilfish
  3. (7.8 like rate) - (1.0 likes per upload) - {2,779 likes from 2,817 uploads} - @ThylacineAlive
  4. (7.7 like rate) - (1.1 likes per upload) - {1,213 likes from 1,106 uploads} - @LaughingDove
  5. (4.7 like rate) - (0.7 likes per upload) - {437 likes from 598 uploads} - @Najade
  6. (4.2 like rate) - (0.7 likes per upload) - {397 likes from 602 uploads} - @WhistlingKite24
  7. (4.2 like rate) - (0.6 likes per upload) - {589 likes from 969 uploads} - @MagpieGoose
  8. (3.9 like rate) - (0.6 likes per upload) - {394 likes from 661 uploads} - @Moebelle
  9. (3.7 like rate) - (0.5 likes per upload) - {484 likes from 896 uploads} - @Terry Thomas
  10. (3.5 like rate) - (0.4 likes per upload) - {2,163 likes from 5,365 uploads} - @vogelcommando
  11. (3.4 like rate) - (0.5 likes per upload) - {612 likes from 1,298 uploads} - @Maguari
  12. (3.3 like rate) - (0.5 likes per upload) - {289 likes from 545 uploads} - @Kudu21
  13. (3.3 like rate) - (0.5 likes per upload) - {322 likes from 631 uploads} - @Hix
  14. (3.1 like rate) - (0.5 likes per upload) - {406 likes from 885 uploads} - @lintworm
  15. (3.0 like rate) - (0.5 likes per upload) - {300 likes from 654 uploads} - @Kakapo
  16. (2.8 like rate) - (0.5 likes per upload) - {220 likes from 482 uploads} - @Milwaukee Man
  17. (2.7 like rate) - (0.4 likes per upload) - {248 likes from 597 uploads} - @FunkyGibbon
  18. (1.9 like rate) - (0.2 likes per upload) - {636 likes from 2,709 uploads} - @KevinB
  19. (1.8 like rate) - (0.3 likes per upload) - {120 likes from 393 uploads} - @carlos55
  20. (1.6 like rate) - (0.3 likes per upload) - {124 likes from 472 uploads} - @pachyderm pro
  21. (1.6 like rate) - (0.2 likes per upload) - {361 likes from 1,704 uploads} - @geomorph
  22. (1.4 like rate) - (0.2 likes per upload) - {102 likes from 445 uploads} - @birdsandbats
  23. (1.3 like rate) - (0.2 likes per upload) - {198 likes from 1,071 uploads} - @gulogulogulo
  24. (0.5 like rate) - (0.1 likes per upload) - {117 likes from 1,737 uploads} - @snowleopard
 
Last edited:
Just a note on likes and like ratios.

Soliciting likes (ie requesting that other users like your content), is strictly against the rules.

Conspiring to artificially inflate likes will see all likes removed from all user accounts involved.

Please be mindful that you don't abuse the likes system - otherwise it becomes meaningless.

It's like the old argument that parents have with their kids about why can't every day be their birthday - because then it would just be like every other day and there would be nothing special about it.
 
Users who added the most tags to content in 2018

  1. (1,333 tags added) birdsandbats
  2. (804 tags added) ro6ca66
  3. (324 tags added) JigerofLemuria
  4. (278 tags added) Gigit
  5. (275 tags added) Daniel Sörensen
  6. (184 tags added) Yi Qi
  7. (174 tags added) Jena
  8. (75 tags added) Loxodonta Cobra
  9. (62 tags added) Babyrousa
  10. (57 tags added) Great Argus
  11. (51 tags added) carlos55
  12. (37 tags added) squirrelmonkey
  13. (27 tags added) Bhutan
  14. (27 tags added) Jurek7
  15. (26 tags added) The_UltimateBea
  16. (25 tags added) m30t
  17. (23 tags added) ZooBinh
  18. (21 tags added) ChaffeeZooFan
  19. (21 tags added) Ashleigh.N
  20. (21 tags added) akasha
  21. (20 tags added) ThylacineAlive
  22. (20 tags added) Giant Panda

upload_2019-1-8_13-58-59.png
 
You must log in or register to reply here.
Back
Top