Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
requests-topic
Data package reporting tools
Avatar
audrey boss
Member
Free Members
sp_UserOfflineSmall Offline
Jul 5, 2013 - 5:05 am

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

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 5, 2013 - 9:01 am

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
audrey boss
Member
Free Members
sp_UserOfflineSmall Offline
Jul 5, 2013 - 5:03 pm

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.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jul 5, 2013 - 10:11 pm

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...

Avatar
audrey boss
Member
Free Members
sp_UserOfflineSmall Offline
Jul 8, 2013 - 5:08 am

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 8, 2013 - 6:24 am

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
audrey boss
Member
Free Members
sp_UserOfflineSmall Offline
Jul 8, 2013 - 11:36 am

Great  Looking forward to hearing more...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17364
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625