Jump to content

Research talk:Anonymous editor acquisition/Signup CTA experiment/Work log/2014-06-20

Add topic
From Meta, a Wikimedia project coordination wiki

Friday, June 20th

[edit]

First thing I'm doing today is extending my flow dataset so that it includes all of the bits from token_info (generated in a previous worklog). I'll need that to split by buckets and other relevant context bits. --Halfak (WMF) (talk) 15:19, 20 June 2014 (UTC)Reply


> dim(flows)
[1] 707959     42

So I have about 708k flows. How many individual tokens?

> length(unique(flows$token));
[1] 707952

Yeah. That can't be right. It looks like I caused a grouping error when I modified my token flow stats query. Re-running... --Halfak (WMF) (talk) 15:31, 20 June 2014 (UTC)Reply


OK. Second attempt. Big money, no whammies!

> dim(flows)
[1] 791862     42

There we go!

> length(unique(flows$token))
[1] 707952

Alright! --Halfak (WMF) (talk) 19:32, 20 June 2014 (UTC)Reply


Flows

[edit]
Messy first attempt

<pre> flows[, list( count = length(token) ), list( wiki, bucket ) ] wiki bucket count 1: dewiki control 38711 2: dewiki post-edit 34783 3: dewiki pre-edit 34441 4: enwiki pre-edit 178741 5: enwiki control 189724 6: enwiki post-edit 171517 7: frwiki pre-edit 28411 8: frwiki post-edit 27180 9: frwiki control 29962 10: itwiki pre-edit 19405 11: itwiki control 20361 12: itwiki post-edit 18626 </pre> ==== Section edit ==== <pre> flows[first_edit_section_click == flow_start, list( count = length(token) ), list( wiki, bucket ) ] wiki bucket count 1: dewiki post-edit 24880 2: dewiki pre-edit 24866 3: dewiki control 27537 4: enwiki pre-edit 112789 5: enwiki control 119389 6: enwiki post-edit 107376 7: frwiki pre-edit 18063 8: frwiki control 19246 9: frwiki post-edit 17420 10: itwiki pre-edit 13883 11: itwiki post-edit 13039 12: itwiki control 14482 </pre> ==== Page edit ==== <pre> flows[first_edit_page_click == flow_start, list( count = length(token) ), list( wiki, bucket ) ] wiki bucket count 1: dewiki control 11174 2: dewiki post-edit 9903 3: dewiki pre-edit 9575 4: enwiki pre-edit 65950 5: enwiki post-edit 64139 6: enwiki control 70330 7: frwiki pre-edit 10349 8: frwiki post-edit 9760 9: frwiki control 10716 10: itwiki pre-edit 5522 11: itwiki control 5879 12: itwiki post-edit 5587 </pre> ==== Section edit --> Pre-edit CTA impression ==== <pre> flows[first_edit_section_click == flow_start & !is.na(first_pre_edit_cta_impression), list( count = length(token) ), list( wiki, bucket ) ] wiki bucket count 1: dewiki pre-edit 23763 2: enwiki pre-edit 109137 3: enwiki control 1 4: enwiki post-edit 1 5: frwiki pre-edit 17526 6: itwiki pre-edit 13454 </pre> ==== Page edit --> Pre-edit CTA impression ==== <pre> flows[first_edit_page_click == flow_start & !is.na(first_pre_edit_cta_impression), list( count = length(token) ), list( wiki, bucket ) ] wiki bucket count 1: dewiki pre-edit 8884 2: enwiki pre-edit 63900 3: frwiki pre-edit 10020 4: frwiki post-edit 1 5: itwiki pre-edit 5324 </pre> ==== Section edit --> Post-edit CTA impression ==== <pre> flows[first_edit_section_click == flow_start & !is.na(first_post_edit_cta_impression), list( count = length(token) ), list( wiki, bucket ) ] wiki bucket count 1: dewiki post-edit 1838 2: enwiki post-edit 16379 3: frwiki post-edit 2592 4: itwiki post-edit 2302 5: itwiki pre-edit 1 </pre> ==== Page edit --> Post-edit CTA impression ==== <pre> flows[first_edit_page_click == flow_start & !is.na(first_post_edit_cta_impression), list( count = length(token) ), list( wiki, bucket ) ] wiki bucket count 1: dewiki post-edit 1158 2: enwiki post-edit 12664 3: frwiki post-edit 1848 4: itwiki post-edit 1787 </pre> ==== Section edit --> Pre-edit CTA impression --> Edit click ==== .... Bah this is too messy and it's going to take forever. I need to try something else.

Pre-edit

[edit]

section edit --> pre-edit --> edit button --> revision saved

[edit]
flows[,
	list(
		n = length(token),
		section_edit = sum(first_edit_section_click == flow_start, na.rm=T),
		pre_edit = sum(first_edit_section_click == flow_start & 
		               !is.na(first_pre_edit_cta_impression), na.rm=T),
		edit_button = sum(first_edit_section_click == flow_start & 
		                  !is.na(first_pre_edit_cta_impression) & 
		                  !is.na(first_edit_button_click), na.rm=T),
		revision_saved = sum(first_edit_section_click == flow_start & 
		                     !is.na(first_pre_edit_cta_impression) & 
		                     !is.na(first_edit_button_click) &
		                     revisions_saved > 0, na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n section_edit pre_edit edit_button revision_saved
# 1: dewiki   control  38711        27537        0           0              0
# 2: dewiki post-edit  34783        24880        0           0              0
# 3: dewiki  pre-edit  34441        24866    23763        3410           1037
# 4: enwiki  pre-edit 178741       112789   109137       18004           8961
# 5: enwiki   control 189724       119389        1           0              0
# 6: enwiki post-edit 171517       107376        1           0              0
# 7: frwiki  pre-edit  28411        18063    17526        2321           1226
# 8: frwiki post-edit  27180        17420        0           0              0
# 9: frwiki   control  29962        19246        0           0              0
#10: itwiki  pre-edit  19405        13883    13454        1991           1077
#11: itwiki   control  20361        14482        0           0              0
#12: itwiki post-edit  18626        13039        0           0              0


page edit --> pre-edit --> edit button --> revision saved

[edit]
flows[,
	list(
		n = length(token),
		page_edit = sum(first_edit_page_click == flow_start, na.rm=T),
		pre_edit = sum(first_edit_page_click == flow_start & 
		               !is.na(first_pre_edit_cta_impression), na.rm=T),
		edit_button = sum(first_edit_page_click == flow_start & 
		                  !is.na(first_pre_edit_cta_impression) & 
		                  !is.na(first_edit_button_click), na.rm=T),
		revision_saved = sum(first_edit_page_click == flow_start & 
		                     !is.na(first_pre_edit_cta_impression) & 
		                     !is.na(first_edit_button_click) &
		                     revisions_saved > 0, na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n page_edit pre_edit edit_button revision_saved
# 1: dewiki   control  38711     11174        0           0              0
# 2: dewiki post-edit  34783      9903        0           0              0
# 3: dewiki  pre-edit  34441      9575     8884        1847            712
# 4: enwiki  pre-edit 178741     65950    63900       14077           7000
# 5: enwiki   control 189724     70330        0           0              0
# 6: enwiki post-edit 171517     64139        0           0              0
# 7: frwiki  pre-edit  28411     10349    10020        1713            949
# 8: frwiki post-edit  27180      9760        1           0              0
# 9: frwiki   control  29962     10716        0           0              0
#10: itwiki  pre-edit  19405      5522     5324        1281            795
#11: itwiki   control  20361      5879        0           0              0
#12: itwiki post-edit  18626      5587        0           0              0


section edit --> pre-edit --> dismiss button --> revision saved

[edit]
flows[,
	list(
		n = length(token),
		section_edit = sum(first_edit_section_click == flow_start, na.rm=T),
		pre_edit = sum(first_edit_section_click == flow_start & 
		               !is.na(first_pre_edit_cta_impression), na.rm=T),
		dismiss_button = sum(first_edit_section_click == flow_start & 
		                  !is.na(first_pre_edit_cta_impression) & 
		                  !is.na(first_dismiss_button_click), na.rm=T),
		revision_saved = sum(first_edit_section_click == flow_start & 
		                     !is.na(first_pre_edit_cta_impression) & 
		                     !is.na(first_dismiss_button_click) &
		                     revisions_saved > 0, na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n section_edit pre_edit dismiss_button revision_saved
# 1: dewiki   control  38711        27537        0              0              0
# 2: dewiki post-edit  34783        24880        0              0              0
# 3: dewiki  pre-edit  34441        24866    23763          13274            376
# 4: enwiki  pre-edit 178741       112789   109137          59432           3278
# 5: enwiki   control 189724       119389        1              0              0
# 6: enwiki post-edit 171517       107376        1              0              0
# 7: frwiki  pre-edit  28411        18063    17526           9652            748
# 8: frwiki post-edit  27180        17420        0              0              0
# 9: frwiki   control  29962        19246        0              0              0
#10: itwiki  pre-edit  19405        13883    13454           6908            565
#11: itwiki   control  20361        14482        0              0              0
#12: itwiki post-edit  18626        13039        0              0              0


page edit --> pre-edit --> dismiss button --> revision saved

[edit]
flows[,
	list(
		n = length(token),
		page_edit = sum(first_edit_page_click == flow_start, na.rm=T),
		pre_edit = sum(first_edit_page_click == flow_start & 
		               !is.na(first_pre_edit_cta_impression), na.rm=T),
		dismiss_button = sum(first_edit_page_click == flow_start & 
		                  !is.na(first_pre_edit_cta_impression) & 
		                  !is.na(first_dismiss_button_click), na.rm=T),
		revision_saved = sum(first_edit_page_click == flow_start & 
		                     !is.na(first_pre_edit_cta_impression) & 
		                     !is.na(first_dismiss_button_click) &
		                     revisions_saved > 0, na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n page_edit pre_edit dismiss_button revision_saved
# 1: dewiki   control  38711     11174        0              0              0
# 2: dewiki post-edit  34783      9903        0              0              0
# 3: dewiki  pre-edit  34441      9575     8884           3296            223
# 4: enwiki  pre-edit 178741     65950    63900          22526           2436
# 5: enwiki   control 189724     70330        0              0              0
# 6: enwiki post-edit 171517     64139        0              0              0
# 7: frwiki  pre-edit  28411     10349    10020           4437            511
# 8: frwiki post-edit  27180      9760        1              1              1
# 9: frwiki   control  29962     10716        0              0              0
#10: itwiki  pre-edit  19405      5522     5324           1873            373
#11: itwiki   control  20361      5879        0              0              0
#12: itwiki post-edit  18626      5587        0              0              0
  1. TODO: Add flow for second edit link click

section edit --> pre-edit --> signup button --> account created --> revision saved

[edit]
flows[,
	list(
		n = length(token),
		sec_edit = sum(first_edit_section_click == flow_start, na.rm=T),
		pre_edit = sum(first_edit_section_click == flow_start & 
		               !is.na(first_pre_edit_cta_impression), na.rm=T),
		signup = sum(first_edit_section_click == flow_start & 
		                    !is.na(first_pre_edit_cta_impression) & 
		                    !is.na(first_signup_button_click), na.rm=T),
		acc_created = sum(first_edit_section_click == flow_start & 
		                      !is.na(first_pre_edit_cta_impression) & 
		                      !is.na(first_signup_button_click) &
		                      !is.na(first_account_creation_complete), na.rm=T),
		rev_saved = sum(first_edit_section_click == flow_start & 
		                     !is.na(first_pre_edit_cta_impression) & 
		                     !is.na(first_signup_button_click) &
		                     !is.na(first_account_creation_complete) &
		                     revisions_saved > 0, na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n sec_edit pre_edit signup acc_created rev_saved
# 1: dewiki   control  38711    27537        0      0           0         0
# 2: dewiki post-edit  34783    24880        0      0           0         0
# 3: dewiki  pre-edit  34441    24866    23763   1357         195       110
# 4: enwiki  pre-edit 178741   112789   109137   9348        2080      1371
# 5: enwiki   control 189724   119389        1      0           0         0
# 6: enwiki post-edit 171517   107376        1      0           0         0
# 7: frwiki  pre-edit  28411    18063    17526   1224         300       217
# 8: frwiki post-edit  27180    17420        0      0           0         0
# 9: frwiki   control  29962    19246        0      0           0         0
#10: itwiki  pre-edit  19405    13883    13454    644         154       122
#11: itwiki   control  20361    14482        0      0           0         0
#12: itwiki post-edit  18626    13039        0      0           0         0

page edit --> pre-edit --> signup button --> account created --> revision saved

[edit]
flows[,
	list(
		n = length(token),
		page_edit = sum(first_edit_page_click == flow_start, na.rm=T),
		pre_edit = sum(first_edit_page_click == flow_start & 
		               !is.na(first_pre_edit_cta_impression), na.rm=T),
		signup = sum(first_edit_page_click == flow_start & 
		                    !is.na(first_pre_edit_cta_impression) & 
		                    !is.na(first_signup_button_click), na.rm=T),
		acc_created = sum(first_edit_page_click == flow_start & 
		                      !is.na(first_pre_edit_cta_impression) & 
		                      !is.na(first_signup_button_click) &
		                      !is.na(first_account_creation_complete), na.rm=T),
		rev_saved = sum(first_edit_page_click == flow_start & 
		                     !is.na(first_pre_edit_cta_impression) & 
		                     !is.na(first_signup_button_click) &
		                     !is.na(first_account_creation_complete) &
		                     revisions_saved > 0, na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n page_edit pre_edit signup acc_created rev_saved
# 1: dewiki   control  38711     11174        0      0           0         0
# 2: dewiki post-edit  34783      9903        0      0           0         0
# 3: dewiki  pre-edit  34441      9575     8884    529         130        93
# 4: enwiki  pre-edit 178741     65950    63900   6142        1933      1250
# 5: enwiki   control 189724     70330        0      0           0         0
# 6: enwiki post-edit 171517     64139        0      0           0         0
# 7: frwiki  pre-edit  28411     10349    10020    821         224       161
# 8: frwiki post-edit  27180      9760        1      0           0         0
# 9: frwiki   control  29962     10716        0      0           0         0
#10: itwiki  pre-edit  19405      5522     5324    362         120        87
#11: itwiki   control  20361      5879        0      0           0         0
#12: itwiki post-edit  18626      5587        0      0           0         0
[edit]
flows[,
	list(
		n = length(token),
		sec_edit = sum(first_edit_section_click == flow_start, na.rm=T),
		pre_edit = sum(first_edit_section_click == flow_start & 
		               !is.na(first_pre_edit_cta_impression), na.rm=T),
		edit_click = sum(first_edit_section_click == flow_start & 
		                  !is.na(first_pre_edit_cta_impression) & 
		                  is.na(first_dismiss_button_click) &
		                  is.na(first_edit_button_click) &
		                  is.na(first_signup_button_click) &
		                  edit_page_clicks + edit_section_clicks > 1 & 
		                  !is.na(first_account_creation_complete), na.rm=T),
		rev_saved = sum(first_edit_section_click == flow_start & 
		                !is.na(first_pre_edit_cta_impression) & 
		                is.na(first_dismiss_button_click) &
		                is.na(first_edit_button_click) &
		                is.na(first_signup_button_click) &
		                edit_page_clicks + edit_section_clicks > 1 & 
		                !is.na(first_account_creation_complete) &
		                revisions_saved > 0, na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n sec_edit pre_edit edit_click rev_saved
# 1: dewiki   control  38711    27537        0          0         0
# 2: dewiki post-edit  34783    24880        0          0         0
# 3: dewiki  pre-edit  34441    24866    23763          1         1
# 4: enwiki  pre-edit 178741   112789   109137         31        21
# 5: enwiki   control 189724   119389        1          0         0
# 6: enwiki post-edit 171517   107376        1          0         0
# 7: frwiki  pre-edit  28411    18063    17526          5         3
# 8: frwiki post-edit  27180    17420        0          0         0
# 9: frwiki   control  29962    19246        0          0         0
#10: itwiki  pre-edit  19405    13883    13454          1         1
#11: itwiki   control  20361    14482        0          0         0
#12: itwiki post-edit  18626    13039        0          0         0


[edit]
flows[,
	list(
		n = length(token),
		page_edit = sum(first_edit_page_click == flow_start, na.rm=T),
		pre_edit = sum(first_edit_page_click == flow_start & 
		               !is.na(first_pre_edit_cta_impression), na.rm=T),
		edit_click = sum(first_edit_page_click == flow_start & 
		                  !is.na(first_pre_edit_cta_impression) & 
		                  is.na(first_dismiss_button_click) &
		                  is.na(first_edit_button_click) &
		                  is.na(first_signup_button_click) &
		                  edit_page_clicks + edit_section_clicks > 1 & 
		                  !is.na(first_account_creation_complete), na.rm=T),
		rev_saved = sum(first_edit_page_click == flow_start & 
		                !is.na(first_pre_edit_cta_impression) & 
		                is.na(first_dismiss_button_click) &
		                is.na(first_edit_button_click) &
		                is.na(first_signup_button_click) &
		                edit_page_clicks + edit_section_clicks > 1 & 
		                !is.na(first_account_creation_complete) &
		                revisions_saved > 0, na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n page_edit pre_edit edit_click rev_saved
# 1: dewiki   control  38711     11174        0          0         0
# 2: dewiki post-edit  34783      9903        0          0         0
# 3: dewiki  pre-edit  34441      9575     8884          8         6
# 4: enwiki  pre-edit 178741     65950    63900         64        49
# 5: enwiki   control 189724     70330        0          0         0
# 6: enwiki post-edit 171517     64139        0          0         0
# 7: frwiki  pre-edit  28411     10349    10020         11         7
# 8: frwiki post-edit  27180      9760        1          0         0
# 9: frwiki   control  29962     10716        0          0         0
#10: itwiki  pre-edit  19405      5522     5324          5         3
#11: itwiki   control  20361      5879        0          0         0
#12: itwiki post-edit  18626      5587        0          0         0

Post-edit

[edit]

section edit --> revision saved --> post edit --> signup button --> account created

[edit]
flows[,
	list(
		n = length(token),
		sec_edit = sum(first_edit_section_click == flow_start, na.rm=T),
		rev_saved = sum(first_edit_section_click == flow_start &
		                     revisions_saved > 0, na.rm=T),
		post_edit = sum(first_edit_section_click == flow_start &
		                revisions_saved > 0 & 
		                !is.na(first_post_edit_cta_impression), na.rm=T),
		signup = sum(first_edit_section_click == flow_start &
		                    revisions_saved > 0 & 
		                    !is.na(first_post_edit_cta_impression) & 
		                    !is.na(first_signup_button_click), na.rm=T),
		acc_created = sum(first_edit_section_click == flow_start &
		                      revisions_saved > 0 & 
		                      !is.na(first_post_edit_cta_impression) &
		                      !is.na(first_signup_button_click) & 
		                      !is.na(first_account_creation_complete), na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n sec_edit rev_saved post_edit signup acc_created
# 1: dewiki   control  38711    27537      3336         0      0           0
# 2: dewiki post-edit  34783    24880      2966      1838     53          22
# 3: dewiki  pre-edit  34441    24866      2169         0      0           0
# 4: enwiki  pre-edit 178741   112789     16635         0      0           0
# 5: enwiki   control 189724   119389     22522         0      0           0
# 6: enwiki post-edit 171517   107376     19642     16377    334         192
# 7: frwiki  pre-edit  28411    18063      2593         0      0           0
# 8: frwiki post-edit  27180    17420      3007      2584     72          50
# 9: frwiki   control  29962    19246      3260         0      0           0
#10: itwiki  pre-edit  19405    13883      2048         0      0           0
#11: itwiki   control  20361    14482      2989         0      0           0
#12: itwiki post-edit  18626    13039      2578      2295     57          31


page edit --> revision saved --> post edit --> signup button --> account created

[edit]
flows[,
	list(
		n = length(token),
		page_edit = sum(first_edit_page_click == flow_start, na.rm=T),
		rev_saved = sum(first_edit_page_click == flow_start &
		                     revisions_saved > 0, na.rm=T),
		post_edit = sum(first_edit_page_click == flow_start &
		                revisions_saved > 0 & 
		                !is.na(first_post_edit_cta_impression), na.rm=T),
		signup = sum(first_edit_page_click == flow_start &
		                    revisions_saved > 0 & 
		                    !is.na(first_post_edit_cta_impression) & 
		                    !is.na(first_signup_button_click), na.rm=T),
		acc_created = sum(first_edit_page_click == flow_start &
		                      revisions_saved > 0 & 
		                      !is.na(first_post_edit_cta_impression) &
		                      !is.na(first_signup_button_click) & 
		                      !is.na(first_account_creation_complete), na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#       wiki    bucket     n page_edit rev_saved post_edit signup acc_created
# 1: dewiki   control  38711     11174      2374         0      0           0
# 2: dewiki post-edit  34783      9903      1930      1158     37          20
# 3: dewiki  pre-edit  34441      9575      1677         0      0           0
# 4: enwiki  pre-edit 178741     65950     14594         0      0           0
# 5: enwiki   control 189724     70330     18089         0      0           0
# 6: enwiki post-edit 171517     64139     15779     12662    309         161
# 7: frwiki  pre-edit  28411     10349      2109         0      0           0
# 8: frwiki post-edit  27180      9760      2210      1839     57          33
# 9: frwiki   control  29962     10716      2341         0      0           0
#10: itwiki  pre-edit  19405      5522      1634         0      0           0
#11: itwiki   control  20361      5879      1984         0      0           0
#12: itwiki post-edit  18626      5587      2042      1782     46          27


section edit --> revision saved --> post edit --> dismiss button --> account created

[edit]
flows[,
	list(
		n = length(token),
		sec_edit = sum(first_edit_section_click == flow_start, na.rm=T),
		rev_saved = sum(first_edit_section_click == flow_start &
		                     revisions_saved > 0, na.rm=T),
		post_edit = sum(first_edit_section_click == flow_start &
		                revisions_saved > 0 & 
		                !is.na(first_post_edit_cta_impression), na.rm=T),
		dismiss = sum(first_edit_section_click == flow_start &
		                    revisions_saved > 0 & 
		                    !is.na(first_post_edit_cta_impression) & 
		                    !is.na(first_dismiss_button_click), na.rm=T),
		acc_created = sum(first_edit_section_click == flow_start &
		                      revisions_saved > 0 & 
		                      !is.na(first_post_edit_cta_impression) &
		                      !is.na(first_dismiss_button_click) & 
		                      !is.na(first_account_creation_complete), na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n sec_edit rev_saved post_edit dismiss acc_created
# 1: dewiki   control  38711    27537      3336         0       0           0
# 2: dewiki post-edit  34783    24880      2966      1838     913           6
# 3: dewiki  pre-edit  34441    24866      2169         0       0           0
# 4: enwiki  pre-edit 178741   112789     16635         0       0           0
# 5: enwiki   control 189724   119389     22522         0       0           0
# 6: enwiki post-edit 171517   107376     19642     16377    8195          80
# 7: frwiki  pre-edit  28411    18063      2593         0       0           0
# 8: frwiki post-edit  27180    17420      3007      2584    1620          10
# 9: frwiki   control  29962    19246      3260         0       0           0
#10: itwiki  pre-edit  19405    13883      2048         0       0           0
#11: itwiki   control  20361    14482      2989         0       0           0
#12: itwiki post-edit  18626    13039      2578      2295    1184           8

page edit --> revision saved --> post edit --> dismiss button --> account created

[edit]
flows[,
	list(
		n = length(token),
		page_edit = sum(first_edit_page_click == flow_start, na.rm=T),
		rev_saved = sum(first_edit_page_click == flow_start &
		                     revisions_saved > 0, na.rm=T),
		post_edit = sum(first_edit_page_click == flow_start &
		                revisions_saved > 0 & 
		                !is.na(first_post_edit_cta_impression), na.rm=T),
		dismiss = sum(first_edit_page_click == flow_start &
		                    revisions_saved > 0 & 
		                    !is.na(first_post_edit_cta_impression) & 
		                    !is.na(first_dismiss_button_click), na.rm=T),
		acc_created = sum(first_edit_page_click == flow_start &
		                      revisions_saved > 0 & 
		                      !is.na(first_post_edit_cta_impression) &
		                      !is.na(first_dismiss_button_click) & 
		                      !is.na(first_account_creation_complete), na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n page_edit rev_saved post_edit dismiss acc_created
# 1: dewiki   control  38711     11174      2374         0       0           0
# 2: dewiki post-edit  34783      9903      1930      1158     791           5
# 3: dewiki  pre-edit  34441      9575      1677         0       0           0
# 4: enwiki  pre-edit 178741     65950     14594         0       0           0
# 5: enwiki   control 189724     70330     18089         0       0           0
# 6: enwiki post-edit 171517     64139     15779     12662    9167         136
# 7: frwiki  pre-edit  28411     10349      2109         0       0           0
# 8: frwiki post-edit  27180      9760      2210      1839    1346          18
# 9: frwiki   control  29962     10716      2341         0       0           0
#10: itwiki  pre-edit  19405      5522      1634         0       0           0
#11: itwiki   control  20361      5879      1984         0       0           0
#12: itwiki post-edit  18626      5587      2042      1782    1230          20


section edit --> revision saved --> post edit --> account creation link --> account created

[edit]
flows[,
	list(
		n = length(token),
		sec_edit = sum(first_edit_section_click == flow_start, na.rm=T),
		rev_saved = sum(first_edit_section_click == flow_start &
		                     revisions_saved > 0, na.rm=T),
		post_edit = sum(first_edit_section_click == flow_start &
		                revisions_saved > 0 & 
		                !is.na(first_post_edit_cta_impression), na.rm=T),
		create_acc = sum(first_edit_section_click == flow_start &
		                    revisions_saved > 0 & 
		                    !is.na(first_post_edit_cta_impression) & 
		                    !is.na(first_create_account_click) &
		                    first_create_account_click > 
		                    first_post_edit_cta_impression, na.rm=T),
		acc_created = sum(first_edit_section_click == flow_start &
		                      revisions_saved > 0 & 
		                      !is.na(first_post_edit_cta_impression) &
		                      !is.na(first_dismiss_button_click) & 
		                      !is.na(first_create_account_click) &
		                      first_create_account_click > 
		                      first_post_edit_cta_impression & 
		                      !is.na(first_account_creation_complete), na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n sec_edit rev_saved post_edit create_acc acc_created
# 1: dewiki   control  38711    27537      3336         0          0           0
# 2: dewiki post-edit  34783    24880      2966      1838         27           5
# 3: dewiki  pre-edit  34441    24866      2169         0          0           0
# 4: enwiki  pre-edit 178741   112789     16635         0          0           0
# 5: enwiki   control 189724   119389     22522         0          0           0
# 6: enwiki post-edit 171517   107376     19642     16377        144          50
# 7: frwiki  pre-edit  28411    18063      2593         0          0           0
# 8: frwiki post-edit  27180    17420      3007      2584         32           6
# 9: frwiki   control  29962    19246      3260         0          0           0
#10: itwiki  pre-edit  19405    13883      2048         0          0           0
#11: itwiki   control  20361    14482      2989         0          0           0
#12: itwiki post-edit  18626    13039      2578      2295         25           5

page edit --> revision saved --> post edit --> account creation link --> account created

[edit]
flows[,
	list(
		n = length(token),
		page_edit = sum(first_edit_page_click == flow_start, na.rm=T),
		rev_saved = sum(first_edit_page_click == flow_start &
		                     revisions_saved > 0, na.rm=T),
		post_edit = sum(first_edit_page_click == flow_start &
		                revisions_saved > 0 & 
		                !is.na(first_post_edit_cta_impression), na.rm=T),
		create_acc = sum(first_edit_page_click == flow_start &
		                    revisions_saved > 0 & 
		                    !is.na(first_post_edit_cta_impression) & 
		                    !is.na(first_create_account_click) &
		                    first_create_account_click > 
		                    first_post_edit_cta_impression, na.rm=T),
		acc_cr = sum(first_edit_page_click == flow_start &
		                      revisions_saved > 0 & 
		                      !is.na(first_post_edit_cta_impression) &
		                      !is.na(first_dismiss_button_click) & 
		                      !is.na(first_create_account_click) &
		                      first_create_account_click > 
		                      first_post_edit_cta_impression & 
		                      !is.na(first_account_creation_complete), na.rm=T)
	),
	list(
		wiki, bucket
	)
]
#      wiki    bucket      n page_edit rev_saved post_edit create_acc acc_cr
# 1: dewiki   control  38711     11174      2374         0          0      0
# 2: dewiki post-edit  34783      9903      1930      1158         14      2
# 3: dewiki  pre-edit  34441      9575      1677         0          0      0
# 4: enwiki  pre-edit 178741     65950     14594         0          0      0
# 5: enwiki   control 189724     70330     18089         0          0      0
# 6: enwiki post-edit 171517     64139     15779     12662        160     61
# 7: frwiki  pre-edit  28411     10349      2109         0          0      0
# 8: frwiki post-edit  27180      9760      2210      1839         18     10
# 9: frwiki   control  29962     10716      2341         0          0      0
#10: itwiki  pre-edit  19405      5522      1634         0          0      0
#11: itwiki   control  20361      5879      1984         0          0      0
#12: itwiki post-edit  18626      5587      2042      1782         27      9