We do not have any tools built in that would allow for this but the easiest way to get such a list is to run a query against the database if that is going to be possible. Can certainly help you with the query if needed.

Hi, thank you – help with the query would be useful. Now that the site and forum are up and running I’d like to run some data gathering exercices on a monthly basis and will need info such as number of posts, joining date etc…Apart from running a query on the database, is it possible to export member info into an excel or csv format? Where do I post to ask for data reporting features? Fore those of us making a living out of running communities, this is crucial information…

Many thanks,

Audrey 

Tell me what data you want in the query and what the criteria is and I can help construct that for you.

As to the general question on reporting I will move that discussion to your other topic.

Hi, that’s great thanks.

I want to know:

– 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

Thank you

yikes. thats more than you are going to get from simple db queries… plus you really need a UI to collect the needed input to run the queries…

would suggest adding these to your custom stats plugin request…  currently discussing that one to see if we want to take on a custom plugin development and if so, what it would entail from a cost perspective…

er… yes. I was offering to help out with a query for this one – ‘PM newbie members who have not posted within a week’. Not the entire suite! Can still do that.

Ha! 

thought this might be too much…

PM newbies who have not posted within 10 days would be a wonderful start

Many thanks,

Audrey

Mr Papa said
yikes. thats more than you are going to get from simple db queries… plus you really need a UI to collect the needed input to run the queries…

would suggest adding these to your custom stats plugin request…  currently discussing that one to see if we want to take on a custom plugin development and if so, what it would entail from a cost perspective…

Will do, thanks

Audrey

‘PM newbies who have not posted within 10 days would be a wonderful start’…

You will need to define ‘newbie’…. Under what conditions is someone a newbie? Or do you simply mean they have NEVER posted? Which would mean – ‘all users who registered up to 10 days ago who have not yet made a forum post’.

Newbie = anyone who registered to the Forum less than 10 days ago

thanks

OK – this query will return a list of all those members who registered within the last 10 days and have not yet made a forum post. Note that this uses the table prefix wp_ so if you have used a different prefix you will need to change this throughout the query.

SELECT ID AS user_id, user_registered, user_login, wp_sfmembers.display_name
FROM wp_users
JOIN wp_sfmembers ON wp_users.ID = wp_sfmembers.user_id
WHERE user_registered > DATE_SUB(CURDATE(), INTERVAL 10 DAY) 
AND posts < 1;