Return to Question

The gathering of this data is as follows: each night I have a programme which crawls the /sites API endpoint on SE, and gathers the list of all sites in the network. Then, after that is complete, it crawls the /info API endpoint for each site and submits all data from that endpoint to my database. I then have a SQL query which I run on the database that reports all these metrics via multiple views and grouping.

If there are any other metrics as far as Votes Per Day, etc. that anyone things would be nice to have in this meta post, comment with the metric and I'll try to gather it around. (Or find me in The 2nd Monitor.)

The gathering of this data is as follows: each night I have a program which crawls the /sites API endpoint on SE, and gathers the list of all sites in the network. Then, after that is complete, it crawls the /info API endpoint for each site and submits all data from that endpoint to my database. I then have a SQL query which I run on the database that reports all these metrics via multiple views and grouping.

If there are any other metrics as far as Votes Per Day, etc. that anyone thinks would be nice to have in this meta post, comment with the metric and I'll try to gather it around. (Or find me in The 2nd Monitor.)

Finally, if we count Votes Per Day as the metric, and consider the number of days since launch as the number of days since the first public appearance (the date of the first Closed Beta, if none then the date of the first Open Beta, if none then the date of the Launch), we rank 30th out of 71 with graduated site, but we rank 32nd out of 316 when compared to all sites (including Meta's and betas).

Site State  | Total Above | Total Below | Highest VPD | Lowest VPD | Average VPD
------------+-------------+-------------+-------------+------------+------------
Open Beta   | 38          | 48          | 103.45      | 2.09       | 16.20
Meta        | 97          | 60          | 108.77      | 0.19       | 3.52
Normal      | 28          | 42          | 20318.85    | 4.92       | 431.37
Closed Beta | 1           | 1           | 46.00       | 12.07      | 29.03

Site State  | Total Above | Highest VPU | Lowest VPU | Average VPU
------------+-------------+-------------+------------+------------
Open Beta   | 47          | 27.79       | 4.56       | 7.80
Meta        | 29          | 10.35       | 4.60       | 6.77
Normal      | 55          | 35.48       | 4.57       | 10.07
Closed Beta | 1           | 11.62       | 11.62      | 11.62

Note: all this data is as of 2 August 2016 at approximately 00:05UTC+00:00.

Site State  | Total Above | Total Below | Highest VPU | Lowest VPU | Average VPU
------------+-------------+-------------+-------------+------------+------------
Open Beta   | 47          | 39          | 27.79       | 1.35       | 5.67
Meta        | 29          | 128         | 10.35       | 0.30       | 3.26
Normal      | 55          | 15          | 35.48       | 0.82       | 8.51
Closed Beta | 1           | 1           | 11.62       | 1.49       | 6.55

If we instead look at Votes Per Entity (where an entity is a question or answer) we end up with an even more disappointing chart:

Site State  | Total Above | Total Below | Highest VPE | Lowest VPE | Average VPE
------------+-------------+-------------+-------------+------------+------------
Open Beta   | 38          | 48          | 7.96        | 1.36       | 4.33
Meta        | 97          | 60          | 19.74       | 1.87       | 5.14
Normal      | 28          | 42          | 16.11       | 1.22       | 4.59
Closed Beta | 1           | 1           | 6.94        | 0.72       | 3.83

Our Votes Per Entity is 4.42, which puts us at 165th of 316. If only counting graduated sites, we're 29th out of 71.

Note: all this data is as of 2 August 2016 at approximately 00:05UTC+00:00.

The gathering of this data is as follows: each night I have a programme which crawls the /sites API endpoint on SE, and gathers the list of all sites in the network. Then, after that is complete, it crawls the /info API endpoint for each site and submits all data from that endpoint to my database. I then have a SQL query which I run on the database that reports all these metrics via multiple views and grouping.

I'm currently putting together the finishing touches on a site where all this data will be hosted, allowing anyone who desires to go in and run queries against it.