BigQuery uses a custom flavor of SQL. We put together a cheat sheet of common queries, terms, functions, best practices and schema names to help you query the Google Analytics 360 tables in BigQuery faster. This is a key resource if you are brand new to SQL or already a pro!
Custom Cohorts Tool for Google Analytics 360
Google Analytics has a cohorts analysis report, but it only allow you to build acquistion date cohorts. Our tool for Google Analytics 360 uses your BigQuery dataset to allow you to build cohorts based on any page or event interaction!…