DEMO ENVIRONMENT · Explore, try, learn. No real payments.

BigQuery

From events to tables: thinking about the export

A table of events is not yet a report. Before the metrics, understand the schema and the granularity.

Read one row

Identify what each record represents and which fields can be repeated or nested. Explore a small sample before building a complex query.

State the granularity

Decide whether you are counting events, users or orders. A join can multiply rows: compare counts and totals before and after each transformation.

Keep one control case

Create a demo case with a known result. A query returning the expected number on a simple sample is easier to validate and to explain. The operational export is not part of this preview.

THINK IT THROUGH

From the concept to a concrete case

Pick a page of the laboratory. Which interaction do you want to observe? Write the event name, two parameters and one case where it should not fire.

Download the checklist ↗
← All articles