Manage the data of 50+ clients without inheriting chaos
When every client lives in its own spreadsheet with its own logic, the real architecture lives in one person's head. The alternative: explicit layers in BigQuery, a multi-client pattern chosen on purpose, and onboarding that takes minutes.
I love how easy to use and fast Detrics is for integrating data. It's super easy to set up a custom database for a client in mere minutes. It's perfect for my needs. Nothing really, atleast for the stuff I use detrics with I use Detrics to combine data from Me…I love how easy to use and fast Detrics is for integrating data. It's super easy to set up a custom database for a client in mere minutes. It's perfect for my needs. Nothing really, atleast for the stuff I use detrics with I use Detrics to combine data from Meta Ads, LinkedIn, and Google. It solves integration issues easily and quickly. I also appreciate its ease of use, allowing me to set up custom databases for clients in minutes.
T
Tom N.
December 23, 2025
The best tool to get data
The templates to create dashboards about diferents topics The limit of the queries quantity for the free version Detrics solves my need to have the data of many clients centralized in one place to make data-driven decisions.
A
Alan D.
September 12, 2025
The boost in productivity for me and my team has been amazing
First of all the easy it is to use and implementation. Really intuitive, great support and the best, no bugs! It was really fast and easy to integrate with all marketing platforms that I use. Detrics allows me to download al marketing metrics and dimensions I…First of all the easy it is to use and implementation. Really intuitive, great support and the best, no bugs! It was really fast and easy to integrate with all marketing platforms that I use. Detrics allows me to download al marketing metrics and dimensions I need to create dashboards for my clientes. Also, It has import and export features that allow me to recreate dashboards in just seconds! Im really hapy with this upgrade to Detrics. I use Detrics every day and my dashboarding experience has changed. So far, I haven't encountered anything that I truly dislike It helps me save time when it comes to reporting. It automates download from all my clients accounts and platforms for me to be able to get more time to think about strategy. One of the best parts is once you've finishe with a client, you can just duplicate files and export queries already created in the original file. So you have active dashboards in just seconds.
I
Ignacio G.
July 18, 2025
Simple Integration and Detrics Economy
I like how Detrics simplifies my report management for my agency. It makes data downloading easier and is very user-friendly. I love how easy it is to integrate and how quickly it responds. Additionally, it is cost-effective, which is a great benefit. I also a…I like how Detrics simplifies my report management for my agency. It makes data downloading easier and is very user-friendly. I love how easy it is to integrate and how quickly it responds. Additionally, it is cost-effective, which is a great benefit. I also appreciate that with just a few clicks I can download, organize everything, and schedule queries very simply. The initial setup was easy, it only required a couple of clicks and creating the account. When the volume of data is absurdly large, it cuts off a bit or it bugs out. Detrics simplifies my report management, makes data downloading easier, and integrates easily. It allows me to organize and schedule queries with just a few clicks, making it very user-friendly and easy to use.
J
Joshua H.
May 13, 2025
Click-and-Refresh Solution
Integration eliminated our weekly manual updates. Connected our data sources through simple clicks and reports now refresh automatically. Completely Satisfactory: There wasn't a single element I found disappointing or lacking in the entire experience. Connecte…Integration eliminated our weekly manual updates. Connected our data sources through simple clicks and reports now refresh automatically. Completely Satisfactory: There wasn't a single element I found disappointing or lacking in the entire experience. Connected previously isolated data sources and delivered automated cross-functional reporting.
L
Lola G.
May 6, 2025
All features performed great with no complaints
I tried dietrics since day one, and it improved so much! All features performed great with no complaints Nothing particul, its a great product for daily use. automation and reporting velocity
Every row Detrics writes to your warehouse carries _detrics_account_id: the ad account, Analytics property or e-commerce store the data came from. Add a master client table in BigQuery that ties each account id to its client and platform, and you have everything you need. When a contract demands hard isolation, a separate dataset per client adds its own IAM, billing and visibility.
Step 2
Design the base table groups
The schemas every client receives are built once and reused: daily campaign performance per platform, creatives for ads. Special requests live apart, named per client.
Step 3
Turn on sync-all
One transfer per source with every account, current and future. Adding a client stops being a project.
Step 4
Consolidate with the three layers
A dashboard consumes exactly one master table. The blending lives in versioned SQL, and the BI tool only visualizes.
Shared with a master client table: minimal transfers, new accounts get captured on their own, and onboarding takes minutes. Per client: hard isolation with IAM, separate billing and datasets each one can see. Hybrids also work: a shared base plus separate datasets for those who demand isolation.
A small BigQuery table that maps each _detrics_account_id to its client and platform. Since every row in your warehouse carries that field, the join works for any data point. Enrich it with monthly budget, fees or whatever matters to your agency: fresh, up-to-date raw data is the foundation, and on top you configure what your business needs.
By connecting Claude to the BigQuery MCP: ask for joins, new master tables and schema changes in natural language, and the agent runs them on your warehouse. We have a step-by-step tutorial to get it running in minutes.
GA4, Meta Ads and Klaviyo support syncing fields specific to each account. The column exists in the table, the accounts that have it fill it, and the rest stay NULL: BigQuery handles sparse columns natively. You can isolate the special case in a client-specific table group or add it to the shared table.
With per-client datasets you apply Google Cloud IAM permissions and billing per project. With a shared dataset, the separation happens in the consolidation layer: every query joins the master client table on _detrics_account_id and filters the accounts that belong.
By separating development from active, and knowing which change is additive (adding a metric) and which is breaking (changing a dimension redefines the table's grain). The architecture skill includes the full table of safe and risky changes.
