IPTV
An IPTV subscription service (anonymised).
Sales and marketing data unified into one governed warehouse: 3-layer attribution down to click level and all ad spend reconciled against real sales, with incremental models cutting analytics costs by ~96%. The SEO operation now runs AI-first: agents connected to Ahrefs over MCP do the recurring analysis and monitoring.
Where it stood
Sales and marketing data apart
Ad platforms, analytics and sales lived in separate systems, so nobody could say which channel brought paying subscribers.
Ad spend nobody could reconcile
Platform-reported results didn't match real sales.
Analytics that cost too much
Full-table queries over growing data made every report expensive.
International SEO at scale
Several regions and hundreds of queries to win and hold, with recurring analysis eating specialist time.
What we did
One governed warehouse
Sales and marketing data unified in BigQuery, modelled in Dataform.
3-layer attribution
Attribution down to click level, with all ad spend reconciled against real sales.
Incremental data models
Models that only process new data, which cut query costs by ~96%.
International SEO
Semantic expansion, a multi-region visibility strategy and continuous technical optimisation.
AI-first SEO operations
Claude agents connected to Ahrefs over MCP run keyword and competitor analysis, rank and backlink monitoring, technical audits and regular insight reports.
// what the agents did
Run the recurring SEO analysis, monitoring and audits; maintain the data checks.
// what people decided
Set strategy and priorities, approve site changes, own the attribution model and the numbers.
What changed
- ~96% lower analytics query costs
- 100% of ad spend reconciled against real sales
- ~80% of high-frequency target queries in the TOP 3, and 95% site visibility
- 870+ ranked queries, sustained over a multi-year engagement
- Senior specialists spend their time on strategy, not data pulls
Get a proposal
Tell us what you want to grow. We reply within 24 hours with what we'd look at first.