Business Operations

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

To reach us, mention @ericbm in #analytics, #sales or #marketing.

Analytics

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

How to submit a data request

Looker is a self-service tool so we encourage everyone to try finding answers within the tool. Get started here if you’re not familiar with Looker, the team in the #analytics Slack channel are more than happy to answer any questions regarding Looker.

Projects: Add an issue to the analytics board in GitHub. This is used as the analytics project board and is triaged every day. Please think through and include the following so we can effectively prioritize your request. - What is the deliverable going to be used for? Why do you need it? This helps the team prioritize requests. - What do you want the deliverable to look like (in as much detail as possible)? For example, if you want a specific chart that illustrates some metric, it would be extremely helpful to draw the chart on paper and attach it. - When do you need the deliverable by? - Is this request a nice-to-have or a necessity?

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

Data sources

Here are the following sources we collect data from:

  • 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

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).

Using Looker

All Instances
Specific Instance Overview (To select a specific company, fill the Unique Server ID field)

Folders:
Marketing
Sales
Product Insights

Getting started with Looker

Looker enables us to explore and visualize Sourcegraph data sources. If you’re a new user, here’s where to get started.

Exploring data
Visualizing data
Building dashboards

Looker developed their own 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 a couple resources to get started.

Introduction to LookML
LookML Terms and Concepts
Complete Looker Docs