Michael Billing

Facebook Ad, Pages and Instagram Insights: Change login/credentials in Power BI

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 »

Funnel Based Attribution in a single SQL statement in BigQuery

Funnel Based Attribution in a single SQL statement in BigQuery Previously I wrote about applying Markov Model Attribution calculations on a Google Analytics click-stream data-set in BigQuery. 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

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

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?

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 »

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

Tap into the power of segmentation with hit-level Google Analytics data! Leave a Comment / DAX, Power BI, Segmentation / By Christian Vermehren 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, …

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

Retroactive goals with your raw Google Analytics data

Retroactive goals with your raw Google Analytics data Leave a Comment / DAX, Power BI / By Christian Vermehren Goals in Google Analytics are not retroactive. They only start showing data once you have configured them. So, if you forget to set them up, this will happen: But don’t despair! If you have downloaded your raw GA data with Scitylana, you can …

Retroactive goals with your raw Google Analytics data Read More »

Why Google Analytics connectors are useless

Why Google Analytics connectors are useless! Users of dashboard tools using built-in Google Analytics connectors (like Power BI and Tableau) having trouble understanding what the numbers really mean – and why they differ from the Google Analytics dashboard. TL;DR The reports from Google Analytics API are already aggregated, DON’T aggregate the result again inside Power BI, Tableau etc. Get raw …

Why Google Analytics connectors are useless Read More »

// Type writer effect