Google Ads Connector

Start moving your Google Ads data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Google Ads connector in the Weld documentation

ad_group

id

google_ads_ad_group_bidding_strategy

effective_target_cpa_micros

long

... 7 more fields

42 more google-ads tables

Explore available Google Ads data

Browse all the data tables available for the Google Ads connector, in our interactive ERD data viewer.

View the Google Ads Data Schema

Transform and model Google Ads data

Get clean data models from your Google Ads data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Google Ads

raw.google_ads.table1

raw.google_ads.table2

Get started with Google Ads SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Google Ads.

Ad Report

Generates an ad report by joining data from various tables in the Google Ads integration. It retrieves information such as date, account ID and name, campaign name and ID, ad group name and ID, ad ID and name, ad status and type, display URL, final URLs, spend, impressions, clicks, CPC, CTR, CPM, and conversions. Additional columns can be manually specified if needed.

URL Report

Generates a report for URL performance in Google Ads. It retrieves data from various tables, including ad stats, accounts, campaigns, ad groups, and ads. The template calculates metrics such as spend, impressions, clicks, CPC, CTR, CPM, and conversions. Additional columns can be specified manually if needed.

Ad stats by country monthly

Generates monthly ad statistics by country, including spend, clicks, CPC, cost per conversion, CTR, conversions, conversion value, impressions, and interactions, using data from Google Ads. It groups the data by month and country criterion ID.

Marketing Insights Dashboard

This SQL template consolidates advertising data from multiple platforms, including Facebook, Google, LinkedIn, TikTok, Snapchat, and Pinterest, into a unified dataset. It aggregates metrics such as clicks, impressions, spend, and conversions, and calculates performance indicators like CTR, CPC, CPM, and conversion rate. The result is grouped by date, platform, account, campaign, and ad identifiers for comprehensive marketing insights.

View all Google Ads templates