Deprecated Event Used in Monitor SaaS xMAU data
Problem
@kbychu noticed some stagnancy in GMAU growth for Monitor and no data for SaaS when looking at the Paid SMAU metric. Upon investigating the usage ping data, we discovered that there are different events that are being used for xMAU metrics for Self-Managed vs SaaS.
For Self-Managed, the metric that is being counted towards xMAU is the incident_management_alerts_total_unique_counts
while in SaaS the event that is being used to count towards xMAU is projects_prometheus_active
- from the metric dictionary it looks like this metric was deprecated and removed for Self-Managed but was not removed from SaaS.
Code used to identify SaaS Events
Click to expand
SELECT
DISTINCT
event_name,
stage_name,
is_representative_of_stage
FROM legacy.gitlab_dotcom_daily_usage_data_events
WHERE stage_name = 'monitor';
Code used to identify Self-Managed Metrics Path
Click to expand
SELECT
DISTINCT
metrics_path,
stage_name
FROM common_mart_product.mart_monthly_service_ping_product_usage
WHERE is_smau = TRUE
GROUP BY 1, 2
LIMIT 1000;
Also, upon further digging, the xMAU metric for Monitor is not available in legacy.gitlab_dotcom_dev_xmau_mart
and is not being brought into the td_xmau
snippet due to this.
Proposal
- Create a
incident_management_alerts
event for SaaS to track Monitor xMAU as both events that are currently present in SaaS data is irrelevant for the current state of Monitor.
Result
Next steps (if any)
- Remove
projects_with_prometheus
as a representative stage for SaaS - Coordinate with PI on the best way forward in creating an event similar to the current Self-Managed
incident_management_alerts_total_unique_counts
for SaaS.