Investigate ways to report out on currently available campaign-events data.
The campaigns engineers are working on priority engineering items and may not be able to begin data instrumentation and pipelining on T320289 in Q3. Nonetheless, the team needs data for base monitoring and reporting.
Note: the solution is unlikely to be an automated solution; it will focus on simplicity.
[[ https://lucid.app/lucidchart/339e3673-2aed-4290-ba3c-dee90331d0f5/edit?invitationId=inv_8976e5e2-607f-4725-aafb-c9e0b22a6c9d&page=0_0# | Schema ]]
[[ https://www.mediawiki.org/wiki/Extension:CampaignEvents/Api | REST API documentation ]]
[[ https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CampaignEvents/+/refs/heads/master/db_patches/tables.json | Gerrit JSON file ]]
[[ https://www.mediawiki.org/wiki/Extension:CampaignEvents/campaign_events_table | Extension:CampaignEvents/campaign_events_table ]] (linked in the infobox in [[ https://www.mediawiki.org/wiki/Extension:CampaignEvents | Extension:CampaignEvents ]])
https://www.mediawiki.org/wiki/Extension_default_namespaces
[] query campaigns-event data on wikishared
[] query the [[ https://datahub.wikimedia.org/dataset/urn:li:dataset:(urn:li:dataPlatform:hive,wmf_product.editor_month,PROD)/Schema?is_lineage_mode=false&schemaFilter= | editor_month table ]]
[] query [[ https://meta.wikimedia.org/wiki/Schema:ServerSideAccountCreation | SSAC ]] for new event editors
[x] sync with Lauren/Claudio/Valerie to discuss contents and potential tooling
[] sync with Lauren/Claudio/Valerie to see if solutions suffice for the interim -- demo reporting outputs
[x] discuss a reporting frequency - monthly
[] discuss potential solutions with PA team given options and tradeoffs
[] adapt setup given input
[] adapt for all wikis, adapt for templating on time each month
[] sync with Gregory -- demo reporting outputs
[] adapt setup given input