Adjust

Views for accessing Adjust derived data

Source Directory

adjust_cohort

Adjust Cohort

adjust.adjust_cohort

Please provide a description for the query

Schema

Column	Description	Type	Nullable
cohort_start_month	first day of the month when cohort starts being recorded	Date	Yes
period_length	length of period - in this table period is set to month	String	Yes
period	period number - number of period(months) between cohort start month and date data is recorded	Integer	Yes
app	application name ex. Firefox iOS and Android, pocket	String	Yes
network		String	Yes
network_token		String	Yes
country		String	Yes
os		String	Yes
cohort_size		Integer	Yes
retained_users		Integer	Yes
retention_rate		Float	Yes
time_spent_per_user		Integer	Yes
time_spent_per_session		Integer	Yes
time_spent		Integer	Yes
sessions_per_user		Float	Yes
sessions		Integer	Yes
date		Date	Yes

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	adjust_derived	adjust_cohort_v1

Source Directory | View Definition | Metadata File

---

adjust_kpi_deliverables

Adjust Kpi Deliverables

adjust.adjust_kpi_deliverables

Please provide a description for the query

Schema

Column	Description	Type	Nullable
date	date of the report and field that the table is partitioned by	Date	Yes
app	name of the application such as Firefox iOS and Android, pocket	String	Yes
network		String	Yes
network_token		String	Yes
campaign		String	Yes
campaign_token		String	Yes
adgroup		String	Yes
adgroup_token		String	Yes
creative		String	Yes
creative_token		String	Yes
country		String	Yes
os		String	Yes
device		String	Yes
clicks		Integer	Yes
installs		Integer	Yes
limit_ad_tracking_install_rate		Float	Yes
click_conversion_rate		Float	Yes
impression_conversion_rate		Float	Yes
sessions		Integer	Yes
daus		Integer	Yes
waus		Integer	Yes
maus		Integer	Yes

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	adjust_derived	adjust_deliverables_v1

Source Directory | View Definition | Metadata File

---