Page MenuHomePhabricator

Rerun baseline for PP3.4 by the end of Q1FY27
Open, Needs TriagePublic

Description

In Q4FY26, we defined a temporary baseline for PP3.4 based on old pageview data.
Once T428550 is finalized, we will have to wait for a few months for data to populate. Towards mid-to-late-Q1, the baseline will need to be update it based on the newly collected data.

Event Timeline

Now that we're updating the bot detection model in the data platform, you should be able to run a query like:

select agent_type, count(*) as freq
from wmf_traffic.webrequest_v2 where dt >= make_timestamp(2026, 7, 2, 0, 0, 0) and dt < make_timestamp(2026, 7, 2, 1, 0, 0) and target.uri_host like "%developer.wikimedia.org%"
group by agent_type;

to get human pageviews for developer.wikimedia.org. Naturally you'll probably want to filter this down to specific URLs etc, which I think Halley will be able to inform.

I'm marking this as blocked by T425666 which tracks the actual introduction of the new model and webrequest_v2. Note that even though the ticket refers to a numerical bot score, we recommend querying for agent_type = "human" instead of using the numerical score directly.

Now that we're updating the bot detection model in the data platform, you should be able to run a query like:

select agent_type, count(*) as freq
from wmf_traffic.webrequest_v2 where dt >= make_timestamp(2026, 7, 2, 0, 0, 0) and dt < make_timestamp(2026, 7, 2, 1, 0, 0) and target.uri_host like "%developer.wikimedia.org%"
group by agent_type;

to get human pageviews for developer.wikimedia.org. Naturally you'll probably want to filter this down to specific URLs etc, which I think Halley will be able to inform.

Thanks @GGoncalves-WMF - I can build on this one to calculate the baseline.

Ottomata closed subtask Restricted Task as Resolved.Aug 3 2026, 5:10 PM