Enable "Sub-Saharan Africa editors by user agent" superset dashboard to update itself automatically
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• ppelberg
	Sep 15 2022, 12:39 AM

Description

In T314202, we created the Sub-Saharan Africa Editors by User Agent superset dashboard.

This task involves the work with making it so said dashboard can update itself automatically. Note: This can be done by changing the dataset to use EditAttemptStep, which now includes geo location data and can queried directly from Superset.

Requirements

The data within the SSA Edits by OS and Browser Superset dashboard is automatically updated in real-time

NOTE: the other two tabs within this dashboard – SSA Editors by Project and Country and All Editors by Project and Location – update mothly.

Open questions

1. How frequently can/should the dashboard be automatically updated?
- Dashboard will update automatically in real-time

Done

Answers to all Open questions are documented
Requirements are implemented

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T265163 Create a system to encode best practices into editing experiences
		Resolved		• ppelberg	T317825 Enable "Sub-Saharan Africa editors by user agent" superset dashboard to update itself automatically

Event Timeline

• ppelberg created this task.Sep 15 2022, 12:39 AM

• ppelberg moved this task from Backlog to Analytics on the Editing-team (Tracking) board.

• ppelberg mentioned this in T314202: [SPIKE] What devices, browsers, OSes, etc. are volunteers from Sub-Saharan Africa using to edit Wikipedia.

MNeisler triaged this task as Medium priority.Sep 15 2022, 6:51 PM

MNeisler moved this task from Triage to Upcoming Quarter on the Product-Analytics board.

MNeisler claimed this task.Sep 15 2022, 8:13 PM

Resolving T314178, would make it so the data within Superset would update itself automatically making this ticket obsolete.

MNeisler moved this task from Upcoming Quarter to Current Quarter on the Product-Analytics board.Oct 12 2022, 6:33 PM

• ppelberg added a parent task: T265163: Create a system to encode best practices into editing experiences.Nov 30 2022, 7:48 PM

• ppelberg updated the task description. (Show Details)Nov 30 2022, 9:49 PM

MNeisler edited projects, added Product-Analytics (Kanban); removed Product-Analytics.Dec 1 2022, 3:09 PM

MNeisler updated the task description. (Show Details)Dec 16 2022, 6:17 PM

VPuffetMichel added a project: EditCheck.Jan 18 2023, 3:59 PM

MNeisler moved this task from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.Feb 22 2023, 1:33 AM

@ppelberg

I've updated the "Sub-Saharan Africa Editors by user agent" dashboard so it now updates automatically to show the latest user agent data on edits from SSA. Instead of a snapshot of data, the dashboard is now set to automatically query data from EditAttempStept. By using EditAttemptStep, we also have access to the Platform field so I added a platform filter to view the data by desktop or phone.

Load Time
Note: This will result in longer load times. It may take up between 1 to 2 minutes for the dashboard to update. If this longer load time causes frequent timeouts, we may need to reopen this task to create a smaller subset of aggregate data and ETL job to automate the update. I've set the default time range to the last 7 days to help minimize load time. This time range can be extended with the provided filters but may cause timeouts if too long of a time range is selected.

Let me know if you have any questions or suggested updates.

• ppelberg edited projects, added Editing-team (Kanban Board); removed Editing-team (Tracking).Mar 1 2023, 9:17 PM

• ppelberg moved this task from Incoming to Ready for Sign Off on the Editing-team (Kanban Board) board.

• ppelberg closed this task as Resolved.Mar 4 2023, 12:32 AM

Enable "Sub-Saharan Africa editors by user agent" superset dashboard to update itself automatically Closed, ResolvedPublicActions