Anfloyanfloy.
+
+ Book
All case studies
LeverXEnterprise SAP consulting

How we built an SEO intelligence layer for LeverX.

LeverX competes for organic search against a field of global SAP integrators, and the intelligence that guided it was pulled by hand: every week a specialist exported SEMrush reports and rebuilt the competitive picture in spreadsheets that were already a week old. We gave the marketing team an intelligence layer instead. One self-updating platform tracks leverx.com against a hand-picked competitor watchlist across four markets every day, and turns raw ranking data into the analysis the team actually acts on: content gaps, striking-distance keywords, cannibalization, and newly published competitor pages, with reporting no one could assemble by hand. It is multi-user by design, so the whole marketing team works on it with role-based access instead of one person's spreadsheet, and a plain-language AI assistant answers any question grounded in the platform's own live data. The dashboard never calls SEMrush live: every view is computed on read from an owned Postgres cache, refreshed on its own every day. It runs in production on LeverX's own cloud, and they own every line of it.

Book a strategy call ↳ 30-min call · zero obligation
Anfloy × LeverX
anfloy.LeverX
[ 01 ]
Daily
self-updating rank tracking, replacing a manual weekly SEMrush pull
[ 02 ]
1
intelligence layer over every keyword, competitor, and market: one source of truth
[ 03 ]
3
user roles, so the whole marketing team runs on one platform, not one specialist
[ 04 ]
100%
owned by LeverX, deployed on their own cloud

The challenge

LeverX competes for organic search against a field of global SAP integrators, and the intelligence that guided it was pulled by hand. Every week, a marketing specialist logged into SEMrush, exported rankings, and rebuilt the competitive report in spreadsheets.

The data was a week old the moment it was done, the analysis only happened when that one person had time, and the whole competitive picture lived in files no one else could open. The team could not self-serve, and it could not answer a question the moment it mattered. That was the problem.

One intelligence layer over their SEO

We replaced the manual workflow with a single intelligence layer over LeverX's entire search footprint. One platform tracks leverx.com against a hand-picked competitor watchlist every day, and turns raw SEMrush data into decisions: rankings, gaps, alerts, and trends in one place, always current.

The decision underneath it: the platform never calls SEMrush live. Ranking data is ingested into its own Postgres cache, and every view is computed from that cache on read, then refreshed on its own by a daily scheduler. The result is one source of truth that is instant, always available, and never a week behind again.

Built for the whole team

It is multi-user by design. The whole marketing team works on one platform through role-based access, owner, admin, and viewer, each person seeing exactly what they should, with one-time temporary passwords and a full audit trail of who did what.

The expertise that used to live in one specialist's spreadsheets now lives in a system the entire team can open, query, and act on. Competitive intelligence stopped being one person's job and became something the whole team runs on.

Reporting no one could do by hand

On top of the data sits the reporting that makes it powerful. Content gaps surface the keywords competitors rank for that LeverX does not, scored by opportunity. Striking-distance finds the keywords sitting one push from page one and drafts a meta title, description, and content angle for each. Cannibalization flags where two LeverX pages compete for the same term, and new-page tracking resolves a competitor page's true publish date, so the team sees what rivals actually just shipped.

All of it pivots by market across the US, UK, DE, and PL, holds a full history of every snapshot, and exports clean. It is reporting no one could assemble by hand, produced automatically, every day.

Ask the intelligence layer

The whole platform is queryable in plain language. A streaming AI assistant answers questions about LeverX's rankings grounded only in the platform's own live data, and it reads the exact numbers on the dashboard, so it can never drift from what the team sees.

Ask where a competitor overtook us last month, or which gaps are worth chasing this quarter, and the answer comes back built from the real data and cited to it, not a generic guess.

Built like production, built to own

It is built like production software, not a demo. Role-based access and an audit log, shipped as Docker containers with a continuous-integration pipeline that boots the whole stack and smoke-tests it on every change, plus a full set of handover docs so LeverX's team can run it without us.

It runs in production on LeverX's own cloud, Railway for the backend, Vercel for the front end, with their own keys. LeverX owns every line of it.

How it fits together

One intelligence layer, the whole team.

The intelligence layer

SEMrush data ingested daily into an owned Postgres cache, every fetch tracked for provenance, turned into rankings, gaps, and reporting computed on read, with a grounded AI assistant on top.

SEMrush export · run-based Postgres cache · compute-on-read analytics · daily scheduler · role-based multi-user access · grounded Claude assistant
The whole team

Owner, admin, and viewer roles, so the entire marketing team works on one platform with an audit trail, not one specialist's spreadsheet.

Every report

Content gaps, striking-distance, cannibalization, and new-page detection, pivoted by market and held in full history, produced automatically every day.

ProductionRuns daily on LeverX's own cloud, with their own keys. LeverX owns every line of it.
[ 01 ]What we built
Self-updating SEO intelligence layerSEMrush (browser export · API · CSV)Run-based Postgres cache · compute-on-readDaily auto-update schedulerMulti-user, role-based access + audit logContent gaps + striking-distance AI suggestionsCannibalization + new-page trackingMulti-locale reporting (US · UK · DE · PL)Historical snapshots + CSV exportGrounded Claude assistantDocker + CI · Railway + Vercel
[ 02 ]More in production
LinkedIn creator, audio mediaThe Voice BoxHow we built a signal-based outbound engine.Read the case study $8M B2B outbound agencyColdIQHow we built an AI company brain.Read the case study Online education programThe Tee Shirt StoreHow we built a chatbot that sells the program.Read the case study
See all case studies
[ 099 ]The next move

Let's build
what your
company needs.

Drop your email. We'll send The Custom Agent Blueprint on what we'd build first for a company like yours, before you ever take a meeting.

↳ Or skip ahead · book a call