firefox-installer
User-facing views related to document namespace firefox-installer; see https://github.com/mozilla-services/mozilla-pipeline-schemas/tree/generated-schemas/schemas/firefox-installer
install
Historical Pings for firefox-installer/install
firefox_installer.install
A historical view of pings sent for the
firefox-installer/install
document type.
This view is guaranteed to contain only complete days
(per submission_timestamp)
and to contain only one row per distinct document_id within a given date.
Clustering fields: normalized_channel, sample_id
| Column | Description | Type | Nullable |
|---|---|---|---|
| _64bit_build | True if the installed build is 64-bit | Boolean | Yes |
| _64bit_os | True if the OS this installer ran on is 64-bit | Boolean | Yes |
| additional_properties | A JSON string containing any payload properties not present in the schema | String | Yes |
| admin_user | True if the user account which ran the installer had administrative privileges | Boolean | Yes |
| attribution | Any attribution data that was included with the installer | String | Yes |
| build_channel | Channel the installer was built with the branding for | String | Yes |
| build_id | Build ID of the installed product. Absent for a failed stub installation. | String | Yes |
| bytes_downloaded | Size of the full installer data that was actually transferred | Integer | Yes |
| default_path | True if the user did not customize the installation path | Boolean | Yes |
| disk_space_error | True if the installation failed because the drive we're trying to install to does not have enough space | Boolean | Yes |
| document_id | The document ID specified in the URI when the client sent this message | String | Yes |
| download_ip | IP address of the server the full installer was downloaded from. May be either IPv4 or IPv6. | String | Yes |
| download_latency | Seconds between sending the full installer download request and receiving the first response data | Integer | Yes |
| download_retries | Number of times the full installer download was retried or resumed | Integer | Yes |
| download_size | Expected size of the full installer download according to the HTTP response | Integer | Yes |
| download_time | Seconds spent downloading the full installer | Integer | Yes |
| file_error | True if the installation failed because the downloaded file couldn’t be read from | Boolean | Yes |
| finish_time | For a stub ping, seconds spent waiting for the installed application to launch. For a full ping, seconds spent on the finish page. | Integer | Yes |
| from_msi | True if the install was launched from an MSI wrapper | Boolean | Yes |
| funnelcake | Funnelcake ID | String | Yes |
| had_old_install | True if at least one existing installation of Firefox was found on the system prior to this installation | Boolean | Yes |
| install_time | For a stub ping, seconds the full installer ran for. For a full ping, seconds spent on the install progress page. | Integer | Yes |
| install_timeout | True if the installation failed because running the full installer timed out. Currently that means it ran for more than 150 seconds for a new installation, or 165 seconds for a paveover installation. | Boolean | Yes |
| installer_type | Which type of installer generated this ping (full or stub) | String | Yes |
| installer_version | Version of the installer itself. May be different from the product version for a stub install. | String | Yes |
| intro_time | Seconds spent on the intro screen | Integer | Yes |
| locale | Locale of the installer and the installed product, in AB_CD format | String | Yes |
| manual_download | True if the user clicked through the error message to the manual full installer download page. | Boolean | Yes |
| metadata | Record | Yes | |
| new_default | True if the new installation was successfully set as the default browser | Boolean | Yes |
| new_launched | True if the installation succeeded and we were able to launch the newly installed application. | Boolean | Yes |
| no_write_access | True if the installation failed because the user doesn’t have permission to write to the path we’re trying to install to. | Boolean | Yes |
| normalized_app_name | Set to "Other" if this message contained an unrecognized app name | String | Yes |
| normalized_channel | Set to "Other" if this message contained an unrecognized channel name | String | Yes |
| normalized_country_code | An ISO 3166-1 alpha-2 country code | String | Yes |
| normalized_os | Set to "Other" if this message contained an unrecognized OS name | String | Yes |
| normalized_os_version | String | Yes | |
| old_build_id | Build ID of the previously installed Firefox, if any | String | Yes |
| old_default | True if an existing Firefox installation was already set as the default browser | Boolean | Yes |
| old_running | True if the installation succeeded and we weren’t able to launch the newly installed application because a copy of Firefox was already running. | Boolean | Yes |
| old_version | Version of the previously installed Firefox, if any | String | Yes |
| options_time | Seconds spent in the options screens. For the stub installer this includes only the profile cleanup prompt. | Integer | Yes |
| os_version | Windows version number in major.minor.build format | String | Yes |
| out_of_retries | True if the installation failed because the download had to be retried too many times (currently 10) | Boolean | Yes |
| ping_version | Only set for stub installer pings | String | Yes |
| preinstall_time | Seconds spent verifying the downloaded full installer and preparing to run it | Integer | Yes |
| profile_cleanup_prompt | Which type of profile cleanup prompt was shown, (reinstall or paveover) | String | Yes |
| profile_cleanup_requested | True if either profile cleanup prompt was shown and the user accepted the prompt | Boolean | Yes |
| sample_id | Hashed version of client_id (if present) useful for partitioning; ranges from 0 to 99 | Integer | Yes |
| server_os | True if the OS this installer ran on is Windows Server | Boolean | Yes |
| service_pack | Latest installed service pack number | String | Yes |
| set_default | True if the option to set the new installation as the default browser was selected | Boolean | Yes |
| sig_not_trusted | True if the installation failed because the signature on the downloaded file wasn’t valid and/or wasn’t signed by a trusted authority | Boolean | Yes |
| sig_unexpected | True if the installation failed because the signature on the downloaded file didn’t have the expected subject and issuer names | Boolean | Yes |
| submission_timestamp | Time when the ingestion edge server accepted this message | Timestamp | Yes |
| succeeded | True if a new installation was successfully created. If false, check the error status fields for the failure reason. | Boolean | Yes |
| update_channel | Value of MOZ_UPDATE_CHANNEL the installer was built with. Generally the same as build_channel | String | Yes |
| user_cancelled | True if the installation failed because the user cancelled it or closed the window | Boolean | Yes |
| version | Version of the installed product. May be different from installer_version for a stub install. Absent for a failed stub installation. | String | Yes |
| silent | True if the installer was run in silent mode (either from an MSI or with command-line parameters) | Boolean | Yes |
| Project | Dataset | Table |
|---|---|---|
| moz-fx-data-shared-prod | firefox_installer_stable | install_v1 |
Source Directory | View Definition | Metadata File