Connor H.

I’m building a list to check whether companies are currently running Google and Meta ads, but I’m running into an issue on the Meta side… I’m using an AI enrichment that attempts to pull the data, the intended process is:

In theory, this should flag each company as either running or not running Meta ads — but it seems its not able to visit the URLs for some reason… My prompt for the AI enrichment is this: Visit the “Facebook Page URL” response provided. Add /about_profile_transparency to the end of the URL. Check the page for the exact line: “This page is currently running ads.” or “This page is not currently running ads.” Based on the result: If “This page is currently running ads.” is found, output “🟢 Running Ads” If “This page is not currently running ads.” is found, output “🟥 Not Running Ads” Important: Only return one of the two outputs (“🟢 Running Ads” or “🟥 Not Running Ads”) and nothing else. If the response is unclear or confidence is below 95%, default to “🟥 Not Running Ads”.

Has anyone built a “find companies” table that leverages Google Search, SerpAPI, or similar services to generate SERP results based on specific keywords and locations…? I’m having issues integrating my SerpAPI results to clay. I’m aiming to create a list of businesses by searching terms like “roofing companies near me” and extracting company names from links found on Page 2 and beyond. Any insights or examples would be greatly appreciated! I’ve done a bit of research into it online and seems there aren’t too many resources on this…