If you’ve used Looker Studio for a while, you’ve probably searched for “Looker Studio slow” more than once. Slow loading reports, timeouts, errors, missing fields… it’s frustrating, and it’s easy to blame Looker Studio itself. But in most cases, Looker Studio is not the real problem. The real problem is how the data is connected. […]
https://www.youtube.com/watch?v=bLdZaPg47NU One thing I’ve seen many struggle with is YOY comparisons in Looker Studio. When setting the compare at period, looker defaults to comparing against the same “dates” the previous year. This becomes problematic. Because every year, week-days differ. For example 2025-11-27 (which is a Thursday) would compare against 2024-11-27 ( same date last year, […]
Our WooCommerce BigQuery connector allows you to fetch all the standard order, product, and customer data. But every WooCommerce store is unique — you might also store valuable information in meta fields. To make sure you can bring those insights into BigQuery, we’ve built support for custom fields. This guide will walk you through how […]
In a world where ecommerce data is scattered across platforms, campaigns, and tools, you need a solid foundation for analytics. For us, that foundation is Google BigQuery. Here are seven concrete reasons why we rely so heavily on BigQuery when building data solutions for our ecommerce clients: 1. We can recover lost or broken data […]
When you need to check if a text field exactly matches a specific pattern — not just contains it — REGEXP_MATCH() is the function you need in Looker Studio. Need a more flexible match function? Check out our guide on REGEXP_CONTAINS(). This guide explains exactly how REGEXP_MATCH() works, shows real-world use cases, common pitfalls to […]
When you need to search for patterns inside your data — not just exact matches — REGEXP_CONTAINS() is one of the most powerful functions you can use inside Looker Studio. If you want a guide on how to “exact match” a pattern, check out our guide on REGEXP_MATCH(). In this guide, you’ll learn exactly how […]
Ever wanted to reorganize your data in Looker Studio (previously Google Data Studio) with just a few simple lines? The CASE statement is exactly what you need. In this guide, we’ll break down how and why to use CASE, especially in an eCommerce setting. By the end, you’ll see how to group dimensional data in […]
How It Works (and Why You Should Care) In this guide, I’ll walk you through the concept of attribution and why it’s critical for online business owners and digital marketers. Attribution is basically the method we use to decide which channel deserves credit for a conversion. Sounds simple, right? The truth is, once you start […]
The best, most customisable and controllable method to add new feeds is by using dynamic feed links which contains your product data in XML format, as it’s widely used across most channels such as Meta, Google, Pinterest, TikTok and more. A dynamic XML feed is also always available online for your channels to read from, […]
In the realm of data analytics, presenting your data in a comprehensible and visually appealing manner is crucial. Looker Studio, a powerful tool for data visualization and business intelligence, offers various ways to format date dimensions to suit your reporting needs. This guide delves into the practical aspects of manipulating date formats in Looker Studio, […]
