# ads\_import

***

## Introduction

**ads\_import** is a pre-built table that allows for the consolidation of impression, click, and spend data from all platforms into a single table. 

#### Without ads\_import : 

<figure><img src="https://1847929239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoRN0sxIyI0UJdSqkwdBu%2Fuploads%2Fws1P4kLxlzdtpSe3IKEh%2FCapture%20d%E2%80%99e%CC%81cran%202024-05-22%20a%CC%80%2016.47.31.png?alt=media&#x26;token=2abeaab0-4601-4036-aa8d-50cd794e9cf9" alt=""><figcaption><p>Example without ads_import</p></figcaption></figure>

#### With ads\_import

<figure><img src="https://1847929239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoRN0sxIyI0UJdSqkwdBu%2Fuploads%2Fhi0VpXpcWp8iYpqSAlqC%2FCapture%20d%E2%80%99e%CC%81cran%202024-05-22%20a%CC%80%2016.50.35.png?alt=media&#x26;token=d3f1cf92-982f-418b-ac81-31387c604c14" alt=""><figcaption><p>Example with ads_import</p></figcaption></figure>

***

## Schema

```sql
`your-project`.quanti.aggregation.ads_import
```

| field name            | type    |
| --------------------- | ------- |
| **date**              | DATE    |
| **quanti\_id**        | STRING  |
| platform\_spend       | FLOAT64 |
| platform\_clicks      | FLOAT64 |
| platform\_impressions | INT64   |

***

## Dimension and Unique keys

The primary keys of the table are:

* `date` : aggregates the data daily.
* `quanti_id` :  aggregates data at a "**ad**" level. The `quanti_id`  allows, via 'tracking templates,' to insert this information into campaign parameters (traditionally called UTM parameters) in order to link <mark style="background-color:purple;">ad-centric</mark> information with <mark style="background-color:yellow;">site-centric</mark> information.

{% hint style="info" %}
Get more information about how is built **quanti\_id** directly in [quanti\_ids](https://docs.quanti.io/transformations/pre-built-tables/quanti_ids "mention")
{% endhint %}

***

## Metrics

The metrics of the table are:&#x20;

* platform\_spend : which accounts for advertising spends.
* platform\_clicks :  which accounts for clicks on advertisements made by users.
* platform\_impressions : which accounts for impressions of advertisements on the platforms' distribution networks.