Skip to main content

Adam's Analytics Adventure: Week 4

Adam Englebright25 July 20143 min read
Adam's Analytics Adventure: Week 4
			<figure class="kg-card kg-image-card kg-card-hascaption"><img src="http://measurelab2.wpengine.com/wp-content/uploads/2014-07-19-15.22.35-1024x768.jpg" class="kg-image" alt="Went for a wander around Lewes itself over the weekend. The images aren't super-relevant, but they're quite nice. This one is down near the Priory." loading="lazy" width="1024" height="768"><figcaption>Went for a wander around Lewes itself over the weekend. The images aren't super-relevant, but they're quite nice. This one is down near the Priory.</figcaption></figure>

Gosh, fourth week already? I've been here nearly a month – not only am I graduating on Monday, I'll also be receiving my first paycheque! Doesn't time fly? Anyway, another quick one this week, as I've eaten up some of my blogging time doing *gasp* actual work, and we're finishing slightly early today, so let's goooooo...

Week of code

I feel like George Justice missed his calling as a law enforcement officer and/or judge. Officer Justice, Lord Justice Justice, &c.
I feel like George Justice missed his calling as a law enforcement officer and/or judge. Officer Justice, Lord Justice Justice, &c.

This week's been quite nice in several ways – my days have been a bit more diverse in terms of activities, and I've spent a lot of my time attempting to do some code stuff, both some pretty rudimentary Javascript stuff from one of Mark's templates in Google Tag Manager and also some slightly more involved stuff because I needed to retrieve and wrangle larger amounts of data than the Spreadsheets add-on or the interface itself would allow.

Remains of the Priory
Remains of the Priory

Fortunately, there's a package for everyone's favourite free software cross-platform statistical programming language that allows you to retrieve data with only a little fuss and bother (it took me all of Wednesday to get the damn thing working, but I got it sorted in the end). I haven't done anything with R since I used it for a bit of a coursework at the beginning of the year (for which I got 88%, so I'm basically an expert) and most of the challenge was working out how to import the data (the code provided by the package people was not completely clear) which is not where most of my R skills lie, having always been given nice, clean, well-formatted .csv's for ease of importing at uni.

Interesting sculpture in the gardens of Southover Grange
Interesting sculpture in the gardens of Southover Grange

Once I had the data, however, it was all good. Sadly, I didn't get to do any of the interesting analysis/visualisation stuff, as the client just wanted it to compare with some internal numbers – however, knowing now how to get the data in, that stuff should be no problem when we do want to do something fun and interesting with a large data set. It's nice, as always, to be able to make use of some of that stuff I spent the last three years learning. I'm also interested to look into the use of PHP and fast Fourier transforms (yeah, I'm interested in looking at Fourier transforms. I didn't even say that when I doing my degree) outlined by friend of Measurelab Jason Bailey over here, but that's something for another week.

coffeewatch 2k14

Coffee #2 (Livanto)
Coffee #2 (Livanto)

Tuesday and Thursday I had one 'Livanto' (my preferred Nespresso

™ pod style

so far), but today I not only ventured into the slightly odd territory of 'Ciocattino' and 'Vanillo' (Livanto but flavoured with chocolate and vanilla, respectively) I had two cups of coffee.

Coffee #3 (Vanillo)
Coffee #3 (Vanillo)

My habit is developing, and my mean heart rate, no doubt, is slowly increasing. Over and out


Suggested content

Measurelab awarded Google Cloud Marketing Analytics Specialisation

At the start of the year, if you’d asked us whether Measurelab would be standing shoulder to shoulder with Europe’s biggest consultancies by September, we would've been surprised. Not because we don't believe in ourselves, but because these things feel so distant - until suddenly, they’re not. So, here it is: we’ve been awarded the Marketing Analytics Services Partner Specialisation in Google Cloud Partner Advantage. What’s the big deal? In Google’s own words (with the obligatory Zs): “Spec

Will Hayes11 Sept 2025

BigQuery AI.GENERATE tutorial: turn SQL queries into AI-powered insights

BigQuery just got a major upgrade, you can now plug directly into Vertex AI using the new AI.GENERATE function. Translation: your analytics data and generative AI are now best friends, and they’re hanging out right inside SQL. That opens up a whole world of new analysis options for GA4 data, but it also raises some questions: * How do you actually set it up? * What’s it good for (and when should you avoid it)? * Why would you batch the query? Let’s walk through it step by step. Step 1: H

Katie Kaczmarek3 Sept 2025

How to start forecasting in BigQuery with zero training

If you’d told me five years ago that I’d be forecasting product demand using a model trained on 100 billion time points… without writing a single line of ML code… I probably would’ve asked how many coffees you’d had that day ☕️ But its a brand new world. And it’s possible. Let me explain What is TimesFM? TimesFM is a new foundation model from Google, built specifically for time-series forecasting. Think of it like GPT for time, instead of predicting the next word in a sentence, it predicts t

Katie Kaczmarek14 Jul 2025