• The number of anonymous users who attempt to edit on ptwiki

Summary:

• The number of daily edit attempts by anonymous editors is 760 in average at 6.25% sample rate.
• The total number of daily edit attempts by anonymous editors is estimated to be 12160 daily.
• The number of unique event.editing_session_id is mostly same as the number of events. It seems the event.editing_session_id is issued for each editing attempt.

Query

select concat(year,'-', LPAD(month,2,'0'),'-', LPAD(day,2,'0')) as dt, 
event.is_oversample,
count(DISTINCT event.editing_session_id) AS num_sessions, count(1) AS num_events
FROM event.editattemptstep
WHERE year=2022 and month= 10 
AND wiki='ptwiki'
--anonymous users
AND event.user_id =0
AND event.action = 'init'
--edit attempts on page edit
AND event.init_type = 'page' 
GROUP BY concat(year,'-', LPAD(month,2,'0'),'-', LPAD(day,2,'0')) , event.is_oversample
ORDER BY dt
LIMIT 10000

• Estimate session_id per users ratio for logged-in users

Based on the data between 2022-10-01 and 2022-10-25, 1 unique logged in editor has 3.8 sessions (unique event.editing_session_id) in average

Query

select 
count(DISTINCT event.editing_session_id) AS num_sessions,  
count(DISTINCT event.user_id) AS num_editors, count(1) AS num_events
FROM event.editattemptstep
WHERE year=2022 and month= 10 
AND wiki='ptwiki'
--loggedin users
AND event.user_id!=0
AND event.action = 'init'
--edit attemps on page edit
AND event.init_type = 'page'

• How many account creations from the editing context?

Summary:

• In average, 10 account creations are from editing context daily.
• @Niharika, do you know whether users on ptwiki will return to the original editing page after they create an account? If yes, the rate of account creations/edit attempts is estimated to be 0.082%.

Query

SELECT concat(year,'-', LPAD(month,2,'0'),'-', LPAD(day,2,'0')) as dt, 
event.displayMobile,
COUNT(1) AS accounts
FROM event.ServerSideAccountCreation 
WHERE year =2022 and month=10 
AND wiki='ptwiki'
AND event.returnToQuery REGEXP "action=v?edit"
AND event.isApi = FALSE
AND event.returnTo IS NOT NULL
GROUP BY concat(year,'-', LPAD(month,2,'0'),'-', LPAD(day,2,'0')), event.displayMobile
ORDER BY dt
LIMIT 1000

@Longvape @Niharika, It seems we have a good number of daily traffic from anonymous users who attempted to edit on ptwiki.
Although, some essential info to determine the total sample size are still unknown , like the baseline of the account creation rate, the standard deviation, the lift ( increase of the account creation rate) we expected to see, we confirmed there are a lot of potential users of IPBEE to sample.

@STran ping.