To investigate and potentially backfill pageviews and unique devices spike starting in Nov 2025 we need to extend the webrequest data retention time to 180 days.
This involves wmf.webrequest, 3 webequest_actor and wmf.pageview_actor tables.
The investigation steps are tracked here:
https://phabricator.wikimedia.org/T416933
Legal approval has been provided.
| Subject | Author | Repo | Branch | Lines +/- | |
|---|---|---|---|---|---|
| Extend webrequest and other data retention | Joal | operations/puppet | production | +11 -5 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | JAllemandou | T418162 Feb 2026, Extend webrequest retention time to 180 days | |||
| Open | JAllemandou | T431968 Revert webrequest retention time back to 90 days |
Change #1243205 had a related patch set uploaded (by Joal; author: Joal):
[operations/puppet@production] Extend webrequest and other data retention
Change #1243205 merged by Btullis:
[operations/puppet@production] Extend webrequest and other data retention
Mentioned in SAL (#wikimedia-analytics) [2026-02-24T20:27:58Z] <btullis> increase webrequest retention from 90 to 180 days with https://gerrit.wikimedia.org/r/c/operations/puppet/+/1243205 for T418162