Statistics by Request

[Son of a Beach]

As requested in another topic, here are some forum database statistics which may (or may not) be of interest to some people. I'll post some other statistics as time goes by, and if anyone has any requests, feel free to post them here, and I'll consider them, if the SQL is not too challenging.

Firstly, the male/female split as recorded in members' forum profiles:
Male: 214
Female: 57
(the remainder, which accounts for the vast majority of members, are unspecified)

Secondly, the posting frequency of the most frequent posters (with names, etc, removed). As you can see there are currently two people who post more frequently than I do (on average over the entire time since they signed up). One is a new member, and this is quite normal for new members, who only need to post a few posts on their first couple of days to jump to the top of the list. The other has been a member for quite some time, but still has a post average higher than mine:

Post Frequency.png

[photohiker]

If you could drag out the stats for the most average words per post, I bet I know who would get the medal

[Ent]

Content removed by poster

[Son of a Beach]

This one took me a while to figure out, but here's a table showing age distribution of members who've entered their full date of birth. Note that entering the date of birth is optional in member profiles, and even if date of birth is entered, many people choose to not include the year of birth.

So the age can only be calculated for those who do enter their full date of birth including the year. Currently this is only 100 people (less than 10% of members), but that is enough to get a fair idea of age distribution.

It appears to be a fairly even spread of the majority of people across the ages between 20 and 40, with somewhat fewer people, but still with a significant presence, from 40 to 60.

Ages.png

[Son of a Beach]

And one more for now...

According to Google Analytics, this site has been viewed by "9,455 Absolute Unique Visitors" in the last month.

This is a statistic I watch for a number of reasons. It gives a good indication of how many 'guest' users come to this site to search or browse for information without joining up with their own account (there are currently only 1310 signed up members). It's also a figure that I pass on to advertisers, as it gives them an idea of how many actual people their advertisements will be viewed by, rather than just the number of times it will be viewed, and therefore can be a key factor in them deciding the real value of advertising here.

Note that it is in quotes, because I don't believe it's actually true. I suspect that for people that log in from two or more different computers, they would be counted as different visitors. This may be as many as about half of the members, but probably not so many of the guests.

[Son of a Beach]

If you could drag out the stats for the most average words per post, I bet I know who would get the medal

Unfortunately, the system doesn't record the number of words per post, and the strain on the system of loading every post in the database one by one, counting the words in each, and then tallying them against the users and their post counts would be too much.

[Ent]

Content removed by poster

[photohiker]

If you could drag out the stats for the most average words per post, I bet I know who would get the medal

Unfortunately, the system doesn't record the number of words per post, and the strain on the system of loading every post in the database one by one, counting the words in each, and then tallying them against the users and their post counts would be too much.

Well, yes. I grant you that. You could approach it from the number of bytes in the post though, that would be a lot less cpu and db intensive.

[ILUVSWTAS]

33 is obviously a strong age for walkers

[Ent]

Content removed by poster

[corvus]

Yes what Brett said
corvus

[photohiker]

I haven't run phpBB for a couple of years, last time I did attainments weren't stored with the text.

[Son of a Beach]

I haven't run phpBB for a couple of years, last time I did attainments weren't stored with the text.

That's still correct. It would be a very poor use of the database to do store attainments (or attachments ) in the same field as the text of the post.

[Son of a Beach]

Here's an unusual Google Analytics graph of the number of visits to the site over the last month. There is a good explanation for the low flat spot, of course.

Notice that the low flat spot is not completely flat.

[Ent]

Content removed by poster

[Son of a Beach]

Well, it's a bit embarassing, but I'm able to laugh at myself (I wouldn't post this sort of thing otherwise, eh?).

The dramatic downward drop coincides with the upgrade of the forums software to version 3.0.6, during which I re-wrote the 'bush' theme from scratch (based on their default theme), to recreate the green look and custom graphics while incorporating the new features. I'd neglected to re-do the Google Analytics code in the template file. Doh! The dramatic upward line several days later coincides with the first time since that I'd looked at Google analytics and got a bit of a shock, but eventually figured out the problem and fixed it.

The reason the line isn't completely flat is because the wiki still gets a very little bit of traffic, and was still using the Google Analytics code.