ESFREN

03Data

Data & Analytics

Each ad platform's figures arrive separately, and do not say the same thing. Sandbox built a pipeline on its data warehouse that collects Meta, Google, TikTok and LinkedIn figures every day, normalizes them and reconciles them with the source and with the client's CRM. They arrive in a single view, open at any time in Sandbox Hub.

  • 01Dashboard
  • 02Decision support
  • 03Attribution
  • 04Tracking
  • 05Data warehouse
  • 06Reconciliation
  • 07Reports at every stage
5 SOURCES0102030405MetaGoogleTikTokLinkedInCRMPipelineINGESTIONNORMALIZATIONRECONCILIATIONDAILYDECISION5 SOURCES0102030405MetaGoogleTikTokLinkedInCRMPipelineINGESTIONNORMALIZATIONRECONCILIATIONDAILY DECISION
WHAT WE DO

Decisions made on reconciled figures

01

A pipeline built by Sandbox, on its data warehouse

The Meta, Google, TikTok and LinkedIn APIs, the client's CRM and its offline data feed Sandbox's data warehouse. As of 28/10/2026, 56 scheduled tasks collect these figures every day, normalize them and reconcile them across platforms. Each client's data stays isolated.

Screen: several sources collected into Sandbox's data warehouse
  1. 1Daily API collection from the four ad platforms
  2. 2Normalization and reconciliation with the source
  3. Data isolated per client, secure and controlled access
  4. Cloud hosting, encrypted data
02

A dashboard open at any time

Figures collected daily open in Sandbox Hub, whenever the client wants. Each view answers a precise question: where the budget goes, what it produces, what is drifting. The active campaigns table loads in under two seconds (measured on 29/09/2026).

Sandbox Hub screen: analytics dashboard
  1. 1The four ad platforms in a single view
  2. 2Indicators collected daily
  3. 3Views set by role and need
  4. 4Free export in standard formats
03

Attribution and CRM reconciliation

Conversions are tied to their acquisition source, then reconciled with the client's CRM: duplicates removed, attribution across several touchpoints. The resulting CPA is the one the CRM sees. A request with no known source counts as lost.

Diagram: reconciliation of conversion sources
  1. 1Configurable attribution across several touchpoints
  2. 2Reconciliation with the client's CRM
  3. 3Duplicates removed across sources
  4. 4Offline conversion verification
04

Alerts and decision support

A drop in click-through rate, a budget overrun, a rising CPA: these gaps raise an alert carrying the recommended action. A human decides what comes next.

Screen: anomaly alerts
  1. 1Alert on a click-through rate drop
  2. 2Alert on a budget overrun
  3. 3The recommended action, attached to every alert
  4. 4Complete history of anomalies and actions taken
OUR APPROACH

From collection to decision, in four steps

  1. 01

    A Single View

    Meta, Google, TikTok, LinkedIn and the client's CRM, collected by API into Sandbox's data warehouse, normalized and reconciled. A single view, instead of five exports made by hand. Monitoring is added in Sandbox Hub: six sources in one platform.

  2. 02

    Daily Collection

    As of 28/10/2026, 56 scheduled tasks collect and transform the figures every day. Decisions are made on dated figures.

  3. 03

    Attribution & Reconciliation

    Conversions are tied to their acquisition source, then reconciled with the CRM: duplicates removed, attribution across several touchpoints.

  4. 04

    Alerts & Decision

    Click-through rate drop, budget overrun, rising CPA: every alert carries the recommended action. A human decides.

IN FIGURES

Measurement, in four figures

Scheduled tasks each day, as of 28/10/202656
At most, to open active campaigns (29/09/2026)2 s
Reconciled sources: four ad platforms, the client's CRM5
Action taken on an alert without a human decision0
FAQ

Frequently asked questions

01Which measurement tools do you use?

A data warehouse to bring the figures together, GA4 and Google Tag Manager for collection, Sandbox Hub for dashboards. Contact requests can also be sent to Meta from the server, through the Meta Conversions API. If your tools are sound, we adapt to them.

02Do you connect GA4, the CRM, ad platforms and offline sources?

Yes. The pipeline brings together Meta Ads, Google Ads, TikTok, LinkedIn, GA4, the client's CRM, read and write, and offline data: calls, in-store sales. It reconciles them and removes duplicates across sources.

03How is a measurement pipeline deployed?

In stages: sources first, then the dashboard, then attribution. The timeline depends on the CRM and on the quality of existing data; it is set during scoping. A narrow first scope can serve as a prototype.

04Who owns the data and the infrastructure?

Your data is yours. GA4 and Google Tag Manager are deployed in your own accounts, and every configuration step is documented; the pipeline and the data warehouse are Sandbox's, where your data stays isolated. If the engagement ends, your accounts and their configuration stay with you.

RELATED SERVICES

Explore our other expertise

01Media Buying & PerformanceSandbox buys your media on Meta, Google, TikTok and LinkedIn, and directly on online news sites. Every media plan is revExplore 02Strategy & AdvisoryFrom recommendation to execution, within the same team: media strategy, communication, brand. Every recommendation startExplore 04Listening & Creative IntelligenceMonitoring collects a category's ads and the online press, and creators in demonstration; creative intelligence reads thExplore

Your figures, in a single view

The first conversation covers what you measure today, and what gets lost between the ad platform, the website and the CRM.

Get in touch