Enjoy all the articles in the section “All articles”. Here you can read about Google Sheets, Looker Studio, Data Visualization online course, Digital marketing and find template overviews and useful tutorials!
If you’re building marketing dashboards in Looker Studio, choosing the right connector for Looker Studio makes a massive difference. I recorded a short video walkthrough where I compare the most popular Facebook Ads connectors for Looker Studio and explain which …
I usually write here about marketing analytics — dashboards, GA4, BigQuery.But today’s story is different. It’s about my first app that we built using AI tools. And yes, we built it in just two days. Last weekend, I joined an …
Can You Really Build an App in 48 Hours Using AI Tools? Read more →
If you’re working with GA4 data in BigQuery — welcome. It can feel overwhelming at first, but once you get a few core queries in place, everything starts making sense. I’ve put together 10 simple, reusable queries that I use …
How to Use SQL with GA4 in BigQuery: 10 Real Examples for Marketers Read more →
Facebook Ads Manager is messy. Long tables, unclear charts, and endless columns make it hard to understand what’s really working. That’s why more marketers and small businesses are turning to Looker Studio (formerly Google Data Studio) to build clear, visual …
3 Ways to Connect Facebook Ads to Looker Studio (2025 Guide + Free Template) Read more →
If you want to dive deeper into understanding which traffic sources bring the most users to your website, this tutorial is perfect for you. Using Google Analytics 4 (GA4) data in BigQuery, you can unlock detailed insights about your user …
BigQuery GA4 Users Sessions Tutorial: How to Identify Your Top Traffic Sources Read more →
If you have your Google Analytics 4 (GA4) data in BigQuery and want to automate running your queries daily, weekly, or hourly, this tutorial will guide you through the entire process. Scheduling queries in BigQuery can save you time and …
How to Automate GA4 Reports in BigQuery with Scheduled Queries Read more →
If you’ve set up your first GA4 export to BigQuery and want to dive deeper into your store’s purchase data, you’re in the right place. In this tutorial, I’ll walk you through how to query purchase revenue effectively using BigQuery …
How to Track GA4 Purchase Revenue in BigQuery (Made Simple) Read more →
Are you looking to track how many conversions your website gets by analyzing raw Google Analytics 4 (GA4) data directly in BigQuery? You don’t need complicated models or advanced machine learning techniques to do this. With just a simple condition …
BigQuery GA4 Conversions Tutorial: How to Count Events with Simple SQL Read more →
If you’ve ever wondered how to analyze your Google Analytics 4 (GA4) data by device type in BigQuery, you’re in the right place. Understanding whether your users come from desktop, mobile, or tablet devices is crucial for tailoring marketing strategies …
How to Filter GA4 Users by Device in BigQuery (Step-by-Step) Read more →
If you’ve ever wondered how to distinguish new users from returning users in your GA4 data within BigQuery, you’re not alone. By default, GA4 exports to BigQuery don’t provide this classification directly, but with a simple timestamp comparison, you can …
BigQuery GA4 Tutorial: Distinguish New and Returning Users Easily Read more →
0 items in the cart (0 €)