Four production systems running inside client analytics environments. Each entry covers the problem, the technical approach, the tools, and the form of evidence available on request.
Each is a real engagement. The system and client names sit behind approvals; supporting diagrams, screenshots, and before/after outputs are available on request.
Forecasting workflows in BigQuery covering GSC query trends, channel traffic, and monthly reporting cycles. Used by analyst and account teams to flag variance against forecast inside the cycle rather than after it. Forecast confidence bands surface the range, not just the point estimate.
LLM-assisted classification across press, review, and social. The system classifies, deduplicates, and surfaces shifts; nothing is auto-published. Annotated bands track positive, neutral, and negative coverage over time so analysts can interpret context, not just deltas.
Tracking how brands and queries surface across AI Overviews, ChatGPT, Perplexity, and conventional search. Each change captured with date, prompt, and rendered citation so visibility shifts can be reviewed weeks later, not just observed in real time.
Automated assembly of recurring reports and decks from GA4, GSC, and ad-platform data. Replaces a multi-hour manual build with a short analyst review pass. Each step on the before bar is a real stage; the after bar shows what remains.
Each case study has documents catalogued and shareable on request. Approvals required for some artefacts.
Source list with status, type, and access route for every public claim.
Open / 02CCN expert citations, IGI Global peer review, publication context.
Open / 03Live URLs for Cointelegraph and AlphaWire, plus a PDF archive.
Open / 04Verbatim quotes from BBC, General Mills, MRI, Diligent Pharma.
Open