Decode GA4
Decode GA4 automatically flattens Google Analytics 4's nested BigQuery export data into clean, ready-to-query tables, with usage-based pricing and no subscription.
🔗 Visit Decode GA4
Description
When a company sends its website analytics data — the kind collected by Google Analytics — into a database for deeper analysis, that data usually arrives in a messy, deeply nested format that's difficult to work with. Imagine someone packed your suitcase for a trip, but instead of folding shirts and pants into separate compartments, they stuffed everything into one bag wrapped inside another bag inside another bag. Decode GA4 is a tool that automatically unpacks that suitcase for you: it takes Google Analytics 4 data sitting in Google BigQuery and turns it into flat, clean tables that anyone comfortable with basic queries can use right away, without needing to understand the original messy structure.
Technically, Decode GA4 runs natively inside BigQuery and eliminates the need to write per-field UNNEST subqueries against GA4's nested event_params and enrichment arrays. It uses metadata-driven incremental processing so each data partition is processed exactly once, automatically adapts to GA4 schema changes as Google evolves the export format, and adds built-in enrichments such as local timestamps and geolocation. Output can be exported as Parquet to GCS, S3, or Azure Blob, and the whole thing deploys in about five minutes via the Google Cloud Marketplace — no external compute or separate ETL infrastructure required.
💬 Our review
The short version: if your team already dumps Google Analytics 4 into BigQuery and dreads writing UNNEST queries every time someone asks a simple question, Decode GA4 removes that chore for a few dollars a month — a genuinely good deal for small and mid-sized sites.
Technically, the honest comparison is against two alternatives: writing your own dbt models or raw SQL UNNEST queries (free in licensing terms, but costs real engineering hours to build and maintain as GA4's schema shifts), and general-purpose ETL tools like Fivetran (priced around $1+ per credit, far more flexible since they move data from dozens of sources, but correspondingly more expensive and heavier to set up for a single use case). Decode GA4's usage-based pricing — roughly $3-8/month for sites under 10K monthly sessions — undercuts both for pure GA4-to-flat-table needs. The trade-off is scope: it only solves the GA4-in-BigQuery flattening problem, not general data integration, so teams already juggling multiple data sources may still need a broader tool alongside it.
💰 Pricing
📊 Global score
🤖 AI-enriched data
$50/Gio (0-1 Gio) dégressif jusqu'à $0.50/Gio au-delà de 500 Gio — sans abonnement
Pros
Élimine les requêtes UNNEST manuelles sur les données GA4 imbriquées
Tarification à l'usage sans abonnement, très abordable pour les petits sites
Évolution automatique du schéma quand GA4 change
Déploiement natif BigQuery en 5 minutes via Google Cloud Marketplace
Export Parquet vers GCS, S3 ou Azure Blob
Cons
Limité exclusivement à GA4 dans BigQuery, pas un outil ETL généraliste
Pas d'essai gratuit formel, juste le paiement à l'usage
Aucun concurrent nommé sur le site, positionnement à vérifier soi-même