Manuel edited projects, added Wikidata Analytics; removed Wikidata Analytics
(Kanban).
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Manuel
Cc: JAllemandou, AndrewTavis_WMDE, Michael, Manuel,
Manuel claimed this task.
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Manuel
Cc: JAllemandou, AndrewTavis_WMDE, Michael, Manuel, Aklapper,
Danny_Benjafield_WMDE, Astuthiodit_1, karapayneWMDE,
Manuel updated the task description.
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: AndrewTavis_WMDE, Manuel
Cc: JAllemandou, AndrewTavis_WMDE, Michael, Manuel, Aklapper,
Danny_Benjafield_WMDE,
AndrewTavis_WMDE added a comment.
Your suggestion make more sense now, @Michael :) If we're looking for
pageviews by users, then we can make the assumption that we don't want
`api.php` and `load.php` for `uri_path` as views should come from another page.
When considering traffic and
Michael added a comment.
> in following @Michael's suggestion for looking into all paths that end in
api.php and load.php we're getting the following:
> [...]
> Ultimately neither number went in the right direction as far as `-` as a
referrer, so that really looks like it's not a
AndrewTavis_WMDE added a comment.
@Manuel, in following @Michael's suggestion for looking into all paths that
end in `api.php` and `load.php` we're getting the following:
URI Path ends in API or load
**Population is**:
All requests from
AndrewTavis_WMDE updated the task description.
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: AndrewTavis_WMDE
Cc: JAllemandou, AndrewTavis_WMDE, Michael, Manuel, Aklapper,
AndrewTavis_WMDE added a comment.
Summarizing the above, @Manuel:
- We're generally able to get a good understanding of mobile users via
looking at `user_agent_map.os_family = 'Android'`, `'iOS'` or `'KaiOS'`
- If we don't have `user_agent_map` as a column, we can create it with a
Manuel updated the task description.
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: AndrewTavis_WMDE, Manuel
Cc: JAllemandou, AndrewTavis_WMDE, Michael, Manuel, Aklapper,
Danny_Benjafield_WMDE,
Manuel updated the task description.
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: AndrewTavis_WMDE, Manuel
Cc: JAllemandou, AndrewTavis_WMDE, Michael, Manuel, Aklapper,
Danny_Benjafield_WMDE,
AndrewTavis_WMDE added a comment.
@Manuel, as mentioned on Mattermost there as of now doesn't seem to be a good
way of deriving `agent_type` for those tables that don't have it. We can get
`spider` through a `UDF`, but `automated` isn't possible at the moment. This
makes the final division
AndrewTavis_WMDE added a comment.
Some general notes on this: as we're working from `wmf.pageview_actor` and
`wmf_raw.mediawiki_private_cu_changes`, there might be a way to leverage their
expanded `agent_type` field such that for at least the former we have
`automated` as an option within
AndrewTavis_WMDE added a comment.
Here's the above `referer` breakdown for mobile for reference, with the big
difference being that we have dramatically less `-` requests - good for
thinking that these are APIs - and have a lot of extension requests:
| referer
AndrewTavis_WMDE added a comment.
@Manuel, re the question of what kind of `referer` values we have for
"desktop" requests, the following query was used to get the results below.
**Population for the following is**:
All requests from `www.wikidata.org` and `m.wikidata.org`
AndrewTavis_WMDE updated the task description.
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: AndrewTavis_WMDE
Cc: JAllemandou, AndrewTavis_WMDE, Michael, Manuel, Aklapper,
AndrewTavis_WMDE updated the task description.
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: AndrewTavis_WMDE
Cc: JAllemandou, AndrewTavis_WMDE, Michael, Manuel, Aklapper,
JAllemandou added a comment.
> However, my assumption is that when only filtering for agent_type !=
'spider' the population will still include a lot of non-UI hits.
The `agent_type` field currently can take 3 values: `spider`, `automated` and
`user`. The `spider` one is used when
Manuel renamed this task from "[Analytics] Identify access via mobile devices "
to "[Analytics] Identify access from mobile vs. desktop devices".
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To:
18 matches
Mail list logo
