BigQuery Connector

Sync Shopify Data to BigQuery

Detrics loads Shopify into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.

Book a Demo

*Free 30-minute consultation

SELECT
  sales_product_title,
  SUM(total_refunds) AS total_refunds,
  SUM(quantity_returned) AS quantity_returned,
  SUM(gross_sales) AS gross_sales
FROM `your_project.marketing_data.shopify_refund_analysis_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY sales_product_title
ORDER BY total_refunds DESC
LIMIT 10

Why send Shopify data to BigQuery?

Cohorts and LTV analysis

With transaction-level orders in SQL you can calculate LTV, repurchase rates, and cohorts no prebuilt dashboard gives you.

History without limits

Platform APIs cap how far back you can query. In BigQuery every Shopify sync is stored across its 13 tables, so you accumulate years of your own history.

One warehouse for everything

Join Shopify with the rest of your platforms in one place, no copy-pasting between sheets.

Ask Claude about it

With your data in BigQuery, Claude can answer business questions about Shopify in plain language.

Shopify tables in BigQuery

This is what Detrics creates for Shopify: 13 preset tables with scheduled syncs, plus any custom one you define.

Marketing & Traffic

marketing_attribution_daily

Sales by marketing channel and traffic source

first order sales channelfirst order traffic typeorder marketing event typegross salesnet salestotal orders+3

session_and_conversion_analysis_daily

Traffic and conversion funnel analysis

referrer sourcereferrer namelanding page typesessionsonline store visitorspageviews+5

traffic_referrer_analysis_daily

Analyze traffic sources and referrer performance

referrer sourcereferrer namelanding page typesessionsonline store visitorspageviews+3

Operations & Customers

customer_analysis_daily

Customer segmentation and cohort analysis

customer cohort monthrfm grouppredicted spend tiercustomersnew customersreturning customers+5

discount_performance_daily

Analyze discount code effectiveness

discount codediscount namediscount typegross salesnet salestotal discount+5

refund_analysis_daily

Track returns and refunds

sales return reasonsales product titlesales product typetotal refundsgross returnsnet returns+6

+1 more table in this group

Sales & Revenue

sales_overview_daily

Key financial metrics overview using ShopifyQL

store namegross salesnet salestotal orderscustomersaverage order value

sales_by_channel_daily

Channel performance breakdown

first order sales channelgross salesnet salestotal ordersnew customersreturning customers

store_financial_overview_daily

Complete financial metrics overview

store namegross salesnet salestotal salestotal orderstotal discount+4

+3 more tables in this group

HOW IT WORKS

From Shopify to your warehouse

Connect your account once. Detrics handles schemas, syncs, and backfills.

First step

Connect your first datasource

Link any of 32+ marketing and ecommerce platforms in a couple of clicks.

Connect a source

Second step

Set up your destination

Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.

Set up destination

Third step

Create your transfer

Choose what to sync and how often. Detrics builds and runs the pipeline for you.

Create a transfer

And that's it

Real-time data, forever

Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.

Book a demo

In the demo we set everything up for you and save you hours.

Then ask Claude about it

With Shopify in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

Compare my Shopify sales this quarter against last quarter

What was my average order value in Shopify over the last 30 days?

How many sales did Shopify record this month vs. last month?

Explore the Shopify MCP server

Every Shopify field, on demand

Preset tables curated by our team
Custom tables with any field combination
Incremental syncs that only load new data
Automatic backfill of up to 12 months of history

140 metrics

274 dimensions

View Shopify Fields

Get Shopify into your warehouse this week