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 PerformanceDate, campaign name, status, impressions, clicks, cost, conversions, conversion value
Keyword PerformanceDate, campaign, ad group, keyword, match type, impressions, clicks, cost, conversions
Click AttributionClick date, GCLID, campaign, ad group (links ad clicks to GA4 sessions)
Account InfoCustomer ID, account name, currency code

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.