# quanti\_ids

***

## Introduction

**Quanti\_ids** is the name given to this pre-built dimension table related to statistics found in **ads\_import** and **ads\_import\_conv**.\
The goal is to consolidate the dimensions of advertising platforms into a single table with a unique table schema.

#### Without quanti\_ids : 

<figure><img src="https://1847929239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoRN0sxIyI0UJdSqkwdBu%2Fuploads%2FH09s4gEgKRyfNjLzGzWp%2FCapture%20d%E2%80%99e%CC%81cran%202024-06-13%20a%CC%80%2016.23.54.png?alt=media&#x26;token=6b5c4d65-1e0f-4da1-b6bd-0c46fb12ad2c" alt=""><figcaption><p>Example without quanti_ids</p></figcaption></figure>

#### Without quanti\_ids :&#x20;

<figure><img src="https://1847929239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoRN0sxIyI0UJdSqkwdBu%2Fuploads%2FoHdOptYYkb0yZvwvVv0f%2FCapture%20d%E2%80%99e%CC%81cran%202024-06-13%20a%CC%80%2016.23.11.png?alt=media&#x26;token=4d807fef-6527-43e6-99cd-d91ba1f815ce" alt=""><figcaption><p>Example with quanti_ids</p></figcaption></figure>

***

## Schema

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

| field name               | type   |
| ------------------------ | ------ |
| quanti\_id               | STRING |
| plateform\_account\_id   | STRING |
| platform\_account\_name  | STRING |
| platform\_campaign\_id   | STRING |
| platform\_campaign\_name | STRING |
| platform\_adgroup\_id    | STRING |
| platform\_adgroup\_name  | STRING |
| platform\_ad\_id         | STRING |
| platform\_ad\_name       | STRING |

***

## Dimension and Unique keys

The primary keys of the table is:

* `quanti_id` :  aggregates dimensions 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.