The main differences are the following:
- The Google Analytics → Google BigQuery pipeline does not require the Google Analytics 360 account.
- Storing and query 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, that significantly decreases BigQuery expenses. The BigQuery Export table for Google Analytics 360 contains over 40 columns with AdSense, AdWords, DoubleClick, and other data that is rarely required.
- With the GA→GBQ pipeline, you start seeing your hit data in 5 minutes.
The BigQuery Export for Google Analytics 360 can take up to 24 hours.