--- title: "Google Ads to Databricks Connector | OWOX" canonical: "https://www.owox.com/connectors/free-google-ads-connector-to-databricks" updated: "2026-10-29" --- # Bring Google Ads data into Databricks Load Google Ads campaigns, ad groups, ads and keywords into Databricks with OWOX Data Marts: one table per endpoint in your catalog, a readable schema, a scheduled refresh. Join search spend with web analytics and CRM to see which campaigns led to deals. ![](https://cdn.owox.com/www/portfolio-management-connectors/free-google-ads-connector-to-aws-athena/icon/1.svg/public)Google Ads · Connected · Ad Group Ads Sta… · Ad Groups · Ad Groups Stats · Campaigns Data Mart · Published · one definition ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Databricks · Date · Cost · ClicksDaily 09:00 Refreshed on a schedule. No exports, no copy-paste. [Get Started Free](https://www.owox.com/app-signup) ## Endpoints ## Google Ads Endpoints [Documentation](https://docs.owox.com/packages/connectors/src/sources/google-ads/readme/) 9 Google Ads endpoints you can import. Each lands in its own table in your data warehouse. * [Ad Group Ads Stats Daily performance for individual ads — impressions, clicks, cost, and conversions. 27 fields · Time series](/data-sources/google-ads#schema-ad-group-ads-stats) * [Ad Groups Your ad group settings — type, status, and bid configuration within each campaign. 9 fields](/data-sources/google-ads#schema-ad-groups) * [Ad Groups Stats Daily ad group performance — impressions, clicks, cost, and conversions. 24 fields · Time series](/data-sources/google-ads#schema-ad-groups-stats) * [Campaigns Your campaign settings — channel type, bidding strategy, budget, and scheduling. 11 fields](/data-sources/google-ads#schema-campaigns) * [Campaigns Stats Daily campaign performance — impressions, clicks, cost, and conversions. 28 fields · Time series](/data-sources/google-ads#schema-campaigns-stats) * [Criterion Ad group targeting criteria — keywords, placements, and negative exclusions with bid settings. 18 fields](/data-sources/google-ads#schema-criterion) * [Geo Stats Daily performance by country and targeting type — impressions, clicks, cost, and conversions. 18 fields · Time series](/data-sources/google-ads#schema-geo-stats) * [Geo Target Constants Reference table of geographic targets — join with geo\_stats on country\_criterion\_id to resolve country names. 7 fields](/data-sources/google-ads#schema-geo-target-constants) * [Keywords Stats Daily keyword performance — impressions, clicks, cost, conversions, and quality score. 26 fields · Time series](/data-sources/google-ads#schema-keywords-stats) ## S00 · Why ## Why join Google Ads with web analytics and CRM in Databricks Google Ads reports clicks and the conversions it counted, and it does not follow a campaign to a deal that closes months later. Put search spend, website touch points and CRM deals in one [data warehouse](/data-storages) so a single query can. * Compare Google Ads spend with Facebook, Microsoft and TikTok * Trace a campaign click to the deal it became * Keep conversions and conversion value in tables you own ![](https://cdn.owox.com/www/portfolio-management-connectors/free-google-ads-connector-to-aws-athena/icon/1.svg/public)Google Ads · Search spend Web analytics · Clicks, form fills CRM · Deals ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Your data warehouse · Databricks · Campaign · Touch point · DealJoined by id · Campaign clicked · Deal months laterOne query links the ad to the deal. ## S01 · Step 1 ## Step 1: Connect Google Ads and choose what to load Create a Data Mart, choose Google Ads as the [data source](/data-sources), authorize with Google or a service account, enter the Customer ID and tick only the fields you need. * 9 endpoints and 166 fields: campaigns, ad groups, ads, keywords and geo * Stats endpoints read an ad account Customer ID; structure endpoints can read a manager account New Data Mart · Choose a source · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2024%2024%22%3E%3Cpath%20fill%3D%22%230866FF%22%20d%3D%22M24%2012.073c0-6.627-5.373-12-12-12s-12%205.373-12%2012c0%205.99%204.388%2010.954%2010.125%2011.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007%201.792-4.669%204.533-4.669%201.312%200%202.686.235%202.686.235v2.953H15.83c-1.491%200-1.956.925-1.956%201.874v2.25h3.328l-.532%203.47h-2.796v8.385C19.612%2023.027%2024%2018.062%2024%2012.073z%22%2F%3E%3C%2Fsvg%3E%0A)Facebook Ads · ![](https://cdn.owox.com/www/portfolio-management-connectors/free-google-ads-connector-to-aws-athena/icon/1.svg/public)Google Ads · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2024%2024%22%3E%3Cpath%20fill%3D%22%23000%22%20d%3D%22M12.525.02c1.31-.02%202.61-.01%203.91-.02.08%201.53.63%203.09%201.75%204.17%201.12%201.11%202.7%201.62%204.24%201.79v4.03c-1.44-.05-2.89-.35-4.2-.97-.57-.26-1.1-.59-1.62-.93-.01%202.92.01%205.84-.02%208.75-.08%201.4-.54%202.79-1.35%203.94-1.31%201.92-3.58%203.17-5.91%203.21-1.43.08-2.86-.31-4.08-1.03-2.02-1.19-3.44-3.37-3.65-5.71-.02-.5-.03-1-.01-1.49.18-1.9%201.12-3.72%202.58-4.96%201.66-1.44%203.98-2.13%206.15-1.72.02%201.48-.04%202.96-.04%204.44-.99-.32-2.15-.23-3.02.37-.63.41-1.11%201.04-1.36%201.75-.21.51-.15%201.07-.14%201.61.24%201.64%201.82%203.02%203.5%202.87%201.12-.01%202.19-.66%202.77-1.61.19-.33.4-.67.41-1.06.1-1.79.06-3.57.07-5.36.01-4.03-.01-8.05.02-12.07z%22%2F%3E%3C%2Fsvg%3E%0A)TikTok Ads · AuthorizeConnected · Endpoint · Campaigns Stats · Ad Group Ads Stats · Ad Groups · Ad Groups Stats ![](https://cdn.owox.com/www/portfolio-management-connectors/free-google-ads-connector-to-aws-athena/icon/1.svg/public)Campaigns Stats · 28 fields · datecost\_microsimpressionsclicksconversionsconversions\_value ## S02 · Step 2 ## Step 2: Load Google Ads into Databricks tables The catalog defaults to main, and the schema and table are pre-filled; change any of them. Run it and the first load lands in your own Databricks workspace. * Each endpoint gets its own table, such as google\_ads\_campaigns\_stats * Cost arrives in micros as cost\_micros; convert it once in your model * Every run is logged in Run History ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Destination · Databricks · Catalog · main · Schema · google\_ads · Table · campaigns\_stats · Run Run History · Pending · Running · SuccessIncremental load ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Table · main.google\_ads.campaigns\_sta… ## S03 · Step 3 ## Step 3: Open the output schema in plain words The first run gives you the output schema: every field with an alias and a readable description, not an API identifier. Your [data quality](/product/data-quality) checks can read it too. * The schema spells out units, such as cost\_micros being cost in micros * Statuses read as plain values: ENABLED, PAUSED, REMOVED ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)main.google\_ads.campaigns\_stats · Output schema · Field · Descriptiondate · Date for time series data · cost\_micros · Cost in Micros · impressions · Number of Impressions · clicks · Number of Clicks · conversions · Number of Conversions · conversions\_value · Total Conversion Value ## S04 · Step 4 ## Step 4: Keep the Google Ads tables linked Campaigns, ad groups, ad stats and campaign stats stay separate tables, joined by ids. In SQL they become one Google Ads [data model](/product/data-modeling). * campaign\_id and ad\_group\_id repeat across tables, so a stats row always finds its campaign and ad group * Join the model to web analytics and CRM on the campaign ![](https://cdn.owox.com/www/portfolio-management-connectors/free-google-ads-connector-to-aws-athena/icon/1.svg/public)Campaigns · campaign\_id · campaign\_name · campaign\_status ![](https://cdn.owox.com/www/portfolio-management-connectors/free-google-ads-connector-to-aws-athena/icon/1.svg/public)Ad Groups · ad\_group\_id · campaign\_id · ad\_group\_name ![](https://cdn.owox.com/www/portfolio-management-connectors/free-google-ads-connector-to-aws-athena/icon/1.svg/public)Ad Group Ads Stats · ad\_id · ad\_group\_id · cost\_micros ![](https://cdn.owox.com/www/portfolio-management-connectors/free-google-ads-connector-to-aws-athena/icon/1.svg/public)Campaigns Stats · campaign\_id · cost\_micros ## S05 · Step 5 ## Step 5: Refresh on a schedule and backfill the history Set it once. A scheduled refresh keeps the Databricks tables current, and a manual run loads a past period of your choice. * Each incremental run reloads today plus a lookback window you set * Backfill a custom start and end date Schedule · Run on a schedule · Daily 09:00 Backfill · Run backfill Run History · Daily schedule · Manual backfill · Daily schedule ## S06 · Step 6 ## Step 6: Reuse the Databricks tables in every tool One set of tables feeds your [data model](/product/data-modeling), [spreadsheets](/product/spreadsheets), [dashboards](/product/dashboards), [AI assistants](/product/ai-assistants) like Claude and ChatGPT and AI insights in Slack or email. * Blend Google Ads with Facebook and Microsoft spend once * Every report reads the same table ![](https://cdn.owox.com/www/portfolio-management-connectors/free-google-ads-connector-to-aws-athena/icon/1.svg/public)Google Ads · Data Mart · Published Blended ad spend ![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets ![](https://cdn.owox.com/www/portfolio-management-data-destination/data-studio/logo/1.svg/public)Data Studio dashboards ![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude, ChatGPT ![](https://cdn.owox.com/www/portfolio-management-data-destination/slack/logo/2.svg/public)Slack, email ## Related connectors [Google Ads to Claude](/connectors/google-ads-connector-to-claude)[Facebook Ads to Databricks](/connectors/free-facebook-ads-connector-to-databricks)[Microsoft Ads to Databricks](/connectors/free-microsoft-ads-connector-to-databricks)[Google Ads to ChatGPT](/connectors/google-ads-connector-to-chatgpt)[TikTok Ads to Databricks](/connectors/free-tiktok-ads-connector-to-databricks)[Bank of Canada to Databricks](/connectors/bank-of-canada-connector-to-databricks)[Criteo Ads to Databricks](/connectors/free-criteo-ads-connector-to-databricks)[LinkedIn Ads to Databricks](/connectors/free-linkedin-ads-connector-to-databricks)[LinkedIn Pages to Databricks](/connectors/free-linkedin-pages-connector-to-databricks) · Show 6 more · Show fewer ## Recent updates * [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog/#compare-linkedin-ads-results-across-markets-spend-by-country-region-and-county-0430) * [0.43.0 · The Sheet link of a Google Sheets source opens the imported tab, not the first one](https://docs.owox.com/docs/changelog/#the-sheet-link-of-a-google-sheets-source-opens-the-imported-tab-not-the-first-one-0430) * [0.43.0 · Connect a Google Sheets plan with one Google sign-in](https://docs.owox.com/docs/changelog/#connect-a-google-sheets-plan-with-one-google-sign-in-0430) * [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410) * [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410) ## Why OWOX ## Why OWOX for Google Ads in Databricks Google's transfer service writes only to BigQuery. OWOX loads Google Ads into Databricks the same way it loads Facebook, TikTok and Microsoft, with a choice of endpoints and fields. * **Google Ads and every other source.** Facebook, TikTok, Microsoft and the rest load the same way, so blended ad spend stays one model in Databricks. * **You choose endpoints and fields.** Pick campaign, ad group, ad, keyword or geo stats and tick only the columns you need. * **Your schedule, any period.** A lookback window picks up late changes, and a backfill loads any custom period. * **Joined by campaign, ad group and ad ids.** The tables arrive ready to meet web analytics and CRM. * **Free to self-host.** The open-source OWOX Data Marts runs in your own infrastructure. [Book a call](/book-a-call) [Get Started Free](https://www.owox.com/app-signup) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get Started Free](https://www.owox.com/app-signup) - [Documentation](https://docs.owox.com/packages/connectors/src/sources/google-ads/readme) - [Ad Group Ads StatsDaily performance for individual ads — impressions, clicks, cost, and…](https://www.owox.com/data-sources/google-ads) — /data-sources/google-ads.md - [data warehouse](https://www.owox.com/data-storages) — /data-storages.md - [data source](https://www.owox.com/data-sources) — /data-sources.md - [data quality](https://www.owox.com/product/data-quality) — /product/data-quality.md - [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md - [spreadsheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md - [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md - [AI assistants](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md - [Google Ads to Claude](https://www.owox.com/connectors/google-ads-connector-to-claude) — /connectors/google-ads-connector-to-claude.md - [Facebook Ads to Databricks](https://www.owox.com/connectors/free-facebook-ads-connector-to-databricks) — /connectors/free-facebook-ads-connector-to-databricks.md - [Microsoft Ads to Databricks](https://www.owox.com/connectors/free-microsoft-ads-connector-to-databricks) — /connectors/free-microsoft-ads-connector-to-databricks.md - [Google Ads to ChatGPT](https://www.owox.com/connectors/google-ads-connector-to-chatgpt) — /connectors/google-ads-connector-to-chatgpt.md - [TikTok Ads to Databricks](https://www.owox.com/connectors/free-tiktok-ads-connector-to-databricks) — /connectors/free-tiktok-ads-connector-to-databricks.md - [Bank of Canada to Databricks](https://www.owox.com/connectors/bank-of-canada-connector-to-databricks) — /connectors/bank-of-canada-connector-to-databricks.md - [Criteo Ads to Databricks](https://www.owox.com/connectors/free-criteo-ads-connector-to-databricks) — /connectors/free-criteo-ads-connector-to-databricks.md - [LinkedIn Ads to Databricks](https://www.owox.com/connectors/free-linkedin-ads-connector-to-databricks) — /connectors/free-linkedin-ads-connector-to-databricks.md - [LinkedIn Pages to Databricks](https://www.owox.com/connectors/free-linkedin-pages-connector-to-databricks) — /connectors/free-linkedin-pages-connector-to-databricks.md - [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog) - [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md