Queries & HQL files can be found on GitLab
Baseline data at: Campaign Metrics GSheets
Table Name: campaign_product_event_registration_activity_daily
schema:
`day_date` date COMMENT 'The day for which the metric is computed over.', `n_participants_registered` int COMMENT 'Number of distinct participants registered in a day.', `n_new_events` int COMMENT 'Number of new events registered in a day.', `n_new_participants_registered` int COMMENT 'Number distinct participants registered in a day who created an account in the last 30 days.',
Table Name: campaign_product_event_registration_people_monthly
schema:
`month` int COMMENT 'The month for which the metric is computed over.', `year` int COMMENT 'year for month over which the metric is computer over', `n_organizers` int COMMENT 'Number of distinct organizers organizing new events created in month..', `n_participants_registered` int COMMENT 'Number of distinct participants registered in a month.',
How Related Are the Metrics? Because they are frequently analyzed together and form a logical grouping, a single table makes more sense. And, at the current scale, performance and scalability are not concerns.
Notes: