The Scenario
You run performance marketing at a SaaS company and the quarterly review is in two days. You've been asked to put together a competitive creative landscape for Google Display — what formats are your 25 direct competitors running, what's the ratio of text ads to image ads, and which advertisers are running the highest volume.
Your team used to do this by hand. Someone would spend a day in the Google Ad Transparency Center, searching domains, building a spreadsheet. The last time it happened, the report arrived the morning of the quarterly review with 7 of the 25 domains missing, no consistent column structure, and the person who built it out of the office. You presented it anyway. You are not doing that again.
The bad version:
- Open the Ad Transparency Center, search the first competitor domain, note the ad text, ad type, and advertiser info in your Excel workbook
- Move to the next domain, discover it has 40+ ads, make an arbitrary call about how many to capture, continue
- Reach domain 16, realize you forgot the advertiser name for the first 10 rows, go back and re-pull them
The quarterly review is Thursday. This was supposed to be background research.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the competitor domain list in your worksheet and connects to Adyntel to pull Google Display ad data — ad text, ad type, advertiser — for every row, consistently, in one pass.
With your 25 competitor domains in column A:
Pull Google ads for every domain in column A using Adyntel and write the ad text, ad type, and advertiser to columns B, C, and D
What You Get
- Column B: ad text for each domain's active Google Display ads
- Column C: ad type (text, image, responsive display, etc.)
- Column D: advertiser name as returned by Adyntel
- Domains with no active Google ads get a clear label in the row
What If the Data Is Not Quite Ready
You want to count text ads vs image ads per domain rather than list individual creatives
Fetch Google ads for each competitor domain in column A using Adyntel and count how many are text ads vs image ads — write the text ad count to column B and image ad count to column C
Some entries in your list are brand names, not domains — you need to normalize them first
For each entry in column A, convert brand names to their primary domain where possible, then pull Google Display ads from Adyntel and write ad text, ad type, and advertiser to columns B, C, and D
You want to flag domains where image ads significantly outnumber text ads
Pull Google ads for each domain in column A using Adyntel, write the text ad count to column B and image ad count to column C, and flag in column D any domain where image ads outnumber text ads by more than 3:1 as 'creative-heavy'
One prompt that pulls, counts, flags, and adds a strategic note per domain
For each domain in column A, pull Google Display ads via Adyntel; write text ad count to column B and image ad count to column C; flag 'creative-heavy' in column D where image ads are 3x or more; and add a one-line strategic note in column E — 'investing in visual creative', 'relying on search copy', or 'balanced mix'
The quarterly deck has what it needs before Thursday morning.
Try It
Get the 7-day free trial of SheetXAI and open your competitor domain list in Excel, then ask it to pull Google Display ad data from Adyntel for every row. Also useful: pulling LinkedIn ad creatives and the full Adyntel integration guide.