The Scenario
It's mid-July and Q3 creative production starts in two weeks. You're a paid social strategist and you've been asked to benchmark 30 competitor Meta ad creatives before the design team gets briefed — what formats, what copy angles, how long do the longer-running creatives appear to have been live.
Your workbook has the 30 domains. Last quarter, someone on the team did this audit by hand in the Meta Ad Library. The workbook that came back had 11 domains missing, three where only image ads were captured and video was skipped entirely, and one domain entered twice. You inherited that sheet. You are not running this process that way again.
The bad version:
- Open the Meta Ad Library, filter by country, search the first domain, scroll through all active ads, copy ad copy and format notes into your Excel workbook
- Repeat for the remaining 29 domains, losing your place twice when the library reloads and resets your filters
- Discover that four domains have hundreds of active ads and you've only captured the first page — now you have to decide whether to re-pull or note the gap and move on
You're a paid social strategist. Your job is to read the data and build the brief. Not to spend a full working day in Meta's UI copying things by hand.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your domain list and connects to Adyntel to pull active Meta ad data for every row — ad copy, creative type, and engagement metrics — without you touching the Meta Ad Library at all.
With your 30 competitor domains in column A:
For each domain in column A, fetch their Meta ads using Adyntel and write the ad copy, creative type, and engagement metrics to columns B, C, and D
What You Get
- Column B: ad copy text for each domain's active Meta ads
- Column C: creative type (image, video, carousel, story, etc.)
- Column D: engagement metrics as returned by Adyntel
- Domains with no active Meta ads get a clear label in their row — you're not left guessing whether a blank means no ads or a failed pull
What If the Data Is Not Quite Ready
Some domains are parent companies — you want ads for specific product brands, not the whole company
For each domain in column A, pull Meta ads using Adyntel; if a domain returns more than 50 active ads, flag it in column E as 'brand umbrella — review manually'; otherwise write ad copy and creative type to columns B and C
You want to flag ads that appear to have been running for more than 30 days as 'evergreen'
For each domain in column A, fetch Meta ads using Adyntel, write ad copy to column B, creative type to column C, and label column D 'evergreen' if the ad appears to have run longer than 30 days, 'recent' otherwise
Your workbook has two worksheets — one for direct competitors and one for adjacent brands
Pull Meta ads from Adyntel for every domain in both the 'Direct' and 'Adjacent' worksheets, combine results in a new worksheet called 'Meta Creative Audit', and include a column indicating which worksheet each domain came from
One prompt that pulls, flags evergreens, and classifies copy angle for the brief
For each domain in column A, pull Meta ads using Adyntel, write ad copy to column B, creative type to column C, label evergreen ads (30+ days) in column D, and classify the primary copy angle in column E — choose from 'transformation', 'feature', 'social proof', 'price', or 'urgency'
One pass. The design brief has what it needs.
Try It
Get the 7-day free trial of SheetXAI and open your competitor domain list in Excel, then ask it to pull Meta ad creatives via Adyntel for every row. Also see bulk-pulling LinkedIn ad creatives and the full Adyntel integration guide.