AMO Stats Prod
Derived data used to power the AMO stats dashboards
amo_stats_dau
Amo Stats Dau
amo_prod.amo_stats_dau
Please provide a description for the query
| 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | amo_prod | amo_stats_dau_v2 |
Source Directory | View Definition | Metadata File
amo_stats_dau_v2
AMO Stats DAU
amo_prod.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.
- Schedule: daily
- Owners:
| 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_prod.amo_stats_installs
Please provide a description for the query
| 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 |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | amo_prod | amo_stats_installs_v3 |
Source Directory | View Definition | Metadata File
amo_stats_installs_v3
AMO Stats DAU
amo_prod.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.
- Schedule: daily
- Owners:
| 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
desktop_addons_by_client_v1
Desktop addons by client
amo_prod.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.
- Schedule: daily
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| app_version | String | Yes | |
| country | String | Yes | |
| locale | String | Yes | |
| app_os | String | Yes | |
| addons | Record | No |
Source Directory | Metadata File
fenix_addons_by_client_v1
Fenix addons by client
amo_prod.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.
- Schedule: daily
- Owners:
| Column | Description | Type | Nullable |
|---|---|---|---|
| submission_date | Date | Yes | |
| client_id | String | Yes | |
| sample_id | Integer | Yes | |
| app_version | String | Yes | |
| country | String | Yes | |
| locale | String | Yes | |
| app_os | String | Yes | |
| addons | Record | No |
Source Directory | Metadata File