- client
- Diários Associados and consulting clients
- role
- solo to majority authorship
- stack
- Python
- FastAPI
- Celery
- Playwright
- PostgreSQL
- Next.js
- TypeScript
- Fastify
- Prisma
- BullMQ
Context
GA4, Search Console, Ad Manager, Trends, PageSpeed/CrUX and Discover hold the answer to almost every business question a publisher has — and none of them answers it alone. The work is in cross-referencing them.
Intervention
A set of in-house tools built on these APIs, each one answering a specific question:
| Tool | Question it answers |
|---|---|
seo-analizer |
Where the domain is losing visibility, and why |
sentinel |
Are the feeds intact? Where is traffic leaking? |
gam |
How much the network billed, by brand, by format |
adstxt-hub |
Is each portal's ads.txt correct and up to date? |
gerador-de-pautas |
Which story ideas have demand right now, based on Trends + GSC + GA4 |
uai-trends / cb-trends |
What is rising in the audience right now |
The recurring stack is FastAPI + Celery + PostgreSQL on the data backend, Next.js for the dashboard, and an LLM where qualitative reading adds value — not where the number is enough.
Outcome
Proprietary tooling in production, with googleapis present in dozens of projects in the collection. It is the consultancy's niche differentiator: marketing data engineering, not agency reporting.
Role
Solo authorship for the most part; verified in autoria.tsv.