ETL pipeline to calculate potential vandalism handed by Automoderator
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	KCVelaga_WMF
	Oct 4 2024, 9:42 AM

Description

Percentage of potential vandalism handled

Data source: wmf.mediawiki_history
Processing: HQL queries and Airflow DAG
Output:
- wmf_product.automoderator_revert_proportion_monthly
- https://analytics.wikimedia.org/published/datasets
Frequency: monthly

Related Changes in GitLab:

	Title	Reference	Author	Source Branch	Dest Branch
	Potential vandalism reverted toolforge jobs	repos/product-analytics/automoderator-toolforge-jobs!2	kcvelaga	vandal-reverted	main

		Status	Subtype	Assigned	Task
		Resolved		KCVelaga_WMF	T369488 Develop a unified Automoderator Activity Dashboard (v1)
		Resolved		KCVelaga_WMF	T376456 ETL pipeline to calculate potential vandalism handed by Automoderator

Queries for potential vandalism reverted by Automoderator

KCVelaga_WMF changed the task status from Open to In Progress.Oct 7 2024, 7:50 AM

KCVelaga_WMF triaged this task as High priority.

Draft: Automoderator potential vandalism reverted DAG

Queries for potential vandalism reverted by Automoderator

Automoderator potential vandalism reverted DAG

Mentioned in SAL (#wikimedia-operations) [2024-10-11T16:10:30Z] <kcvelaga@deploy2002> Started deploy [airflow-dags/analytics_product@1fb69c4]: T376456

Mentioned in SAL (#wikimedia-operations) [2024-10-11T16:11:34Z] <kcvelaga@deploy2002> Finished deploy [airflow-dags/analytics_product@1fb69c4]: T376456 (duration: 01m 15s)