> ## Documentation Index
> Fetch the complete documentation index at: https://support.detrics.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Introduction

> Sync your marketing data directly into Google BigQuery with Detrics Data Warehouse

<Info>**Last updated:** March 18, 2026</Info>

Detrics Data Warehouse syncs your marketing, e-commerce, and analytics data directly into **Google BigQuery**. The data lands in 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?

<CardGroup cols={2}>
  <Card title="SQL-Native Analysis" icon="database">
    Query your marketing data with standard SQL. Join campaigns across platforms,
    build custom attribution models, or feed dashboards with live warehouse data.
  </Card>

  <Card title="Your Data, Your Project" icon="lock">
    Data lands in your own GCP project and BigQuery dataset. You own it, you
    control access, and you decide how long to keep it.
  </Card>

  <Card title="Claude-Ready Data" icon="robot">
    Connect your warehouse to Claude via MCP.
    Your marketing data is always structured and ready for AI analysis.
  </Card>

  <Card title="Scale Without Limits" icon="chart-line">
    BigQuery handles petabytes. Whether you have 5 ad accounts or 500, your
    queries stay fast and your storage scales automatically.
  </Card>
</CardGroup>

## 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**](https://app.detrics.io/datasources). 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

<AccordionGroup>
  <Accordion title="Three Sync Modes" icon="arrows-rotate">
    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.
  </Accordion>

  <Accordion title="Flexible Scheduling" icon="clock">
    Sync as often as every hour or as infrequently as monthly. Set the exact hour, day of week, or day of month, all in your timezone.
  </Accordion>

  <Accordion title="Per-Table Configuration" icon="sliders">
    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.
  </Accordion>

  <Accordion title="Consistent Column Naming" icon="text-size">
    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.
  </Accordion>

  <Accordion title="Custom Fields" icon="puzzle-piece">
    Platforms like GA4, Meta Ads, and Klaviyo support custom dimensions and conversion metrics. Detrics discovers and syncs them alongside standard fields.
  </Accordion>

  <Accordion title="Real-Time Progress" icon="signal">
    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.
  </Accordion>
</AccordionGroup>

## What's Next?

<CardGroup cols={2}>
  <Card title="Quickstart Guide" icon="rocket" href="/bigquery/quickstart">
    Set up your first BigQuery sync in under 10 minutes, from destination to your first query.
  </Card>

  <Card title="Core Concepts" icon="book" href="/bigquery/how-detrics-syncs-work">
    Understand how the sync pipeline works, what sync modes mean, and how Detrics manages your data.
  </Card>
</CardGroup>