Research:Article feedback/Data

Article Feedback v5

Data & Metrics

Stage 1: Design
(December 2011 - March 2012)

Stage 2: Placement
(March 2012 - April 2012)

Stage 3: Impact on engagement
(April 2012 - May 2012)

WP:AFT5 (Talk)
Feature requirements

Dashboards

Overview
Article samples
Feature data
Clicktracking data

Volume analysis
Quality assessment
Reader survey / Team survey
Usability testing

Volume analysis
Quality assessment

Conversions and newcomer quality

Final tests

Quality assessment
Research report (2012 Q4)
Moderation tools usability study

The data collected via the AFTv5 extension is stored in the following MySQL tables of the MediaWiki database and is replicated on the Toolserver. A real-time data stream is available here.

aft_article_answer

mysql> EXPLAIN aft_article_answer;
+-----------------------+------------------+------+-----+---------+-------+
| Field                 | Type             | Null | Key | Default | Extra |
+-----------------------+------------------+------+-----+---------+-------+
| aa_feedback_id        | int(10) unsigned | NO   | PRI | NULL    |       |
| aa_field_id           | int(10) unsigned | NO   | PRI | NULL    |       |
| aa_response_rating    | int(11)          | YES  |     | NULL    |       |
| aa_response_text      | blob             | YES  |     | NULL    |       |
| aa_response_boolean   | tinyint(1)       | YES  |     | NULL    |       |
| aa_response_option_id | int(10) unsigned | YES  |     | NULL    |       |
+-----------------------+------------------+------+-----+---------+-------+

aft_article_feedback

mysql> EXPLAIN aft_article_feedback;
+------------------------+------------------+------+-----+----------------+----------------+
| Field                  | Type             | Null | Key | Default        | Extra          |
+------------------------+------------------+------+-----+----------------+----------------+
| af_id                  | int(10) unsigned | NO   | PRI | NULL           | auto_increment |
| af_page_id             | int(10) unsigned | NO   | MUL | NULL           |                |
| af_user_id             | int(11)          | NO   |     | NULL           |                |
| af_user_ip             | varbinary(32)    | YES  |     | NULL           |                |
| af_user_anon_token     | varbinary(32)    | NO   |     |                |                |
| af_revision_id         | int(10) unsigned | NO   | MUL | NULL           |                |
| af_bucket_id           | int(10) unsigned | NO   |     | 0              |                |
| af_cta_id              | int(10) unsigned | NO   |     | 0              |                |
| af_link_id             | int(10) unsigned | NO   |     | 0              |                |
| af_created             | binary(14)       | NO   | MUL |                |                |
| af_abuse_count         | int(10) unsigned | NO   |     | 0              |                |
| af_helpful_count       | int(10) unsigned | NO   |     | 0              |                |
| af_unhelpful_count     | int(10) unsigned | NO   |     | 0              |                |
| af_oversight_count     | int(10) unsigned | NO   |     | 0              |                |
| af_is_deleted          | tinyint(1)       | NO   |     | 0              |                |
| af_is_hidden           | tinyint(1)       | NO   |     | 0              |                |
| af_net_helpfulness     | int(11)          | NO   |     | 0              |                |
| af_has_comment         | tinyint(1)       | NO   |     | 0              |                |
| af_is_unhidden         | tinyint(1)       | NO   |     | 0              |                |
| af_is_undeleted        | tinyint(1)       | NO   |     | 0              |                |
| af_is_declined         | tinyint(1)       | NO   |     | 0              |                |
| af_activity_count      | int(10) unsigned | NO   |     | 0              |                |
| af_hide_user_id        | int(10) unsigned | NO   |     | 0              |                |
| af_oversight_user_id   | int(10) unsigned | NO   |     | 0              |                |
| af_hide_timestamp      | binary(14)       | NO   |     |                |                |
| af_oversight_timestamp | binary(14)       | NO   |     |                |                |
+------------------------+------------------+------+-----+----------------+----------------+

aft_article_feedback_properties

mysql> EXPLAIN aft_article_feedback_properties;
+-----------------+------------------+------+-----+---------+-------+
| Field           | Type             | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+-------+
| afp_feedback_id | int(10) unsigned | NO   | PRI | NULL    |       |
| afp_key         | varbinary(255)   | NO   | PRI | NULL    |       |
| afp_value_int   | int(11)          | NO   |     | NULL    |       |
| afp_value_text  | varbinary(255)   | NO   |     |         |       |
+-----------------+------------------+------+-----+---------+-------+

aft_article_feedback_ratings_rollup

mysql> EXPLAIN aft_article_feedback_ratings_rollup;
+--------------+------------------+------+-----+---------+-------+
| Field        | Type             | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+-------+
| arr_page_id  | int(10) unsigned | NO   | PRI | NULL    |       |
| arr_field_id | int(10) unsigned | NO   | PRI | NULL    |       |
| arr_total    | int(10) unsigned | NO   |     | NULL    |       |
| arr_count    | int(10) unsigned | NO   |     | NULL    |       |
+--------------+------------------+------+-----+---------+-------+

aft_article_feedback_ratings_rollup

mysql> EXPLAIN aft_article_feedback_select_rollup;
+----------------+------------------+------+-----+---------+-------+
| Field          | Type             | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| afsr_page_id   | int(10) unsigned | NO   | PRI | NULL    |       |
| afsr_option_id | int(10) unsigned | NO   | PRI | NULL    |       |
| afsr_field_id  | int(10) unsigned | NO   |     | NULL    |       |
| afsr_total     | int(10) unsigned | NO   |     | NULL    |       |
| afsr_count     | int(10) unsigned | NO   |     | NULL    |       |

aft_article_field

mysql> EXPLAIN aft_article_field;
+---------------+---------------------------------------------+------+-----+---------+----------------+
| Field         | Type                                        | Null | Key | Default | Extra          |
+---------------+---------------------------------------------+------+-----+---------+----------------+
| afi_id        | int(10) unsigned                            | NO   | PRI | NULL    | auto_increment |
| afi_name      | varbinary(255)                              | NO   | MUL | NULL    |                |
| afi_data_type | enum('text','boolean','rating','option_id') | YES  | MUL | NULL    |                |
| afi_group_id  | int(10) unsigned                            | YES  |     | NULL    |                |
| afi_bucket_id | int(10) unsigned                            | NO   |     | NULL    |                |
+---------------+---------------------------------------------+------+-----+---------+----------------+

aft_article_field_group

mysql> EXPLAIN aft_article_field_group;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| afg_id   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| afg_name | varbinary(255)   | NO   | UNI | NULL    |                |
+----------+------------------+------+-----+---------+----------------+

aft_article_field_option

mysql> EXPLAIN aft_article_field_option;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| afo_option_id | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| afo_field_id  | int(10) unsigned | NO   | MUL | NULL    |                |
| afo_name      | varbinary(255)   | NO   |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+

aft_article_filter_count

mysql> EXPLAIN aft_article_filter_count;
+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| afc_page_id      | int(10) unsigned | NO   | PRI | NULL    |       |
| afc_filter_name  | varbinary(64)    | NO   | PRI | NULL    |       |
| afc_filter_count | int(10) unsigned | NO   |     | NULL    |       |
+------------------+------------------+------+-----+---------+-------+

aft_article_revision_feedback_ratings_rollup

mysql> EXPLAIN aft_article_revision_feedback_ratings_rollup;
+------------------+------------------+------+-----+---------+-------+
| Field            | Type             | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+-------+
| afrr_page_id     | int(10) unsigned | NO   | PRI | NULL    |       |
| afrr_revision_id | int(10) unsigned | NO   | PRI | NULL    |       |
| afrr_field_id    | int(10) unsigned | NO   | PRI | NULL    |       |
| afrr_total       | int(10) unsigned | NO   |     | NULL    |       |
| afrr_count       | int(10) unsigned | NO   |     | NULL    |       |
+------------------+------------------+------+-----+---------+-------+

aft_article_revision_feedback_select_rollup

mysql> EXPLAIN aft_article_revision_feedback_select_rollup;
+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| arfsr_page_id     | int(10) unsigned | NO   | PRI | NULL    |       |
| arfsr_revision_id | int(10) unsigned | NO   | PRI | NULL    |       |
| arfsr_option_id   | int(10) unsigned | NO   | PRI | NULL    |       |
| arfsr_field_id    | int(10) unsigned | NO   | PRI | NULL    |       |
| arfsr_total       | int(10) unsigned | NO   |     | NULL    |       |
| arfsr_count       | int(10) unsigned | NO   |     | NULL    |       |
+-------------------+------------------+------+-----+---------+-------+