Plan-level reporting for SaaS Usage Ping
Related to Finalize SQL Query for Billable Member to create data model in GitLab.com Production Data Warehouse
Problem
Currently, we cannot break out Usage Ping on SaaS by free/paid plans as Usage Ping is reported at the instance level. To get these metrics, the data team is recreating our usage ping queries in Sisense which is a lot of extra manual work.
The goal of this issue is to report Usage Ping metrics scoped by Free, Bronze, Silver, and Gold plans. This means we'll be running Usage Ping on GitLab.com up to five times to report on the instance level usage and 4x for plan-level usage.
In the related issue https://gitlab.com/gitlab-data/analytics/-/issues/5791, the data team will be exploring the SQL query for joining a user to a plan type.
Proposal
Result
Next steps (if any)
-
Script to generate Usage Ping SQL in JSON -
For each metric add group-scope (table.project_id, table.namespace_id), generate queries to go to plan. -
In Event Dictionary, each metric will have a group-scope listed (i.e. epics.namespace_id). Auto-generate and have PMs sign off.
Old next steps
-
Understand SQL query to use data team -
Make any necessary changes to our database models -
Add logic to Usage Ping to scope by plan type -
Run Usage Ping to loop through each plan type
Edited by Alper Akgun