Page MenuHomePhabricator

Use `x_analytics` `ismobile` instead of url `.m` subdomain for webrequest mobile-web `access_method`
Closed, ResolvedPublic

Description

Currently the webrequest access_method field is using the URL .m subdomain to flag traffic from mobile web.
We need to change this to use the new x_analytics subfield: ismobile.

Details

Related Changes in Gerrit:
Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
Update webrequest jarrepos/data-engineering/airflow-dags!1621joalupdate_webrequest_jarmain
Customize query in GitLab

Event Timeline

JAllemandou triaged this task as High priority.

Change #1178532 had a related patch set uploaded (by Joal; author: Joal):

[analytics/refinery@master] Update webrequest access_method computation

https://gerrit.wikimedia.org/r/1178532

Change #1178595 had a related patch set uploaded (by Joal; author: Joal):

[analytics/refinery/source@master] Remove webrequest access_method UDF and core code

https://gerrit.wikimedia.org/r/1178595

Change #1178595 merged by jenkins-bot:

[analytics/refinery/source@master] Remove webrequest access_method UDF and core code

https://gerrit.wikimedia.org/r/1178595

Change #1178532 merged by Joal:

[analytics/refinery@master] Update webrequest access_method computation

https://gerrit.wikimedia.org/r/1178532

@JAllemandou It looks like the new logic is live for webrequest and pageview datasets, is that right?

In the coming week, we'll rollout to test.wikipedia.org (T401595).

It is fine for testwiki if it isn't live yet, and we will of course wait for this and T401666 to resolve before the next phase of rollouts. I am asking so that, if it happens to be live already, I can do some testing in the hour after the switch on pageview stats. Otherwise I will do that at another time.

@JAllemandou It looks like the new logic is live for webrequest and pageview datasets, is that right?

Absolutely!

In the coming week, we'll rollout to test.wikipedia.org (T401595).
It is fine for testwiki if it isn't live yet, and we will of course wait for this and T401666 to resolve before the next phase of rollouts. I am asking so that, if it happens to be live already, I can do some testing in the hour after the switch on pageview stats. Otherwise I will do that at another time.

This should ne problem for webrequest/pageview, but will impact unique-devices. As long as @maya, @nshahquinn-wmf and @Hghani are ok, I'm ok :)

Thanks @JAllemandou. I checked pageviews for wikitech.wikimedia.org. This makes for a great test case, because it has no mobile subdomain and thus has no existing "mobile web" pageviews (details about why, at T190384#11153446). Any such pageviews counted now, must be from the unified mobile routing:

Following the 5 Sep rollout, it now has mobile pageviews! https://w.wiki/FH7E

Screenshot 2025-09-08 at 16.01.11.png (1,594×1,527 px, 161 KB)

I also checked test.wikipedia.org and mediawiki.org, but those are harder to get a strong signal from, because we're expecting "no change" and they're fairly small wikis with a lot of fluctuation.Plus, they still receive explicit traffic to m-dot URL as well, so we can't attribute it fully to unified mobile routing.

In the coming week, we'll rollout to test.wikipedia.org (T401595).
It is fine for testwiki if it isn't live yet, and we will of course wait for this and T401666 to resolve before the next phase of rollouts. I am asking so that, if it happens to be live already, I can do some testing in the hour after the switch on pageview stats. Otherwise I will do that at another time.

This should ne problem for webrequest/pageview, but will impact unique-devices. As long as @maya, @nshahquinn-wmf and @Hghani are ok, I'm ok :)

Hey @JAllemandou I believe the impact of this is to unique devices domain table and we are discussing in T401666. im not sure if you needed something specific from us in this task.

Hey @JAllemandou I believe the impact of this is to unique devices domain table and we are discussing in T401666. im not sure if you needed something specific from us in this task.

My question was about starting the rollout for testwiki, for which we will see an impact on unique-devices.
The change have been rooled out, nothing more needed :) Thanks @Mayakp.wiki