Data Science

Subset Your Google Analytics Data with R

August 17, 2016


R is a relatively easy language to use when performing statistical and graphical analyses on data. However, after choosing your dataset, you may still need to subset it. Luckily, R’s built-in functionality can be especially helpful in getting the sections of data you need. Since Becky gave us a great introduction to querying Google Analytics […]

Google Apps Script: An Unsung Hero

August 10, 2016


Google Apps Script is a service provided by Google that allows small bits of JavaScript that can interact with other Google Services and other services that provide a web-based API. The Apps Script can be triggered based on web requests, Google Forms, Google Sheets, Google Docs, or, most interestingly, a timer. The time-based triggers are […]

Highlights from ICML 2016

July 5, 2016


I just got back from the International Conference on Machine Learning (ICML) in New York City. For five days, machine learning researchers and practitioners presented and discussed the latest trends and cutting edge algorithms in the field. I was really excited to use my yearly professional development opportunity to attend this conference. At LunaMetrics, we […]

Marketing Channel Attribution with Markov Models in R

June 30, 2016

Data empowers us to better understand our users and their behaviors, while methods provide us with the means for analysis. These methods, ranging anywhere from simplistic (i.e. frequency) to complex (i.e. clustering), allow us to choose what we want to understand from the data. A popular way to understand our users and their behaviors in […]

Getting Started with R and Google Analytics

June 2, 2016

R is a statistical tool that can enrich you website data analysis. Unfortunately, R has a steep learning curve and can be intimidating to a first time user. However, the payoff is worth the effort. In this post I will help you get started by demonstrating some of the most useful R commands. First, you […]

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.

Compare Actual vs Predicted Data with Google Analytics and CausalImpact

April 21, 2016

Google Analytics (GA) is a great tool for collecting and analyzing web site data, but it’s not without its limitations. If you need to run more advanced analyses, you probably find yourself pulling the data out of GA and putting it into other complementary tools, such as R, Tableau, Shufflepoint (and more!). Today’s focus will be on CausalImpact, an open-source package in R developed by the data gurus themselves (Google).

Page 1 of 212
Contact Us.


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

Follow Us



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