Context
A professional property appraisal service in Brasília, where every inquiry is a business opportunity.
Challenge
The previous version was a single-page application that relied on JavaScript to display content, which makes it harder for Google to read. Contact requests had no organized place to be tracked.
Goal
Rebuild the website with complete, indexable HTML, and turn every inquiry into a logged, trackable lead.
Solution
A rebuild in Astro with static pages, a form that saves requests to a database and a dedicated admin dashboard to track each lead.
Architecture
- Astro 7 for static pages
- PHP endpoints for the form
- MySQL database for leads
- Admin dashboard with login
Features
- Contact form with database logging
- Dashboard with status, notes and CSV export
- WhatsApp button with a different message for each service page
SEO
- Search intent map per page
- Explicit rule against duplicate neighborhood pages (anti-doorway)
- Automatic checks of links, H1, title, description, canonical, structured data and sitemap
Automation
- Quality check script before each release, including a scan for secrets exposed in the code
- Deploy that backs up the server before publishing
Results
- Website migrated from SPA to indexable static HTML
- Leads centralized in a dedicated dashboard
- Publishing process with automatic checks and backups