Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Forum statistics
Avatar
audrey boss
Member
Free Members
Offline
Jul 4, 2013 - 6:40 am

Hi, 

 

I am drawing up guidelines for my moderators and would like them to PM newbie members who have not posted within a week. Is there an easy way to extract this information or does she have to go in to each new member's profile and check activity?

Many thanks,

Audrey

Avatar
Yellow Swordfish
Glinton, England
SP Master
Offline
Jul 4, 2013 - 6:59 am

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
audrey boss
Member
Free Members
Offline
Jul 5, 2013 - 5:00 am

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 

Avatar
Yellow Swordfish
Glinton, England
SP Master
Offline
Jul 5, 2013 - 6:23 am

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.

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

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

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
Offline
Jul 5, 2013 - 9:54 pm

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
Offline
Jul 6, 2013 - 4:48 am

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.

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

Ha! 

thought this might be too much...

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

 

Many thanks,

Audrey

 

Avatar
audrey boss
Member
Free Members
Offline
Jul 8, 2013 - 4:55 am

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

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

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

andy-signature.png
YELLOW
SWORDFISH
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: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625