Skip to main content
Last updated: March 18, 2026
Detrics Data Warehouse syncs your marketing, e-commerce, and analytics data directly into Google BigQuery — your own dataset, in your own GCP project, on your own terms. You choose exactly which metrics, dimensions, and platforms to sync. Detrics handles the pipeline: fetching data from platform APIs, normalizing column names, deduplicating rows, and loading everything into BigQuery on a schedule you define.

​
Why BigQuery?

SQL-Native Analysis

Query your marketing data with standard SQL. Join campaigns across platforms, build custom attribution models, or feed dashboards with live warehouse data.

Your Data, Your Project

Data lands in your own GCP project and BigQuery dataset. You own it, you control access, and you decide how long to keep it.

Cross-Platform Joins

Combine Meta Ads spend with Shopify revenue, Google Analytics sessions with Google Ads clicks, or any other combination — all in one SQL query.

Scale Without Limits

BigQuery handles petabytes. Whether you have 5 ad accounts or 500, your queries stay fast and your storage scales automatically.

​
What Makes Detrics Different

Detrics is purpose-built for digital marketing agencies and e-commerce teams. Unlike general-purpose ETL tools that connect hundreds of data domains, Detrics focuses exclusively on the platforms modern marketing teams actually use:
  • Advertising — Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, X Ads, Pinterest Ads, Bing Ads, Mercado Ads, Google DV360
  • Analytics & SEO — Google Analytics 4, Google Search Console
  • Social Media — Instagram Insights, Facebook Insights, Facebook Public Data, TikTok Organic
  • Email Marketing — Klaviyo, Mailchimp
  • CRM — HubSpot
  • E-commerce — Shopify, TiendaNube, WooCommerce, Google Merchant Center
  • Payments — Stripe
This focus means deeper integration with each platform: proper attribution windows for ad platforms, entity-level data for CRMs, product-level detail for e-commerce, and custom field support where platforms offer it. You control exactly what data flows into your warehouse — which metrics, which dimensions, which filters, and which sync strategy. This is an ETL approach: you extract the data you need, transform it with normalized column names and deduplication, then load it into BigQuery ready for analysis.

​
How It Works

The Detrics Data Warehouse pipeline has four main components: 
1. Data Sources (your connected platforms)
        ↓
2. Table Groups & Tables (what data to fetch, how to structure it)
        ↓
3. Transfers (schedule, accounts, destination binding)
        ↓
4. Destination (your BigQuery dataset)
  1. Connect your platforms — Use the same OAuth connections you already have in Detrics (Meta, Google, Shopify, etc.)
  2. Define your tables — Pick metrics and dimensions, set filters, and configure time aggregation
  3. Create a transfer — Bind a table group to a destination, select accounts, and set a sync schedule
  4. Query in BigQuery — Your data appears in clean, snake_case tables with consistent column naming across all platforms

​
Key Capabilities

Choose how each table syncs: Incremental (append and deduplicate by date), Full Refresh (replace the entire table), or Full Append (append snapshots for historical tracking). Each mode serves different analysis needs.
Sync as often as every hour or as infrequently as monthly. Set the exact hour, day of week, or day of month — in your timezone.
When creating a transfer, you assign a sync mode to each table — so one transfer can mix daily campaign metrics (incremental) with campaign settings (full refresh). Each table also has its own refresh window, time aggregation, filters, and historical range.
All column names are normalized to snake_case across every platform. No more campaign.name vs campaignName vs CAMPAIGN_NAME — write cross-platform SQL without worrying about naming conventions.
Platforms like GA4, Meta Ads, and Klaviyo support custom dimensions and conversion metrics. Detrics discovers and syncs them alongside standard fields.
Watch your transfers sync in real time. See which table is loading, how many rows have been processed, and track progress across chunks for large syncs.

​
What’s Next?

Quickstart Guide

Set up your first BigQuery sync in under 10 minutes — from destination to your first query.

Core Concepts

Understand how the sync pipeline works, what sync modes mean, and how Detrics manages your data.