I as a Community Manager would like to receive or be able to access a weekly report (e.g. in Google Docs as a spreadsheet) with the following information: 1) the number and usernames (with links, if possible) of all accounts that were created between Monday and Sunday of the previous week. 2) the number and usernames (with links, if possible) of all accounts that performed a first contribution between Monday and Sunday of the previous week The Monday to Sunday bracket could be "last 7 days", if that's easier to implement.
Please create an ongoing report using the two queries describer in the User Story.
First contribution defined by: one reply on the questions forums or one edit to the KB or one tweet using Army of Awesome Veseper, Joni correct me if I'm wrong.
Kadir has access to the db. Does this have to live in SUMO or can't this be a script run against the databases he has access to?
Defining a first contribution as one edit to the KB sounds right to me.
To answer Will's question - I think Kadir had an idea of recycling an existing email report and making a new query for it. To answer Madalina's request - nothing wrong there, one/first edit to the KB is a good measure of activity.
Correction: contribution on the support forum should be defined as one reply which was not on the user's own thread. This can also be a report sent to email.
Added to champion backlog
You need to log in before you can comment on or make changes to this bug.