BigQuery Connector

Sync Salesforce Data to BigQuery

Detrics loads Salesforce 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
  opportunity_lead_source,
  SUM(opportunity_count) AS opportunity_count,
  SUM(opportunity_amount) AS opportunity_amount,
  SUM(opportunity_expected_revenue) AS opportunity_expected_revenue
FROM `your_project.marketing_data.salesforce_won_revenue_by_lead_source_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY opportunity_lead_source
ORDER BY opportunity_count DESC
LIMIT 10

Why send Salesforce data to BigQuery?

Historical pipeline

Snapshots of every pipeline stage to analyze close velocity and real stage-to-stage conversion.

History without limits

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

One warehouse for everything

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

Salesforce tables in BigQuery

Our team sets these up with you during onboarding: 5 preset tables with scheduled syncs, plus any custom one you define.

Sales & Opportunities

sales_rep_performance_daily

Opportunity totals per rep

opportunity owner nameopportunity stage nameopportunity is wonopportunity countopportunity amountopportunity expected revenue+1

won_revenue_by_lead_source_daily

Revenue attribution by lead source

opportunity lead sourceopportunity typeopportunity stage nameopportunity countopportunity amountopportunity expected revenue+3

revenue_by_product_daily

Line-item revenue per product

opportunity line item product nameopportunity line item product codeopportunity line item opportunity nameopportunity line item countopportunity line item quantityopportunity line item unit price+1

+1 more table in this group

Marketing & Leads

campaign_roi_daily

Campaign budget vs won-deal revenue

campaign namecampaign typecampaign statuscampaign budgeted costcampaign actual costcampaign amount all opportunities+7

HOW IT WORKS

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

How long does a deal take to close on average in Salesforce?

Which rep closed the most revenue in Salesforce this quarter?

How many new opportunities did Salesforce record this month?

Explore the Salesforce MCP server

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

48 metrics

329 dimensions

View Salesforce Fields

Get Salesforce into your warehouse this week