[Spike] Extract QuickSurveys responses from Reading List beta feature users for analysis
Closed, ResolvedPublic1 Estimated Story Points
Actions

Assigned To

Authored By

	HFan-WMF
	May 12 2026, 7:37 PM

Project Tags

Referenced Files

None

Subscribers

Description

As part of the Reading list beta rollout, we have launched a QuickSurvey to collect user feedback (https://phabricator.wikimedia.org/T417405) via 2 questions: a generic "usefulness" rating (yes/no) and an open ended feature request text box.

We need a way to extract the survey responses from data storage, so we can analyze the results, learn from them, and act upon them accordingly.

Survey results can come in the form of spreadsheet, or any other format that would facilitate the team to be able to see:

Percentage of respondents from a given time period who replied "yes" or "no" to the first question
Open ended responses that people have submitted into the second optional question.

If this is a manual process, we can pull the results at the end of every workweek for snapshots.

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		HFan-WMF	T417405 [EPIC] Reading list quick survey for beta users
		Resolved		HFan-WMF	T426120 [Spike] Extract QuickSurveys responses from Reading List beta feature users for analysis

Event Timeline

HFan-WMF created this task.May 12 2026, 7:37 PM

HFan-WMF triaged this task as Medium priority.

AnneT subscribed.May 12 2026, 8:20 PM

Jdlrobson-WMF moved this task from Incoming to Needs refinement on the Reader Experience Team board.Jun 2 2026, 5:29 PM

HFan-WMF moved this task from Needs refinement to REx Sprint 22 [Q4 Jun 2 - Jun 15] on the Reader Experience Team board.Jun 2 2026, 5:49 PM

HFan-WMF edited projects, added: Reader Experience Team (REx Sprint 22 [Q4 Jun 2 - Jun 15]); removed: Reader Experience Team.

HFan-WMF set the point value for this task to 1.Jun 2 2026, 5:53 PM

Timeboxing to just 1 point -- an engineer to provide query that allows interested superset users to find survey results easily.

Superset query:

SELECT event.surveyanswers, event.surveyresponsefreetext
  FROM event.quicksurveysresponses
  WHERE event.surveycodename = 'ReadingLists beta feature survey'
    AND year = 2026
    AND cardinality(event.surveyresponsefreetext) > 0
  ORDER BY dt DESC

Link to saved query: https://superset.wikimedia.org/sqllab?savedQueryId=1437