Firefox desktop
metric-hub
Pre-defined metrics for firefox_desktop. These metrics are defined in metric-hub
ad_click_rate
Ad Click Rate
This is a Population Ratio Metric. It is the total number of ad clicks over all clients in the population divided by the total number of SAP searches over all clients in the population.
Data Source: ``
Definition:
None
active_hours
Active hours
Measures the amount of time (in 5-second increments) during which Firefox received user input from a keyboard or mouse. The Firefox window does not need to be focused.
Data Source: clients_daily
Definition:
{{agg_sum("active_hours_sum")}}
uri_count
URIs visited
Counts the total number of URIs visited. Includes within-page navigation events (e.g. to anchors).
Data Source: clients_daily
Definition:
{{agg_sum("scalar_parent_browser_engagement_total_uri_count_sum")}}
search_count
SAP searches
Counts the number of searches a user performed through Firefox's Search Access Points. Learn more in the search data documentation.
Data Source: search_clients_engines_sources_daily
Definition:
{{agg_sum("sap")}}
tagged_search_count
Tagged SAP searches
Counts the number of searches a user performed through Firefox's Search Access Points that were submitted with a partner code and were potentially revenue-generating. Learn more in the search data documentation.
Data Source: search_clients_engines_sources_daily
Definition:
{{agg_sum("tagged_sap")}}
tagged_follow_on_search_count
Tagged follow-on searches
Counts the number of follow-on searches with a Mozilla partner tag. These are additional searches that users performed from a search engine results page after executing a tagged search through a SAP. Learn more in the search data documentation.
Data Source: search_clients_engines_sources_daily
Definition:
{{agg_sum("tagged_follow_on")}}
ad_clicks
Ad clicks
Counts clicks on ads on search engine result pages with a Mozilla partner tag.
Data Source: search_clients_engines_sources_daily
Definition:
{{agg_sum("ad_click")}}
searches_with_ads
Search result pages with ads
Counts search result pages served with advertising. Users may not actually see these ads thanks to e.g. ad-blockers. Learn more in the search analysis documentation.
Data Source: search_clients_engines_sources_daily
Definition:
{{agg_sum("search_with_ads")}}
organic_search_count
Organic searches
Counts organic searches, which are searches that are not performed through a Firefox SAP and which are not monetizable. Learn more in the search data documentation.
Data Source: search_clients_engines_sources_daily
Definition:
{{agg_sum("organic")}}
search_with_ads_organic
Organic searches with ads
Counts search result pages from organic searches served with advertising. Organic searches are not performed through a Firefox SAP and are not monetizable. Users may not actually see these ads thanks to e.g. ad-blockers. Learn more in the search analysis documentation.
Data Source: search_clients_engines_sources_daily
Definition:
{{agg_sum("search_with_ads_organic")}}
ad_clicks_organic
Organic ad clicks
Counts clicks on ads on search engine result pages organic searches. Organic searches are not performed through a Firefox SAP and are not monetizable.
Data Source: search_clients_engines_sources_daily
Definition:
{{agg_sum("ad_click_organic")}}
unenroll
Unenrollments
Counts the number of clients with an experiment unenrollment event.
Data Source: normandy_events
Definition:
{{agg_any(
""" event_category = 'normandy'
AND event_method = 'unenroll'
AND event_string_value = '{experiment_slug}'
""")}}
notification_clicks
System Notification Clicks
Counts the number of clients that launched Firefox to handle the notification corresponding to this experiment.
Data Source: browser_launched_to_handle_events
Definition:
{{agg_any(
""" event_method = 'system_notification'
AND event_object = 'toast'
AND STARTS_WITH(mozfun.map.get_key(event_map_values, 'name'), '{experiment_slug}:')
""")}}
view_about_logins
about:logins viewers
Counts the number of clients that viewed about:logins.
Data Source: events
Definition:
{{agg_any(
""" event_method = 'open_management'
AND event_category = 'pwmgr'
""")}}
view_about_protections
about:protections viewers
Counts the number of clients that viewed about:protections.
Data Source: events
Definition:
{{agg_any(
""" event_method = 'show'
AND event_object = 'protection_report'
""")}}
connect_fxa
Connected FxA
Counts the number of clients that took action to connect to FxA. This does not include clients that were already connected to FxA at the start of the experiment and remained connected.
Data Source: events
Definition:
{{agg_any(
""" event_method = 'connect'
AND event_object = 'account'
""")}}
pocket_rec_clicks
Clicked Pocket organic recs in New Tab
Counts the number of Pocket rec clicks made by each client.
Data Source: activity_stream_events
Definition:
COUNTIF(
event = 'CLICK'
AND source = 'CARDGRID'
AND JSON_EXTRACT_SCALAR(value, '$.card_type') = 'organic'
)
pocket_spoc_clicks
Clicked Pocket sponsored content in New Tab
Counts the number of Pocket sponsored content clicks made by each client.
Data Source: activity_stream_events
Definition:
COUNTIF(
event = 'CLICK'
AND source = 'CARDGRID'
AND JSON_EXTRACT_SCALAR(value, '$.card_type') = 'spoc'
)
days_of_use
Days of use
The number of days in the interval that each client sent a main ping.
Data Source: clients_daily
Definition:
COUNT(submission_date)
qualified_cumulative_days_of_use
QCDOU
The number of days in the interval that each client sent a main ping, given that the client had >0 active hours and >0 URIs loaded.
Data Source: clients_daily
Definition:
COUNTIF(
active_hours_sum > 0 AND
scalar_parent_browser_engagement_total_uri_count_normal_and_private_mode_sum > 0
)
daily_active_users
DAU
The number of unique clients with >0 active hours and >0 URIs loaded that
we received a main ping from each day. To be comparable to DAU used for KPI
tracking, this metric needs to be aggregated by submission_date. If the
metric is NOT aggregated by submission_date, the metric is similar to a
"days of use" metric. For more details, refer to
the DAU description in the Mozilla Data Documentation.
For questions, please contact bochocki@mozilla.com or firefox-kpi@mozilla.com.
Data Source: clients_daily
Definition:
COUNTIF(active_hours_sum > 0 AND total_uri_count > 0)
daily_active_users_v2
Firefox Desktop DAU
This is the official DAU reporting definition. The logic is
defined in bigquery-etl
and is automatically cross-checked, actively monitored, and change controlled.
Whenever possible, this is the preferred DAU reporting definition to use for Desktop.
This metric needs to be aggregated by submission_date. If it is not aggregated by submission_date,
it is similar to a "days of use" metric, and not DAU.
For more information, refer to [the DAU description in Confluence](https://mozilla-hub.atlassian.net/wiki/spaces/DATA/pages/314704478/Daily+Active+Users+DAU+Metric).
For questions please contact bochocki@mozilla.com or firefox-kpi@mozilla.com.
Data Source: active_users_aggregates_v1
Definition:
SUM(dau)
client_level_daily_active_users_v1
Firefox Desktop Client-Level DAU
This metric reports DAU values similar (but not necessarily identical)
to the official DAU reporting definition.
It's generally preferable to use the official DAU reporting definition when possible; this metric
exists only for cases where reporting client_id is required (e.g. for experiments). This metric
needs to be aggregated by submission_date. If it is not aggregated by submission_date, it is
similar to a "days of use" metric, and not DAU.
For more information, refer to [the DAU description in Confluence](https://mozilla-hub.atlassian.net/wiki/spaces/DATA/pages/314704478/Daily+Active+Users+DAU+Metric).
For questions please contact bochocki@mozilla.com or firefox-kpi@mozilla.com.
Data Source: clients_daily
Definition:
COUNTIF(active_hours_sum > 0 AND total_uri_count > 0 AND isp_name <> 'BrowserStack')
desktop_dau_kpi
Desktop DAU KPI
The average number of unique clients with >0 active hours and >0 URIs loaded that
we received a main ping from each day in the 28-day period ending on December 15th.
To reconstruct the annual Desktop DAU KPI, this metric needs to be aggregated by
EXTRACT(YEAR FROM submission_date).
For questions, please contact bochocki@mozilla.com or firefox-kpi@mozilla.com.
Data Source: clients_daily
Definition:
COUNTIF(
active_hours_sum > 0 AND
total_uri_count > 0 AND
FORMAT_DATE('%m-%d', submission_date) BETWEEN '11-18' AND '12-15'
) / 28
desktop_dau_kpi_v2
Firefox Desktop DAU KPI
The average Firefox Desktop DAU
in the 28-day period ending on December 15th. This is the official Desktop DAU KPI reporting definition. The logic for calculating DAU is
defined in bigquery-etl
and is automatically cross-checked, actively monitored, and change controlled.
To reconstruct the annual Desktop DAU KPI, this metric needs to be aggregated by
EXTRACT(YEAR FROM submission_date).
For more information, refer to [the DAU description in Confluence](https://mozilla-hub.atlassian.net/wiki/spaces/DATA/pages/314704478/Daily+Active+Users+DAU+Metric).
For questions please contact bochocki@mozilla.com or firefox-kpi@mozilla.com.
Data Source: active_users_aggregates_v1
Definition:
SUM(IF(FORMAT_DATE('%m-%d', submission_date) BETWEEN '11-18' AND '12-15', dau, 0)) / 28
disable_pocket_clicks
Disabled Pocket in New Tab
Counts the number of clicks to disable Pocket in New Tab made by each client.
Data Source: activity_stream_events
Definition:
COUNTIF(
event = 'PREF_CHANGED'
AND source = 'TOP_STORIES'
AND JSON_EXTRACT_SCALAR(value, '$.status') = 'false'
)
disable_pocket_spocs_clicks
Disabled Pocket sponsored content in New Tab
Counts the number of clicks to disable Pocket sponsored content in New Tab made by each client.
Data Source: activity_stream_events
Definition:
COUNTIF(
event = 'PREF_CHANGED'
AND source = 'POCKET_SPOCS'
AND JSON_EXTRACT_SCALAR(value, '$.status') = 'false'
)
content_shutdown_crashes
Content Shutdown Crashes
Number of Content Shutdown Crashes
Data Source: crash
Definition:
SUM(IF(REGEXP_CONTAINS(payload.process_type, 'content') AND REGEXP_CONTAINS(payload.metadata.ipc_channel_error, 'ShutDownKill'), 1, 0))
content_crashes
Content Crashes
Number of Content Crashes
Data Source: crash
Definition:
SUM(IF(REGEXP_CONTAINS(payload.process_type, 'content') AND NOT REGEXP_CONTAINS(COALESCE(payload.metadata.ipc_channel_error, ''), 'ShutDownKill'), 1, 0))
shutdown_hangs
Shutdown Hangs
Number of Shutdown Hangs
Data Source: crash
Definition:
SUM(IF(payload.metadata.moz_crash_reason LIKE r'MOZ\_CRASH%', 1, 0))
oom_crashes
OOM Crashes
Number of Out of Memory Crashes
Data Source: crash
Definition:
SUM(IF(payload.metadata.oom_allocation_size IS NOT NULL, 1, 0))
main_crashes
Main Crashes
Number of Main Crashes
Data Source: crash
Definition:
SUM(IF(payload.process_type = 'main' OR payload.process_type IS NULL, 1, 0))
startup_crashes
Startup Crashes
Number of Startup Crashes
Data Source: crash
Definition:
SUM(IF(payload.metadata.startup_crash = '1', 1, 0))
gmplugin_crashes
Gmplugin Crashes
Number of GMPlugin (for loading DRM media in a highly sandboxed process) Crashes
Data Source: main
Definition:
SUM(COALESCE(`moz-fx-data-shared-prod`.udf.keyed_histogram_get_sum(payload.keyed_histograms.subprocess_crashes_with_dump,'gmplugin'), 0))
gpu_crashes
Gpu Crashes
Number of GPU Crashes
Data Source: main
Definition:
SUM(COALESCE(`moz-fx-data-shared-prod`.udf.keyed_histogram_get_sum(payload.keyed_histograms.subprocess_crashes_with_dump, 'gpu'), 0))
plugin_crashes
Plugin Crashes
Number of Plugin Crashes
Data Source: main
Definition:
SUM(COALESCE(`moz-fx-data-shared-prod`.udf.keyed_histogram_get_sum(payload.keyed_histograms.subprocess_crashes_with_dump, 'plugin'), 0))
child_process_launch_ms
Child Process Launch Ms
Time spent in the generic child process launching code, which is run off-main-thread and used by all child process types
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.child_process_launch_ms) IGNORE NULLS)
content_process_count
Content Process Count
A count of the number of content processes, collected every five minutes.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.content_process_count) IGNORE NULLS)
content_process_max
Content Process Max
The maximum number of content processes, submitted when a new maximum is reached.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.content_process_max) IGNORE NULLS)
checkerboard_severity
Checkerboard Severity
Opaque measure of the severity of a checkerboard event
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.checkerboard_severity) IGNORE NULLS)
content_frame_time_vsync
Content Frame Time Vsync
The time, in percentage of a vsync interval, spent from the vsync that started a paint in the content process until that frame is presented in the compositor.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.content_frame_time_vsync) IGNORE NULLS)
fx_new_window_ms
Fx New Window Ms
Firefox: Time taken to open a new browser window (ms)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.fx_new_window_ms) IGNORE NULLS)
fx_tab_switch_composite_e10s_ms
Fx Tab Switch Composite E10S Ms
Firefox: Time in ms between tab selection and first composite of the tab content in e10s windows
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.fx_tab_switch_composite_e10s_ms) IGNORE NULLS)
fx_tab_switch_total_e10s_ms
Fx Tab Switch Total E10S Ms
Firefox: Time in ms between tab selection and tab content paint in e10s windows
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.fx_tab_switch_total_e10s_ms) IGNORE NULLS)
timestamps_first_paint_two
Timestamps First Paint Two
Record the timestamp of the first main window paint, in milliseconds since process start. Intended to replace first_paint since first_paint is broken.
Data Source: main
Definition:
SUM(payload.processes.parent.scalars.timestamps_first_paint_two)
timestamps_about_home_topsites_first_paint
Timestamps About Home Topsites First Paint
Record the timestamp of when the first about:home's Topsites are painted. Only records if about:home is set as the default homepage, and if sessions are not being restored by default.
Data Source: main
Definition:
SUM(payload.processes.parent.scalars.timestamps_about_home_topsites_first_paint)
keypress_present_latency_ms
Keypress Present Latency Ms
Time between receiving a keypress event on the event loop and compositing its result onto the screen (ms)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.gpu.histograms.keypress_present_latency) IGNORE NULLS)
scroll_present_latency
Scroll Present Latency
Time between receiving a scroll event on the event loop and compositing its result onto the screen (ms)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.gpu.histograms.scroll_present_latency) IGNORE NULLS)
memory_total
Memory Total
Total Memory Across All Processes (KB)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.memory_total) IGNORE NULLS)
cycle_collector_max_pause
Cycle Collector Max Pause
Longest pause for an individual slice of one cycle collection, including preparation (ms)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.cycle_collector_max_pause) IGNORE NULLS)
cycle_collector_max_pause_content
Cycle Collector Max Pause Content
Longest pause for an individual slice of one cycle collection, including preparation (ms)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.cycle_collector_max_pause) IGNORE NULLS)
cycle_collector_visited_gced
Cycle Collector Visited GCED
Number of JS objects visited by the cycle collector
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.cycle_collector_visited_gced) IGNORE NULLS)
cycle_collector_visited_ref_counted
Cycle Collector Visited Ref Counted
Number of ref counted objects visited by the cycle collector
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.cycle_collector_visited_ref_counted) IGNORE NULLS)
gc_max_pause_2
Gc Max Pause 2
Longest GC slice in a GC (ms)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.gc_max_pause_ms_2) IGNORE NULLS)
gc_max_pause_2_content
Gc Max Pause 2 Content
Longest GC slice in a GC (ms)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.gc_max_pause_ms_2) IGNORE NULLS)
gc_ms
Gc Ms
Time spent running JS GC (ms)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.gc_ms) IGNORE NULLS)
gc_ms_content
Gc Ms Content
Time spent running JS GC (ms) in the content process
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.gc_ms) IGNORE NULLS)
gc_slice_during_idle
Gc Slice During Idle
Percent of GC slice done during idle time
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.gc_slice_during_idle) IGNORE NULLS)
gc_slice_during_idle_content
Gc Slice During Idle Content
Percent of GC slice done during idle time in the content process
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.gc_slice_during_idle) IGNORE NULLS)
gc_non_incremental
Gc Non Incremental
Was the GC non-incremental?
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.gc_non_incremental) IGNORE NULLS)
gc_reason_2
Gc Reason 2
Reason (enum value) for initiating a GC
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.gc_reason_2) IGNORE NULLS)
gc_mark_rate_2
Gc Mark Rate 2
The number of objects marked per ms during GC.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.gc_mark_rate_2) IGNORE NULLS)
gc_budget_overrun
Gc Budget Overrun
How long a GC slice ran over its budget in microseconds
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.gc_budget_overrun) IGNORE NULLS)
memory_unique_content_startup
Memory Unique Content Startup
Unique Set Size of Content Process at Startup (KB)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.memory_unique_content_startup) IGNORE NULLS)
perf_first_contentful_paint_ms
Perf First Contentful Paint Ms
The time between navigationStart and the first contentful paint of a foreground http or https root content document, in milliseconds. The contentful paint timestamp is taken during display list building and does not include rasterization or compositing of that paint.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.perf_first_contentful_paint_ms) IGNORE NULLS)
time_to_first_interaction_ms
Time To First Interaction Ms
Time in milliseconds from the first non-blank paint to the creation time of the next click, key, mouse or scroll event per top-level content browsing context.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.time_to_first_interaction_ms) IGNORE NULLS)
perf_page_load_time_ms
Perf Page Load Time Ms
Time in milliseconds from navigationStart to loadEventStart for the foreground http or https root content document
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.perf_page_load_time_ms) IGNORE NULLS)
input_event_response_coalesced
Input Event Response Coalesced
Time (ms) from the Input event being created to the end of it being handled, but with overlapping events coalesced.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.input_event_response_coalesced_ms) IGNORE NULLS)
mouseup_followed_by_click_present_latency
Mouseup Followed By Click Present Latency
Time between receiving a mouseup which follow by a mouseclick on the event loop and compositing its result onto the screen (ms)
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.gpu.histograms.mouseup_followed_by_click_present_latency) IGNORE NULLS)
fx_page_load_ms_2
Fx Page Load Ms 2
Firefox: Time taken to load a page (ms). This includes all static contents, no dynamic content. Page reloads and loading of about: pages are not included.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.fx_page_load_ms_2) IGNORE NULLS)
perf_dom_content_loaded_time
Perf DOM Content Loaded Time
Time in milliseconds from navigationStart to domContentLoaded for the foreground http or https root content document.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.perf_dom_content_loaded_time_ms) IGNORE NULLS)
perf_dom_contentperf_dom_content_loaded_time_from_responsestart_ms_loaded_time
Perf DOM Content Loaded Time From Response Start
Time in milliseconds from responseStart to domContentLoaded for the foreground http or https root content document.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.perf_dom_content_loaded_time_from_responsestart_ms) IGNORE NULLS)
perf_page_load_time_from_responsestart
Perf Page Load Time from Response Start
Time in milliseconds from navigationStart to loadEventStart for the foreground http or https root content document.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.perf_page_load_time_from_responsestart_ms) IGNORE NULLS)
perf_request_animation_callback_non_pageload
Perf Request Animation Callback Non Pageload
Time spent in milliseconds calling all request animation frame callbacks for a document after it has reached readystate complete.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.perf_request_animation_callback_non_pageload_ms) IGNORE NULLS)
perf_request_animation_callback_pageload
Perf Request Animation Callback Pageload
Time spent in milliseconds calling all request animation frame callbacks for a document after it has reached readystate complete.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.perf_request_animation_callback_pageload_ms) IGNORE NULLS)
loaded_tab_count
Loaded Tab Count
Number of fully loaded (i.e., not pending from session restore) tabs opened across all windows, collected at most every 5 minutes whenever the user interacts with the browser in the following ways: open tab/window, page load, restoring a pending tab.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.loaded_tab_count) IGNORE NULLS)
active_ticks
Browser Engagement Active Ticks
The count of the number of five-second intervals ('ticks') the user was considered 'active' in a subsession. Session activity involves keyboard or mouse interaction with the application. It does not take into account whether or not the window has focus or is in the foreground, only if it is receiving these interaction events.
Data Source: main
Definition:
SUM(payload.processes.parent.scalars.browser_engagement_active_ticks)
subsession_length
Subsession Length
The subsession length until now in seconds, monotonic
Data Source: main
Definition:
SUM(payload.info.subsession_length)
tab_pinned_event_count
Browser Engagement Tab Pinned Event Count
The count of tab pinned events per subsession, across all windows, after the session has been restored. This includes tab pinned events from private windows.
Data Source: main
Definition:
SUM(payload.processes.parent.scalars.browser_engagement_tab_pinned_event_count)
tab_open_event_count
Browser Engagement Tab Open Event Count
The count of tab open events per subsession, across all windows, after the session has been restored. This includes tab open events from private windows and from manual session restorations (i.e. after crashes and from about:home).
Data Source: main
Definition:
SUM(payload.processes.parent.scalars.browser_engagement_tab_open_event_count)
tab_unload_to_reload
Tab Unload To Reload
How long (sec) a tab had been unloaded until it was reloaded.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.tab_unload_to_reload) IGNORE NULLS)
tab_reload_count
Browser Engagement Tab Reload Count
The count of tab reload events by the user after unloaded.
Data Source: main
Definition:
SUM(payload.processes.parent.scalars.browser_engagement_tab_reload_count)
tab_unload_count
Browser Engagement Tab Unload Count
The count of tab unload events by TabUnloader due to a low-memory situation.
Data Source: main
Definition:
SUM(payload.processes.parent.scalars.browser_engagement_tab_unload_count)
concurrent_pinned_tab_count
Browser Engagement Concurrent Pinned Tab Count
The count of maximum number of pinned tabs open during a subsession. This includes private windows and the ones opened when starting the browser. Starting Firefox 85 this includes number of restored pinned tabs at startup.
Data Source: main
Definition:
SUM(payload.processes.parent.scalars.browser_engagement_max_concurrent_tab_pinned_count)
concurrent_opened_tab_count
Browser Engagement Concurrent Opened Tab Count
The count of maximum number of tabs open during a subsession, across all windows, including tabs in private windows and restored at startup.
Data Source: main
Definition:
SUM(payload.processes.parent.scalars.browser_engagement_max_concurrent_tab_count)
opened_tab_count
Opened Tab Count
Number of tabs opened across all windows, collected at most every 5 minutes whenever the user interacts with the browser in the following ways: open tab/window, page load.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.tab_count) IGNORE NULLS)
js_pageload_xdr_encoding_ms
Js Pageload Xdr Encoding Ms
Time spent during page load XDR encoding Javascript in ms.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.js_pageload_xdr_encoding_ms) IGNORE NULLS)
js_pageload_protect_ms
Js Pageload Protect Ms
Time spent during page load protecting JIT executable memory.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.js_pageload_protect_ms) IGNORE NULLS)
js_pageload_parse_ms
Js Pageload Parse Ms
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.js_pageload_parse_ms) IGNORE NULLS)
js_pageload_execution_ms
Js Pageload Execution Ms
Time spent during page load syntax parsing JS scripts on the main thread in ms.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.js_pageload_execution_ms) IGNORE NULLS)
js_pageload_delazification_ms
Js Pageload Delazification Ms
Time spent during page load delazifying Javascript in ms.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.js_pageload_delazification_ms) IGNORE NULLS)
js_pageload_baseline_compile_ms
Js Pageload Baseline Compile Ms
Time spent during page load baseline compiling Javascript in ms.
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.processes.content.histograms.js_pageload_baseline_compile_ms) IGNORE NULLS)
input_event_response_ms
Input Event Response Ms
Time (ms) from the Input event being created to the end of it being handled for events handling during page load only
Data Source: main
Definition:
ARRAY_AGG(mozfun.hist.extract(payload.histograms.input_event_response_ms) IGNORE NULLS)
memory_pressure_count
Memory Pressure Count
Event memory pressure count
Data Source: events_memory
Definition:
SUM(SAFE_CAST(SPLIT(event_string_value, ',')[OFFSET(1)] AS NUMERIC))
search_with_ads
Search with Ads
Total number of Searches with Ads
Data Source: search_clients_engines_sources_daily
Definition:
SUM(search_with_ads)
ad_click
Ad Clicks
Total number of Ad Clicks
Data Source: search_clients_engines_sources_daily
Definition:
SUM(ad_click)
sap
SAP Search Count
Total number of SAP search counts
Data Source: search_clients_engines_sources_daily
Definition:
SUM(sap)
ad_click_organic
Organic Ad Click Count
Total number of Organic Ad Click Counts
Data Source: search_clients_engines_sources_daily
Definition:
SUM(ad_click_organic)
is_default_browser
Is Default Browser
Was Firefox the default browser at any point during the interval?
Data Source: clients_daily
Definition:
COALESCE(LOGICAL_OR(is_default_browser), FALSE)
is_default_pdf_handler
Is Default PDF Handler (Windows)
Was Firefox the default PDF Handler at any point during the interval?
Data Source: main
Definition:
COALESCE(LOGICAL_OR(mozfun.map.get_key(payload.processes.parent.keyed_scalars.os_environment_is_default_handler, '.pdf')), FALSE)
is_pinned
Is Pinned (Windows Taskbar)
Was Firefox pinned to the Windows Taskbar at any point during the interval?
Data Source: clients_daily
Definition:
COALESCE(LOGICAL_OR(scalar_parent_os_environment_is_taskbar_pinned), FALSE)
newtab_searches
Newtab Handoff Searches
Count of searches performed on the New Tab and handed off to the urlbar
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(searches, 0))
newtab_any_searches
Any Newtab Searches
Client performed any Newtab Handoff searches during the experiment
Data Source: newtab_clients_daily
Definition:
{{agg_any("searches > 0")}}
newtab_gt4_searches
Any Newtab Searches
Client performed any Newtab Handoff searches during the experiment
Data Source: newtab_clients_daily
Definition:
COALESCE(CASE WHEN SUM(searches) > 4 THEN 1 ELSE 0 END, 0)
newtab_searches_with_ads
Newtab Searches with Ads
Count of searches performed on the New Tab that resulted in an ad impression on the SERP
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(tagged_search_ad_impressions, 0))
newtab_ad_clicks
Newtab Ad Clicks
Count of searches performed on the New Tab that resulted in an ad click
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(tagged_search_ad_clicks, 0))
newtab_ad_click_rate
Newtab Ad Click Rate
New Tab ad clicks divided by New Tab searches with ads
Data Source: newtab_clients_daily
Definition:
SAFE_DIVIDE(COALESCE(SUM(tagged_search_ad_clicks, 0)), COALESCE(SUM(tagged_search_ad_impressions, 0)))
organic_pocket_clicks
Organic Pocket Clicks
Count of clicks on Organic Pocket content.
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(organic_pocket_clicks, 0))
sponsored_pocket_clicks
Sponsored Pocket Clicks
Count of clicks on Sponsored Pocket content.
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(sponsored_pocket_clicks, 0))
organic_pocket_impressions
Organic Pocket Impressions
Count of impressions on Organic Pocket content.
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(organic_pocket_impressions, 0))
sponsored_pocket_impressions
Sponsored Pocket Impressions
Count of impressions of Sponsored Pocket content.
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(sponsored_pocket_impressions, 0))
all_tile_impressions_pos1_2
All Tiles Impressions Count (Position 1 and 2)
Count of Impressions of All Tiles (sponsored and organic) in the first and second positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE
WHEN topsite_tile_interactions.topsite_tile_position < 2 THEN COALESCE(topsite_tile_interactions.sponsored_topsite_tile_impressions, 0) + COALESCE(topsite_tile_interactions.organic_topsite_tile_impressions, 0)
ELSE 0 END
),
0
)
all_tile_impressions_pos3_more
All Tiles Impressions Count (Position 3 or greater)
Count of Impressions of All Tiles (sponsored and organic) in the third and greater positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE
WHEN topsite_tile_interactions.topsite_tile_position >= 2 THEN COALESCE(topsite_tile_interactions.sponsored_topsite_tile_impressions, 0) + COALESCE(topsite_tile_interactions.organic_topsite_tile_impressions, 0)
ELSE 0 END
),
0
)
all_tile_clicks_pos1_2
All Tiles Clicks Count (Position 1 and 2)
Count of Clicks of All Tiles (sponsored and organic) in the first and second positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE
WHEN (topsite_tile_interactions.topsite_tile_position < 2 AND (topsite_tile_interactions.sponsored_topsite_tile_clicks > 0 OR topsite_tile_interactions.organic_topsite_tile_clicks > 0))
THEN COALESCE(topsite_tile_interactions.sponsored_topsite_tile_clicks, 0) + COALESCE(topsite_tile_interactions.organic_topsite_tile_clicks, 0)
ELSE 0 END
),
0
)
all_tile_clicks_pos3_more
All Tiles Clicks Count (Position 3 or greater)
Count of Clicks of All Tiles (sponsored and organic) in the third and greater positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE
WHEN (topsite_tile_interactions.topsite_tile_position >= 2 AND (topsite_tile_interactions.sponsored_topsite_tile_clicks > 0 OR topsite_tile_interactions.organic_topsite_tile_clicks > 0))
THEN COALESCE(topsite_tile_interactions.sponsored_topsite_tile_clicks, 0) + COALESCE(topsite_tile_interactions.organic_topsite_tile_clicks, 0)
ELSE 0 END
),
0
)
sponsored_tile_impressions
Sponsored Tile Impressions
Count of impressions of Sponsored Tiles (aka Sponsored Topsites on New Tab) across all positions.
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(sponsored_topsite_tile_impressions, 0))
sponsored_tile_impressions_pos1_2
All Tiles Impressions Count (Position 1 and 2)
Count of Impressions of All Tiles (sponsored and organic) in the first and second positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE
WHEN
topsite_tile_interactions.sponsored_topsite_tile_impressions > 0 AND topsite_tile_interactions.topsite_tile_position < 2
THEN topsite_tile_interactions.sponsored_topsite_tile_impressions
ELSE 0
END),
0
)
sponsored_tile_impressions_pos3_more
All Tiles Impressions Count (Position 3 or greater)
Count of Impressions of All Tiles (sponsored and organic) in the third and greater positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE
WHEN
topsite_tile_interactions.sponsored_topsite_tile_impressions > 0 AND topsite_tile_interactions.topsite_tile_position >= 2
THEN topsite_tile_interactions.sponsored_topsite_tile_impressions
ELSE 0
END),
0
)
sponsored_tile_clicks
Sponsored Tile Clicks
Count of clicks of Sponsored Tiles (aka Sponsored Topsites on New Tab) across all positions.
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(sponsored_topsite_tile_clicks, 0))
sponsored_tile_clicks_pos1_2
Sponsored Tiles Clicks Count (Position 1 and 2)
Count of Clicks of Sponsored Tiles in the first and second positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE
WHEN
topsite_tile_interactions.sponsored_topsite_tile_clicks > 0 AND topsite_tile_interactions.topsite_tile_position < 2
THEN topsite_tile_interactions.sponsored_topsite_tile_clicks
ELSE 0
END),
0
)
sponsored_tile_clicks_pos3_more
Sponsored Tiles Clicks Count (Position 3 or greater)
Count of Clicks of Sponsored Tiles in the third and greater positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE
WHEN
topsite_tile_interactions.sponsored_topsite_tile_clicks > 0 AND topsite_tile_interactions.topsite_tile_position >= 2
THEN topsite_tile_interactions.sponsored_topsite_tile_clicks
ELSE 0
END),
0
)
newtab_newtab_enabled
Newtab Newtab Enabled
Whether or not new tabs are set to display the default New Tab page.
Data Source: newtab_clients_daily
Definition:
COALESCE(MAX(IF(newtab_newtab_category = 'enabled', 1, 0)), 0)
newtab_homepage_enabled
Newtab Homepage Enabled
Whether or not the homepage is set to display the default New Tab page.
Data Source: newtab_clients_daily
Definition:
COALESCE(MAX(IF(newtab_homepage_category = 'enabled', 1, 0)), 0)
newtab_search_enabled
Newtab Search Enabled
Whether or not the SAP (i.e., search handoff) is enabled on the New Tab.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(MAX(CAST(newtab_search_enabled AS INT)), 0)
newtab_tiles_enabled
Newtab Tiles Enabled
Whether or not tiles are enabled on the New Tab. Includes both sponsored and nonsponsored tiles.
Data Source: newtab_clients_daily
Definition:
COALESCE(MAX(CAST(topsites_enabled AS INT)), 0)
newtab_pocket_enabled
Newtab Pocket Enabled
Whether or not Pocket is enabled on the New Tab.
Data Source: newtab_clients_daily
Definition:
COALESCE(MAX(CAST(pocket_enabled AS INT)), 0)
newtab_sponsored_pocket_stories_enabled
Newtab Sponsored Pocket Stories Enabled
Whether or not Pocket Sponsored Stories is enabled on the New Tab.
Data Source: newtab_clients_daily
Definition:
COALESCE(MAX(CAST(pocket_sponsored_stories_enabled AS INT)), 0)
newtab_engagement
Newtab Engagement
Whether or not the client had a newtab search OR a pocket click OR a tile click.
Data Source: newtab_clients_daily
Definition:
COALESCE(MAX(CASE WHEN visits_with_non_impression_engagement > 0 THEN 1 ELSE 0 END), 0)
newtab_visits
Newtab Visit Count
Count of New Tab visits
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(newtab_visit_count), 0)
newtab_engaged_visits
Newtab Engaged Visit Count
Count of New Tab visits with any engagement
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(visits_with_non_impression_engagement), 0)
newtab_non_search_engagement
Newtab Non-Search Engaged Visit Count
Count of New Tab visits with non-search engagement
Data Source: newtab_clients_daily
Definition:
COALESCE(SUM(visits_with_non_search_engagement), 0)
newtab_organic_topsite_clicks
Newtab Organic Tile Clicks
Count of New Tab organic tile clicks across all positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(SUM(topsite_tile_interactions.organic_topsite_tile_clicks, 0))
newtab_organic_topsite_impressions
Newtab Organic Tile Impressions
Count of New Tab organic tile impressions across all positions.
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(SUM(topsite_tile_interactions.organic_topsite_tile_impressions, 0))
imported_bookmarks
Imported Bookmarks
Count of clients who imported bookmarks
Data Source: clients_daily
Definition:
LOGICAL_OR(bookmark_migrations_quantity_all IS NOT NULL AND bookmark_migrations_quantity_all != 0)
imported_bookmarks_count
Total Number of Imported Bookmarks
Total number of imported bookmarks per client who imported
Data Source: clients_daily
Definition:
NULLIF(SUM(bookmark_migrations_quantity_all), 0)
imported_logins
Imported Logins
Count of clients who imported logins
Data Source: clients_daily
Definition:
LOGICAL_OR(logins_migrations_quantity_all IS NOT NULL AND logins_migrations_quantity_all != 0)
imported_logins_count
Total Number of Imported Logins
Total number of imported logins per client who imported
Data Source: clients_daily
Definition:
NULLIF(SUM(logins_migrations_quantity_all), 0)
imported_history
Imported History
Count of clients who imported history
Data Source: clients_daily
Definition:
LOGICAL_OR(history_migrations_quantity_all IS NOT NULL AND history_migrations_quantity_all != 0)
imported_history_count
Total Number of Imported History Links
Total number of imported history links per client who imported
Data Source: clients_daily
Definition:
NULLIF(SUM(history_migrations_quantity_all), 0)
fxa_signed_in
FxA Sign-in Rate
Did the client sign in to Firefox Desktop
Data Source: clients_daily
Definition:
CAST(COALESCE(SUM(CASE WHEN fxa_configured IS TRUE THEN 1 ELSE 0 END),0) > 0 AS INT)
retained
Retained
Records whether a client submitted any pings (i.e. used Firefox).
Data Source: clients_daily
Definition:
COALESCE(SUM(pings_aggregated_by_this_row), 0) > 0
non_ssl_loads_v1
Non-SSL Loads
Page loads of Firefox users that were not using SSL
Data Source: main
Definition:
SUM(
mozfun.map.get_key(mozfun.hist.extract(payload.histograms.http_pageload_is_ssl).values, 0)
)
ssl_loads_v1
SSL Loads
Page loads of Firefox users that were using SSL
Data Source: main
Definition:
SUM(
mozfun.map.get_key(mozfun.hist.extract(payload.histograms.http_pageload_is_ssl).values, 1)
)
http_pageload_is_ssl_ratio_v1
SSL Loads Probe Ratio
Ratio of clients that have the http_pageload_is_ssl_ratio_v1 probe
Data Source: main
Definition:
COUNT(payload.histograms.http_pageload_is_ssl) / COUNT(*)
sponsored_tiles_disabled
Sponsored Tiles Disabled Event
Boolean that identifies clients that disabled sponsored tiles during experiment
Data Source: sponsored_tiles_clients_daily
Definition:
{{agg_any("sponsored_tiles_disable_count > 0")}}
sponsored_tiles_dismissals
Sponsored Tiles Dismissals Count
Count of sponsored tiles dismissals in all positions
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(SUM(topsite_tile_interactions.sponsored_topsite_tile_dismissals), 0)
any_sponsored_tiles_dismissals
Any Sponsored Tiles Dismissed
Clients that dismissed any sponsored tiles
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(LOGICAL_OR(
topsite_tile_interactions.sponsored_topsite_tile_dismissals > 0
), FALSE)
sponsored_tiles_dismissals_pos1_2
Sponsored Tiles Dismissals Count (Positions 1 and 2)
Count of sponsored tiles dismissals in the first two positions
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE WHEN topsite_tile_interactions.sponsored_topsite_tile_dismissals > 0 AND topsite_tile_interactions.topsite_tile_position < 2 THEN topsite_tile_interactions.sponsored_topsite_tile_dismissals ELSE 0 END),
0
)
sponsored_tiles_dismissals_pos3_more
Sponsored Tiles Dismissals Count (Position 3 or greater)
Count of sponsored tiles dismissals in the third and greater positions
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(
SUM(CASE WHEN topsite_tile_interactions.sponsored_topsite_tile_dismissals > 0 AND topsite_tile_interactions.topsite_tile_position >= 2 THEN topsite_tile_interactions.sponsored_topsite_tile_dismissals ELSE 0 END),
0
)
organic_tiles_dismissals
Organic Tiles Dismissals Count
Count of organic tiles dismissals in all positions
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(SUM(topsite_tile_interactions.organic_topsite_tile_dismissals),0)
any_organic_tiles_dismissals
Any Organic Tiles Dismissed
Clients that dismissed any organic tiles
Data Source: newtab_visits_topsite_tile_interactions
Definition:
COALESCE(LOGICAL_OR(
topsite_tile_interactions.organic_topsite_tile_dismissals > 0
), FALSE)
separate_search_engine
Split PBM search engine
Indicates whether the client configured separate search engines for regular browsing and private browsing mode.
Data Source: search_clients_engines_sources_daily
Definition:
COALESCE(ANY_VALUE(default_search_engine != default_private_search_engine), false)
new_profiles_v1
New Profiles
The number of newly acquired Firefox Desktop clients. A client is newly acquired on the first date they appear in either of new profile, main or first shutdown pings based on submission date
Data Source: clients_first_seen_v2
Definition:
COUNT(*)
pdf_engagement
Data Source: metrics
Definition:
(
(COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "freetext")) > 0, FALSE) OR
COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "ink")) > 0, FALSE)) AND
(COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "print")) > 0, FALSE) OR
COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "save")) > 0, FALSE))
)
pdf_freetext
Data Source: metrics
Definition:
(
COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "freetext")) > 0, FALSE)
)
pdf_ink
Data Source: metrics
Definition:
(
COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "ink")) > 0, FALSE)
)
pdf_print
Data Source: metrics
Definition:
(
COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "print")) > 0, FALSE)
)
pdf_save
Data Source: metrics
Definition:
(
COALESCE(SUM(mozfun.map.get_key(metrics.labeled_counter.pdfjs_editing, "save")) > 0, FALSE)
)
pdf_opening
Data Source: metrics
Definition:
(
COALESCE(SUM(metrics.counter.pdfjs_used) > 0, FALSE)
)
repeat_first_month_user
Repeat First Month Users
Clients that were DAU at least once between their 2nd and 28th days, inclusive (first day = Day 1).
Data Source: clients_first_seen_28_days_later
Definition:
LOGICAL_OR(COALESCE(qualified_second_day, FALSE))
new_profile_retained_week4
Week 4 Retained Users
Clients that were DAU at least once between their 22nd and 28th days, inclusive (first day = Day 1).
Data Source: clients_first_seen_28_days_later
Definition:
LOGICAL_OR(COALESCE(qualified_week4, FALSE))
cohort_clients_in_cohort
Number of Clients in Daily Cohort of New Users
The number of new profiles per day (using method from clients_first_seen_v2)
Data Source: desktop_cohort_daily_retention
Definition:
SUM(COALESCE(num_clients_in_cohort, 0))
cohort_clients_active_on_day
Number of Clients Retained on Day
Number of Clients Retained (Qualifying as DAU) on each day
Data Source: desktop_cohort_daily_retention
Definition:
SUM(COALESCE(num_clients_dau_on_day, 0))
cohort_clients_active_in_week
Number of Clients Retained in Last Week
Number of Clients Retained (Qualifying as DAU) in previous 7 days (current day inclusive)
Data Source: desktop_cohort_daily_retention
Definition:
SUM(COALESCE(num_clients_dau_active_atleastonce_in_last_7_days, 0))
cohort_clients_active_in_month
Number of Clients Retained in Last Month
Number of Clients Retained (Qualifying as DAU) in previous 28 days (current day inclusive)
Data Source: desktop_cohort_daily_retention
Definition:
SUM(COALESCE(num_clients_dau_active_atleastonce_in_last_28_days, 0))
socket_crash_count_v1
Client Crash Count
Number of Socket crashes by a single client. Filter on this field to remove clients with large numbers of crashes.
Data Source: clients_daily
Definition:
SUM(socket_crash_count)
socket_crash_active_hours_v1
Client Crash Active Hours
Total active hours of a client with socket crashes
Data Source: clients_daily
Definition:
SUM(IF(socket_crash_count > 0, active_hours_sum, 0))
socket_crash_dau_v1
Daily Active Users with socket crashes
Daily active user count with socket crashes
Data Source: clients_daily
Definition:
COUNTIF(socket_crash_count > 0)