App Store

Views on the App Store data pulled from Fivetran.

firefox_app_store_territory_source_type_report

Firefox App Store Territory Source Type Report

app_store.firefox_app_store_territory_source_type_report

Please provide a description for the query

Schema
Column	Type	Nullable
app_id	Integer	Yes
date	Timestamp	Yes
source_type	String	Yes
territory	String	Yes
_fivetran_synced	Timestamp	Yes
impressions	Integer	Yes
impressions_unique_device	Integer	Yes
meets_threshold	Boolean	Yes
page_views	Integer	Yes
page_views_unique_device	Integer	Yes
date_pst	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	app_store_external	firefox_app_store_territory_source_type_report_v1

Firefox Downloads Territory Source Type Report

app_store.firefox_downloads_territory_source_type_report

Please provide a description for the query

Schema
Column	Type	Nullable
app_id	Integer	Yes
date	Timestamp	Yes
source_type	String	Yes
territory	String	Yes
_fivetran_synced	Timestamp	Yes
first_time_downloads	Integer	Yes
meets_threshold	Boolean	Yes
redownloads	Integer	Yes
total_downloads	Integer	Yes
date_pst	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	app_store_external	firefox_downloads_territory_source_type_report_v1

Firefox Usage Territory Source Type Report

app_store.firefox_usage_territory_source_type_report

Please provide a description for the query

Schema
Column	Type	Nullable
app_id	Integer	Yes
date	Timestamp	Yes
source_type	String	Yes
territory	String	Yes
_fivetran_synced	Timestamp	Yes
active_devices	Integer	Yes
active_devices_last_30_days	Integer	Yes
deletions	Integer	Yes
installations	Integer	Yes
meets_threshold	Boolean	Yes
sessions	Integer	Yes
date_pst	Timestamp	Yes

Referenced Tables
Project	Dataset	Table
moz-fx-data-shared-prod	app_store_external	firefox_usage_territory_source_type_report_v1