BigQuery Connector

Sync Tiendanube Data to BigQuery

Detrics loads Tiendanube 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
  order_billing_country,
  SUM(order_total) AS order_total,
  SUM(order_total_usd) AS order_total_usd,
  SUM(order_subtotal) AS order_subtotal
FROM `your_project.marketing_data.tiendanube_customer_geographic_revenue_analysis_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY order_billing_country
ORDER BY order_total DESC
LIMIT 10

Why send Tiendanube 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 Tiendanube sync is stored across its 10 tables, so you accumulate years of your own history.

One warehouse for everything

Join Tiendanube 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 Tiendanube in plain language.

Tiendanube tables in BigQuery

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

Operations & Shipping

order_fulfillment_analysis_daily

Order status progression with shipping details

order numberorder statusorder shipping statusorder totalorder total productsorder shipping cost customer+3

customer_contact_and_marketing_attribution_daily

Customer contact and marketing attribution

order numberorder created atorder UTM sourceorder totalorder total productsorder discount+5

payment_processing_and_settlement_analysis_daily

Payment methods, timing, and settlement status

order numberorder created atorder paid atorder totalorder subtotalorder discount+3

+1 more table in this group

Sales & Orders

daily_sales_performance_daily

Daily revenue and order volume trends

store name esorder totalorder total products

utm_campaign_performance_daily

Marketing campaign revenue attribution

order numberorder UTM sourceorder UTM campaignorder totalorder total products+4

customer_geographic_revenue_analysis_daily

Revenue distribution across customer locations

order numberorder shipping provinceorder shipping cityorder totalorder total usdorder subtotal+3

+3 more tables in this group

HOW IT WORKS

From Tiendanube 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 Tiendanube in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

Which order UTM source drives the most revenue in my store?

Compare my Tiendanube sales this quarter against last quarter

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

Explore the Tiendanube MCP server

Every Tiendanube 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

20 metrics

157 dimensions

View Tiendanube Fields

Get Tiendanube into your warehouse this week