BigQuery Connector

Sync Adobe Analytics Data to BigQuery

Detrics loads Adobe Analytics 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
  campaign,
  SUM(orders) AS orders,
  SUM(revenue) AS revenue,
  SUM(visits) AS visits
FROM `your_project.marketing_data.adobe_analytics_campaign_performance_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY campaign
ORDER BY orders DESC
LIMIT 10

Why send Adobe Analytics data to BigQuery?

Unsampled data

Query complete events with SQL, free of the sampling and cardinality limits of the web interface.

History without limits

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

One warehouse for everything

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

Adobe Analytics tables in BigQuery

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

Acquisition

traffic_sources

Visits by referrer type

referrer typevisits

Content

top_pages_daily

Visits and page views by page

pagevisitspage views

Geo

visits_by_country

Visits by country

geo countryvisits

Marketing

campaign_performance_daily

Visits, orders and revenue by campaign

campaignvisitsordersrevenue

Search

search_keywords

Visits by search keyword

search engine keywordvisits

HOW IT WORKS

From Adobe Analytics to your warehouse

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

First step

Connect your first datasource

Link any of 37+ 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 Adobe Analytics in BigQuery, the Detrics MCP server lets you manage your warehouse and run queries in plain language. MCP access is included with every BigQuery plan.

What were my top traffic sources in Adobe Analytics this month?

Compare my Adobe Analytics page views against last quarter

Which page converts best according to Adobe Analytics?

Explore the Adobe Analytics MCP server

Every Adobe Analytics 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

13 metrics

66 dimensions

View Adobe Analytics Fields

Get Adobe Analytics into your warehouse this week