BigQuery value through integration with Google Analytics Premium
Anonymous | TrustRadius Reviewer
March 31, 2017

BigQuery value through integration with Google Analytics Premium

Score 8 out of 10
Vetted Review
Verified User
Review Source

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.
Google BigQuery is well suited to applications where the data is coming from another Google Cloud product and the data will be used in frequent ad hoc queries. The performance of BigQuery on ad hoc queries makes it a good source for business intelligence applications. Additionally, automating repeated queries and common workflows with Google App Scripts is a good application with BigQuery.

Google BigQuery Feature Ratings

Automatic software patching
Not Rated
Database scalability
8
Automated backups
9
Database security provisions
9
Monitoring and metrics
9
Automatic host deployment
9