Skip to main content
Last updated: November 20, 2026

What Are Table Groups?

A table group is a collection of related tables for a single platform. Each table group belongs to one platform (e.g., Meta Ads, Google Ads, Shopify), and each table in the group defines a specific dataset to sync, with its own metrics, dimensions, filters, and sync settings. Think of a table group as a schema definition: “For Meta Ads, I want these 4 tables with these specific fields.” When you create a transfer, you bind a table group to a destination and a schedule.

Why Groups?

Table groups let you:
  • Reuse definitions: The same table group can be used by multiple transfers (e.g., sync the same tables for different accounts or to different destinations)
  • Organize logically: Group related tables together (campaign metrics + ad metrics + audience breakdowns)
  • Mix sync modes: When creating a transfer, you assign a sync mode to each table, so you can combine incremental daily metrics with full refresh settings data in one transfer

Creating a Table Group

  1. Go to Data Warehouse → Tables
  2. Click New Table Group
  3. Select the platform (e.g., Meta Ads, Google Analytics 4, Shopify)
  4. Choose your starting point:

Premade Presets

Detrics offers premade table groups with pre-configured metrics and dimensions for common use cases. Presets come in three tiers: You can customize any premade group after creating it, add or remove tables and change fields.

From Scratch

Start with an empty group and build each table manually. Best when you know exactly which fields you need or when working with platforms where premade presets don’t cover your use case.

Configuring Tables

Each table in a group maps to one BigQuery table. Here’s what you configure:

Table Name

The name that will be used for the BigQuery table. Must be unique within the table group. Names are converted to snake_case automatically (e.g., “Campaign Performance” becomes campaign_performance). If you set a table name prefix on the transfer (e.g., meta_ads_), the final BigQuery table name will be meta_ads_campaign_performance.

Metrics

Quantitative fields to include, the numbers you want to analyze. Examples:
  • Advertising: spend, impressions, clicks, conversions, ctr, cpc, cpm, roas
  • E-commerce: gross_sales, order_count, average_order_value, refund_amount
  • Analytics: sessions, total_users, new_users, bounce_rate, engagement_rate
  • Email: email_opens, email_clicks, unsubscribes, revenue_per_recipient
The field picker shows all available metrics for the selected platform, organized by category. Use the search bar to find specific fields quickly.

Dimensions

Categorical fields that define the granularity of your data, how rows are grouped. Examples:
  • Common: campaign_name, ad_name, date, country, device
  • E-commerce: product_title, product_type, order_status
  • Analytics: source_medium, landing_page, page_path
The dimensions you choose determine how many rows your table will have. Adding more dimensions creates more granular (and larger) tables. Start with the dimensions you actually need for analysis and add more later if needed.

Time Aggregation

How data is grouped over time:
Incremental sync mode (assigned at the transfer level) requires Daily time aggregation, or Hourly time aggregation on Meta Ads, Google Ads, Google Analytics 4 and Microsoft Ads. If you need weekly, monthly, or total aggregation, or hourly aggregation on another platform, use Full Refresh or Full Append.

Historical Sync Range

How far back to fetch data on the initial sync. Options: 1 month, 3 months, 6 months, 12 months, 24 months, or all time. Hourly tables also offer 7 days and 14 days. Hourly tables accept up to 1 month, and new hourly tables default to 14 days. Hourly tables that already had a longer range keep it. If you need a longer history, use a daily table.

Filters

Optional conditions to narrow the data. For example:
  • campaign_name CONTAINS "Brand": Only sync branded campaigns
  • spend GREATER_THAN 0: Only sync rows with actual spend
  • country EQUALS "US": Only sync US data
Available filter operators: Filters can be combined with AND or OR logic. The regex operators accept full regular-expression syntax only on GA4 and Google Ads; everywhere else they match a plain |-separated list of texts. See How Filters Work for details.
Filters are applied at the platform API level, not in BigQuery. This means filtered-out rows are never fetched or stored, reducing sync time and storage costs.

Data Preview

Before creating or saving a table, you can preview the data it will produce. Click Preview to fetch a sample of rows using the current configuration. This helps you verify that the right fields and filters are selected before running a full sync.

Editing Tables After Creation

You can edit any table at any time. Before saving, Detrics shows a change preview that classifies each change and warns you about its impact. Nothing happens to your BigQuery data at the moment you save. Every change is applied on the next run of each transfer that uses the table, so you can edit a table as many times as you like between runs; only the configuration at the time of the next run matters. Here’s what happens for each type of change:

What happens for each change

The exact behavior depends on the change and on the sync mode of the transfers using the table:

Why it works this way

Detrics never deletes your warehouse data. BigQuery has no undo, so instead of dropping a column (which would destroy its history forever), Detrics renames your existing table to <table>_archive_<UTC timestamp>_vN and creates a fresh one under the original name. The archive keeps working for queries and is never deleted automatically; it stays in your destination, counting toward your BigQuery storage, until you delete it yourself. Dimension changes re-download history because they change what each row represents. Rows at the old level of detail can’t mix with rows at the new one, so Detrics rebuilds the table and re-fetches the full historical range automatically. Incremental Dedup refreshes a rolling window of daily or hourly rows by deleting and reinserting them. Changing the aggregation under it would corrupt that window operation, which is why the change is blocked instead of silently accepted.

Configuration changes

These take effect on the next sync without any schema or data migration:
  • Changing filters: Applied on the next sync. For full data coherency with the new filters, run a historical resync manually.
  • Changing sync mode: Takes effect on the next sync.
  • Changing refresh window: Takes effect on the next sync.
  • Changing historical sync range: Takes effect on the next resync.
  • Changing platform-specific options: Applied on the next sync.

Several Transfers Writing One Table

Two or more transfers can write the same BigQuery table, for example one Meta table filled by transfers that cover different ad accounts. Each transfer writes its own accounts into the table. A table can be shared when the transfers use:
  • The same destination
  • The same table group and table
  • The same table name prefix
When you create a transfer, enable a table or change a prefix that would write a table another transfer already writes, Detrics shows which transfer it is and asks you to confirm with Share table. Tables shared with other transfers show a Shared with N transfers badge in the transfer’s Tables tab. How shared tables behave:
  • One transfer per account: an account can be written by only one transfer per table. In the account picker, accounts another transfer already writes to a shared table are greyed out.
  • All accounts transfers: an account selected explicitly in another transfer is skipped. Between two transfers that both sync all accounts, the older transfer keeps the shared account. Skipped accounts are listed in the run details.
  • One set of fields: every transfer uses the same table definition, so a field change applies to all of them. Transfers that need to reload history after the change do it on their next scheduled run.
  • Sync modes can differ: each transfer keeps its own sync mode. A Full Refresh replaces only that transfer’s accounts. Rows from the other transfers stay as they are.
  • Removed accounts and deleted transfers: their rows stay in the table, unless the only transfer left writing it uses Full Refresh.
Transfers from different table groups can’t share a table, even if the tables look identical today. A later field change in one group wouldn’t reach the other. Use a different table name prefix instead.

Duplicating and Copying

  • Duplicate a table group: Creates a copy of the entire group with all its tables, useful for creating variations (e.g., same fields but different filters)
  • Copy a table: Creates a copy of a single table within the same group or to a different group