Skip to main content

UA | Universal Analytics

It can be hard to make sense of the data in the GA3 BigQuery export tables. Our articles show you how to utilise Universal Analytics data in BigQuery.

— A collection of 38 posts
December 2020

How to replicate the 'Conversions | (Enhanced) Ecommerce | Shopping behavior' funnel report

November 2020

Tutorial: How to create your own custom channel grouping

November 2020

Custom dimensions & metrics

November 2020

Enhanced Ecommerce products: dimensions & metrics

November 2020

Ecommerce products: dimensions & metrics

November 2020

(Enhanced) Ecommerce transactions: dimensions & metrics

November 2020

Goal conversions: dimensions & metrics

November 2020

How to query an intraday table (and combine it with daily tables)

November 2020

Event tracking: dimensions & metrics

November 2020

Page tracking: dimensions & metrics

November 2020

Platform and device: dimensions & metrics

November 2020

Geo network: dimensions & metrics

November 2020

How to query realtime tables and views (and combine it with daily tables)

November 2020

Traffic sources: dimensions & metrics

November 2020

Date and time: dimensions & metrics

November 2020

Session: dimensions & metrics

November 2020

User: dimensions & metrics

November 2020

Introduction to Google Analytics 360 export data in BigQuery

November 2020

How to replicate the 'Conversions | (Enhanced) Ecommerce | Sales performance' report

November 2020

How to replicate the 'Conversions | (Enhanced) Ecommerce | Product performance' report

November 2020

How to replicate the 'Conversions | (Standard) Ecommerce | Product performance' report

November 2020

How to replicate the 'Conversions | (Standard) Ecommerce | Transactions' report

November 2020

How to replicate the 'Behavior | Events | Pages' report

November 2020

How to replicate the 'Behavior | Events | Top Events' report

October 2020

Tutorial: How to replicate the 'Behavior | Site content | All pages' report

October 2020

How to replicate the 'Acquisition | Campaigns | All campaigns' report

October 2020

How to replicate the 'Acquisition | All traffic | Referrals' report

October 2020

How to replicate the 'Acquisition | All traffic | Source/Medium' report

October 2020

How to replicate the 'Acquisition | All traffic | Channels' report

October 2020

How to replicate the 'Audience | Mobile | Devices' report