SERP Pipeline

How It Works

• Cluster Queries: Groups agencies by keywords, searches Google Local to find websites in bulk.
• Exact Queries: One query per unmatched agency for precise matching.
• Geo Queries: Neighborhood-based discovery using ~600 bairros from CSV. Finds agencies not in CRECI.

Results go to serp_results table. Queries tracked in queries table. Deduplication via place_id.