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 …
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! 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 »
SCITYLANA: “Hello BigQuery” The clouds are coming in… Well, it means we can extract hit-level / not sampled data from your favorite FREE GA view and upload it automatically to your BigQuery project. Just like the big boys do with GA 360 but just less expensive. Swoosh… ! It updates the data automatically behind the scenes every morning. And …
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! 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 …
Visualize your raw GA data instantly with this Power BI template Leave a Comment / Uncategorized / By Christian Vermehren 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 …
Visualize your raw GA data instantly with this Power BI template Read 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 …
ase your campaigns on facts instead of feelings. Combine your data sources in MS Power BI. Get to know the whole funnel – from source to conversion. Load raw Google Analytics data in Power BI through Scitylana Load online campaign data from Facebook etc. Once loaded, find the fields that your various data sources have in …
Marketing-to-sales funnel insights finally made easy! Read More »
When I test a SCITYLANA implementation for one of our customers I start out by checking the front page of the site in question and investigate what is sent to Google Analytics. I expect to find a custom dimension with a special SCITYLANA value set. We say it’s tagged with SCITYLANA. In this post I …
What if I could just Ctrl+Copy ALL of my Google Analytics data and Ctrl+Paste them anywhere I would like? That would be great, certainly fun and probably very powerful! Well… some people have already been doing this for a while. The challenge: GA data are aggregated and not super suited for moving anywhere else. I’m …
