GA4 Convert - Free, Open Source Tool

This tool is for SQL-literate analysts who wish to simplify their work with GA4 BigQuery export.
It produces a clean relational data structure with strongly typed fields, suitable for querying with SQL and BI tools.

GA4 export is not "analysis-ready" by default. GA4 Convert produces tables with stable, familiar grains:

  • sessions
  • pageviews
  • tracked events (configurable by analyst)
  • event parameters
Additionally, GA4 Convert defines a small set of standard views that flatten common event parameters into fixed columns. Analysts can query "forms", "downloads", "outbound clicks", "site search", and "videos" without repeatedly unpacking parameters.

This makes it much easier to answer questions like: "What happened in this session?", "Which pages led to a form submit?", or "How many file downloads came from this landing page?"

Canonical, coerced event parameters. Event parameters are often messy: numbers arrive as strings, booleans are inconsistently represented, dates come in multiple formats, the same parameter can appear with different types across events.

The tool creates a canonical view of event parameters where values are coerced into typed columns (or NULL), and coercion failures are explicitly flagged. This gives you a reliable foundation for monitoring, learning rules later, and building consistent analysis views.

De-duplication of events. It flags likely duplicates based on a composite key.


© sys2biz Pty Limited, 2020 | Privacy Policy | Analytics permissions | LinkedIn | Facebook