combined_browser_metrics/dashboards/browser_active_users.dashboard.lookml (2,690 lines of code) (raw):
---
- dashboard: browser_active_users
title: Browser Active Users
layout: newspaper
preferred_viewer: dashboards-next
description: ''
refresh: 1 hour
preferred_slug: Qeuimt5jWZV6p5ePAcGUQo
elements:
- title: Mobile DAU (Fenix, Firefox iOS, Focus Android, Focus iOS)
name: Mobile DAU (Fenix, Firefox iOS, Focus Android, Focus iOS)
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.daily_active_users, active_users_aggregates.submission_date]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix,Firefox iOS,Focus Android,Focus iOS
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#9059FF"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
listen: {}
row: 16
col: 0
width: 12
height: 6
- title: Desktop DAU
name: Desktop DAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.daily_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Firefox Desktop
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have at least one mouse/keyboard interaction and visit at least one URI.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 10
col: 0
width: 12
height: 6
- title: Fenix DAU
name: Fenix DAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.daily_active_users, active_users_aggregates.submission_date]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#3FE1B0"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
listen: {}
row: 22
col: 0
width: 12
height: 6
- title: Firefox iOS DAU
name: Firefox iOS DAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.daily_active_users, active_users_aggregates.submission_date]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Firefox iOS
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#0060E0"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
listen: {}
row: 28
col: 0
width: 12
height: 6
- title: Focus iOS DAU
name: Focus iOS DAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.daily_active_users, active_users_aggregates.submission_date]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Focus iOS
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#073072"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
listen: {}
row: 40
col: 0
width: 12
height: 6
- title: Focus Android DAU
name: Focus Android DAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.daily_active_users, active_users_aggregates.submission_date]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Focus Android
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#005E5D"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
listen: {}
row: 34
col: 0
width: 12
height: 6
- name: ''
type: text
title_text: ''
subtitle_text: ''
body_text: |-
<div style="border-radius:5px;padding:5px;background:#e8e8e8;height: 60px;">
<nav style="font-size: 15px;">
<a style="padding:5px 25px; float: left; line-height: 40px; color: #f7f2f2; font-weight: bold; background:#090808; border-radius:5px;" href="https://mozilla.cloud.looker.com/dashboards/1178">
Browser Active Users
</a>
<a style="padding:5px 25px; float: left; line-height: 40px; color: #8a8888;" href="https://mozilla.cloud.looker.com/dashboards/1784">
Browser Active Users By Geo
</a>
<a style="padding:5px 25px; float: left; line-height: 40px; color: #8a8888;" href="https://mozilla.cloud.looker.com/dashboards/1245">
Browser KPI Forecasts
</a>
</nav>
</div>
row: 0
col: 0
width: 24
height: 2
- name: " (2)"
type: text
title_text: ''
subtitle_text: ''
body_text: |-
<div id="top">
<p style="float: left; font-size: 16px">
Jump to:
<a href="https://mozilla.cloud.looker.com/dashboards/1178#dau">
DAU
</a> |
<a href="https://mozilla.cloud.looker.com/dashboards/1178#mau">
MAU
</a> |
<a href="https://mozilla.cloud.looker.com/dashboards/1178#wau">
WAU
</a>
</p>
<!--
<a
style="padding:5px 20px; float: right; line-height: 20px; color: #a646e4; border-radius:5px; border: 1px solid #a646e4; margin: 5px;"
target="_blank"
href="https://forms.gle/76nACVQYgnw7FP7s8">
Dashboard Feedback
</a>
-->
</div>
row: 6
col: 0
width: 24
height: 2
- name: " (3)"
type: text
title_text: ''
subtitle_text: ''
body_text: |-
<div>
<nav style="font-size: 12px;">
<a
style="padding:5px 20px; float: right; line-height: 20px; color: #a646e4; border-radius:5px; border: 1px solid #a646e4; margin: 5px;"
target="_blank"
href="https://forms.gle/76nACVQYgnw7FP7s8">
Dashboard Feedback
</a>
</nav>
</div>
row: 140
col: 0
width: 24
height: 2
- name: " (4)"
type: text
title_text: ''
subtitle_text: ''
body_text: "<div id=\"dau\" style=\"display: flex; align-items: center; justify-content:\
\ space-between; background-color: #333; padding: 0px 20px; border-radius: 5px;\"\
>\n\n<h2 style=\"color: #FFF\">DAU (Daily Active Users)</h2>\n\n<a\nstyle=\"\
font-size: 12px; padding: 10px 20px; color: #222; border-radius: 5px; border:\
\ 1px solid #222; margin: 5px; margin-left: auto; background-color: #FFF;\"\n\
target=\"_blank\" \nhref=\"https://mozilla-hub.atlassian.net/wiki/spaces/DATA/pages/314704478/Daily+Active+Users+DAU+Metric#DAU-KPI\"\
>\nDAU Definition\n</a>\n\n</div>"
row: 8
col: 0
width: 24
height: 2
- name: " (5)"
type: text
title_text: ''
subtitle_text: ''
body_text: |-
## 🚀 Recent updates
- #### **Combined DAU, WAU, and MAU:** This dashboard now features "Combined" metrics, which sum the Desktop and Mobile DAU/WAU/MAU metrics. While these metrics may double-count users who are active on both platforms, they are reliable indicators of overall growth across Firefox products.
*Questions or Suggestions? We’d love to hear from you! [Fill out a survey here](https://docs.google.com/forms/d/e/1FAIpQLSeAQTFBnThMY4HGzTj7WoSV1F51bclrQNFSwKAewrcvUhPYtQ/viewform) or reach out to [#data-help](https://mozilla.slack.com/archives/C4D5ZA91B).*
row: 2
col: 1
width: 22
height: 4
- name: " (6)"
type: text
title_text: ''
subtitle_text: ''
body_text: |-
<div id="mau" style="display: flex; align-items: center; justify-content: space-between; background-color: #333; padding: 0px 20px; border-radius: 5px;">
<h2 style="color: #FFF">MAU (Monthly Active Users)</h2>
<div style="margin-left: auto; display: flex;">
<a
style="font-size: 12px; padding: 10px 20px; color: #222; border-radius: 5px; border: 1px solid #222; background-color: #FFF; margin-right: 10px;"
href="https://mozilla-hub.atlassian.net/wiki/spaces/DATA/pages/314704478/Daily+Active+Users+DAU+Metric#WAU-and-MAU">
MAU Definition
</a>
<a
style="font-size: 12px; padding: 10px 20px; color: #222; border-radius: 5px; border: 1px solid #222; background-color: #FFF;"
href="https://mozilla.cloud.looker.com/dashboards/1178#top">
Jump to Top
</a>
</div>
</div>
row: 52
col: 0
width: 24
height: 2
- title: Desktop MAU
name: Desktop MAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.monthly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Firefox Desktop
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.monthly_active_users,
id: active_users_aggregates.monthly_active_users, name: MAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
active_users_aggregates.monthly_active_users: "#FF7139"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 28-day periodthat have at least one mouse/keyboard interaction and visit at least one URI.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
style: {
color: "#555",
fontSize: "1.0em",
},
useHTML: true,
align: "left",
x: 50,
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'MAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 54
col: 0
width: 24
height: 6
- title: Fenix MAU
name: Fenix MAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.monthly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.monthly_active_users,
id: active_users_aggregates.monthly_active_users, name: MAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#3FE1B0"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 28-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'MAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 66
col: 0
width: 24
height: 6
- title: Focus Android MAU
name: Focus Android MAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.monthly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Focus Android
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.monthly_active_users,
id: active_users_aggregates.monthly_active_users, name: MAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#005E5D"
active_users_aggregates.monthly_active_users: "#005E5D"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 28-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'MAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 78
col: 0
width: 24
height: 6
- title: Mobile MAU (Fenix, Firefox iOS, Focus Android, Focus iOS)
name: Mobile MAU (Fenix, Firefox iOS, Focus Android, Focus iOS)
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.monthly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix,Firefox iOS,Focus Android,Focus iOS
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.monthly_active_users,
id: active_users_aggregates.monthly_active_users, name: MAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#9059FF"
active_users_aggregates.monthly_active_users: "#9059FF"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 28-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'MAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 60
col: 0
width: 24
height: 6
- title: Firefox iOS MAU
name: Firefox iOS MAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.monthly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Firefox iOS
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.monthly_active_users,
id: active_users_aggregates.monthly_active_users, name: MAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#0060E0"
active_users_aggregates.monthly_active_users: "#0060E0"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 28-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'MAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 72
col: 0
width: 24
height: 6
- name: " (7)"
type: text
title_text: ''
subtitle_text: ''
body_text: |-
<div id="wau" style="display: flex; align-items: center; justify-content: space-between; background-color: #333; padding: 0px 20px; border-radius: 5px;">
<h2 style="color: #FFF">WAU (Weekly Active Users)</h2>
<div style="margin-left: auto; display: flex;">
<a
style="font-size: 12px; padding: 10px 20px; color: #222; border-radius: 5px; border: 1px solid #222; background-color: #FFF; margin-right: 10px;"
href="https://mozilla-hub.atlassian.net/wiki/spaces/DATA/pages/314704478/Daily+Active+Users+DAU+Metric#WAU-and-MAU">
WAU Definition
</a>
<a
style="font-size: 12px; padding: 10px 20px; color: #222; border-radius: 5px; border: 1px solid #222; background-color: #FFF;"
href="https://mozilla.cloud.looker.com/dashboards/1178#top">
Jump to Top
</a>
</div>
</div>
row: 96
col: 0
width: 24
height: 2
- title: Firefox iOS WAU
name: Firefox iOS WAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.weekly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Firefox iOS
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.weekly_active_users,
id: active_users_aggregates.weekly_active_users, name: WAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#0060E0"
active_users_aggregates.monthly_active_users: "#0060E0"
active_users_aggregates.weekly_active_users: "#0060E0"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 7-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'WAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 116
col: 0
width: 24
height: 6
- title: Focus Android WAU
name: Focus Android WAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.weekly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Focus Android
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.weekly_active_users,
id: active_users_aggregates.weekly_active_users, name: WAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#005E5D"
active_users_aggregates.monthly_active_users: "#005E5D"
active_users_aggregates.weekly_active_users: "#005E5D"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 7-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'WAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 122
col: 0
width: 24
height: 6
- title: Desktop WAU
name: Desktop WAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.weekly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Firefox Desktop
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.weekly_active_users,
id: active_users_aggregates.weekly_active_users, name: WAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
active_users_aggregates.monthly_active_users: "#FF7139"
active_users_aggregates.weekly_active_users: "#FF7139"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 28-day periodthat have at least one mouse/keyboard interaction and visit at least one URI.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'WAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 98
col: 0
width: 24
height: 6
- title: Fenix WAU
name: Fenix WAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.weekly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.weekly_active_users,
id: active_users_aggregates.weekly_active_users, name: WAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#3FE1B0"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 7-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'WAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 110
col: 0
width: 24
height: 6
- title: Focus iOS MAU
name: Focus iOS MAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.monthly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Focus iOS
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.monthly_active_users,
id: active_users_aggregates.monthly_active_users, name: MAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#073072"
active_users_aggregates.monthly_active_users: "#073072"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 28-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'MAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 84
col: 0
width: 24
height: 6
- title: Focus iOS WAU
name: Focus iOS WAU
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.weekly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Focus iOS
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.weekly_active_users,
id: active_users_aggregates.weekly_active_users, name: WAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#073072"
active_users_aggregates.monthly_active_users: "#073072"
active_users_aggregates.weekly_active_users: "#073072"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 7-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'WAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 128
col: 0
width: 24
height: 6
- title: Mobile WAU (Fenix, Firefox iOS, Focus Android, Focus iOS)
name: Mobile WAU (Fenix, Firefox iOS, Focus Android, Focus iOS)
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.weekly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix,Firefox iOS,Focus Android,Focus iOS
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.weekly_active_users,
id: active_users_aggregates.weekly_active_users, name: WAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#9059FF"
active_users_aggregates.monthly_active_users: "#9059FF"
active_users_aggregates.weekly_active_users: "#9059FF"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 7-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'WAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 104
col: 0
width: 24
height: 6
- title: Focus iOS DAU 28-Day Moving Average YoY%
name: Focus iOS DAU 28-Day Moving Average YoY%
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.daily_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Focus iOS
active_users_aggregates.submission_date: after 115 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 5000
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
- category: table_calculation
description: Calculates the YoY value using a 365-day offset
expression: |-
${dau_28_day_moving_average} /
offset(
${dau_28_day_moving_average},
if(extract_years(${active_users_aggregates.submission_date}) = 2024
AND ${active_users_aggregates.submission_date} >= date(2024, 2, 29),
366, 365)
) - 1
label: DAU YoY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: dau_yoy
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: dau_yoy,
id: dau_yoy, name: DAU YoY}], showLabels: true, showValues: true, unpinAxis: true,
tickDensity: default, tickDensityCustom: 5, type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: show
first_last: first
num_rows: '392'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
dau_yoy: "#073072"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have at least one mouse/keyboard interaction and visit at least one URI.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
hidden_pivots: {}
hidden_fields: [active_users_aggregates.daily_active_users, dau_28_day_moving_average]
listen: {}
row: 40
col: 12
width: 12
height: 6
- title: Firefox iOS DAU 28-Day Moving Average YoY%
name: Firefox iOS DAU 28-Day Moving Average YoY%
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.daily_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Firefox iOS
active_users_aggregates.submission_date: after 115 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 5000
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
- category: table_calculation
description: Calculates the YoY value using a 365-day offset
expression: |-
${dau_28_day_moving_average} /
offset(
${dau_28_day_moving_average},
if(extract_years(${active_users_aggregates.submission_date}) = 2024
AND ${active_users_aggregates.submission_date} >= date(2024, 2, 29),
366, 365)
) - 1
label: DAU YoY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: dau_yoy
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: show
first_last: first
num_rows: '392'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
dau_yoy: "#0060E0"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have at least one mouse/keyboard interaction and visit at least one URI.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
hidden_pivots: {}
hidden_fields: [active_users_aggregates.daily_active_users, dau_28_day_moving_average]
listen: {}
row: 28
col: 12
width: 12
height: 6
- title: Fenix DAU 28-Day Moving Average YoY%
name: Fenix DAU 28-Day Moving Average YoY%
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.daily_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix
active_users_aggregates.submission_date: after 115 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 5000
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
- category: table_calculation
description: Calculates the YoY value using a 365-day offset
expression: |-
${dau_28_day_moving_average} /
offset(
${dau_28_day_moving_average},
if(extract_years(${active_users_aggregates.submission_date}) = 2024
AND ${active_users_aggregates.submission_date} >= date(2024, 2, 29),
366, 365)
) - 1
label: DAU YoY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: dau_yoy
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: show
first_last: first
num_rows: '392'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
dau_yoy: "#3FE1B0"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have at least one mouse/keyboard interaction and visit at least one URI.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
hidden_pivots: {}
hidden_fields: [active_users_aggregates.daily_active_users, dau_28_day_moving_average]
listen: {}
row: 22
col: 12
width: 12
height: 6
- title: Mobile DAU 28-Day Moving Average YoY% (Fenix, Firefosx iOS, Focus Android,
Focus iOS)
name: Mobile DAU 28-Day Moving Average YoY% (Fenix, Firefosx iOS, Focus Android,
Focus iOS)
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.daily_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix,Firefox iOS,Focus Android,Focus iOS
active_users_aggregates.submission_date: after 115 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 5000
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
- category: table_calculation
description: Calculates the YoY value using a 365-day offset
expression: |-
${dau_28_day_moving_average} /
offset(
${dau_28_day_moving_average},
if(extract_years(${active_users_aggregates.submission_date}) = 2024
AND ${active_users_aggregates.submission_date} >= date(2024, 2, 29),
366, 365)
) - 1
label: DAU YoY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: dau_yoy
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: show
first_last: first
num_rows: '392'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
dau_yoy: "#9059FF"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have at least one mouse/keyboard interaction and visit at least one URI.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
hidden_pivots: {}
hidden_fields: [active_users_aggregates.daily_active_users, dau_28_day_moving_average]
listen: {}
row: 16
col: 12
width: 12
height: 6
- title: Desktop DAU 28-Day Moving Average YoY%
name: Desktop DAU 28-Day Moving Average YoY%
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.daily_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Firefox Desktop
active_users_aggregates.submission_date: after 115 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 5000
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
- category: table_calculation
description: Calculates the YoY value using a 365-day offset
expression: |-
${dau_28_day_moving_average} /
offset(
${dau_28_day_moving_average},
if(extract_years(${active_users_aggregates.submission_date}) = 2024
AND ${active_users_aggregates.submission_date} >= date(2024, 2, 29),
366, 365)
) - 1
label: DAU YoY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: dau_yoy
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: show
first_last: first
num_rows: '392'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
dau_yoy: "#FF7139"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have at least one mouse/keyboard interaction and visit at least one URI.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
hidden_pivots: {}
hidden_fields: [active_users_aggregates.daily_active_users, dau_28_day_moving_average]
listen: {}
row: 10
col: 12
width: 12
height: 6
- title: Focus Android DAU 28-Day Moving Average YoY%
name: Focus Android DAU 28-Day Moving Average YoY%
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.daily_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Focus Android
active_users_aggregates.submission_date: after 115 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 5000
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
- category: table_calculation
description: Calculates the YoY value using a 365-day offset
expression: |-
${dau_28_day_moving_average} /
offset(
${dau_28_day_moving_average},
if(extract_years(${active_users_aggregates.submission_date}) = 2024
AND ${active_users_aggregates.submission_date} >= date(2024, 2, 29),
366, 365)
) - 1
label: DAU YoY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: dau_yoy
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: show
first_last: first
num_rows: '392'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
dau_yoy: "#005E5D"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients that have at least one mouse/keyboard interaction and visit at least one URI.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
hidden_pivots: {}
hidden_fields: [active_users_aggregates.daily_active_users, dau_28_day_moving_average]
listen: {}
row: 34
col: 12
width: 12
height: 6
- title: Combined MAU (Desktop + Mobile)
name: Combined MAU (Desktop + Mobile)
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.monthly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix,Firefox iOS,Focus Android,Focus iOS,Firefox
Desktop
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.monthly_active_users,
id: active_users_aggregates.monthly_active_users, name: MAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#9059FF"
active_users_aggregates.monthly_active_users: "#ff1203"
advanced_vis_config: |-
{
chart: {},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'MAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 90
col: 0
width: 24
height: 6
- title: Combined WAU (Desktop + Mobile)
name: Combined WAU (Desktop + Mobile)
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.weekly_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix,Firefox iOS,Focus Android,Focus iOS,Firefox
Desktop
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: '', orientation: left, series: [{axisId: active_users_aggregates.weekly_active_users,
id: active_users_aggregates.weekly_active_users, name: WAU}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#9059FF"
active_users_aggregates.monthly_active_users: "#9059FF"
active_users_aggregates.weekly_active_users: "#ff1203"
advanced_vis_config: |-
{
chart: {},
caption: {
text: 'The number of unique clients in a 7-day period that have <a href="https://docs.google.com/document/d/1-sP8F0XskeyVIXApXjWn26mpTLjvW9CQ6bQsZZoS5B4/edit#heading=h.qdndw0yzycur">a nonzero session length</a>.<br/>Excludes known sources of bot activity and Mozilla Online (<a href="https://docs.google.com/document/d/1l00C8JnjTYrwo9tqZdmFrL8OTHMvAorBKZ0tbFzkR-w/edit">decision brief</a>).',
useHTML: true,
align: "left",
x: 50,
style: {
color: "#555",
fontSize: "1.0em",
},
},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'WAU'
}]
}
defaults_version: 1
hidden_pivots: {}
listen: {}
row: 134
col: 0
width: 24
height: 6
- title: Combined DAU 28-Day Moving Average YoY%
name: Combined DAU 28-Day Moving Average YoY%
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.submission_date, active_users_aggregates.daily_active_users]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix,Firefox iOS,Focus Android,Focus iOS,Firefox
Desktop
active_users_aggregates.submission_date: after 115 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 5000
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
- category: table_calculation
description: Calculates the YoY value using a 365-day offset
expression: |-
${dau_28_day_moving_average} /
offset(
${dau_28_day_moving_average},
if(extract_years(${active_users_aggregates.submission_date}) = 2024
AND ${active_users_aggregates.submission_date} >= date(2024, 2, 29),
366, 365)
) - 1
label: DAU YoY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: dau_yoy
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: show
first_last: first
num_rows: '392'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#FF7139"
dau_yoy: "#ff1203"
advanced_vis_config: |-
{
chart: {},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
hidden_pivots: {}
hidden_fields: [active_users_aggregates.daily_active_users, dau_28_day_moving_average]
listen: {}
row: 46
col: 12
width: 12
height: 6
- title: Combined DAU (Desktop + Mobile)
name: Combined DAU (Desktop + Mobile)
model: combined_browser_metrics
explore: active_users_aggregates
type: looker_line
fields: [active_users_aggregates.daily_active_users, active_users_aggregates.submission_date]
fill_fields: [active_users_aggregates.submission_date]
filters:
active_users_aggregates.app_name: Fenix,Firefox iOS,Focus Android,Focus iOS,Firefox
Desktop
active_users_aggregates.submission_date: after 60 weeks ago
sorts: [active_users_aggregates.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: mean(offset_list(${active_users_aggregates.daily_active_users},
0, 28))
label: DAU 28-Day Moving Average
value_format: "#,##0"
value_format_name: __custom
_kind_hint: measure
table_calculation: dau_28_day_moving_average
_type_hint: number
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: true
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
y_axes: [{label: Daily Active Users, orientation: left, series: [{axisId: active_users_aggregates.daily_active_users,
id: active_users_aggregates.daily_active_users, name: DAU}, {axisId: dau_28_day_moving_average,
id: dau_28_day_moving_average, name: DAU 28-Day Moving Average}], showLabels: true,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}]
x_axis_zoom: true
y_axis_zoom: true
limit_displayed_rows_values:
show_hide: hide
first_last: last
num_rows: '31'
series_colors:
active_users_aggregates.daily_active_users: "#CCC"
dau_28_day_moving_average: "#ff1203"
advanced_vis_config: |-
{
chart: {},
legend: {
align: "right",
verticalAlign: "top",
layout: "horizontal",
floating: false,
},
series: [{
name: 'DAU'
}, {
name: 'DAU 28-Day Moving Average'
}]
}
defaults_version: 1
listen: {}
row: 46
col: 0
width: 12
height: 6