by Doug

13/06/2019

BigQuery, Case Studies, Google Tag Manager

Consistent Optimize treatments – Cross device for logged in users

I offer this post as a proof of concept to solve for a specific use case following some internal work at ConversionWorks and a coincidental, somewhat related post from Industry Legend Simo Ahava Read Simo’s article and you’ll see an elegant solution to first party cookie behaviour restrictions imposed by ITP.  The solution described here…

Read more

by Doug

12/06/2019

BigQuery, Google Analytics

Auto PII detection at scale

Scanning a whole BigQuery table using DLP (The data loss prevention product on GCP) to detect possible, likely or very likely PII in Google Analytics (GA) data is simple. This post describes a solution to automate Personally Identifiable Information (PII – sensitive data) discovery at scale.  Some familiarity with Google Cloud Platform (GCP) is assumed but…

Read more

by Huiyan

25/07/2018

BigQuery, Google Analytics

BigQuery Caveat – Two exits in one Google Analytics session?

Yesterday during a BigQuery analysis (with Google Analytics data) we encountered a weird thing. Within the same session, a tiny proportion of the sessions had more than one exit, a maximum of two exits, to be exact. (Exit is defined as having “hits.isExit = True”.)   As shown, all of those exit hits are pageview…

Read more