Connecting Google Ads

  1. Open Connections from the account menu.
  2. Click Connect next to Google Ads.
  3. Sign in and grant access to your Ads account.
  4. Select the customer account from the list.
  5. Click Enable to start syncing.

Available Data

TableKey Columns
Campaign Performancestats_date, campaign_id, campaign_name, campaign_status, impressions, clicks, cost, cost_micros, conversions, conversions_value
Keyword Performancestats_date, campaign_id, campaign_name, ad_group_id, ad_group_name, keyword_text, match_type, impressions, clicks, cost, conversions
Click Attributionclick_date, gclid, campaign_id, campaign_name, ad_group_id, keyword_text (links ad clicks to GA4 sessions via GCLID)
Account Infocustomer_id, descriptive_name, currency_code, last_synced_at

Key Metrics

  • CTR — clicks / impressions
  • CPC — cost / clicks
  • ROAS — conversion value / cost
  • Cost is stored in your account's currency and automatically converted to your display currency.

Example Questions

  • "What's our total Google Ads spend this month?"
  • "Top 5 campaigns by ROAS"
  • "Show me daily ad spend as a line chart"
  • "Which keywords have the highest CPC?"
  • "Compare Google Ads vs Microsoft Ads performance"

Notes

  • Cost values are automatically converted to your organisation's display currency.
  • Click attribution data can be joined with GA4 sessions via GCLID for full-funnel analysis.