The initial analysis of blocked edit attempts rate by wiki shows some mismatch. Post the info here for discussion and investigation.
The edit attempts block rate is defined as:
the number blocked edit attempts / estimated total edit attempts = the number blocked edit attempts / (the number of sampled edit attempts / sample rate)

@Tchanders, after exploration, Ipblocks_table is the schema that could be used to identify soft block and hard block. But some definitions in the documentation is not clear. For example,

Should we instrument this?

Report to community is published at
https://meta.wikimedia.org/wiki/IP_Editing:_Privacy_Enhancement_and_Abuse_Mitigation/IP_Editing_Restriction_Study/Farsi_Wikipedia.

The report is reviewed with product leads and published at https://www.mediawiki.org/wiki/Product_Analytics/Data_Products/ptwiki_metrics_summary_Jun2022.

Report is published at https://www.mediawiki.org/wiki/Product_Analytics/Data_Products/fawiki_metrics_summary .

Have created below tickets to track the next step analyses.

1. Explore measurement of hard blocks and soft blocks. T322679
2. Analyze blocked account creations. T322680
3. Analyze blocked edit attempts. T322682

After reviewed the question list, we identified the questions that we already have or could have data answers. The other questions are great questions. But we don't have quantitative data to answer them yet,

What we already have

that following questions already had data available on existing dashboards or analysis reports.

Have completed the exploration analysis for traffic. Feel free to reopen if we have more questions about it.

We did some initial analysis of WMF pageview metric on Hebrew Wikisource.
Pageviews referred by Google search engine counts for more than 90% pageviews from external search engine. [1]
However, we did not see pageviews referred by external search engine dropped as "Page Experience" Score dropped. [2] [3]

I have created a list of events that need to be tracked to calculate each metric, please find them in Col B in Instrumentation spec.

@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.

• 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%.

• 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.

@Fuzzy, we need to know the timeline of the campaign on Hebrew Wikisource for analysis. That's the reason I am looking for the source of the statement. Do you know the timeline?

Hebrew Wikisource is not in the campaign list in https://meta.wikimedia.org/wiki/CentralNotice/Calendar. Please clarify the source of below statement.

The query in T317715#8281408 might be outdated ( worked in 2021-08). Should we use vector-2022 as the event.skin keyword now?

@Jdlrobson , thanks for pinging me.

Data is ready in spreadsheet:

@ovasileva , marked it as resolved. Feel free to reopen if you have any followup questions.

@ovasileva , mark it as resolved. Feel free to reopen if you have any followup questions.

All tasks are done. Data is presented in report

@ovasileva, here is the summary of vector-2022 optout rate on pilot wikis. Let me know if you have any questions.

we've been running some banners over the past week. Could you repeat the query to see if these have had any effect on the results?

@Niharika, please review the draft of analytics report. Let me know if you have any questions.

I summarized the data about opt-in/opt-out in below table. Please review and confirm whether the notes are correct.
If I understand our discussion correctly, accept_disclaimer is equivalent to enable_ipinfo in current instrumentation. But the add-up does not match, given 523+2221= 2744 > 2225. Do you know what possibly causes the difference?