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. A/B test new features
  2. Money made with new features
  3. Re-tweets for release tweet
  4. Usage per feature
  5. Usage stats
  6. 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. Lever
  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

We want the tools to be open source so we can ship this as a product. Also see the "Complete BizOps" Google Doc. We'll use Singer, PostgreSQL, and Superset.

  1. Ingestion/ETL: The open source Singer from StitchData. This competes with the proprietary options from them and Fivetran, Alooma, Segment and Looker, and Snaplogic.
  2. Warehouse: PostgeSQL, maybe later with a column extension. If people need SaaS BigQuery is nice option and Druid seems like a good pure column oriented database.
  3. Display/analytics: Superset (Apache open source, most changed repository) instead of the open source alternative Metabase which is Clojure based and runs on the JVM or Redash. Proprietary alternates are Looker and Tableau.