Automated Competitor Ad Analysis on Meta

Automatically gather competitive intelligence by scraping ads from the Meta (Facebook) Ad Library, performing an AI-powered strategic analysis on them, and compiling the insights into a structured report in Google Sheets.
This automation acts as your personal ad intelligence analyst. It starts by reading a list of your competitors from a Google Sheet you provide. Then, for each competitor, it opens a browser and navigates to the Meta Ad Library.
The automation systematically scrapes all of their currently running ads and filters them to find the "greatest hits"—the ads that have been running the longest, based on a minimum number of days you can set. These long-running ads are often a company's most successful and revealing campaigns.
Next, the magic happens: the automation feeds the data on these key ads to an AI model, asking it to perform a strategic analysis. It extracts the ad's hook, classifies its creative type, and provides a concise strategic insight into why the ad is effective. It also generates an overall summary of the competitor's ad strategy.
Finally, all of this structured data—including the ad-by-ad analysis and the overall strategic summaries—is neatly organized and written to a new tab in your original Google Sheet, creating a powerful, actionable competitive intelligence report.
Usage Ideas
  • Weekly Competitive Scan: Run this automation weekly to keep a constant pulse on your competitors' ad strategies and new campaign launches.
  • Quarterly Strategy Review: Generate a comprehensive report on your top 5 competitors' most successful ads to inform your own quarterly marketing strategy.
  • Creative Inspiration: Analyze the hooks and creative types that are working in your industry to brainstorm ideas for your own ad campaigns.
  • Identify Market Trends: By analyzing multiple competitors, you can spot emerging trends in messaging, offers, and ad formats within your niche.
  • Onboard New Team Members: Quickly bring new marketing hires up to speed on the competitive landscape with a detailed, data-driven report.
Customization Ideas
This template is a powerful starting point that can be easily tailored to your specific needs. You have the flexibility to:
  • Change Your Data Source and Destination: While this template uses Google Sheets to read your competitor list and save the final report, you can easily change this to use another service. For example, you could read competitors from a CRM or send the final report to a Slack channel.
  • Define "Significant" Ads: You can easily adjust the minDaysActive setting to change the filter for what you consider a long-running ad. Focus on brand-new campaigns (e.g., 7 days) or only the most established ones (e.g., 90+ days).
  • Customize the AI Analysis: The heart of this automation is the AI's analysis. You can modify the prompts to ask different strategic questions. For example, you could ask the AI to analyze the target audience, the pricing mentioned, or the emotional sentiment of the ad copy.
  • Tailor Your Final Report: You can change the columns in the output report to match the insights you care about most. If you customize the AI analysis, you can add new columns to capture that new information.
Agent Inputs
Required Parameters
Name
Type
Default
googleSheetUrl
string
None
URL of the Google Sheet containing competitor names in Column A of Sheet1. Results will be written to an 'Ad Intelligence Results' tab.
Optional Parameters
Name
Type
Default
maxCompetitors
number
3
Maximum number of competitors to process per run. Use -1 to process all available competitors.
minDaysActive
number
30
Minimum number of days an ad must be running to be considered 'long-running' and included in results.