Analytics

Finance has the company wide responsibility for analytics. Examples of the types of metrics we want to track are below per department.

Cross department metrics

Cross department metrics are essential to measure our journeys.

Department metrics

Sales

  1. Incremental ACV
  2. ARR
  3. TCV
  4. ARR
  5. Renewal rate
  6. Win rate and time for every sale stage and the overall process.
  7. Time to close
  8. Pipeline created
  9. Pipeline Requirement Projection
  10. Sales efficiency (above 0.8)
  11. Pipeline coverage (above 3)
  12. Up-sell (EES to EEP, EEP to EEU)
  13. Average deal size

Peopleops

  1. Inbound applications per week
  2. Interviews per applicant
  3. eNPS score of team members
  4. Applicant score per requirement and value
  5. Declined applicant NPS score
  6. Offer accept rate
  7. Accepted offers/hires
  8. Cycle time (apply to accepted offer)
  9. Terminations (Voluntary regrettable, Voluntary PIP, Involuntary)
  10. Share of people on PIPs

Marketing

  1. Visitors to the website
  2. Downloads
  3. MQL
  4. SQL
  5. Blended CAC
  6. Program spend / Total spend (above 0.5)
  7. Conversion percentages, cycle time, and CAC per channel
  8. New contributers from the wider community per release/month

Engineering

  1. Merge requests (total, community, ours)
  2. Cycle time
  3. Time to review
  4. Bug fixes (cherry-picks into stable)

Finance

  1. Order to cash time
  2. Runway (above 12 months)
  3. 40 rule (above 40%)
  4. Magic number (above 0.7)

Product

  1. Money made with new features
  2. Re-tweets for release tweet
  3. Usage per feature
  4. Usage stats
  5. Bottlenecks to increased customer sophistication

Many of the metrics you would normally track outside of the product we collect inside of the product so it is also useful to our self hosted users. This includes cohort analytics, conversational development analytics, and cycle time analytics.

Data sources

  1. Salesforce
  2. Zuora
  3. Marketo
  4. Zendesk
  5. NetSuite
  6. Mailchimp
  7. Google Analytics
  8. Discover.org
  9. Applicant Tracking System
  10. GitLab version check
  11. GitLab usage ping
  12. GitLab.com

We want a single data warehouse and a central data model. We bring all relevant data to single storage place. Make it platform agnostic, so for example do not build it into Salesforce. We want to build data model to be used consistently across tools and teams. For example something as simple as unique customer ID, product or feature names/codes.

On the other hand we're open to pragmatic solutions linking for example Salesforce and Zendesk, if there are boring solutions available we'll adopt them instead of creating our own.

Tools

These are still to be decided, some suggestions below.

  1. Ingestion: Fivetran, Alooma, Segment and Looker, StitchData (open source)
  2. Warehouse: BigQuery
  3. Display: Looker, Redash, Superset (Apache open source), or Metabase (open source)