BigQuery value through integration with Google Analytics Premium
March 31, 2017
BigQuery value through integration with Google Analytics Premium
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Google BigQuery
BigQuery is used to access the data collected through Google Analytics and merge that information with data from other business systems. The integration of BigQuery and Google Analytics made this an efficient approach to developing and maintaining data used in the organization's business intelligence reporting along with deep-dive analysis into advertising performance.
- Quickly query summary metrics from time-series data
- Integration with other Google Cloud products
- Scalability to handle unpredictable changes in data volumes
- Integrating with data outside of Google Cloud can be slow
- Data and the related queries are structured differently than in SQL Server, so there is some training necessary before broadly adopting
- Understanding the pricing of various queries can be a challenge. Figuring out what makes a query more expensive than another takes time.
- Streamlined the use of data from other Google products - particularly Google Analytics Premium
- Low storage costs allow for a large repository of information to be retained for historical analysis and reporting
- Management of BigQuery is simple and handled by 1 person internally to integrate with Google Analytics data
Other locally hosted solutions are capable of providing the required level of performance, but the administration requirements are significantly more involved than with BigQuery. Additionally, there are capacity and availability concerns with locally hosted platforms that are a concern when working with data used for digital marketing analysis and ad performance optimization.