Google Ads connector reference

Important

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Azure 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.

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.

  • Last updated on