Skip to content

AMO Stats Dev

Derived data used to power the dev instance of the AMO stats dashboards

Source Directory

amo_stats_dau

Amo Stats Dau

amo_dev.amo_stats_dau

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
addon_id String Yes
dau Integer Yes
dau_by_addon_version Record No
dau_by_app_os Record No
dau_by_app_version Record No
dau_by_fenix_build Record No
dau_by_country Record No
dau_by_locale Record No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod amo_dev amo_stats_dau_v2

Source Directory | View Definition | Metadata File


amo_stats_dau_v2

AMO Stats DAU dev/stage

amo_dev.amo_stats_dau_v2

Reduced stats table for dev and stage versions of the AMO service.

Schema
Column Description Type Nullable
submission_date Date Yes
addon_id String Yes
dau Integer Yes
dau_by_addon_version Record No
dau_by_app_version Record No
dau_by_fenix_build Record No
dau_by_locale Record No
dau_by_country Record No
dau_by_app_os Record No

Source Directory | Metadata File


amo_stats_installs

Amo Stats Installs

amo_dev.amo_stats_installs

Please provide a description for the query

Schema
Column Description Type Nullable
submission_date Date Yes
hashed_addon_id String Yes
total_downloads Integer Yes
downloads_per_campaign Record No
downloads_per_content Record No
downloads_per_source Record No
downloads_per_medium Record No
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod amo_dev amo_stats_installs_v3

Source Directory | View Definition | Metadata File


amo_stats_installs_v3

AMO Installs dev/stage

amo_dev.amo_stats_installs_v3

Reduced daily installs table for dev and stage versions of the AMO service.

Schema
Column Description Type Nullable
submission_date Date Yes
hashed_addon_id String Yes
total_downloads Integer Yes
downloads_per_source Record No
downloads_per_content Record No
downloads_per_medium Record No
downloads_per_campaign Record No

Source Directory | Metadata File