BigQuery Connector

Sync Mercado Libre Organic Data to BigQuery

Detrics loads Mercado Libre Organic 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_id,
  SUM(order_total_amount) AS order_total_amount,
  SUM(order_paid_amount) AS order_paid_amount,
  SUM(order_total_quantity) AS order_total_quantity
FROM `your_project.marketing_data.mercado_organic_recent_orders`
GROUP BY order_id
ORDER BY order_total_amount DESC
LIMIT 10

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

One warehouse for everything

Join Mercado Libre Organic 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 Mercado Libre Organic in plain language.

Mercado Libre Organic tables in BigQuery

This is what Detrics creates for Mercado Libre Organic: 4 preset tables with scheduled syncs, plus any custom one you define.

Seller & Sales Performance

reputation_snapshot

Seller's current standing on Mercado Libre

account IDaccount namereputation leveluser pointstotal transactionscompleted transactions+7

top_items_by_sold_quantity

Catalog ranked by lifetime sold quantity per item

item IDitem titleitem statusitem priceitem available quantityitem sold quantity+5

recent_orders

Order list for the selected period

order IDorder date createdorder statusorder total amountorder paid amountorder total quantity+5

+1 more table in this group

HOW IT WORKS

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

What was my average order value in Mercado Libre Organic over the last 30 days?

How many sales did Mercado Libre Organic record this month vs. last month?

Which Mercado Libre Organic products got the most orders this week?

Explore the Mercado Libre Organic MCP server

Every Mercado Libre Organic 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

51 metrics

73 dimensions

View Mercado Libre Organic Fields

Get Mercado Libre Organic into your warehouse this week