Jump to content

Research talk:Anonymous editor acquisition/Signup CTA experiment/Work log/2014-05-14

Add topic
From Meta, a Wikimedia project coordination wiki

Wednesday, May 14th

[edit]

Today I'm checking that the instrumentation for the experiment is working. My plan is to set up the current version of the experiment and instrumentation, run through the UI and check the database to make sure the events were stored as expected. To do this, I need a query that will gather all of the relevant events and sort them by timestamp.

SET @token = "TcjQiedcb6GJF0RzzkB8MoWoqPkKS5dR";
SELECT * FROM (
    SELECT timestamp, "button click" as event, CONCAT(event_namespace, ": ", event_cta) AS details 
    FROM SignupExpCTAButtonClick_8102619 WHERE timestamp > "20140514" AND event_token = @token
    UNION
    SELECT timestamp, "CTA impression" as event, CONCAT(event_namespace, ": ", event_cta) AS details 
    FROM SignupExpCTAImpression_8101716 WHERE timestamp > "20140514" AND event_token = @token
    UNION
    SELECT timestamp, "page link click" as event, CONCAT(event_namespace, ": ", event_link) AS details
    FROM SignupExpPageLinkClick_8101692 WHERE timestamp > "20140514" AND event_token = @token
    UNION
    SELECT tracked.timestamp, "edit" as event, CONCAT(event_revId, ": ", event_revId) AS details
    FROM TrackedPageContentSaveComplete_7872558 tracked
    INNER JOIN PageContentSaveComplete_5588433 complete ON
        complete.event_revisionId = tracked.event_revId AND
        tracked.wiki = complete.wiki
    WHERE tracked.timestamp > "20140514" AND event_token = @token
) AS events
ORDER BY timestamp;

Scratch that. I forgot about server-side events. I just went about grepping for events in my vagrant log and found SignupExpAccountCreationImpression.

OK Here's the list:

  • SignupExpPageLinkClick
    • create account Done
    • edit page Done
    • edit section Done
    • Check namespace other than zero Done
    • Check for
      • Post edit Done
      • Pre edit Done
      • Control Done
  • SignupExpCTAButtonClick
    • Edit (pre-edit) Done
    • Signup (pre-edit) Done
    • Dismiss (pre-edit) Done
    • Signup (post-edit) Done
    • Dismiss (post-edit) Done
  • SignupExpCTAImpression
    • Pre-edit Done
    • Post-edit Done
  • TrackedPageContentSaveComplete
    • Logged out Done
    • Logged in Done
  • SignupExpAccountCreationImpression Done
    • Also discussed the implications of storing this event on the server-side
  • SignupExpAccountCreationComplete NoN

I can't seem to generate a SignupAccountCreationComplete event. --Halfak (WMF) (talk) 23:07, 14 May 2014 (UTC)Reply