European Search Award Winner 2025
Best local campagne SEO (Large)
How a single CASE SQL query made Lucardi’s local visibility shine
How a single CASE SQL query made Lucardi’s local visibility shine
D2C (Direct-2-Consumer)
Search
+14,7%
market share in local search results
+32,2%
growth in non-branded local traffic (YoY)
+7,7%
increase in clicks from the Local Pack (YoY)
What?
Driving More Store Visits with Minimal Resources
Awards
How?
Automation from the First Search: Data and AI in one seamless flow
Follo (formerly OrangeValley) created a smart approach centered around a single CASE SQL query that automatically linked all relevant keywords to the right local pages. Using Python scripts and layered datasets, we identified which pages were missing or needed optimization. With the help of the OpenAISheet engine, we generated unique, brand-consistent content for each city—complete with internal links within local clusters. Publication was handled through an API-driven workflow, enabling 394 pages to go live automatically and flawlessly.
Smartly engaging local searchers with high purchase Intent
Locally relevant in every search
The strategy targeted people searching locally for jewelry or services like ear piercings—think consumers who browse online but prefer to buy in-store, or users comparing competitors in their area. By focusing on non-branded keywords per city and smartly combining them with specific product categories, Lucardi achieved large-scale local relevance—without manual customization.
From manual optimization to scalable content deployment
Working smarter with fewer resources
What would normally take dozens of hours of manual work was fully automated. Screaming Frog mapped the existing content structure, while Python scripts and SQL clustering determined which pages needed to be created or improved. AI-generated texts automatically aligned with the brand’s tone and local search intent. Smart internal linking connected pages within relevant clusters. The entire flow, from analysis and creation to validation and publication, ran without any involvement from a content specialist.
More output, less Workload
Efficiency as a competitive advantage
By automating the entire process, we enabled a fast and efficient nationwide rollout. What would normally take 60 hours was now achieved with a single workflow, 7.5 times more efficiently. This massive boost in efficiency freed up Lucardi’s internal team to focus on strategic initiatives instead of operational tasks.
“We were impressed by the creativity and innovation demonstrated in this campaign, especially how a technical constraint and limited time was turned into a real opportunity. The use of automation was clever, and the team delivered some brilliant results on a low budget.”
Jury Quote - European Search Awards 2025: Best Local Campaign (SEO) (Large) Winner
Data, speed, and results: Rewarded with gold
Recognized by the European Search Awards 2025
Lucardi’s local SEO approach was awarded the European Search Award for Best Local Campaign (SEO): Large. The case was also nominated in the category Best Low Budget Campaign (SEO): Large. A clear recognition that with one scalable solution, smart automation, and minimal resources, you can achieve consistent results, and set a new standard for local visibility.
