Business Operations

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

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 OKRs? - 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
  • Apollo: Email marketing automation
  • Sourcegraph.com Site-admin pages: customer subscriptions and license keys
  • Pings from self-hosted Sourcegraph instances containing anonymous and aggregated information
  • 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.

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 spreadsheetsthat 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 data: Every week on Sunday night or Monday morning, BizOps triggers scripts that retrieve data from HubSpot and upload it to BigQuery. This does mean that currently our HubSpot data in Looker is not updated during the week. If you have a particular reason you’d like it to be updated during the week, mention @ericbm in the #analytics channel in Slack.

Using Looker

Looker is a self-service tool with many pre-built reports and visualizations. Read our instructions for getting started with Lookr and reach out in the #analytics Slack channel if you have any questions.

Folders

Getting started with Looker

Looker provides tools for building and exploring custom reports and visualizations using custom fields captured from various Sourcegraph data sources. If you’re a new user, here’s where to get started.

Querying Looker data

Looker created a query language called LookML for defining calculations and data relationships in a SQL database. The ‘Explores’ and other functionality you see in Looker is all based on a LookML model. The average Sourcegraph teammate should not need to write any LookML code, but should you need or want to, here are some resources to get started.