it doesn’t strike me as a great idea to write non-EL data into the log DB. Can we host these tables into prod or staging instead? You’ll be able to perform UNIONS with tables in log.
I think the plan is to change this EL instance to log the event "this user has now made X edits within their first 30 days", where X is in {1, 5, 10, 25, 50, 100}. That will start happening when this patch: https://gerrit.wikimedia.org/r/#/c/98079/1/WikimediaEvents.php is merged. So my idea is to backfill these milestone events so new the query can just be:
select month, count(*) from EL_table where event = 'NewEditorMilestone' and milestone = 5 group by month