Business Operations

The Business Operations (BizOps) team is responsible for translating business goals (strategy) into tactical operations (execution).

Finance and reporting

Sources of truth

Billing

Each month, expansion and MAU amounts are calculated and sent as invoices through Xero.

Analytics

This page describes Sourcegraph’s analytics function, our data sources, and how to use our data tools.

To reach us, mention @ericbm in the most relevant channel (i.e. #marketing for a marketing-related question).

Submitting a data request

Projects: Proposals to capture and report on new data are in GitHub issues in the Sourcegraph analytics repository. Provide the following data to help us understand and prioritize your request:

  • What is the purpose of the visualization?
  • Will it be frequently used, or is it only needed sporadically?
  • How does it support Sourcegraph’s company and team goals?
  • Do you know how you want the data visualized? If you need a new graph or chart, adding a photo of a sketch on paper helps immensely.
  • When does this need to be delivered?
  • How urgent is this request?

Small asks and questions: Post in the #analytics channel.

If you need clarification or are not sure about any of the above, ask a question in the Slack #analytics channel.

Data sources

We collect data from the following:

  • Google Analytics: Website analytics for Sourcegraph marketing and docs pages (not Sourcegraph.com)
  • HubSpot: Marketing automation and CRM
  • MixMax: Email marketing automation (Apollo is not used in production, but still retains data)
  • ZoomInfo: Data enrichment of account and contact information
  • Sourcegraph.com Site-admin pages: customer subscriptions and license keys
  • Pings from self-hosted Sourcegraph instances containing anonymous and aggregated information. There are specific guidelines that must be followed for teams to add ping data.
  • Custom tool to track events on the Sourcegraph.com instance
  • Prometheus dashboards show high-level insight into the health of a Sourcegraph instance to admins. Sourcegraph teammates can see the health of Sourcegraph.com.

We have written policies about how we handle customer information.

Data tools

  • Looker: Business intelligence/data visualization tool
  • Google Cloud Platform: BigQuery is our data warehouse and the database Looker runs on top of
  • Google Sheets: There are a number of spreadsheets that Looker queries (by way of BigQuery).
  • BizOps builds ad-hoc tools to analyze data for various reasons. The projects are in the Google Drive Analytics folder and the source code is available in the analytics repo.

Data pipelines

Every underlying data source (not chart!) is assumed to always be up-to-date unless noted otherwise.

HubSpot

The HubSpot data pipeline is updated once per day (in the afternoon PST). If you need the latest data at any time, post in the #analytics channel in Slack and the BizOps team can run the pipeline manually.

Lead-generation from HubSpot is triggered by Zapier and is always up-to-date. Marketing operations has more information on lead-gen events.

Using Looker

Looker is a self-service tool with many pre-built reports and visualizations. The onboarding doc is located in Looker. Reach out in the #analytics Slack channel if you have any questions, we’re happy to help!