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
[x] query campaigns-event data on wikishared
[x] 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 ]]
[x] sync with Lauren/ @cmelo / 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
[x] assess best table to use for gathering global id, global username, and registration information (date, auto created, api created); [[ https://docs.google.com/document/d/1tmBpfj4XmaZMdhSYIMpUwm-rnSaxI_oVFxk_gpF_27g/edit | reference chart ]] created and double checked with MWW
[] discuss potential solutions with PA team given options and tradeoffs POSTPONED
[] 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
-- query [[ https://meta.wikimedia.org/wiki/Schema:ServerSideAccountCreation | SSAC ]] for new event editors > postponed while we define new campaign editors T329382
see also T322751