Pull Google Ads data into Microsoft Excel
Search spend usually reaches Excel as an export nobody trusts. Load Google Ads into your data warehouse, join it to sessions and deals, and pull one governed Data Mart into the workbook your team already uses.
Google AdsConnectedAd Group Ads Sta…Ad GroupsAd Groups StatsCampaigns
Microsoft ExcelDateCostClicksDaily 09:00Google Ads spend reaches Excel as an export pasted over last week's tab, and nobody trusts it.
Paste this into your AI assistant. It loads Google Ads into your data warehouse with OWOX Data Marts, joins it to sessions and deals, and pulls one governed Data Mart into your workbook with the add-in.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/google-ads-connector-to-microsoft-excel.md. The task: pull my Google Ads Data Mart into a Microsoft Excel workbook with the add-in: cost, clicks and conversions by campaign and week next to sessions and deals, refreshed when I open it. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Google Ads Endpoints
9 Google Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad Group Ads Stats
Daily performance for individual ads — impressions, clicks, cost, and conversions.
27 fieldsTime seriesAd Groups
Your ad group settings — type, status, and bid configuration within each campaign.
9 fieldsAd Groups Stats
Daily ad group performance — impressions, clicks, cost, and conversions.
24 fieldsTime seriesCampaigns
Your campaign settings — channel type, bidding strategy, budget, and scheduling.
11 fieldsCampaigns Stats
Daily campaign performance — impressions, clicks, cost, and conversions.
28 fieldsTime seriesCriterion
Ad group targeting criteria — keywords, placements, and negative exclusions with bid settings.
18 fieldsGeo Stats
Daily performance by country and targeting type — impressions, clicks, cost, and conversions.
18 fieldsTime seriesGeo Target Constants
Reference table of geographic targets — join with geo_stats on country_criterion_id to resolve country names.
7 fieldsKeywords Stats
Daily keyword performance — impressions, clicks, cost, conversions, and quality score.
26 fieldsTime series
Why Google Ads does not go straight to Excel
Google Ads can feed Excel by export or add-on, but not reliably, at scale or business-ready. Cost arrives in micros, conversions are the ones Google counted, and nothing says what a customer was worth. The join to sessions and CRM happens in the data warehouse.
- Google Ads reports the conversions it counted, not the revenue they became
- The data analyst converts cost, joins sessions and deals, and signs off the Data Mart
- A workbook built on it stays correct when the account structure changes
Google AdsSearch ad spendMicrosoft Exc…
Data warehouseJoined by idStep 1: Load Google Ads into your data warehouse first
Google AdsData MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksgoogle_ads.campaigns_statsStep 2: Link Google Ads to web analytics and deals
In your data warehouse the model sets Google Ads beside Facebook Ads and Microsoft Ads, then joins web analytics sessions by a campaign key. Pick an industry to see the shape of its model.
- Search and social spend in one table, ready for a pivot
- Sessions and deals join by SQL keys, not a VLOOKUP over exports
- platform_cpa is calculated once, whoever opens the workbook
Google AdsCampaigns Stats
Facebook AdsAd spend
Microsoft AdsAd spendStep 3: Pull Google Ads data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published Google Ads Data Mart (Campaigns Stats), tick the columns you want and press Create & Run.
- Pick cost_micros, clicks and conversions by date and campaign_name
- The data warehouse does the heavy lifting; Excel receives rows, not an API
Microsoft ExcelYour columns staydatecampaign_namecost_microsStep 4: Refresh the Google Ads workbook when you need it
Refresh the workbook when the next review comes. The add-in re-pulls the imported columns and keeps your pivots and formulas intact.
- Add a CPA column of your own; refresh will not touch it
- Pull on demand, so a quiet week costs nothing
Microsoft ExcelYour column staysdatecampaign_…cost_micr…YoursStep 5: Reuse Google Ads inside OWOX MCP
The Google Ads Data Mart is reusable in OWOX MCP, your assistant for data. Request any report, chat with it, then get it in Google Sheets or Excel in one click.
- Compare channels by asking, not by rebuilding the pivot
- The chat and the workbook share platform_cpa
Google SheetsOpenExcelOpen
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Short links resolve only on known short link services and domains you allow
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.37.0Unchecking a column in the OWOX Extension no longer fails Save & Run
Why OWOX for Google Ads in Excel
Export buttons and macros move Google Ads rows into Excel one report at a time. OWOX keeps one Data Mart behind every workbook.
- Search spend in context. Keywords and campaigns sit beside sessions and CRM deals in your data warehouse.
- Nine endpoints, your choice. Campaign stats, ad groups, keywords and geo are separate tables a workbook can pick from.
- Your formulas survive. The add-in refreshes the columns it imported and nothing else.
- Maintained for you. Google Ads API version changes are the connector's job, not yours.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.