Skip to content

amo_prod

amo_stats_dau

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod amo_prod amo_stats_dau_v2

Source Directory | Metadata File | View Definition


amo_stats_dau_v2

Daily user statistics to power addons.mozilla.org stats pages. See bug 1572873.

Each row in this table represents a particular addon on a particular day and provides all the information needed to populate the various "Daily Users" plots for the AMO stats dashboard.

Source Directory | Metadata File | View Definition


amo_stats_installs

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod amo_prod amo_stats_installs_v3

Source Directory | Metadata File | View Definition


amo_stats_installs_v3

Daily install statistics to power addons.mozilla.org stats pages. See bug 1654330. Note that this table uses a hashed_addon_id defined as TO_HEX(SHA256(addon_id)) because the underlying event pings have limitations on length of properties attached to events and addon_id values are sometimes too long. The AMO stats application looks up records in this table based on the hashed_addon_id.

Source Directory | Metadata File | View Definition


desktop_addons_by_client_v1

Clients_daily-like table that records only the dimensions and addon info necessary to power daily the amo_stats_dau_v2 query.

Source Directory | Metadata File | View Definition


fenix_addons_by_client_v1

Clients_daily-like table on top of the various Firefox for Android channels that records only the dimensions and addon info necessary to power the daily amo_stats_dau_v2 query.

Source Directory | Metadata File | View Definition