All resources

OWOX Video

Useful video guides on analytics, data, warehousing & much more

Discover the most common data mistakes marketers make, from ignoring raw data quality to misreading attribution models, and learn how to avoid them.

5 Data Mistakes Even Smart Marketers Make All the Time

Marketing Analytics
→
Explore eight compelling reasons to export your GA4 data to BigQuery, from raw-hit-level access to advanced SQL analysis and longer data retention.

8 Reasons to Export GA4 Data to BigQuery

GA4
→
Start the 12-step data analytics roadmap with Stage 1: setting clear goals, asking the right questions, and identifying the key metrics that matter.

The Plan: Stage #1 of the Data Analysis Process

Data Analytics
→
Learn how to deliver actionable insights in stage four of data analysis, from visualization techniques to storytelling with data for stakeholders.

Delivering Insights: Stage #4 of the Data Analysis Process

Data Analytics
→
Learn to use the UNIQUE function in Google Sheets for extracting distinct values, removing duplicates, and combining UNIQUE with SORT, FILTER, and COUNTIF.

Mastering the UNIQUE Function in Google Sheets

Google Sheets Tips
→
Master stage three of data analysis: data preparation techniques including cleaning, transforming, and structuring raw data for meaningful insights.

Data Preparation: Stage #3 of the Data Analysis Process

Data Analytics
→
Unlock the full power of the QUERY function in Google Sheets with SQL-like syntax for filtering, sorting, aggregating, and pivoting your spreadsheet data.

Exploring QUERY Function in Google Sheets: The Full Guide

Google Sheets Tips
→
Understand SQL JOINs with visual examples: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, and UNION explained for beginners and pros.

Joining tables in SQL | INNER, LEFT, RIGHT, FULL JOIN, UNION

Data Analytics
→
Learn to use ARRAYFORMULA in Google Sheets to apply calculations across entire ranges, combine it with IF, SUMIF, and VLOOKUP, and avoid common pitfalls.

Mastering ARRAYFORMULA in Google Sheets

Google Sheets Tips
→
Explore stage two of the data analysis process: data collection methods, tools, and best practices for gathering accurate and complete datasets.

Data Collection: Stage #2 of the Data Analysis Process

Data Analytics
→
Discover the top five data analytics challenges businesses face and how to overcome them using a proven 12-step roadmap for actionable, reliable analytics.

Top 5 Problems Businesses Face in Data Analytics (And How to Overcome Them)

Data Analytics
→
An introduction to data analytics: key roles like analyst, engineer, and scientist, essential skills for the field, and how analytics transforms business.

What is Data Analytics?

Data Analytics
→
Master SQL subqueries with clear examples covering correlated and non-correlated subqueries, EXISTS, IN, and subqueries in SELECT, FROM, and WHERE clauses.

How to Use SUBQUERIES in SQL with Examples

SQL
→
Master VLOOKUP in Google Sheets with practical examples covering syntax, exact and approximate matches, error handling, and common use cases.

Everything About VLOOKUP in Google Sheets

Google Sheets Tips
→
Learn multiple methods to split cells in Google Sheets using SPLIT function, Text to Columns, REGEXEXTRACT, and other techniques with practical examples.

How to Split Cells in Google Sheets

Google Sheets Tips
→
Learn three ways to connect BigQuery to Google Sheets: the built-in connector, Apps Script, and OWOX Data Marts for automated, always-fresh reporting.

How to Connect BigQuery to Google Sheets

Google BigQuery
→
Continue learning SQL with Part 2: data types, CREATE TABLE, INSERT INTO, UPDATE, and DELETE statements explained with hands-on examples in 20 minutes.

Learn Basic SQL Queries in 20 minutes (Part 2) | Data Analytics for Beginners

SQL
→
Learn how primary and foreign keys link database tables, with best practices for key selection, common mistakes to avoid, and real-world SQL examples.

Linking Database Tables | Primary & Foreign Keys

SQL
→
Explore data warehousing fundamentals: what a warehouse is, whether your business needs one, and a comparison of BigQuery, Snowflake, Redshift, and Azure.

Why, When & Which Data Warehouse Is Perfect for Your Business Needs

Data Analytics
→
Learn how to build effective corporate reports in spreadsheets, from structuring dashboards to automating data pulls from your warehouse.

Corporate Reporting in Spreadsheets

Data Analytics
→
Learn what database queries are, how SQL works, essential SQL components, real-world query applications, and how AI tools help you write queries faster.

What is a Query?

SQL
→
Learn how to use ChatGPT to write SQL queries for BigQuery from scratch, including prompt engineering tips and best practices for accurate results.

How to Use ChatGPT To Write SQL Queries For BigQuery From Scratch

SQL
→
Start learning SQL from scratch in just 20 minutes. This beginner lesson covers SELECT, FROM, WHERE, ORDER BY, LIMIT, and basic filtering techniques.

Learn Basic SQL Queries in 20 minutes (Lesson 1) | Data Analytics for Beginners

SQL
→
Understand the GA4 event data schema in BigQuery, including nested fields, event parameters, user properties, and how to query them with SQL.

GA4 Events Data Schema in BigQuery

GA4
→
Learn how to write SQL queries against GA4 event data in BigQuery, including unnesting event parameters, filtering events, and building custom reports.

How to Query GA4 Event Data in BigQuery

GA4
→
Step-by-step guide to building a GA4 User Acquisition standard report in BigQuery using SQL, replicating the native GA4 interface with full flexibility.

How to Build a GA4 User Acquisition Standard Report in BigQuery

GA4
→
See how OWOX connects BigQuery to Google Sheets in one click for automated SQL-based reports, scheduled refreshes, charts, pivots, and team sharing.

OWOX BigQuery Reports Extension for Google Sheets

Google BigQuery
→
Understand Customer Lifetime Value, why LTV matters for marketing strategy, and practical steps to calculate and improve it for long-term business growth.

What is Customer Lifetime Value?

Data Analytics
→
Learn what data-driven marketing really means versus common misconceptions, and discover practical frameworks for becoming a more data-informed marketer.

What is data-driven marketing in 2024?

Marketing Analytics
→
Learn essential data analytics terminology including dimensions, metrics, sessions, events, attribution, and more in this beginner-friendly video guide.

8 Data Analytics Terms Everyone Should Know

Data Analytics
→
Understand why data freshness is critical for decisions in 2024, how stale data leads to missed opportunities, and strategies to keep analytics current.

The Critical Role of Data Freshness in 2024

Data Analytics
→
Understand the difference between metrics and dimensions, how they relate to KPIs, and how to use them for measuring marketing campaign success.

What Are Metrics & Dimensions?

Marketing Analytics
→
Learn what marketing KPIs are and get seven actionable tips for choosing the right performance metrics, from lifetime value to sales funnel analysis.

What Are KPIs? 7 TIPS For Defining YOURS

Marketing Analytics
→
Explore seven practical use cases for server-side tracking, from improving data accuracy and ad performance to bypassing ad blockers and boosting privacy.

Top 7 Use Cases of Server-Side Tracking

Marketing Analytics
→
Understand why server-side tracking is replacing client-side pixels, how it improves data accuracy, and what it means for privacy-first analytics.

Beyond Pixels: Server-Side Tracking in 2024

Marketing Analytics
→
Explore how marketing mix modeling and attribution are evolving in 2024, with strategies for optimizing spend and measuring performance across channels.

Marketing Mix Modeling

Marketing Analytics
→
Explore what business intelligence looks like in 2024, how BI benefits marketing, and the evolving landscape of data-driven decision-making for teams.

What is Business Intelligence in 2024?

Data Analytics
→
Compare client-side and server-side tracking across eight key dimensions including data accuracy, privacy compliance, and implementation complexity.

Client-side Tracking vs Server-side Tracking. 8 main differences

Marketing Analytics
→