Closed
Bug 1208468
Opened 9 years ago
Closed 5 years ago
Automated weekly new account creation / first contribution report
Categories
(support.mozilla.org :: Users and Groups, task, P3)
support.mozilla.org
Users and Groups
Tracking
(Not tracked)
RESOLVED
WONTFIX
People
(Reporter: mdziewonski, Unassigned)
Details
User Story
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.
Flags: needinfo?(mdziewonski)
Flags: needinfo?(jsavage)
Comment 2•9 years ago
|
||
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.
Flags: needinfo?(jsavage)
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.
Flags: needinfo?(mdziewonski)
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.
Status: NEW → RESOLVED
Closed: 5 years ago
Resolution: --- → WONTFIX
You need to log in
before you can comment on or make changes to this bug.
Description
•