quanti_ids

Presentation of the aggregation table of dimensions from advertising platforms.

---

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 :

Example without quanti_ids

Without quanti_ids :

Example with quanti_ids

---

Schema

`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 ad-centric information with site-centric information.