Linus Larsson's blog
GTM variable that removes PII from query string
Published on 2021-06-07 in GTM
This is my first GTM Template that I’ve added to the Template Gallery. What this variable does is that it allows you to modify a query string from the URL in order to make sure that you are not sending any PII by mistake to third party services. You can find the template on https://tagmanager.google.com/gallery/#/owners/qvalento-gtm-templates/templates/query-string-modifier...
Create simple brand color themes in Data Studio
Published on 2020-05-23 in Data Studio
In this post, I will show you how to get your brand colors as a customized theme in Data Studio super easily. Imagine never having to type in one color at a time again! So first things first. In order to get all the brand colors (or at least most of them), you will have...
Automatically store screenshots of your website with R
Published on 2019-07-08 in R
How cool would it be to be able to see how your, or anyone else’s, website was presented on a specific day? With this script in R, I will show you how you can save screenshots of any website you want to and store the images in Google Cloud Storage, although you can easily store...
Sending error messages from R to Slack
Published on 2019-06-06 in R
When you’re working with scheduled R scripts, it could be useful to get an alert when something goes wrong. Of course, there are ways to send emails, but wouldn’t it be nice if your entire team could get a notice in real time in Slack instead (or as a complement to emails)? This is actually...
Upload data from R to an HTML page with rmarkdown and ftpUpload
Published on 2019-05-16 in R
I just stumbled upon a new favorite function in R, the possibility to upload HTML files directly via FTP from the console. This means that you can create a script, extracting and cleaning data, then plot the relevant information and push it to a live web page on your domain, i.e. you can create a...
Create your own IMDB database in Google Cloud with R
Published on 2019-05-05 in R
Two of my biggest hobbies are watching movies/series and data. So not a big surprise that I wanted to get all the IMDB data into Google BigQuery. Once you have all the important data in BigQuery, you could easily search for anything you want to, e.g. movies that stars two of your favorite actors, getting...
Scheduling data imports in Google Cloud with RStudio – Part 2
Published on 2019-02-14 in R
Hopefully you just read the first part of this guide and are ready for implementing code on your virtual machine in order to schedule daily data imports to BigQuery. Authorizing access to applications First off we need to upload our JSON file to the machine. Simply click on “upload” in the file box in the...
Scheduling data imports in Google Cloud with RStudio – Part 1
Published on 2019-02-14 in R
This post will guide you through the setup process for setting up a scheduler in Google Cloud with RStudio. I will also show you two use cases for what data you can import to Google BigQuery; Google Analytics (free version) and Google Search Console. If you manage to get this to work then I bet...