Google Ads connector reference

Beta

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.

This page provides reference information for the managed Google Ads connector in Lakeflow Connect, including supported tables, column definitions, and data types.

Supported tables

The Google Ads connector supports the following types of tables:

• Resource tables: Configuration data about your Google Ads account, like campaigns, ad groups, and ads. These tables are fully refreshed on each pipeline run.
• Report tables: Performance metrics, like impressions, clicks, and conversions. These tables support incremental ingestion.

Resource tables

Table name	Description
customer	Information about Google Ads accounts.
campaign	Campaign configuration and settings.
campaign_budget	Budget settings for campaigns.
campaign_criterion	Targeting criteria for campaigns.
ad_group	Ad group configuration.
ad_group_criterion	Targeting criteria for ad groups.
ad	Individual ad details and settings.

Report tables

Table name	Description
customer_report	Account-level performance metrics.
campaign_report	Campaign-level performance metrics.
ad_group_report	Ad group-level performance metrics.
ad_report	Ad-level performance metrics.
keyword_report	Keyword-level performance metrics.
search_query_report	Search query-level performance metrics.

Data type conventions

Money storage (micros)

Google Ads stores monetary values in micros to avoid rounding issues. One million micros equals one unit of currency:

• 1,000,000 micros = $1.00 USD
• 5,500,000 micros = $5.50 USD

Fields with _micros suffix contain values stored in micros. Divide by 1,000,000 to convert to your currency.

Primary keys

Tables use (Primary Key) notation to indicate columns that form the primary key. Composite primary keys are indicated by multiple columns marked as (Primary Key).

Resource table schemas

customer

Information about Google Ads accounts.

Column	Data type	Description
id	long	Primary key. Customer account ID.
resource_name	string	Google Ads resource name.
descriptive_name	string	Human-friendly name for the Google Ads account.
currency_code	string	Currency code for the account.
time_zone	string	Time zone of the account.
status	string	Status of the account.
manager	boolean	Whether this customer is a Manager Account (MCC).

campaign

Campaign configuration and settings.

Column	Data type	Description
id	long	Primary key. Campaign ID.
name	string	Campaign name.
status	string	Campaign status.
advertising_channel_type	string	Advertising channel type.
start_date	string	Campaign start date.
end_date	string	Campaign end date.
campaign_budget	string	Associated campaign budget.
bidding_strategy_type	string	Bidding strategy type.

campaign_budget

Budget settings for campaigns.

Column	Data type	Description
id	long	Primary key. Budget ID.
resource_name	string	Google Ads resource name.
name	string	Budget name.
amount_micros	long	Budget amount in micros. Divide by 1,000,000 to convert to currency.
delivery_method	string	How Google spends the daily budget (standard or accelerated).
period	string	Budget period.
status	string	Budget status.

campaign_criterion

Targeting criteria for campaigns.

Column	Data type	Description
campaign_id	long	Primary key. Campaign ID.
criterion_id	long	Primary key. Criterion ID.
resource_name	string	Google Ads resource name.
type	string	Criterion type.
status	string	Criterion status.
negative	boolean	Whether this criterion excludes an audience.
bid_modifier	double	Bid modifier value.

ad_group

Ad group configuration.

Column	Data type	Description
id	long	Primary key. Ad group ID.
name	string	Ad group name.
status	string	Ad group status.
campaign_id	long	Associated campaign ID.
type	string	Ad group type.
cpc_bid_micros	long	Cost per click bid in micros.
target_cpa_micros	long	Target cost per acquisition in micros.

ad_group_criterion

Targeting criteria for ad groups.

Column	Data type	Description
criterion_id	long	Primary key. Criterion ID.
ad_group_id	long	Primary key. Ad group ID.
resource_name	string	Google Ads resource name.
status	string	Criterion status.
type	string	Criterion type.
negative	boolean	Whether this criterion excludes an audience.
keyword_match_type	string	Keyword match type (exact, phrase, broad).
keyword_text	string	Keyword text.

ad

Individual ad details and settings. This table corresponds to ad_group_ad in the Google Ads API.

Column	Data type	Description
id	long	Primary key. Ad ID.
ad_group_id	long	Primary key. Ad group ID.
status	string	Ad status.
ad_type	string	Ad type.
final_urls	array<string>	Landing page URLs after clicking the ad.
policy_summary_approval_status	string	Whether the ad is approved under Google Ads policy (APPROVED or DISAPPROVED).
policy_summary_review_status	string	Whether Google has finished reviewing the ad (REVIEW_IN_PROGRESS or REVIEWED).

Report table schemas

customer_report

Account-level performance metrics.

Column	Data type	Description
customer_id	long	Primary key. Customer account ID.
date	string	Primary key. Date in YYYY-MM-DD format.
device	string	Primary key. Device type.
ad_network_type	string	Primary key. Ad network type.
impressions	long	Number of impressions.
clicks	long	Number of clicks.
cost_micros	long	Cost in micros. Divide by 1,000,000 to convert to currency.
conversions	double	Number of conversions.
conversions_value	double	Total conversion value.
ctr	double	Click-through rate.
average_cpc	double	Average cost per click.

campaign_report

Campaign-level performance metrics.

Column	Data type	Description
customer_id	long	Primary key. Customer account ID.
id	long	Primary key. Campaign ID.
date	string	Primary key. Date in YYYY-MM-DD format.
device	string	Primary key. Device type.
ad_network_type	string	Primary key. Ad network type.
campaign_name	string	Campaign name.
campaign_status	string	Campaign status.
impressions	long	Number of impressions.
clicks	long	Number of clicks.
cost_micros	long	Cost in micros.
conversions	double	Number of conversions.

ad_group_report

Ad group-level performance metrics.

Column	Data type	Description
customer_id	long	Primary key. Customer account ID.
id	long	Primary key. Ad group ID.
date	string	Primary key. Date in YYYY-MM-DD format.
device	string	Primary key. Device type.
ad_network_type	string	Primary key. Ad network type.
ad_group_name	string	Ad group name.
ad_group_status	string	Ad group status.
campaign_id	long	Associated campaign ID.
impressions	long	Number of impressions.
clicks	long	Number of clicks.
cost_micros	long	Cost in micros.

keyword_report

Keyword-level performance metrics.

Column	Data type	Description
customer_id	long	Primary key. Customer account ID.
date	string	Primary key. Date in YYYY-MM-DD format.
ad_group_criterion_criterion_id	long	Primary key. Criterion ID.
ad_group_id	long	Primary key. Ad group ID.
device	string	Primary key. Device type.
ad_network_type	string	Primary key. Ad network type.
keyword_text	string	Keyword text.
keyword_match_type	string	Keyword match type.
impressions	long	Number of impressions.
clicks	long	Number of clicks.
cost_micros	long	Cost in micros.

ad_report

Ad-level performance metrics.

Column	Data type	Description
customer_id	long	Primary key. Customer account ID.
date	string	Primary key. Date in YYYY-MM-DD format.
ad_id	long	Primary key. Ad ID.
ad_group_id	long	Primary key. Ad group ID.
device	string	Primary key. Device type.
ad_network_type	string	Primary key. Ad network type.
campaign_id	long	Associated campaign ID.
impressions	long	Number of impressions.
clicks	long	Number of clicks.
cost_micros	long	Cost in micros.
conversions	double	Number of conversions.

search_query_report

Search query-level performance metrics.

Column	Data type	Description
customer_id	long	Primary key. Customer account ID.
date	string	Primary key. Date in YYYY-MM-DD format.
resource_name	string	Primary key. Google Ads resource name.
search_term	string	User's search term.
search_term_match_type	string	How the keyword matched the search term.
ad_group_id	long	Associated ad group ID.
campaign_id	long	Associated campaign ID.
impressions	long	Number of impressions.
clicks	long	Number of clicks.

Incremental ingestion

Report tables support incremental ingestion with a configurable lookback window. The connector uses the date column as the cursor column for tracking incremental updates.

For more information about incremental ingestion and lookback windows, see Google Ads connector concepts.