[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2024-01-29 Thread Manuel
Manuel removed a project: Wikidata Analytics (Kanban). TASK DETAIL https://phabricator.wikimedia.org/T344052 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Manuel Cc: AndrewTavis_WMDE, Aklapper, Manuel, Danny_Benjafield_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2024-01-29 Thread Manuel
Manuel claimed this task. TASK DETAIL https://phabricator.wikimedia.org/T344052 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Manuel Cc: AndrewTavis_WMDE, Aklapper, Manuel, Danny_Benjafield_WMDE, Astuthiodit_1, karapayneWMDE, Invadibot,

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2023-10-10 Thread AndrewTavis_WMDE
AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T344052 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: AndrewTavis_WMDE, Aklapper, Manuel, Danny_Benjafield_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2023-10-10 Thread AndrewTavis_WMDE
AndrewTavis_WMDE added a comment. @Manuel, as the plan is to start working on a canonical edits data table that will fit our needs with WMF, do you envision tracking that in this task, or would it make sense to make a new one for that that we can then include all the stakeholders we'd be

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2023-10-09 Thread AndrewTavis_WMDE
AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T344052 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: AndrewTavis_WMDE, Aklapper, Manuel, Danny_Benjafield_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2023-10-09 Thread AndrewTavis_WMDE
AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T344052 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: AndrewTavis_WMDE, Aklapper, Manuel, Danny_Benjafield_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2023-10-09 Thread AndrewTavis_WMDE
AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T344052 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: AndrewTavis_WMDE, Aklapper, Manuel, Danny_Benjafield_WMDE, Astuthiodit_1,

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2023-10-06 Thread AndrewTavis_WMDE
AndrewTavis_WMDE claimed this task. AndrewTavis_WMDE updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T344052 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: AndrewTavis_WMDE, Aklapper, Manuel,

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2023-09-20 Thread AndrewTavis_WMDE
AndrewTavis_WMDE added a comment. > Also you are explicitly filering for `is_pageview = True` Just a quick note on this, @Manuel: I was told by WMF that for `wmf.pageview_actor` we still need to do a filter for `WHERE is_pageview = True` as the filtering that makes this table is

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2023-09-01 Thread Manuel
Manuel added a comment. > pageview_actor It seems that `pageview_actor` may not be a suitable candidate after all. Pageviews seem to exclude edits: https://meta.wikimedia.org/wiki/Research:Page_view#Are_edits_considered_pageviews? Also you are explicitly filering for

[Wikidata-bugs] [Maniphest] T344052: [Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision)

2023-09-01 Thread Manuel
Manuel renamed this task from "[Analytics] Join data from all-access-tables (like webrequest) with edit-tables (that e.g. include oldids and users) " to "[Analytics] Join data from all-access-tables (like webrequest) with edit-tables (like revision) ". Manuel updated the task description. TASK