I get tired of wasting time searching for this in old files… I typically use BigQuery, but when it is handy, it is handy.
This is just a memo. It is mid-March and I think it is worth writing a few words of what is happening: a pandemic. Something I have not experienced before. In some places also a pandemonium. What information do I have at this moment? The virus originated in a “wet market” in Wuhan. The type […]
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
It’s now March. Folks, I think it is safe for me to recall 2018 and welcome 2019! 2018 was, to put it lightly, a pivotal year. In 2018… I had my first son, left Amazon, traveled 20+ hours (with kids) to visit family in Florida stopping by Canada after four years of absence and went […]