Case study

Serpiora: AI-powered SEO software for professionals and agencies

Spanish-language SEO platform that turns Search Console, local SEO, competitor and content data into prioritised tasks, with an AI that cites its sources and reports that build themselves.

LaravelSEOIn-house product
Project

SEO data turned into measurable actions

Search Console, Analytics, Google Maps and keyword tools tell you what is happening, but each one separately and without saying what to do next. Serpiora, conceived and built by AGQ, brings that data into a single platform, finds opportunities backed by evidence and measures the effect of every change, without touching the client’s website.
01

Challenge

Move from dashboards full of metrics to clear decisions, without inventing search volumes or attributing results blindly.

02

Approach

Sync each project’s real data sources with read-only access, combine them in a single data model and prioritise every opportunity with the evidence behind it.

03

Outcome

A complete flow to analyse, prioritise, act and measure, with tasks that compare the baseline period with the period after and reports ready for the client.

Serpiora architecture: a Laravel application syncs Search Console, Bing, Analytics, Google Places and other sources and produces opportunities, tasks, reports and an MCP server
Simplified diagram: Serpiora reads the data with read-only access and never changes the website.
Technology

A stack built to connect real data

Laravel handles organisations, projects, background syncs, tasks and reports; Inertia powers the dashboard; the Google and Bing APIs provide the search data, and OpenAI and MCP connect the AI to each project’s evidence.

LaravelInertiaGoogle APIsOpenAIMCP
Features

From data to task

Each opportunity shows the query, the page and the data point behind it, and can be turned into a task with an owner.

Search Console and keywords

Queries, pages and clusters with their intent, plus detection of keywords close to the top 10, with low CTR or cannibalised.

Local SEO

Google Maps ranking grid by area, Google Business Profile analysis, reviews and local competitors.

AI with sources

An assistant that queries the project data, cites its sources, drafts briefs and tracks brand visibility in AI assistants.

Reports and alerts

Agency-branded PDF reports, a client link, daily alerts and a weekly performance digest.

Mock-up of the Serpiora dashboard with clicks, impressions, prioritised opportunities and the before and after of an applied task
Illustrative mock-up of the Serpiora dashboard with sample data.
Results

What Serpiora brings to professionals and agencies

Serpiora is an in-house product, so this case study explains how it works instead of publishing usage figures.

Evidence-based priorities

Before: metrics without context. Now: opportunities ranked by potential, with their source data.

Measurable impact

Before: changes nobody tracked. Now: every task compares the baseline period with the period after.

AI that doesn’t make things up

Before: generic answers. Now: recommendations with sources that separate facts from hypotheses.

Organised clients

Before: spreadsheets and manual reports. Now: one workspace per client, with permissions and automated reports.

FAQ

Frequently asked questions about Serpiora

The essentials about the product and how it was built.

A Spanish-language, AI-powered SEO software that brings Search Console, opportunities, on-page audits, local SEO, competitors, content, tasks and reports together in one platform.

No. Audits and recommendations are presented for review; the platform never publishes or changes anything on the site.

Read-only. Tokens are stored encrypted and data is isolated per organisation and project.

No. It works with the project’s real data and the providers you connect, such as Keyword Planner, SerpApi or DataForSEO, so estimates are never presented as observed data.

Laravel and Inertia, integrations with the Google, Bing and other SEO provider APIs, OpenAI for the assistant and an MCP server to use the data from other AI assistants.

Need a custom tool?

I can review your idea without assumptions and define a realistic first version.