Research:Article feedback/Data

From Meta, a Wikimedia project coordination wiki
Jump to: navigation, search
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[edit]

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[edit]

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[edit]

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[edit]

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[edit]

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[edit]

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[edit]

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[edit]

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[edit]

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[edit]

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[edit]

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    |       |
+-------------------+------------------+------+-----+---------+-------+