Jump to content

[Infographic] 2012 Year on The Hub in review - By the numbers


Matt

Recommended Posts

Posted

Your manipulation of stats has earned you a like, sir!

 

thumbup1.gif *yay* and its probably actually pretty accurate considering liking only came in last year. Now to figure out a way to convert likes to beer.

  • Replies 84
  • Created
  • Last Reply
Posted

We could chuck in a couple of assumptions to get a more accurate figure based on 2012.

 

You have been registered since 2007. If we made 2 assumptions:

A) number of posts per year is more or less consistent.

cool.png No-one liked any of your posts before 2012 whistling.gif

 

Then your ratio jumps up to 10% !!

 

according to that math...i have a ratio of 62.8% ph34r.png

Posted

thumbup1.gif *yay* and its probably actually pretty accurate considering liking only came in last year. Now to figure out a way to convert likes to beer.

 

Do that and you will be my favouritest hubber EVA!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Posted

according to that math...i have a ratio of 62.8% ph34r.png

 

well done. you are topping the list at the moment (comment updated). sorry hayley.

Posted

There are definitely many hours that can be killed digging through the stats.

 

Some are easier to pull out of the various tables than others. The easier ones made it into the graphic, but there are some interesting stats mentioned already that I'd like to pull out.

 

I'll see what I can do today to pull out these and any other suggestions:

 

- BrettMTB's "Likes - posts" ratio (counting posts from when likes where introduced)

- Overall site activity split (forums vs. classifieds vs. PM vs. home page / news etc.)

- Overall most viewed & replied to topics (including Chit chat)

Posted

awesome admin :) The original suggestion came from Carpet.

 

Here's a formula for the "likes to beer" suggestion which I think you must have accidentally missed:

 

-- members who post more than 1000 posts a year with a ratio >=30% get 1 x beer. TODO: multiply beer by factor 10 of ratio - 10% = 1 beer, etc.

select nickname from members where ratio > 0.3 and num_posts > 1000 and date > '01-01-2012'

Posted

awesome admin smile.png The original suggestion came from Carpet.

 

Here's a formula for the "likes to beer" suggestion which I think you must have accidentally missed:

 

-- members who post more than 1000 posts a year with a ratio >=30% get 1 x beer. TODO: multiply beer by factor 10 of ratio - 10% = 1 beer, etc.

select nickname from members where ratio > 0.3 and num_posts > 1000 and date > '01-01-2012'

 

I need a drink after reading all that… blush.png

Posted

Here's the overall split across the site sections (based on page views for November 2012):

 

1. Classifieds: 40%

2. Forums: 38%

3. Home page & News: 12%

4. Search (all sections): 6.4%

5. Member Profiles & PMs: 2.6%

6. Gallery & Events: 1%

 

More to follow...

Posted

Top 20 Topics across all Forums - By Topic Views

Only topics created in 2012, rank based on topic views.

  1. Tattooed, burlesque and beautiful women of the world. Views: 652025, Posts: 10052
     
  2. Hubbers Please help a Lady Views:270771, Posts: 8967
     
  3. Lance Armstrong Banned and Stripped of TDF Titles Views: 112624, Posts: 3468
     
  4. Team 360Life Suspension: David George busted Views: 91311, Posts: 962
     
  5. 2012 94.7 Views: 83115, Posts: 1284
     
  6. Tour de France 2012 Views: 81214, Posts: 2836
     
  7. Boast about your latest purchases here... Views: 57619, Posts: 831
     
  8. Office Warning: Cleavage days pics Views: 43870, Posts: 118
     
  9. sani2c - newbie questions Views: 39925, Posts: 589
     
  10. ASG Trans Baviaans 24hr MTB Marathon 2012 Views: 29246, Posts: 512
     
  11. Die Burger Cycle Tour Views: 28310, Posts: 704
     
  12. OFFICIAL MODDERFONTEIN MTB TRAIL ANNOUNCEMENT Views: 27380, Posts: 350
     
  13. Cycling ladies in capetown/durbanville? Views: 26547, Posts: 498
     
  14. Rugby... Views: 25083, Posts: 1335
     
  15. Coffee machine Views: 24680, Posts: 613
     
  16. 2013 Bikes now @ CWC Views: 24168, Posts: 194
     
  17. [Event] NISSAN TRAILSEEKER #3 Down & Dirty Views: 24064, Posts: 494
     
  18. Cyclist knocked down in St James this morning Views: 22502, Posts: 297
     
  19. Lonmin Saga/death toll. Views: 22293, Posts: 891
     
  20. TheHub as entertainment... Views: 21461, Posts: 672

Posted

no no...with the new formula, i have almost 100% then.....

tis between the dangly one and you.........lets see what admin comes up with.....

 

mine will decrease significantly as my early years did not have much posting

Posted

Top 20 Topics across all Forums - By Topic Views

Only topics created in 2012, rank based on topic views.

 

VERY interesting to see that the idea thread did not even feature this year...

Archived

This topic is now archived and is closed to further replies.

Settings My Forum Content My Followed Content Forum Settings Ad Messages My Ads My Favourites My Saved Alerts My Pay Deals Help Logout