by Doug

14/06/2019

BigQuery, Google Analytics

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

BigQuery, Google Analytics

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

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 Doug

21/05/2019

Google Analytics

Unique Pageviews, page depth, pageviews per session – do you know the difference?

Starting with a great question I just had a great Google Analytics question from one of our superstar clients and I want to share the answer with you. What’s the difference between Page Depth and Unique Pageviews?  At face value they appear to be very similar but segmenting on each shows different results.  What gives?…

Read more

by Luke

15/05/2019

Google Ads, Paid Search, Smart Bidding

Google Marketing Live 2019 – Smart Bidding Improvements

Google Marketing Live 2019 has been packed full of new releases, features and announcements after it’s first day. Leaving us with a fair few topics of discussion about how best to, in Google’s words, ‘be responsible, be there and be useful’. What we’ll be focusing on here are the updates and improvements to smart bidding…

Read more

by Leila

30/04/2019

Google Ads, Internet Marketing, Online Advertising, Paid Search

News Flash! New Sorting Functionality For Google Ads Campaigns!

It’s always exciting to see new developments to the Google Ads UI and this morning was no exception! You can now sort Google Ads campaigns in the UI side bar! Sort by Cost, Status, Conversions and more:     Try it out through the sorting arrows icon, shown on the far left hand side of…

Read more