A few moments ago I posted the article below on LinkedIn. It is my first time creating an article on LinkedIn, rather than posting writings from here. While I am not a fan of creating articles in platforms I don’t control, I am curious on the effects. The complete article can be found here: How […]
I get tired of wasting time searching for this in old files… I typically use BigQuery, but when it is handy, it is handy.
I keep recreating queries from client to client, case to case. Let’s see if I can just use this blog as a future resource. SELECT from UNNEST Very useful for when you just want a particular value from the nested values. The below is from BigQuery, Google Analytics App + Web (app) exports. SELECT device.operating_system […]
I had come across something like this developer’s cheat sheet a while back and forgotten about it. Today I received an email from Google pointing to it and though I’d better save it for future reference. Also, I wonder how well this is going to age 🙂 The image is from https://medium.com/google-cloud/every-google-cloud-product-described-in-4-words-or-less-4d3f37f4567b by @gregsramblings
I keep coming across different ways of sites asking for cookie permissions and forgetting the ones I think are noteworthy. I’m creating this post as a scrapbook of sorts, with the different permission screens that get my attention. Feel free to email me if you think I should add one. Telegraph Uniqlo UK
As a non-techie delving in digital analytics I often come across the notion that SQL, Python, R and other scripting languages are the main requirement to enter this space. No doubt, these are important. But in this post I would like to make a case for web analytics folks to better understand the cloud. The […]