A UK B2B performance marketing agency
An AI assistant their clients use directly
Project overview
Giving clients direct access to their own data
Our client is a UK B2B performance marketing agency managing ten ad, analytics and CRM platforms per client. Clients wanted answers without waiting for a report, and the agency's daily data loads were timing out as often as 43 times a day. Sinarc built an AI assistant inside the agency's client portal, backed by automated daily pipelines into BigQuery, so clients could ask questions of their own data directly.

The need
Ten platforms, and a pipeline that kept failing
Each client account pulled data from up to ten different ad, analytics and CRM platforms, the kind of paid media, SEO and CRM mix a B2B performance agency runs. Daily data loads into the reporting warehouse were timing out up to 43 times a day, breaking dashboards and delaying reports. Clients still had to wait for a report before they could see how their spend was performing, and adding a new client meant new code, not just new configuration.
The solution
Thirteen daily pipelines and an assistant in the portal
We built 13 automated daily pipelines covering every ad, analytics and CRM platform the agency uses, drawing on Gyrus's standard connectors for platforms such as Google Ads, LinkedIn Ads and Microsoft Ads, and rewrote the failing jobs to fix the reliability issues causing the timeouts. Leads were joined through to closed-won deals in BigQuery alongside campaign spend. On top of that warehouse, we shipped an AI assistant inside the agency's own client portal, built so each client's AI access is scoped to only their own data, plus a separate internal workspace for the agency's team that is also usable from Claude.
What we did
The outcome
Clients asking questions of their own data
Clients self-serve: Clients ask questions of their own data directly through the portal, instead of waiting on a report.
Data kept separate: Each client's AI access is scoped to their own data only, enforced in the system and covered by automated tests.
Reliability fixed: Daily pipeline timeouts went from 43 a day to zero after the rebuild.
No code to onboard: Adding a new client account is a setup entry in the warehouse, not a development task.
Ongoing support: Sinarc continues to support and extend the platform and pipelines with the agency.
Sector: Marketing and advertising. Built on Gyrus, Sinarc’s data and AI platform for marketing agencies.