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

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  N

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

Return to "Anonymous editor acquisition/Signup CTA experiment/Work log/2014-05-14" page.