Google BigQuery

Replicating the Google Analytics All Pages Report in BigQuery

June 1, 2018

While BigQuery is often the perfect tool for doing data science and machine learning with your Google Analytics data, it can sometimes be frustrating to query basic web analytics metrics. In this post, I’ll walk through calculating some fundamental metrics at the page level by replicating the All Pages report for the Google Merchandise Store […]

Connect Google Analytics Data To Your Tools via BigQuery

July 26, 2017

connect-your-tools-via-bq

One of the huge advantages of Google Analytics 360 is the connect that pipes Google Analytics data directly into Google BigQuery. If you are a GA360 customer and you current create reports outside of the Google Analytics interface, in some other platform or tool, consider pulling data out of Google BigQuery rather than using the […]

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

pbs-case-study-behind-the-scenes

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 […]

Page 1 of 212
Contact Us.

Follow Us

1.877.220.LUNA

1.412.381.5500

getinfo@lunametrics.com

Questions?
We'll get back to you
in ONE business day.
Our Locations
THE FOUNDRY [map] LunaMetrics

24 S. 18th Street
Suite 100

Pittsburgh, PA 15203

THE STUDIO [map]

4115 N. Ravenswood
Suite 101
Chicago, IL 60613

THE LODGE [map]

2100 Manchester Rd.
Building C, Suite 1750
Wheaton, IL 60187