Join our zoo community

ZooChat 2018 stats

Discussion in 'Announcements' started by Simon Hampel, 1 Jan 2019.

  1. ZooBinh

    ZooBinh Well-Known Member 5+ year member

    Joined:
    2 Sep 2017
    Posts:
    3,369
    Location:
    Ohio
    It's so odd that I received 600+ likes, especially on some of my earlier posts :p!
     
  2. Great Argus

    Great Argus Well-Known Member 5+ year member

    Joined:
    30 Mar 2018
    Posts:
    5,442
    Location:
    California
    Ended up higher on most of these stats than I thought I would!

    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!
     
  3. TheGerenuk

    TheGerenuk Well-Known Member 5+ year member

    Joined:
    8 Sep 2017
    Posts:
    2,870
    Location:
    Brampton, Ontario, Canada
    Thanks for using my picture in the explanation!
     
    Simon Hampel likes this.
  4. ThylacineAlive

    ThylacineAlive Well-Known Member 10+ year member

    Joined:
    20 Oct 2012
    Posts:
    10,699
    Location:
    Connecticut, U.S.A.
    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
     
    ZooBinh likes this.
  5. ZooBinh

    ZooBinh Well-Known Member 5+ year member

    Joined:
    2 Sep 2017
    Posts:
    3,369
    Location:
    Ohio
    I think its because it isn't from the members who gave the most likes.
     
  6. Brum

    Brum Well-Known Member 10+ year member

    Joined:
    27 May 2011
    Posts:
    3,704
    Location:
    Birmingham, UK
    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.
     
    ZooBinh and ThylacineAlive like this.
  7. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
    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.
     
    Great Argus likes this.
  8. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
    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!
     
  9. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
    Jambo and ThylacineAlive like this.
  10. ThylacineAlive

    ThylacineAlive Well-Known Member 10+ year member

    Joined:
    20 Oct 2012
    Posts:
    10,699
    Location:
    Connecticut, U.S.A.
  11. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
    Your 2813 media likes made rather a large difference to the overall result! :oops:
     
  12. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
    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!).
     
  13. CarLover

    CarLover Well-Known Member 5+ year member

    Joined:
    27 Sep 2017
    Posts:
    288
    Location:
    Philadelphia
    Thanks. You post great pictures. I wish I could travel to as many zoos as you do.
     
    ThylacineAlive likes this.
  14. ThylacineAlive

    ThylacineAlive Well-Known Member 10+ year member

    Joined:
    20 Oct 2012
    Posts:
    10,699
    Location:
    Connecticut, U.S.A.
    Thank you :) It takes a lot of planning and working extra shifts to make these trips happen but they're worth it in the end!

    ~Thylo
     
    ZooBinh likes this.
  15. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
    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: 15 Jan 2019
  16. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
    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: 7 Jan 2019
  17. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
    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.
     
  18. Terry Thomas

    Terry Thomas Well-Known Member Premium Member 5+ year member

    Joined:
    5 Mar 2018
    Posts:
    698
    Location:
    NSW
    I like to acknowledge the ability of photographers; at times incredible. A little encouragement is always good.
     
    ThylacineAlive likes this.
  19. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
  20. Simon Hampel

    Simon Hampel Administrator Staff Member 20+ year member

    Joined:
    18 Oct 2003
    Posts:
    4,026
    Location:
    Sydney, Australia
    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