R: Applied Markov attribution for Google Analytics Free using Scitylana and BigQuery

This blog post is all about showing how powerful click-stream data is. Especially when you put the data in BigQuery or any other C-store based OLAP warehouse with separated compute and storage. BigQuery at the time of writing offers 10 GB of free storage and 1 TB/month of free Query – for life (yes, that …

R: Applied Markov attribution for Google Analytics Free using Scitylana and BigQueryRead More »

The role of leadership and strategy in digital transformation

We live in a rapidly changing world. Every part of our society is undergoing fundamental transformation driven by a fast-paced digital revolution. The revolution started more than a decade ago but is now accelerating and becoming more and more overwhelming. We feel it especially in the business world. New business models are wreaking havoc across …

The role of leadership and strategy in digital transformationRead More »

How long does it take Google Analytics to delete a user’s data from a property?

We at Scitylana are curious about how long it takes for Google Analytics to clean up after a user requests deletion of data. We set out to test it. Expecting it could take days  – we will be testing once every day. Since we have the Scitylana plugin installed we have a Google Analytics clientId …

How long does it take Google Analytics to delete a user’s data from a property?Read More »

How we handle GDPR article 17 requests using Google Tag Manager and email?

FYI: Also try our GDPR Delete tool We needed an easy way to delete users from our Google Analytics Free to comply with GDPR article 17 and we wanted it to be as easy as possible. We succeeded and decided to make it easy for you as well – and yes it is free, but …

How we handle GDPR article 17 requests using Google Tag Manager and email?Read More »

Tap into the power of segmentation with hit-level Google Analytics data!

Success in marketing is all about matching the right content with the right audience. You need segmentation for this. Segmentation is what allows you to zoom in on your target group. It allows you to identify, then target, high-performing users whilst at the same time improving or removing low performers. Measuring the total conversion rate …

Tap into the power of segmentation with hit-level Google Analytics data!Read More »

Why Google Analytics connectors are useless

I see many users of graphical dashboard tools using built-in Google Analytics connectors (like Power BI, QlikView, and Tableau) having trouble understanding what the numbers really mean – and why they differ from the Google Analytics dashboard. Maybe you’ve had the same frustrating experience as many others: A user of Tableau reports a “mismatch” between GA …

Why Google Analytics connectors are uselessRead More »

Visualize your raw GA data instantly with this Power BI template

Okay, so you’ve implemented SCITYLANA and pulled out loads of nice hit-level data from your Google Analytics account. Now you want to put all that data to impressive use! But what to focus on and how to get started? Use this free Power BI template Although SCITYLANA works with all sorts of tools (BigQuery, Data …

Visualize your raw GA data instantly with this Power BI templateRead More »

The Cost of Sampling in Google Analytics

Recently, Jonathan Weber at LunaMetrics wrote a great post regarding the accuracy of Google Analytics sampling, revealing how users shouldn’t just take it at face value but also check for potential inaccuracies. Weber shows that while sampling works well for overall trends on your website, it can become very inaccurate. One good example of this is when you’re looking …

The Cost of Sampling in Google AnalyticsRead More »