by Doug

26/07/2019

Uncategorised

GTM Monitor v2.0

Hands up who’s browser history looks like this: Yep, lots of Simo-treasure!  The most recent post was a fine collaboration between Simo Ahava and another community pillar, Mark Edmondson describing how to build and GTM monitor using GCP components and a great new GTM feature. I like this a lot – I’ve followed the article to…

Read more

by Doug

24/07/2019

Uncategorised

What is “The Cloud” anyway?

Summary My last few posts have been quite heavy on “Google Cloud Platform” product usage.  I appreciate these are of a more technical bent, and as I humbly boldly claim to be able to speak to engineers and humans, I’m going to shift gears in this post to explain what, how, and why ConversionWorks uses Google Cloud…

Read more

by Doug

14/06/2019

Uncategorised

Custom data pipeline to BigQuery in realtime

This post describes a technique that is a combination of two techniques I’ve read in posts written by Simo Ahava and Mark Edmondson, two of the smartest chaps you’ll ever meet. Simo’s article (linked above in case you don’t know how the interwebs works), describes how to use customTask to syphon GA data into Snowplow….

Read more

by Doug

13/06/2019

Uncategorised

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

Uncategorised

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

Uncategorised

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