Case studies

What was broken, what was built, and what runs reliably now

Specific examples across contract automation, CRM rebuilds, creator discovery, reporting normalisation, and internal AI operating systems.

Case study

Creator Discovery + Data Enrichment

Cross-platform creator discovery shipped: YouTube, Instagram, and TikTok

Built cross-platform creator discovery workflows for YouTube, Instagram and TikTok: scraper runs, profile enrichment, handle normalisation, deduplication against the influencer index, and quality filters before downstream use.

  • YTdiscovery + API enrichment
  • IGprofile enrichment
  • TTscraper workflow
  • Indexdedupe layer
  • Normalised creator handles and platform URLs before records entered the operating workflow.
  • Used scraper outputs, enrichment checks and index matching to reduce duplicate or low-quality leads.
  • Built reusable evidence for creator operations, data quality and cross-platform enrichment work.
Read full case study →
Case study

Reporting + KPI Normalisation

Completed schema/reporting fixes

Stabilised KPI reporting by using Google Sheets as the working data base, then pushing and referencing that data into Looker and other dashboards so the numbers were easier to explain and use.

  • Sheetsworking data base
  • Lookerdashboard layer
  • ClickUpops reference
  • Driftreduced ambiguity
  • Mapped operational questions to explicit metrics and Sheets-backed dashboard outputs.
  • Reduced reporting drift between workflow tools, Google Sheets and dashboards.
  • Shows the reporting-normalisation thread without exposing private data.

Additional delivery work

More work across automation, data, and operations — including internal tooling and personal workflow systems.

FLOW
CRM Rebuild (TechCity)

Rebuilt CRM and sales infrastructure from scratch — 35% faster sales cycles and 80% fewer lost leads across six portfolio businesses.

OPS
Career Ops Pipeline

Multi-source job search with LLM evaluation, tailored outputs, and tracker integration.

SYS
Personal OS Dashboard

Live task orchestration, forensic decision ledger, FTS5 memory search, and model quota management.

AI
Second Brain Knowledge Layer

277 notes embedded with hybrid search, MCP tools, and nightly consolidation.

FLOW
Make deployment governance

Safer versioning, deploy and handover for complex Make automations.

ENG
n8n infrastructure rebuild

17-phase Docker-containerised platform with AI-native connectivity.

OPS
ClickUp CRM from scratch

2 Spaces, 5 interconnected lists, cross-list relationships, per-list automations.

Want the relevant case-study angle for your workflow?

Send the handoff or tool stack. I will respond with the likely first fix and whether a sprint or audit is the right entry point.

Contact Simon