AWS DevOps Terraform

AWS Neptune with Terraform

I’ve prepared a small example on setting up AWS Neptune with Terraform at github.com.   I might post a complete guide in the future, for now, just a bunch of bullet points for using AWS Neptune with that example: The AWS Neptune instance will be launched into some VPC (of course) You can’t access AWS Neptune from your computer, even if the VPC has an internet gateway enabled OR you have some kind of tunnel. You…

Continue reading

Uncategorized

Terraform and Terratest for AWS Example

Gruntworks open-sourced their terraform, docker, packer etc. testing framework and I simply find it amazing. To my knowledge, there is nothing comparable out there. Let’s take a look at a simple example. You can find the code at https://github.com/datacisions/terraform-examples. What we will do: Write a terratest to check whether a particularly labeled EC 2 instance is there;  Run it an see it fail; Write the terraform code necessary to make it pass, to deploy the instance and…

Continue reading

Uncategorized

Data Studio Hack – Joining Author Data in Google Sheets for Google Data Studio

Let’s join Google Analytics with author data in Google Sheets, to display it nicely in Google Data Studio. Why? I write, so I’m naturally interested in evaluating content heavy websites. Content analysis usually consists of two parts: Looking at the data from the platform on which you distribute your content, e.g. your blog (who reads what, and how often?) Looking at the meta-data of your content (which topic, who wrote this, when, how long is…

Continue reading

Uncategorized

AWS S3 Bash Unit Testing Using localstack

Localstack is an awesome idea. It’s a locally run AWS mocking environment. It’s a cool thing to have if you’re developing an AWS based application. However, I stumbled across localstack because I was looking for ways to unit test my infrastructure. Even if cloud infrastructure is super fast compared to the “old school” way of infrastructure, for developing, it’s still pretty slow (try turning on and off a Redshift DB a couple of times just…

Continue reading

Uncategorized

SEO Dos and Don’ts of global SEO

I care about global SEO. And, if you’re working in any kind of globally active company, you should too. But let’s rewind a little bit and paint a picture of what your website is probably like. Before we get into what the goal of global SEO really is. The contents of this post: The Global Website in a Picture Google as a Cannon The Goal and Problem of Global SEO Confusing the Cannoneer DO Have…

Continue reading

Uncategorized

Data Studio Hack – Get a Filter Control to Apply on Multiple Data Sources

Suppose you have multiple data sources in one Google Data Studio report. Of course, you’d like to filter either on the date or on campaign sources, or input devices or whatever. And of course, you’d like to have one filter control to filter all your tables, hence the complete report. Currently, this is a little tricky in Google Data Studio and all hinges on the so-called “field ID” (This post an in-depth explanation of the…

Continue reading

Uncategorized

Data Studio Hack – Connecting to the WordPress mySQL Database

I am amazed at how little attention the new Google Data Studio has gotten. I’ve been working with complex systems out there; There are a ton of “data studios” which are extremely complex and need trained people to operate and deliver something, usually not that pretty, on the screen. The Google Data Studio is simple and offers great integration of the default data sources, especially Google Analytics. However, it’s not limited to Google data. And…

Continue reading

Uncategorized

GTM Hack – Mouseflow Tag in Google Tag Manager and Experiment Data

I’ve already covered one third-party tag in Google Tag Manager and today I’d like to cover the second one. It’s the Mouseflow Tag. Mouseflow basically records and evaluate the actual mouse & click flow of your website visitors. It immensely useful in evaluating user experience on a qualitative level. But the tag isn’t as straightforward to implement as I thought at first; at least not, if you want to have the tag, push some data…

Continue reading

Uncategorized

Brand Residue – Google Just Changed My Title Tag

“Help! Google changes my title tag.” Sounds familiar? To me it does. I got that call a bunch of times already, and I got it just yesterday in a new and interesting situation, namely in a rebranding. I’d like to focus on this specific situation because in a company rebranding, this topic is pretty important. After all, how do you want to rebrand, if Google won’t let you? Companies change their name, not often, but…

Continue reading

Uncategorized

GTM Hack – Assigning UA IDs Based on Subdirectories using RegEx Tables in GTM

There’s a new cool feature in GTM called a RegEx Table variable. Here’s a simple use case. Suppose your website has subdirectories for each language version. So you’d have website.com/en/with English content website.com/fr/with French content website.com/zh/with Chinese content. For many purposes it’s useful to track those websites in different Google Analytics properties. Now using a RegEx Table variable this has become pretty simple. Where you’d previously either had to create many multiple tags (copies of…

Continue reading