If you are building dashboards in and and tool like Tableau, Power BI you will be tempted to query the Google Analytics API directly using some built-in connector. This might seem really nice for a while, until you discover sampling, the distinct count challenge, retroactive changes to goals. In this series I will try to …
If you have received a notification from Google regarding sunsetting Google Analytics Services SDKs you will need our help to extract all your data before January 31, 2020. The reason you need our help is that Scityana is the only ETL that can extract raw data from the Google Analytics API, which is what you …
This Blogpost is for you, if you are considering switching from Google Analytics to Firebase Analytics, but are worried about losing years of valuable data in the process. What’s the big deal you ask? Well for those of us, who already know the power of raw data, it is a relief that Firebase Analytics will …
Firebase Analytics – Get started without loosing your historical Google Analytics data Read More »
So maybe you already heard the news, but if you havent’ we are happy to tell you that you are now able to extract the ClientID as hit-level data historically with Scitylana. Basically this means that getting hit-level data has never been easier for you and this open up a world of opportunities. One of …
Stop talking about attribution modelling! Aaargh! I need to blow off some steam and if I’m alone with this, I apologize for making you curious about, what all the yelling is for! So why am I yelling?, well I’ve just finished a conference call, between me, a client and a self-proclaimed data-driven, machine-learning, AI specialized …
Facebook Ad, Pages and Instagram Insights: Change login/credentials in Power BI Leave a Comment / connector, Power BI / By Michael Frost Billing How do I change the credentials or Facebook account/login in Microsoft Power BI, when I use one of the the Scitylana Facebook/Instagram connectors? This article applies to the connectors: Facebook Ad Insights Facebook Page Insights Instagram Insights …
Facebook Ad, Pages and Instagram Insights: Change login/credentials in Power BI Read More »
Marketing Attribution Previously I wrote about applying Markov Model Attribution using R on a Google Analytics click-stream data-set in BigQuery to find which campaign initiatives comes out with best performance.Shapley Value is another similar Machine Learning algorithm that is very popular for calculating the worth of a campaign.Attribution becomes important if you spend a lot of …
Funnel Based Attribution in a single SQL statement in BigQuery Read More »
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 …
R: Applied Markov attribution for Google Analytics Free using Scitylana and BigQuery Read More »
The role of leadership and strategy in digital transformation Leave a Comment / Digital strategy, Digital transformation / By Christian Vermehren 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 …
The role of leadership and strategy in digital transformation Read More »
How long does it take Google Analytics to delete a user’s data from a property? 1 Comment / ga connector, Investigation / By Michael Frost Billing 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 …
How long does it take Google Analytics to delete a user’s data from a property? Read More »
