The list of metrics has been finalized in T371981

Likely two queries will be needed, each for

daily activity tracking

• It can be iterated based on automod_reverts_info.sql)
  • Need to ensure rollbacks are covered properly
• Data source: MariaDB replicas
• Frequency: Daily
• Keep it as part of moderation-mariadb-jobs job repo.
  • Some of the processing steps such as Automoderator name for wiki etc. have to be included

revert/vandalism proportion handled by Automoderator

• This can be done daily as well, but it is better if wmf.mediawiki_history is considered as source rather than the replicas.
• Frequency: monthly