ads_import

Introduction to the data aggregation table for advertising platforms.

---

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 :

Example without ads_import

With ads_import

Example with ads_import

---

Schema

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

Get more information about how is built quanti_id directly in quanti_ids

---

Metrics

The metrics of the table are:

• 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.