A query to generate the Google Analytics Shopping behavior funnel report in BigQuery. In this report you'll find completion and abandonment data about your enhanced ecommerce funnel performance, segmented by user type.
In this tutorial I will show you - step by step - how to mirror the default channel grouping according to the Google Analytics definitions and set up a custom channel grouping, all in BigQuery.
The most important custom dimensions and metrics for GA360 BigQuery export, for different scopes like user, session, hit and product.
The most important enhanced ecommerce products dimensions and metrics for GA360 BigQuery export, like product, product sku, product category (enhanced ecommerce), product brand, unique purchases, product revenue, product adds to cart and product detail views.
The most important ecommerce products dimensions and metrics for GA360 BigQuery export, like product, product sku, product category, unique purchases and product revenue.