BigQuery Connector

Sync Google Business Profile Data to BigQuery

Detrics loads Google Business Profile 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
  location_name,
  SUM(views_total) AS views_total,
  SUM(views_maps) AS views_maps,
  SUM(views_search) AS views_search
FROM `your_project.marketing_data.google_business_profile_performance_overview_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY location_name
ORDER BY views_total DESC
LIMIT 10

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

One warehouse for everything

Join Google Business Profile 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 Google Business Profile in plain language.

Google Business Profile tables in BigQuery

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

Performance & Visibility

performance_overview_daily

Key visibility and action metrics by location

location namelocation IDviews totalviews mapsviews searchactions website+2

location_details

Location information with performance indicators

location namelocation address localitylocation address countryviews totalreview avg star rating+5

daily_performance_trend_daily

Daily views and website clicks over time

location namelocation IDviews totalactions website

Reviews & Keywords

review_summary

Review counts and ratings by location

location namereview reviewer namereview star ratingreview total countreview avg star rating+2

search_keywords

Top search keywords driving impressions

location namesearch keywordslocation IDsearch impressions

HOW IT WORKS

From Google Business Profile 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 Google Business Profile 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.

Summarize my Google Business Profile data for the last 6 weeks

Traffic dropped this week according to Google Business Profile. Find out why.

Which pages lost the most visits in Google Business Profile this month?

Explore the Google Business Profile MCP server

Every Google Business Profile 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

23 metrics

82 dimensions

View Google Business Profile Fields

Get Google Business Profile into your warehouse this week