FY22-Q1 KR: VP, Product: Fix 14 of 14 underlying data quality issues impacting the accuracy of product and CS usage metrics, and deliver Wave 3 metrics to Salesforce and Gainsight (10/14:71%)

How to Achieve details:

Main Data Integrity Tracking Sheet

Fulfillment @amandarueda
KR: Fix 2 data issues

Targeted to Complete by EOQ1

• Get Context on licenses database table in License Dot https://gitlab.com/gitlab-org/license-gitlab-com/-/issues/190
• Correctly identify the correct attributes coming from Customer DB

Product Intelligence
KR: Fix 5 data quality issues

• Create an automated event dictionary for Snowplow Events gitlab-org&5247 (closed) @jeromezng @kokeefe
• Create an automated event dictionary for Usage Ping metrics gitlab-org&5425 (closed) @jeromezng @kokeefe
• Naming convention of Snowplow Events gitlab-org&5218 (closed) @jeromezng @kokeefe @kokeefe
• Naming convention of Usage Pings gitlab-org&5532 (closed) @jeromezng @kokeefe
• Definition of a MAU @kokeefe

Data @rparker2

KR: identify data issues and provide ongoing support to verify solutions

1. Self-Managed License Match: Match ~5k unlinked Licenses from Usage Ping to Customer Accounts/Subscriptions https://gitlab.com/gitlab-org/license-gitlab-com/-/issues/205
2. SaaS Active Seats Reporting: Retain a history of seats activated/deactivated by subscription and namespace and add this new data to Snowflake https://gitlab.com/gitlab-org/fulfillment-meta/-/issues/146
3. SaaS CI Minutes Used Reporting: Retain a history of CI minutes used by day by subscription and namespace and add this new data to Snowflake https://gitlab.com/gitlab-org/fulfillment-meta/-/issues/146
4. SaaS Daily Storage Used Reporting: Retain a history of Total Storage used by day by subscription and namespace and add this new data to Snowflake https://gitlab.com/gitlab-org/fulfillment-meta/-/issues/146
5. Object Model Documentation: Document the object and attribute model for GitLab.com, Customer, License, Versions Databases and Snowplow events for use by the Data Team to ensure accurate modeling of Product Usage Data.
6. GitLab Databases: Add incremental IDs or Change Dates to GitLab to support incremental data pulls.
7. SaaS: Retain a history of all subscription changes and supporting detail, including Zuora Subscription Id and Zuora Rate Plan Id https://gitlab.com/gitlab-org/fulfillment-meta/-/issues/146

• Allocates time to investigate and identify X quality issues by XX date
• Provide ongoing support to product/engineering team to verify solutions