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.

Account Report

Generates an account report for the Google Ads integration. It retrieves data from the `google_ads.account_stats` and `google_ads.account` tables, and calculates various metrics such as spend, impressions, clicks, CPC, CTR, CPM, and conversions. The results are grouped by date, account ID, account name, currency code, auto tagging status, and time zone.

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.

Ad-group Report

Generates an ad-group report by retrieving data from the Google Ads integration. It combines information from various tables such as ad_group_stats, account, campaign, and ad_group to provide metrics such as spend, impressions, clicks, CPC, CTR, CPM, and conversions. The report is grouped by date, account, campaign, and ad group.

Campaign Report

Generates a campaign report by joining data from the Google Ads integration. It retrieves various metrics such as spend, impressions, clicks, CPC, CTR, CPM, and conversions for each campaign, along with account information. The template uses common aggregation functions and grouping to summarize the data at the desired level of granularity.

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.

View all Google Ads templates