SolutionsTalk to us

A UK B2B performance marketing agency

An AI assistant their clients use directly

10platforms unified, incl. CRM
43 → 0daily data-load failures
No codeto onboard a new client

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.

Written insights by channel and device, followed by recommendations

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

GyrusBigQueryCRM IntegrationAI AssistantClient PortalGoogle AdsLinkedIn AdsPipeline Reliability

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.

See our strategy in action.

Book a free consultation