Automated weekly new account creation / first contribution report


Users and Groups
3 years ago
8 months ago


(Reporter: vesper, Unassigned)


Firefox Tracking Flags

(Not tracked)


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.


3 years ago
Please create an ongoing report using the two queries describer in the User Story.

Comment 1

3 years ago
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)
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)

Comment 4

3 years ago
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)

Comment 5

3 years ago
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.

Comment 6

3 years ago
Added to champion backlog


8 months ago
Priority: -- → P3
You need to log in before you can comment on or make changes to this bug.