Google BigQuery

Enhanced Goal Tracking with Google BigQuery

May 30, 2017

enhanced-ecommerce-with-BigQuery

The Google Analytics interface provides many ways of analyzing your goal conversions, including goal set tabs, funnel visualizations, and goal flow reports. The Analytics 360 Suite also provides custom funnels that allow you to create retroactive funnels based on advanced criteria. However, the BigQuery integration with Google Analytics allows users to deal with even more […]

The Value of Google BigQuery and Google Analytics 360

May 17, 2017

value-of-bq-and-ga-360

The integration between Google Analytics 360 and BigQuery is perhaps the most empowering feature in all of web analytics. (There, I said it!) Its hit-level data and cloud-based infrastructure give BigQuery analysis capabilities not found in other web analytics platforms, including both free tools and paid. BigQuery can be the link between third-party data and […]

Case Study: Audience Modeling with Google Analytics 360 and Google Cloud Platform

March 1, 2017

Google recently published a case study with LunaMetrics and PBS where we used Google Analytics 360, BigQuery, and Google Cloud Datalab to perform a clustering analysis on website audiences. The case study is worth checking out, but here’s a quick summary. PBS.org is a digital content hub with supporting information and streaming video for PBS […]

Self-Joins, Windowing, and User Defined Functions in BigQuery

May 12, 2016

Google’s BigQuery offers unprecedented access to Google Analytics data for Google Analytics 360 (Premium) customers. With great data comes great challenges, especially when you start attempting complicated calculations beyond the traditional metrics in Google Analytics. There are many ways to write queries in Google’s BigQuery, each has its strengths and weakness. Some of the basics of writing queries were covered in a previous post, but now we’re going to look at three different approaches to writing complex queries.

Querying Google Analytics Data in BigQuery

February 11, 2016

BigQuery, a database designed to query massive datasets in parallel using an SQL-like language, is a member of the Google Cloud Platform. What makes BigQuery interesting for Google Analytics users, specifically Premium customers, is that Google can dump raw Google Analytics data into BigQuery daily. While this enables many types of analysis that can’t be performed within the Google Analytics interface, it […]

Page 1 of 212
Contact Us.

LunaMetrics

24 S. 18th Street, Suite 100,
Pittsburgh, PA 15203

Follow Us

1.877.220.LUNA

1.412.381.5500

getinfo@lunametrics.com

Questions?
We'll get back to you
in ONE business day.