On 2020-04-09 emailed:
WITH
apReviewers AS (SELECT userID, ANY_VALUE(email) AS email, COUNT(*) AS apCount, ANY_VALUE(ru.timestamp) as registrationTimestamp FROM `logs.reviews` JOIN `logs.registeredUsers` AS ru USING (userID) WHERE promptIndex IS NOT NULL AND sessionID IS NOT NULL GROUP BY userID ORDER BY apCount DESC),
apCondition AS (SELECT userID, JSON_EXTRACT_SCALAR(extra, "$['condition']") AS condition FROM `logs.userEvents` WHERE JSON_EXTRACT_SCALAR(extra, "$['experimentName']") = "labelApplicationPrompts")
SELECT * FROM apReviewers JOIN apCondition USING (userID) ORDER BY apCount DESC
They induce a different “mode” of thinking, which readers find enjoyable.
Transitions back and forth between recall and application prompts aren’t jarring; people know what to do when answering a question.
They may be too easy to be meaningfully helpful.