Account Creation Improvement Project/Results

Welcome

Discuss

Participate

Research

Assumptions

Testing

Results

Contact

Resources

You can get involved: Spread the word by signing up and getting your community involved. Help build new messages for the account creation process by clicking here. Discuss the open questions Participate in the discussion on the project's talk page Use the Toolserver if you have an account and analyse the existing data. The results in the Account Creation Improvement Project were collected in a rather lengthy report. Here are the highlights: the surveys showed us that people wanted to be "a part of Wikipedia" here are some of the "before" results on various language versions below are the results from the first low-quality tests that we ran from February 23-March 30 the high-quality tests that we ran, showed a very clear "win" for the "ACP1" version of account creation (visible at http://en.wikipedia.org/w/index.php?title=Special:UserLogin&action=submitlogin&type=signup&campaign=ACP1 until the CustomUserSignup extension was removed from en wiki in August 2012). when using that version of the account creation process, we can increase the number of newcomers who make 1 edit with 15% on an average day that version of the account creation process also increases the number of newcomers who make 5 edits with about 1%. These figures may seem very abstract, but by increasing the inflow of new Wikipedians who make 5 edits from 6.12% to 7.02 on an average day, we gain 9 persons per day! From 59.90 (with the present model) to 68.90 persons (with ACP1). English Wikipedia Day Number of new user accounts New accounts with at least one edit on the day of account creation Percentage Accounts with at least five edits February 1 7,132 1,997 28% 2 6,980 1,990 29% 3 6,922 1,949 28% 4 6,894 1,991 29% 5 6,035 1,703 28% 6 6,410 1,761 27% 7 7,122 1,969 28% 8 6,855 1,825 27% 9 7,283 2,099 29% 10 6,804 2,020 30% 11 6,638 1,865 28% 12 5,926 1,599 27% 13 6,348 1,754 28% 14 6,963 1,983 28% 15 7,732 2,086 27% 16 7,380 2,114 29% 17 7,180 2,177 30% 18 6,561 1,914 29% 19 5,906 1,712 29% 20 6,068 1,681 28% 21 7,112 2,057 29% 22 7,201 2,064 29% 23 7,341 2,151 33% 24 7,099 2,063 29% 25 6,574 2,328 35% 26 5,938 1,614 27% 27 6,197 1,710 27% 28 7,279 2,192 30% March 01 7,266 2,364 32% 02 7,267 2,433 33% 03 7,028 2,210 31% 04 6,474 2,051 32% 05 5,627 1,722 30% 06 5,961 1,823 31% 07 7,025 2,115 30% 08 6,935 2,447 35% 09 7,118 2,264 32% 10 6,956 2,281 33% 11 6,080 1,917 32% 12 5,354 1,501 28% 13 5,979 1,663 28% 14 6,798 2,035 30% 15 6,803 2,074 30% 16 7,151 2,183 31% 17 6,729 1,992 30% 18 6,066 1,879 31% 19 5,621 1,616 29% 20 5,998 1,788 30% 21 6,883 2,067 30% 22 6,939 2,124 31% 23 7,099 2,118 30% 24 6,697 2,124 32% 25 6,010 1,852 31% 26 5,734 1,719 30% 27 6042 1756 29% 28 7121 2161 30% 29 6951 2163 31% 30 [1] 6821 2064 30% 31 7056 2095 April 1 6448 1978 31% 2 5595 1533 27% 3 5877 1522 26% 4 7162 2082 29% 5 7078 2094 30% 6 7258 2137 29% 7 6993 2073 30% 8 6182 1828 30% 9 5353 1438 27% 10 5859 1535 26% 11 6808 1988 29% 12 7290 2101 29% 13 7102 1979 28% 14 6844 2035 30% 15 6293 1765 28% 16 5560 1481 27% 17 5573 1516 27% 18 6961 1999 29% 19 6904 1982 29% 20 6171 1722 28% 21 6511 1909 29% 22 6128 1726 28% 23 5471 1553 28% 24 5487 25 6743 26 7310 27 6987 28 6849 29 6236 30 5512 May 1 5804 2 6918 3 6676 4 6856 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Step-by-step guide: how to extract the data Step 1: Log in to the toolserver. Step 2: Use the command "sql enwiki_p" to start extracting the data for the English Wikipedia. Step 3: Run SQL queries: How many user accounts have been created per day in February? (list by day ascending) SELECT DAY(user_registration) AS day, count(user_id) FROM user WHERE user_registration IS NOT NULL AND user_registration>"20110200000000" AND user_registration<"20110300000000" GROUP BY day; How many of the new users have made at least one edit on the day of account creation? SELECT COUNT(*) FROM (select DISTINCT user.user_id from user left JOIN user_daily_contribs ON user.user_id=user_daily_contribs.user_id where user_registration IS NOT NULL AND user_registration>"20110222000000" AND user_registration<"20110223000000" AND day>="2011-02-22" AND day<"2011-02-23") as dummy; Note: This gives the number of new users who started editing on the day of account creation. In order to get the data for the next day, the ciphers in bold have to be adjusted. Notes