Introducing the Events Explorer

Pierre Estephan
Wed Jun 08 2022
ANNOUNCEMENT

Today, quickly querying and understanding your product data can be an intimidating task. More often than not, you’ll need knowledge of SQL (or other query language), good understanding of your underlying data model and schema to get started, and the time and server compute to run often expensive, slow queries.

The Events Explorer is the newest addition to our suite of tools at Statsig and aims to simplify this process. By taking a sample of product events over a two week period that is representative of your overall product data, we allow you to perform lightning fast queries that run in seconds, not minutes with no SQL required. The Events Explorer helps you quickly and easily understand trends in your product and user data, with low lift and no technical background knowledge.

There are three main ways to use the Events Explorer that I would like to share with you today; the Table View, the Samples View and the Time Series.

To follow along and play with the examples yourself, log in to our demo account here, and click the links below each image.

The Table View

The Table View allows you to breakdown your data with aggregations. You might visit this view if you wants answers to questions such as;

  • How many people reach the checkout screen per day? How many of those actually complete a purchase?
  • How many purchases do we have per country/age-group/etc? What is the average amount spent per purchase?
  • What events are being logged by the product? How many of each event?

This can be a great place to start to understand what is being logged — the default view will show you the count of all events. This query quickly reveals 103M product_view events, 2.2M checkout_events and 0.8M purchase_events being logged over the last week .

https://console.statsig.com/4TLCtqzctSqusYcQljJLJE/events_explorer

From here, we are only a few clicks away from drilling down to more complex aggregations to answer questions we might have. Let’s use this view to answer the question: “Which countries spend the most on purchases and what is the average purchase price per country?” From the previous query, you simply need to (1) filter down to the purchase_event, (2) group by country and (3) aggregate the sum/average for the purchase_events to answer this question.

https://console.statsig.com/4TLCtqzctSqusYcQljJLJE/4UjjVRqDvuIBFTdlIJSMMi

In only a few clicks, we have an answer: the bulk of purchase_event value is driven by the US and India ($33M and $17M), where-as Mexico and Canada drive much less by comparison. The average purchase price is quite similar across different countries.

We currently support Count, Sum and Average aggregations, but plan to support more powerful aggregations in the future.

The Time Series

The Time Series allows you to explore all of your aggregations and groupings across the axis of time. Take our previous query looking at purchases in the US and India; plotting it as a time series allows us to quickly see which hours different regions are active, and can reveal trends in usage.

https://console.statsig.com/4TLCtqzctSqusYcQljJLJE/1FjKXEGOd2ysrkN1P84knM

Monitoring product usage trends can be a powerful tool to help you prioritize which features you should be working on. It can help you confirm the work you’re doing is impactful to your topline and is aligned with the way people use your product.

This view is also very powerful operationally, as you release new products and monitor for product errors.

  • You can monitor the gradual rollout of a product or feature, i.e. watching usage/impressions/clicks start to ramp up in a specific region or for a new feature.
  • You can watch for spikes in error logs, understand which users were affected and when, and monitor rolling out a fix as errors return to baseline.
  • You can quickly gain context on spikes in app errors or reported issues; i.e. Are these errors specific to a certain region? A certain platform? Are they affecting iOS, Android, Web, or all three? Did the time these errors started spiking coincide with any gate or experiment launches?
  • If a user or employee reports an issue, you can quickly confirm if this issue is widespread or localized i.e. is there a sharp drop in checkout impressions for everyone or only on our staging tier.

The time series view has settings to view data at different time granularities (ranging from 5min to 1day), allows for overlaid comparisons i.e. the week/week comparison for a single event, and can show up to 8 series in one chart.

The Samples View

Finally, the Samples View allows you to see sample rows for events that you care about. This is a great starting place to explore data when you may be unfamiliar with the underlying data schema or what exactly is being logged. With this you can quickly see exactly which fields are being logged, what data is being logged in each field and what kind of filters or groupings you might be able to apply to each field.

https://console.statsig.com/4TLCtqzctSqusYcQljJLJE/5SZxgTTlhmNP8kOJLx8ceY

One way we use this view at Statsig is to audit and understand what we log per event to inform which logging and telemetry we are missing/should consider adding in future sprints.

Another common usecase for the samples view is to view detailed events for a single user, to reconstruct their user journey, which can be useful to understand for new user activations or for users reporting product issues.

Overall, the Events Explorer aims to provide fast, easy to use product observability, regardless of your familiarity with technical query languages or the underlying design of the data model.

I’m fortunate to work with some super talented colleagues on this, and we’d all love to hear any feedback you might have while trying out the product. Please feel free to share any feedback you have in our slack channel here, and tag myself, Ritvik, Anu or Jason.


Try Statsig Today

Explore Statsig’s smart feature gates with built-in A/B tests, or create an account instantly and start optimizing your web and mobile applications. You can also schedule a live demo or chat with us to design a custom package for your business.

MORE POSTS

Recently published

My Summer as a Statsig Intern

RIA RAJAN

This summer I had the pleasure of joining Statsig as their first ever product design intern. This was my first college internship, and I was so excited to get some design experience. I had just finished my freshman year in college and was still working on...

Read more

Long-live the 95% Confidence Interval

TIMOTHY CHAN

The 95% confidence interval currently dominates online and scientific experimentation; it always has. Yet it’s validity and usefulness is often questioned. It’s called too conservative by some [1], and too permissive by others. It’s deemed arbitrary...

Read more

Realtime Product Observability with Apache Druid

JASON WANG

Statsig’s Journey with Druid This is the text version of the story that we shared at Druid Summit Seattle 2022. Every feature we build at Statsig serves a common goal — to help you better know about your product, and empower you to make good decisions for...

Read more

Quant vs. Qual

MARGARET-ANN SEGER

💡 How to decide between leaning on data vs. research when diagnosing and solving product problems Four heuristics I’ve found helpful when deciding between data vs. research to diagnose + solve a problem. Earth image credit of Moncast Drawing. As a PM, data...

Read more

The Importance of Default Values

TORE

Have you ever sent an email to the wrong person? Well I have. At work. From a generic support email address. To a group of our top customers. Facepalm. In March of 2018, I was working on the games team at Facebook. You may remember that month as a tumultuous...

Read more
ANNOUNCEMENT

CUPED on Statsig

CRAIG

Run experiments with more speed and accuracy We’re pleased to announce the rollout of CUPED for all our customers. Statsig will now automatically use CUPED to reduce variance and bias on experiments’ key metrics. This gives you access to a powerful experiment...

Read more

We use cookies to ensure you get the best experience on our website.

Privacy Policy