# Pre-built tables

***

## Why pre-prebuilt transformations ?

Having data in your cloud is one thing.\
Having structured data ready for analysis is another.\
Once your data is fed into the tables, it remains scattered across different data sets. Consolidating these data can be lengthy and tedious.

QUANTI: manage some transformations, always useful for 100% of our customers.

<figure><img src="https://1847929239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoRN0sxIyI0UJdSqkwdBu%2Fuploads%2Ff3NzsCpAEawheIxsjSsC%2FCapture%20d%E2%80%99e%CC%81cran%202024-05-18%20a%CC%80%2009.40.21.png?alt=media&#x26;token=2815b70a-f14c-4762-9055-2bfa91cc42c9" alt=""><figcaption></figcaption></figure>

## How

This chapter deals with the topic of **transformation** and the aggregation work also called [**RECONCILIATION**](https://docs.quanti.io/transformations/the-principle-of-reconciliation)**.** This is made possible thanks to:

* Perfect knowledge of the specificities of advertising partners' APIs allows us to extract data correctly and centralize their storage in client-dedicated Data Warehouses.
* A method to standardize and harmonize data originally coming from different advertising platforms.
* A method to align navigation data (Site-centric - e.g., Google Analytics 4) with campaign data (Ad-centric - e.g., Meta) to automate the calculation of key performance indicators (e.g., Return On Ads Spend).

<figure><img src="https://1847929239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoRN0sxIyI0UJdSqkwdBu%2Fuploads%2F7bu8Rr2u3wFtIKxy6Eeg%2FCapture%20d%E2%80%99e%CC%81cran%202024-05-15%20a%CC%80%2010.38.14.png?alt=media&#x26;token=0b0debe6-c4ea-4fa6-881f-4a665aac780d" alt=""><figcaption><p>Reconciliation = Automatic calculated fields</p></figcaption></figure>

The general idea of this transformation step is to make the data more digestible and more usable for visualization, analysis, and decision-making purposes.

## Pre-built tables

{% content-ref url="pre-built-tables/ads\_import" %}
[ads\_import](https://docs.quanti.io/transformations/pre-built-tables/ads_import)
{% endcontent-ref %}

{% content-ref url="pre-built-tables/ads\_import\_conv" %}
[ads\_import\_conv](https://docs.quanti.io/transformations/pre-built-tables/ads_import_conv)
{% endcontent-ref %}

{% content-ref url="pre-built-tables/quanti\_ids" %}
[quanti\_ids](https://docs.quanti.io/transformations/pre-built-tables/quanti_ids)
{% endcontent-ref %}