How Iluminators replaced manual reporting with one analytics system for every client

Customer logo
Case study thumbnail
Iluminators is a French digital marketing agency that manages Meta and Google Ads campaigns for many clients. Reporting relied on manual exports and spreadsheets, and every account was measured slightly differently. We gave the agency one analytics setup that works the same way for every client.

Founded in

France

Became Customer

Website

About Iluminators

Iluminators is a digital marketing agency based in France. It manages Meta Ads and Google Ads campaigns for a portfolio of clients, and for each of them it is responsible not only for running the campaigns but also for showing clearly what the budget is delivering.

For an agency, reporting is part of the product. Clients judge the relationship by how well they understand their results, and the agency's own team needs the same clarity to optimize campaigns and decide where to move budget.

The challenge

Reporting relied heavily on manual work. Each client report started with downloading data from Meta and Google Ads, combining it in spreadsheets and formatting it by hand. The process worked, but it took time away from the work that actually improves results, and it became heavier with every new client.

There was also a consistency problem. Spend, leads and conversions, cost per lead and acquisition, and conversion rate were calculated slightly differently from one account to the next. That made it hard to compare clients, spot patterns or explain differences with confidence.

What the agency needed
  • One place where Meta and Google Ads performance comes together, without manual exports.

  • A single set of KPI definitions that applies to every client.

  • A clear cross-channel view for the internal team, to support faster optimization decisions.

  • Client-facing reports that look and read the same way, and that are quick to set up for each new account.

Our approach

We began with the definitions, because consistent reporting is impossible without them. Together with the agency's Head of Technology we agreed how each core KPI is calculated and applied that logic to every client account. With the definitions in place, the technical work could follow a clear plan, run by a team of two to five Solverix specialists.

What we put in place
  • Automated ETL pipelines that consolidate Meta and Google Ads performance into one dataset, refreshed without manual exports.

  • Standard KPI definitions across all clients: spend, leads and conversions, cost per lead and acquisition, and conversion rate.

  • Power BI dashboards that give the agency's team a cross-channel view for internal optimization.

  • Client-facing report templates, so recurring reporting scales with every new client.

Under the hood: Solverix OS with Power BI on top

Iluminators already wanted to use Power BI, and that was the right choice for the front end. What Power BI does not provide on its own is a clean, consistent data foundation. Solverix OS fills that role: it extracts data from both ad platforms, loads it into a central store and transforms it with the agreed KPI logic before any report reads it.

This is the main difference between a custom data layer and building everything inside a BI tool or Microsoft Fabric. The business logic is defined once, outside individual report files, so every dashboard and every client template uses exactly the same numbers. When a definition changes, it changes everywhere at once, and a new client account is added to the pipeline instead of rebuilt by hand.

Built for the team to keep growing
  • The agency's team works in Power BI, a tool it already knows, while the data underneath stays consistent.

  • New clients are onboarded on the same templates and definitions, so reporting grows with the business instead of the workload.

  • The engagement started in September 2025 and is still running. Regular check-ins and online support cover report progress, new KPI logic and new client setups as the agency's needs change.

The result

Much of the manual exporting and spreadsheet work is gone, and that time now goes into campaign work. The team understands campaign performance better and makes budget decisions faster. Every client receives reports that look and read the same way, which makes the agency's work easier to understand and easier to trust.

In their words

"They consistently delivered all items on time, meeting deadlines without compromising on quality."

Aimen Salem, Head of Technology, Iluminators (verified 5.0 review on Clutch)

Closing perspective

For a growing agency, reporting should scale with the client list, not with the hours the team can spend in spreadsheets. By separating the data foundation from the dashboards and agreeing on shared definitions, Iluminators turned reporting from a recurring chore into a consistent part of the service it offers every client.

"They consistently delivered all items on time, meeting deadlines without compromising on quality."

Reviewer portrait

Aimen Salem

Head of Technology, Iluminators

On this page

Keep exploring how modern teams ship

Keep exploring how modern teams ship