Support Forum

Data package reporting tools

AB audrey boss
audrey boss
Member

Hi. I run a thriving community of which my simple press forum is a huge part. In order to grow and manage the community effectively, I need access to reporting tools on member data and participation – as I imagine most people do in my situation.

A document with date joined, number of posts, number of logins, average number of posts per member, per forum, average time lapsed between posts per member and as an average, most popular topics/forums in terms of view and posts etc…

I believe this will make SP a much stronger platform and the number 1 choice for small businesses running online communities for profit. Also, I would be willing to pay a premium for this plugin/service.

Thanks,Audrey

 

6 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

Actually – in 6-7 years this is the first request for such a beast!

Mostly the data is available using SQL queries and at the end of the day this is what SQL is for – interrogating the database and extracting the data you want. Likewise, most decent SQL tools can pipe data into XML, CSV and probably other formats as well.

Most hosting comes with access to phpMyAdmin which will serve to perform all of these tasks although there are better tools available and there are even some, I believe, SQL Query plugins for WordPress that might be good enough to produce the sort of data you want.

But – we will also talk this over to see if we would want to take on the task of creating a one-off tool for this sort of querying.

AB audrey boss
audrey boss
Member

Thanks for the reply and apologies for the ignorance. I am not a developer. Just a layperson handling most of my site stuff. As such, SQL queries are like a foreign language to me! I will look into it though, as I do have access to PHPMyAdmin, so thank you.

MP Mr Papa
Mr Papa
Member

its more than just queries really…  would be best as a plugin for setting some options and starting to collect the needed information that is not currently being collected (ie wp does NOT record the number of logins for a user)…

We will be discussing if we want to take on this premium custom plugin development.  I think its fair to say, yes we do, just have to look at timing and availability.  I will be gone for a week starting sunday and sooner or later WP is going to finally release 3.6 and getting our 5.3 out will take priority.  so may take us a week or so to get back with  you… will try to keep you appraised…

AB audrey boss
audrey boss
Member

No problem and many thanks for looking into this. I have to say I am really impressed by your level of customer service…it is refreshing in the WP community where I feel customers are mostly left to fend for themselves…

We are also slowing doen over the summer and moving offices which means we wouldn’t be able to follow this on top of regular activities before September really.

We are however, quite keen to see if there is a possibility to develop this type of plugin so please keep us posted and if you need guinea pigs we are available. We will be getting a new intern starting after the summer so I can dedicate some resources to this.

Also, as suggested, I am including here the top queries we would be interested in gathering info from…

– how many new members in a given time span (i.e. from 1st July to 7th July)

– how many total posts in a given time span

– how many total newbie posts within 21 days/3 months/6 months

– average number of newbie posts within 21 days/3 months/6 months

– average number of posts for all members within 21 days/3 months/6 months

YS Yellow Swordfish
Yellow Swordfish
Member

All noted. Steve (Mr Papa) is away this week but we are discussing this and will do so more when he returns.