1028255 - Query Mozillians database for community growth data

Status: RESOLVED WONTFIX

(Participation Infrastructure :: Phonebook, defect)

Description

[William Reynolds [:williamr]]

We can use the data in Mozillians.org to look at how our community has grown. This data would be especially useful for the Community Building Team in their planning. We would like to run this query so we can then analyze the data:

SELECT date_mozillian, date_joined, last_updated, country, is_vouched FROM profile JOIN auth_user ON profile.user_id=auth_user.id;

There is no personal information returned by this query - just dates, a country name and whether or not the user is vouched. Feel free to email the resultset to me or attach to this bug.

Comment 1

[William Reynolds [:williamr]]

Sheeri, could you help us run this query on the mozillians.org production database? Thanks!

Comment 2

[Sheeri Cabral [:sheeri]]

Sure! Although is it worth it for me to extract the data, and then you send it to the community building team, which will then send the data back to me for the data warehouse where all this is happening?

If you don't need anything in the interim, this is a data source we can just pull from.

Comment 3

[Sheeri Cabral [:sheeri]]

Do you still need this report?

Comment 4

[Sheeri Cabral [:sheeri]]

And if you do still want this info, do you just want the numbers, or do you want a tableau graph that will update based on the data in the database - e.g. live update?

We can work with you on what you want for a community dashboard, if that's not already happening.