Data Warehouse Reporting

BigQuery Can Reconstruct the AI Traffic GA4 Hides

by

GA4’s channel classification discards referrer data that BigQuery’s raw event export preserves. The collected_traffic_source record and page_referrer event parameter contain the original source information for every session — including AI-referred visits that GA4 dumped into Direct. A SQL query against the BigQuery export can surface AI traffic that the GA4 interface will never show. Loamly found 70.6% of AI sessions arrive without referrer headers, but BigQuery also enables behavioural pattern matching — landing page analysis, session timing, and engagement fingerprints — to probabilistically identify AI-driven visits even when the referrer is genuinely absent.

GA4’s 14-Month Wall: Why BigQuery Export Is Your Only Year-Over-Year

by

GA4 deletes event-level data after 14 months at most, and the default is just 2 months, so year-over-year comparisons in Explorations quietly break. The retention limit hits Exploration and funnel reports, not standard aggregated reports. Because GA4’s BigQuery export does not backfill any history, the only durable fix is to enable export before you need the data, so events flow into BigQuery and persist with no retention limit. For most small WooCommerce stores the cost runs under 5 dollars a month, making BigQuery the practical home for long-term analysis.

Stop Building Dashboards. Start Having Conversations With Your Data.

by

70% of analytics dashboards are rarely or never used after the first month (Gartner). Dashboards answer the questions you thought to ask when you built them — not the question you have right now. Conversational analytics, powered by an AI model like Claude querying your BigQuery event data directly, inverts this. Any question, same day, zero technical knowledge required. For WooCommerce operators who are constantly pivoting — new products, new markets, new channels — the fixed dashboard has become the enemy of insight. The moment store owners discover they can just ask, the dashboard era ends for them.

BigQuery for WooCommerce: Your Data Warehouse Costs Less Than You Think

by

BigQuery eliminates every GA4 limitation WooCommerce store owners face—data thresholds that hide small-store insights, sampling that distorts reports, and consent gaps that create blind spots. Google offers 1TB of free BigQuery processing per month (Google Cloud, 2025), making data warehousing accessible to stores of any size. GA4’s built-in BigQuery export exists but introduces sampling and 24-48 hour delays. Server-side tracking direct to BigQuery provides complete, unsampled, real-time data. Combined with Looker Studio’s native BigQuery connection, store owners get unlimited custom dashboards built on data they fully own.