Connector

Google Ads Connector to Microsoft Excel

Own your Google Ads data in Microsoft Excel with OWOX Data Marts. Collect granular, analytics-ready Google Ads data, control schema and refresh logic, and reuse it across Microsoft Excel and AI Insights.

Get started free

Endpoints

Google Ads endpoints

9 Google Ads endpoints you can import. Each lands in its own table in your warehouse.

  • Google Ads Ad Group Ads Stats

    Daily performance for individual ads — impressions, clicks, cost, and conversions.

    26 fieldsTime seriesgoogle_ads_ad_group_ads_stats

  • Google Ads Ad Groups

    Your ad group settings — type, status, and bid configuration within each campaign.

    9 fieldsgoogle_ads_ad_groups

  • Google Ads Ad Groups Stats

    Daily ad group performance — impressions, clicks, cost, and conversions.

    24 fieldsTime seriesgoogle_ads_ad_groups_stats

  • Google Ads Campaigns

    Your campaign settings — channel type, bidding strategy, budget, and scheduling.

    11 fieldsgoogle_ads_campaigns

  • Google Ads Campaigns Stats

    Daily campaign performance — impressions, clicks, cost, and conversions.

    28 fieldsTime seriesgoogle_ads_campaigns_stats

  • Google Ads Criterion

    Ad group targeting criteria — keywords, placements, and negative exclusions with bid settings.

    17 fieldsgoogle_ads_criterion

  • Google Ads Geo Stats

    Daily performance by country and targeting type — impressions, clicks, cost, and conversions.

    18 fieldsTime seriesgoogle_ads_geo_stats

  • Google Ads Geo Target Constants

    Reference table of geographic targets — join with geo_stats on country_criterion_id to resolve country names.

    7 fieldsgoogle_ads_geo_target_constants

  • Google Ads Keywords Stats

    Daily keyword performance — impressions, clicks, cost, conversions, and quality score.

    26 fieldsTime seriesgoogle_ads_keywords_stats

Data schema

Google Ads data schema

Google Ads Ad Group Ads Stats 26 fields · google_ads_ad_group_ads_stats
FieldTypeDescription
ad_idSTRINGAd ID
ad_statusSTRINGAd Status (ENABLED, PAUSED, REMOVED)
ad_final_urlsARRAYFinal URLs for the Ad
ad_group_idSTRINGAd Group ID
campaign_idSTRINGCampaign ID
dateSTRINGDate for time series data
impressionsNUMBERNumber of Impressions
clicksNUMBERNumber of Clicks
cost_microsNUMBERCost in Micros
conversionsNUMBERNumber of Conversions
ctrNUMBERClick-Through Rate
average_cpcNUMBERAverage Cost Per Click
conversions_valueNUMBERTotal Conversion Value
cost_per_conversionNUMBERCost Per Conversion
ad_typeSTRINGAd Type (TEXT_AD, EXPANDED_TEXT_AD, RESPONSIVE_SEARCH_AD, etc.)
ad_nameSTRINGAd Name
ad_group_nameSTRINGAd Group Name
campaign_nameSTRINGCampaign Name
conversion_rateNUMBERConversion Rate
view_through_conversionsNUMBERView-Through Conversions
all_conversionsNUMBERAll Conversions
all_conversions_valueNUMBERAll Conversions Value
average_costNUMBERAverage Cost
average_cpmNUMBERAverage CPM
interactionsNUMBERNumber of Interactions
interaction_rateNUMBERInteraction Rate
Google Ads Ad Groups 9 fields · google_ads_ad_groups
FieldTypeDescription
ad_group_idSTRINGAd Group ID
ad_group_nameSTRINGAd Group Name
ad_group_statusSTRINGAd Group Status (ENABLED, PAUSED, REMOVED)
ad_group_typeSTRINGAd Group Type (SEARCH_STANDARD, DISPLAY_STANDARD, etc.)
campaign_idSTRINGCampaign ID
campaign_nameSTRINGCampaign Name
ad_group_cpc_bid_microsNUMBERAd Group CPC Bid in Micros
ad_group_cpm_bid_microsNUMBERAd Group CPM Bid in Micros
ad_group_target_cpa_microsNUMBERAd Group Target CPA in Micros
Google Ads Ad Groups Stats 24 fields · google_ads_ad_groups_stats
FieldTypeDescription
ad_group_idSTRINGAd Group ID
ad_group_nameSTRINGAd Group Name
ad_group_statusSTRINGAd Group Status (ENABLED, PAUSED, REMOVED)
campaign_idSTRINGCampaign ID
dateSTRINGDate for time series data
impressionsNUMBERNumber of Impressions
clicksNUMBERNumber of Clicks
cost_microsNUMBERCost in Micros
conversionsNUMBERNumber of Conversions
ctrNUMBERClick-Through Rate
average_cpcNUMBERAverage Cost Per Click
conversions_valueNUMBERTotal Conversion Value
cost_per_conversionNUMBERCost Per Conversion
conversion_rateNUMBERConversion Rate
view_through_conversionsNUMBERView-Through Conversions
all_conversionsNUMBERAll Conversions
all_conversions_valueNUMBERAll Conversions Value
cost_per_all_conversionsNUMBERCost Per All Conversions
average_costNUMBERAverage Cost
average_cpmNUMBERAverage CPM
interactionsNUMBERNumber of Interactions
interaction_rateNUMBERInteraction Rate
engagement_rateNUMBEREngagement Rate
engagementsNUMBERNumber of Engagements
Google Ads Campaigns 11 fields · google_ads_campaigns
FieldTypeDescription
campaign_idSTRINGCampaign ID
campaign_nameSTRINGCampaign Name
campaign_statusSTRINGCampaign Status (ENABLED, PAUSED, REMOVED)
campaign_advertising_channel_typeSTRINGAdvertising Channel Type (SEARCH, DISPLAY, VIDEO, etc.)
campaign_start_dateSTRINGCampaign Start Date
campaign_end_dateSTRINGCampaign End Date
campaign_bidding_strategy_typeSTRINGBidding Strategy Type (MANUAL_CPC, TARGET_CPA, TARGET_ROAS, etc.)
campaign_budget_amount_microsNUMBERCampaign Budget Amount in Micros
campaign_target_cpa_microsNUMBERTarget CPA in Micros (if using Target CPA bidding)
campaign_target_roasNUMBERTarget ROAS (if using Target ROAS bidding)
campaign_advertising_channel_sub_typeSTRINGAdvertising Channel Sub Type
Google Ads Campaigns Stats 28 fields · google_ads_campaigns_stats
FieldTypeDescription
campaign_idSTRINGCampaign ID
campaign_nameSTRINGCampaign Name
campaign_statusSTRINGCampaign Status (ENABLED, PAUSED, REMOVED)
dateSTRINGDate for time series data
impressionsNUMBERNumber of Impressions
clicksNUMBERNumber of Clicks
cost_microsNUMBERCost in Micros
conversionsNUMBERNumber of Conversions
ctrNUMBERClick-Through Rate
average_cpcNUMBERAverage Cost Per Click
conversions_valueNUMBERTotal Conversion Value
cost_per_conversionNUMBERCost Per Conversion
conversion_rateNUMBERConversion Rate
view_through_conversionsNUMBERView-Through Conversions
all_conversionsNUMBERAll Conversions
all_conversions_valueNUMBERAll Conversions Value
cost_per_all_conversionsNUMBERCost Per All Conversions
average_costNUMBERAverage Cost
average_cpmNUMBERAverage CPM
engagement_rateNUMBEREngagement Rate
engagementsNUMBERNumber of Engagements
interactionsNUMBERNumber of Interactions
interaction_rateNUMBERInteraction Rate
search_impression_shareNUMBERSearch Impression Share
search_budget_lost_impression_shareNUMBERSearch Budget Lost Impression Share
search_rank_lost_impression_shareNUMBERSearch Rank Lost Impression Share
video_viewsNUMBERVideo Views (for Video campaigns)
video_view_rateNUMBERVideo View Rate
Google Ads Criterion 17 fields · google_ads_criterion
FieldTypeDescription
criterion_idSTRINGCriterion ID
criterion_typeSTRINGCriterion Type (KEYWORD, PLACEMENT, etc.)
criterion_statusSTRINGCriterion Status (ENABLED, PAUSED, REMOVED)
keyword_textSTRINGKeyword Text
keyword_match_typeSTRINGKeyword Match Type (EXACT, PHRASE, BROAD)
ad_group_idSTRINGAd Group ID
campaign_idSTRINGCampaign ID
quality_scoreNUMBERQuality Score
final_urlsARRAYFinal URLs
negativeBOOLEANWhether to target (false) or exclude (true) the criterion
cpc_bid_microsNUMBERCPC Bid in Micros
effective_cpc_bid_microsNUMBEREffective CPC Bid in Micros (includes bid modifiers)
position_estimates_first_page_cpc_microsNUMBEREstimated CPC Bid needed to appear on first page
position_estimates_top_of_page_cpc_microsNUMBEREstimated CPC Bid needed to appear at top of page
position_estimates_first_position_cpc_microsNUMBEREstimated CPC Bid needed to appear in first position
ad_group_nameSTRINGAd Group Name
campaign_nameSTRINGCampaign Name
Google Ads Geo Stats 18 fields · google_ads_geo_stats
FieldTypeDescription
country_criterion_idSTRINGCriterion ID for the country (maps to geo_target_constant_id in geo_target_constants table)
location_typeSTRINGGeo targeting type: AREA_OF_INTEREST (user searched for this location) or LOCATION_OF_PRESENCE (user was physically in this location)
dateSTRINGDate for time series data
campaign_idSTRINGCampaign ID
campaign_nameSTRINGCampaign Name
campaign_statusSTRINGCampaign Status (ENABLED, PAUSED, REMOVED)
impressionsNUMBERNumber of Impressions
clicksNUMBERNumber of Clicks
cost_microsNUMBERCost in Micros
conversionsNUMBERNumber of Conversions
conversions_valueNUMBERTotal Conversion Value
ctrNUMBERClick-Through Rate
average_cpcNUMBERAverage Cost Per Click
all_conversionsNUMBERAll Conversions (includes cross-device and view-through)
all_conversions_valueNUMBERAll Conversions Value
view_through_conversionsNUMBERView-Through Conversions
cost_per_conversionNUMBERCost Per Conversion
conversion_rateNUMBERConversion Rate
Google Ads Geo Target Constants 7 fields · google_ads_geo_target_constants
FieldTypeDescription
geo_target_constant_idSTRINGCriterion ID - join key with country_criterion_id in geo_stats
nameSTRINGEnglish name of the geo target (e.g. United States, California, New York)
country_codeSTRINGISO-3166-1 alpha-2 country code (e.g. US, GB, DE)
target_typeSTRINGType of geo target (e.g. Country, Region, City, MetroArea, PostalCode)
statusSTRINGStatus of the geo target constant (ENABLED or REMOVAL_PLANNED)
canonical_nameSTRINGFully qualified name including parent targets (e.g. New York,New York,United States)
parent_geo_targetSTRINGResource name of the parent geo target constant
Google Ads Keywords Stats 26 fields · google_ads_keywords_stats
FieldTypeDescription
keyword_idSTRINGKeyword Criterion ID
keyword_textSTRINGKeyword Text
keyword_match_typeSTRINGKeyword Match Type (EXACT, PHRASE, BROAD)
keyword_statusSTRINGCriterion Status (ENABLED, PAUSED, REMOVED)
ad_group_idSTRINGAd Group ID
campaign_idSTRINGCampaign ID
dateSTRINGDate for time series data
impressionsNUMBERNumber of Impressions
clicksNUMBERNumber of Clicks
cost_microsNUMBERCost in Micros
conversionsNUMBERNumber of Conversions
ctrNUMBERClick-Through Rate
average_cpcNUMBERAverage Cost Per Click
conversions_valueNUMBERTotal Conversion Value
cost_per_conversionNUMBERCost Per Conversion
quality_scoreNUMBERQuality Score
conversion_rateNUMBERConversion Rate
view_through_conversionsNUMBERView-Through Conversions
all_conversionsNUMBERAll Conversions (including cross-device, store visits, etc.)
all_conversions_valueNUMBERAll Conversions Value
average_costNUMBERAverage Cost Per Interaction
average_cpmNUMBERAverage CPM (Cost Per Thousand Impressions)
search_impression_shareNUMBERSearch Impression Share
search_rank_lost_impression_shareNUMBERSearch Rank Lost Impression Share
top_impression_percentageNUMBERTop Impression Percentage
absolute_top_impression_percentageNUMBERAbsolute Top Impression Percentage

Trust

Data Partner You Can Trust

users

175K

Executives and data analysts across 20+ industries

G2 rating

4.9★

“A trusted data analytics partner” — verified review

npm installs

156K

In Open Source We Trust

Customers

What users are saying

Every claim has a receipt.

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A3re: trusting AI
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
C9re: one source of truth
Mark SimmonsMark SimmonsCMO, Pürblack®
“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
E7re: getting time back
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“We regained time. And time is the one resource that never comes back.”

Turn your Google Ads Connector to Microsoft Excel data into business decisions

Get started free