Data Connector

Analyze Your Google Ads Data with AI

Connect direct or MCC-managed customer accounts and ask questions about campaign, keyword, search-term, cost, and conversion performance.

Read-only accessDirect & MCC accountsLive GAQL reporting

Direct and manager accounts

Discover directly accessible customers and customer accounts managed through an MCC hierarchy.

Read-only by design

Formula Bot executes GAQL through the Google Ads Search endpoint and cannot create or modify campaigns.

Refreshable reporting

Live queries and saved dashboard queries rerun against current Google Ads data.

What You Can Analyze

Campaign performance

  • Which campaigns drove the most conversions?
  • Show spend and ROAS for the last 30 days
  • Compare impressions and clicks by campaign

Keywords & search terms

  • Which keywords spend without converting?
  • Top search terms by conversions?
  • Compare keyword match types

Ad groups & ads

  • Which ad groups have the best CPA?
  • Show ad performance by day
  • Find low-CTR ads with meaningful volume

Conversion reporting

  • Conversion value by campaign?
  • How has CPA changed this month?
  • Show all conversions and cost by week

Explore Other Connectors

Google Analytics

Connect Google Analytics 4 to Formula Bot and analyze website traffic, user behavior, and conversions using AI-powered natural language queries.

Google Search Console

Connect Google Search Console to Formula Bot and analyze search performance, keyword rankings, and indexing with AI-powered queries.

Tableau

Connect Tableau Cloud to Formula Bot and chat with synced dashboards, views, and datasources as BI collections.

Google Sheets

Connect Google Sheets to Formula Bot and sync spreadsheet data for AI-powered analysis, dashboards, reports, and scheduled refreshes.

Google Drive

Connect Google Drive to Formula Bot and import spreadsheets, CSVs, and data files for AI-powered analysis without manual downloads.

Dropbox

Connect Dropbox to Formula Bot and import Excel, CSV, and TSV files for AI-powered analysis without manual downloads.

OneDrive

Connect Microsoft OneDrive to Formula Bot and import Excel, CSV, and TSV files directly into AI chats, dashboards, and reports.

SharePoint

Connect Microsoft SharePoint to Formula Bot and import Excel, CSV, and TSV files from document libraries for AI-powered analysis.

Google BigQuery

Connect Google BigQuery to Formula Bot and analyze massive datasets in your data warehouse using AI-powered natural language queries.

Snowflake

Connect your Snowflake data warehouse to Formula Bot and analyze your data with AI-powered natural language queries. No SQL required.

MySQL

Connect your MySQL database to Formula Bot and query your data using AI-powered natural language. No SQL expertise required.

PostgreSQL

Connect your PostgreSQL database to Formula Bot and explore your data with AI-powered natural language queries. No SQL required.

Supabase

Connect your Supabase Postgres database to Formula Bot and analyze live product, user, and event data with AI-powered natural language queries.

Microsoft SQL Server

Connect Microsoft SQL Server to Formula Bot and explore enterprise data with AI-powered natural language queries. No SQL expertise needed.

Frequently Asked Questions

No. The connector is read-only and uses only the Google Ads Search endpoint for reporting.
Google provides one Google Ads API OAuth scope rather than a narrower reporting-only scope. Formula Bot restricts the connector itself to account discovery and read-only Search requests.
Yes. Formula Bot discovers customer hierarchies and saves the required manager customer context with each selected account.
You can query compatible Google Ads reporting resources including campaigns, ad groups, ads, keywords, search terms, segments, costs, and conversions.
Google Ads returns cost fields in micros. Formula Bot preserves the raw API values and uses the selected account currency and timezone as analysis context.
Yes. Dashboard refresh reruns the saved GAQL. Rolling DURING ranges move forward, while literal historical dates remain fixed.

Ready to Analyze Your Google Ads Data?