The main differences are the following:
- The Google Analytics → Google BigQuery pipeline does not require the Google Analytics 360 account.
- Storing and querying processing data collected with the GA→GBQ pipeline is cheaper.
The pipeline collects hit and session data into 2 tables and the tables contain only necessary information, which significantly decreases BigQuery expenses. The BigQuery Export table for Google Analytics 360 contains over 40 columns with AdSense, Google Ads, DoubleClick, and other data that is rarely required.
- With the GA→GBQ pipeline, your hit data appears in BigQuery in 5 minutes.
The BigQuery Export for Google Analytics 360 can take up to 24 hours.