Google Analytics BigQuery schema

Photo by Stephen Phillips - Hostreviews.co.uk on Unsplash

Preface

Google Analytics is widely used in various industries for tracking user activities in Web and mobile applications. For most of the users, the default reporting provided by GA is usually sufficient as long as the tracking of the application is in place (If not, go for the custom reporting! :p ).