KPI reporting (Key Performance Indicator reporting) is the process of collecting, tracking, and visualizing your most important business metrics — from marketing spend and conversion rates to revenue and customer lifetime value. It’s how teams understand whether their marketing and sales activities actually drive results. But here’s the problem: most companies still rely on manual […]
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 […]
What is BigQuery? A simple guide for beginners Many companies collect massive amounts of data from their e-commerce, advertising, website, and other channels – but few know how to analyze it in a smart way. This is where Google BigQuery comes in. In this guide, you’ll get a simple explanation of what BigQuery is and […]
Want to connect your Meta Ads data to Looker Studio without paying for expensive data integration tools like Supermetrics or Funnel? In this step-by-step guide, we’ll show you how to easily link your ad data using Ondigital’s custom Looker connector. No coding required, just the right data at a competitive price. 🧰 What You’ll Need: […]
Want to connect your Microsoft Ads data to Looker Studio without paying for expensive integration tools like Supermetrics or Funnel? In this step-by-step guide, we’ll show you how to quickly link your ad data using Ondigital’s custom Looker connector—no coding required, just the right data at a competitive price. 🧰 What You’ll Need: A Microsoft […]
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 […]
Delve into the realm of marketing mix modeling and unlock the secrets to crafting winning marketing strategies. Discover how this analytical approach empowers businesses to allocate resources effectively and stay ahead in today’s competitive landscape. In the dynamic world of marketing, success hinges on the ability to make informed decisions backed by data-driven insights. With […]
