The Scenario
You're a paid search analyst and someone on the account team just forwarded you a Slack message: the brand's top-spending campaign is eating through budget at twice the expected rate and nobody knows which ad groups are responsible. You have about an hour before a team standup where you're expected to have an answer.
Your Google Ads account has 80 ad groups spread across that campaign. You need clicks, impressions, average CPC, and conversions for each one — sorted so the over-bidding, low-converting groups jump out immediately.
The bad version:
- Navigate to Ad Groups inside the specific campaign in the Google Ads UI, set the date range, and stare at the pagination — 80 ad groups means at least three pages.
- Export to CSV, open in the sheet, sort by cost, discover the "Avg. CPC" column exported as a formatted string ("$2.34") and broke your sort order.
- Add a conversion rate formula column manually, format it as a percentage, go back to the original export because you forgot to include conversion value.
The standup is in 55 minutes. You're supposed to have a hypothesis, not a half-formed export.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data you're working with, connects to Google Ads through its built-in integration, and runs the query for you. No pagination, no string reformatting, no formula columns to add by hand.
Query Google Ads for all ad groups and pull their clicks, impressions, average CPC, conversion rate, and cost for the last 30 days into my Google Sheet, grouped by campaign name
What You Get
- One row per ad group, grouped by campaign name in column A.
- Columns: Campaign Name | Ad Group Name | Clicks | Impressions | Avg. CPC (numeric) | Conversions | Conversion Rate | Cost.
- Avg. CPC arrives as a plain decimal — no string-to-number conversion needed before sorting.
- Ad groups are sorted within each campaign by cost descending, so the expensive underperformers surface immediately.
What If the Data Is Not Quite Ready
You only want ad groups inside one specific campaign
Pull all ad groups from the campaign named "Brand – Exact Match" in my Google Ads account with their last 30 days of clicks, impressions, average CPC, conversions, and cost, and write the results into my Google Sheet sorted by cost descending
The ad group names use an internal naming convention and you need a cleaned label
Query Google Ads for all ad groups in my account with their last 30 days of clicks, impressions, average CPC, and cost, then write the results into my sheet and add a "Label" column in column I that strips the campaign prefix from each ad group name using the pattern "[CampaignPrefix]_"
You need to join ad group data from two separate campaigns side by side
Pull all ad groups from the campaigns named "Brand – Broad" and "Competitor Conquest" in my Google Ads account with last 30 days of clicks, conversions, and cost, and write the combined results into my Google Sheet with a Campaign Name column so I can filter or sort by campaign
The full audit prompt — flag over-bidding ad groups in one shot
Query all ad groups in my Google Ads account for the last 30 days — pull clicks, impressions, average CPC, conversions, conversion rate, and cost — write the results into my Google Sheet sorted by cost descending, and highlight any row where average CPC exceeds $4.00 and conversion rate is below 2% in orange so the over-bidding groups stand out immediately
One prompt does the pull, the sort, and the conditional formatting — nothing left to add manually before the standup.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with your ad group tracking layout, then ask it to pull last 30 days of ad group performance grouped by campaign. Also see: Pull Campaign Performance Metrics for the campaign-level view, or back to the Google Ads overview.