Google Ads06:00
Written to 
fs_spend_by_campaign
Google Ads to BigQuery
Spend, clicks and conversions at the level you report on, in your own dataset. Every run that reaches the last seven days fetches them again, so late conversions land.
30 days of Plus, free, no card. Then one report keeps refreshing weekly.
Google AdsGoogle Ads06:01
Written to fs_keyword_performance
Google Ads06:02
Written to fs_weekly_ads_summary
What lands in BigQuery
- One table per report, named fs_ and the report name.
- Include Date, Week starting or Month and history builds up. Each run replaces only its own dates.
- Five levels: account, campaign, ad group, ad and keyword, with quality score at keyword level.
- Cost arrives in your account's currency, not in micros.
Google's BigQuery Data Transfer Service has a free Google Ads connector that loads daily. Fresh Sheets sends the reports you build, on your schedule, as often as hourly on Max.
Connect your Google account from the Fresh Sheets sidebar and pick the Ads account. Under a manager account, clients one level down are listed.
Which plans send to BigQuery
Pro and Max, and the free 30 days. Sending to BigQuery uses no extra refreshes: one run counts once, wherever it lands.
FAQ
Questions
Can it change anything in my Ads account?
No. Google offers no read-only Ads permission, so the access could write, but our code never does.
Why fetch the last seven days again?
Conversions keep arriving after the click. Fetching the last week again means the table catches them.
Other sources to BigQuery
Analytics
Send your Google Ads reports to BigQuery
BigQuery is included in the free 30 days, then on Pro and Max.