duet/mr1DEVELOPMENT/dashboards/dev_desktop_mozorg_funnel.dashboard.lookml (1,336 lines of code) (raw):
---
- dashboard: desktop_moz_org_funnel_windows
title: Desktop Moz.org Funnel (Windows)
layout: newspaper
preferred_viewer: dashboards-next
description: ''
preferred_slug: u0Rs8lm4XO8FbR5N3pgvnd
elements:
- name: ''
type: text
title_text: ''
body_text: '[{"type":"p","id":1702805888235,"children":[{"text":"The Desktop Moz.org
Windows Funnel consists of Windows users who acquired Firefox via our website
("},{"type":"a","url":"https://www.mozilla.org/","children":[{"text":"https://www.mozilla.org/"}],"id":1705472569796},{"text":").
Documentation is available in the "},{"type":"a","url":"https://docs.google.com/document/d/1W0FwfsaI8mO3ONuSKmoSqvwjEqiyEYTf2MIls-q9zJU/edit","children":[{"text":"Dashboard
Manual: Desktop Moz.org Funnel (Windows)"}],"id":1705472602325},{"text":". For
questions, contact @shong. "}]},{"type":"p","id":1705472953496,"children":[{"bold":true,"text":"Metrics"},{"text":"
listed blow: "}]},{"type":"p","id":1702806075533,"children":[{"text":"","bold":true}]},{"type":"p","id":1705472957185,"children":[{"bold":true,"text":"Non
Fx Sessions:"},{"text":" Number of visits to our website (counted via GA Sessions) "},{"text":"Non
Fx Downloads: ","bold":true},{"text":"Number of those visits that resulted in
a download (counted via GA)"}]},{"type":"p","id":1702806207741,"children":[{"text":"New
Installs:","bold":true},{"text":" Number of successful, new (no older Firefox
install found) installs "},{"text":" New Profiles: ","bold":true},{"text":"Number
of new profiles created as a result of a Firefox firstrun"}]},{"type":"p","id":1702806318450,"children":[{"text":"Repeat
Users:","bold":true},{"text":" Number of new profiles that returned for a second
session within their first 28 days"}]},{"type":"p","id":1702806435330,"children":[{"text":"Week
4 Retained: ","bold":true},{"text":"Number of new profiles that were still active
21 to 28 days after they first appeared. "}]}]'
rich_content_json: '{"format":"slate"}'
row: 13
col: 0
width: 15
height: 6
- name: Funnel Overview
title: Funnel Overview
note_state: collapsed
note_display: hover
note_text: Returned Second Day and Retained Week4 may be undercounted if "Days
Waiting Wk4 Results" is not 0
merged_queries:
- model: duet
explore: dev_desktop_session
type: table
fields: [dev_desktop_session.join_field, dev_desktop_session.non_fx_sessions,
dev_desktop_session.non_fx_downloads]
filters:
dev_desktop_session.year_over_year: 'No'
dev_desktop_session.join_field: 'yes'
dev_desktop_session.funnel_derived: mozorg windows funnel
sorts: [dev_desktop_session.non_fx_sessions desc]
limit: 5000
column_limit: 50
join_fields: []
- model: duet
explore: dev_desktop_install
type: table
fields: [dev_desktop_install.join_field, dev_desktop_install.new_installs]
filters:
dev_desktop_install.join_field: 'yes'
dev_desktop_install.funnel_derived: mozorg windows funnel
sorts: [dev_desktop_install.new_installs desc]
limit: 500
column_limit: 50
join_fields:
- field_name: dev_desktop_install.join_field
source_field_name: dev_desktop_session.join_field
- model: duet
explore: dev_desktop_new_profiles
type: table
fields: [dev_desktop_new_profiles.join_field, dev_desktop_new_profiles.new_profiles]
filters:
dev_desktop_new_profiles.join_field: 'yes'
dev_desktop_new_profiles.funnel_derived: mozorg windows funnel
sorts: [dev_desktop_new_profiles.new_profiles desc]
limit: 500
column_limit: 50
join_fields:
- field_name: dev_desktop_new_profiles.join_field
source_field_name: dev_desktop_session.join_field
- model: duet
explore: dev_desktop_usage
type: table
fields: [dev_desktop_usage.join_field, dev_desktop_usage.returned_second_day,
dev_desktop_usage.retained_week4]
filters:
dev_desktop_usage.join_field: 'yes'
dev_desktop_usage.funnel_derived: mozorg windows funnel
dev_desktop_usage.week4_reported_date: 'Yes'
sorts: [dev_desktop_usage.returned_second_day desc]
limit: 500
column_limit: 50
join_fields:
- field_name: dev_desktop_usage.join_field
source_field_name: dev_desktop_session.join_field
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
y_axes: [{label: '', orientation: left, series: [{axisId: dev_desktop_session.non_fx_sessions,
id: dev_desktop_session.non_fx_sessions, name: Non Fx Sessions}, {axisId: dev_desktop_session.non_fx_downloads,
id: dev_desktop_session.non_fx_downloads, name: Non Fx Downloads}, {axisId: dev_desktop_install.new_installs,
id: dev_desktop_install.new_installs, name: New Installs}, {axisId: dev_desktop_new_profiles.new_profiles,
id: dev_desktop_new_profiles.new_profiles, name: New Profiles}, {axisId: dev_desktop_usage.returned_second_day,
id: dev_desktop_usage.returned_second_day, name: Returned Second Day},
{axisId: dev_desktop_usage.retained_week4, id: dev_desktop_usage.retained_week4,
name: Retained Week4}], showLabels: true, showValues: true, unpinAxis: false,
tickDensity: default, tickDensityCustom: 5, type: linear}]
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
x_axis_label: ''
show_x_axis_ticks: false
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
x_axis_zoom: true
y_axis_zoom: true
trellis: ''
stacking: ''
limit_displayed_rows: false
limit_displayed_rows_values:
show_hide: hide
first_last: first
num_rows: 0
legend_position: center
series_types: {}
point_style: none
series_colors:
dev_desktop_session.non_fx_downloads: "#005E5D"
dev_desktop_new_profiles.new_profiles: "#FF2A8A"
dev_desktop_usage.returned_second_day: "#FFA537"
dev_desktop_usage.retained_week4: "#A7341F"
series_labels:
dev_desktop_usage.returned_second_day: Repeat Users
dev_desktop_usage.retained_week4: Week 4 Retained
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
column_spacing_ratio: 0
column_group_spacing_ratio: 0
show_dropoff: true
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
type: looker_column
hidden_fields: [dev_desktop_session.join_field]
column_limit: 50
listen:
- Analysis Period: dev_desktop_session.analysis_period
Countries: dev_desktop_session.normalized_country_code_subset
Include Dates Where: dev_desktop_session.week4_reported_date_described
- Analysis Period: dev_desktop_install.analysis_period
Countries: dev_desktop_install.normalized_country_code_subset
Include Dates Where: dev_desktop_install.week4_reported_date_described
- Analysis Period: dev_desktop_new_profiles.analysis_period
Countries: dev_desktop_new_profiles.normalized_country_code_subset
Include Dates Where: dev_desktop_new_profiles.week4_reported_date_described
- Analysis Period: dev_desktop_usage.analysis_period
Countries: dev_desktop_usage.normalized_country_code_subset
row: 4
col: 0
width: 24
height: 9
- name: " (2)"
type: text
title_text: ''
body_text: |
<div style="border-radius: 5px; padding: 5px 10px; background: #090808; height: 55px; color: red;">
<nav style="font-size: 15px;">
<img style="color: #efefef; padding: 5px 25px; float: left; height: 40px;" src="https://www.mozilla.org/media/protocol/img/logos/mozilla/logo-word-hor.e20791bb4dd4.svg"/>
<a style="color: #efefef; border: 1px solid white; padding: 5px 25px; float: left; line-height: 40px;" href="https://mozilla.cloud.looker.com/dashboards/duet::desktop_moz_org_funnel_windows">
Moz.org Funnel (Windows)</a>
<a style="color: #efefef; padding: 5px 25px; float: left; line-height: 40px;" href="https://mozilla.cloud.looker.com/dashboards/duet::desktop_moz_org_funnel_mac">
Moz.org Funnel (Mac)</a>
<a style="color: #efefef; padding: 5px 25px; float: left; line-height: 40px;" href="https://mozilla.cloud.looker.com/dashboards/duet::desktop_distribution_builds_funnel">
Distribution Builds</a>
<a style="color: #efefef; padding: 5px 25px; float: left; line-height: 40px;" href="...tobelinkedlater">
Unknown Funnel[COMING]</a>
</nav>
</div>
row: 0
col: 0
width: 24
height: 2
- title: Report Period
name: Report Period
model: duet
explore: dev_desktop_dates
type: single_value
fields: [dev_desktop_dates.max_date, dev_desktop_dates.min_date]
filters:
dev_desktop_dates.join_field: 'yes'
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: "concat(\nto_string(${dev_desktop_dates.min_date}), \n \" to \"\
\ ,\nto_string(${dev_desktop_dates.max_date})\n)"
label: Report Period
value_format:
value_format_name:
_kind_hint: measure
table_calculation: report_period
_type_hint: string
custom_color_enabled: true
show_single_value_title: true
show_comparison: false
comparison_type: value
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
show_view_names: false
defaults_version: 1
hidden_fields: [dev_desktop_dates.max_date, dev_desktop_dates.min_date]
listen:
Analysis Period: dev_desktop_dates.analysis_period
Include Dates Where: dev_desktop_dates.week4_reported_date_described
row: 2
col: 0
width: 14
height: 2
- title: Days Reporting
name: Days Reporting
model: duet
explore: dev_desktop_dates
type: single_value
fields: [dev_desktop_dates.days]
filters:
dev_desktop_dates.join_field: 'yes'
limit: 500
column_limit: 50
custom_color_enabled: true
show_single_value_title: true
show_comparison: false
comparison_type: value
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
comparison_label: Waiting Wk4 Results
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: false
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
defaults_version: 1
note_state: collapsed
note_display: hover
note_text: 'Total number of reported days in the reporting period. Note, this
may not match with the range in the "Analysis Period" filter, because for the
most recent dates, we may be waiting for data to arrive/process. '
listen:
Analysis Period: dev_desktop_dates.analysis_period
Include Dates Where: dev_desktop_dates.week4_reported_date_described
row: 2
col: 14
width: 5
height: 2
- name: Non Fx Sessions
title: Non Fx Sessions
note_state: collapsed
note_display: hover
note_text: 'Number of visits to our website (counted via GA Sessions) '
merged_queries:
- model: duet
explore: dev_desktop_session
type: table
fields: [dev_desktop_session.join_field, dev_desktop_session.non_fx_sessions]
filters:
dev_desktop_session.join_field: 'yes'
dev_desktop_session.funnel_derived: mozorg windows funnel
dev_desktop_session.week4_reported_date: ''
sorts: [dev_desktop_session.non_fx_sessions desc]
limit: 500
column_limit: 50
join_fields: []
- model: duet
explore: dev_desktop_session
type: table
fields: [dev_desktop_session.join_field, dev_desktop_session.non_fx_sessions]
filters:
dev_desktop_session.join_field: 'yes'
dev_desktop_session.funnel_derived: mozorg windows funnel
dev_desktop_session.week4_reported_date: ''
dev_desktop_session.year_over_year: 'Yes'
sorts: [dev_desktop_session.non_fx_sessions desc]
limit: 500
column_limit: 50
join_fields:
- field_name: dev_desktop_session.join_field
source_field_name: dev_desktop_session.join_field
custom_color_enabled: true
show_single_value_title: true
show_comparison: true
comparison_type: change
comparison_reverse_colors: false
show_comparison_label: true
comparison_label: YOY
enable_conditional_formatting: true
conditional_formatting: [{type: equal to, value: !!null '', background_color: "#3FE1B0",
font_color: !!null '', color_application: {collection_id: mozilla, palette_id: mozilla-sequential-0},
bold: false, italic: false, strikethrough: false, fields: !!null ''}]
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
type: single_value
series_types: {}
hidden_fields: [q1_dev_desktop_session.non_fx_sessions]
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: "(${dev_desktop_session.non_fx_sessions} - ${q1_dev_desktop_session.non_fx_sessions})\
\ / \n ${q1_dev_desktop_session.non_fx_sessions}"
label: change
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: change
_type_hint: number
listen:
- Analysis Period: dev_desktop_session.analysis_period
Countries: dev_desktop_session.normalized_country_code_subset
Include Dates Where: dev_desktop_session.week4_reported_date_described
- Analysis Period: dev_desktop_session.analysis_period
Countries: dev_desktop_session.normalized_country_code_subset
Include Dates Where: dev_desktop_session.week4_reported_date_described
row: 20
col: 0
width: 5
height: 4
- name: " (3)"
type: text
title_text: ''
body_text: |-
<div style="background-color: #3FE1B0; height: 20px; width: 600px; display: flex; align-items: center; padding-left: 200px;">
<span style="color: white;">mozilla.org / Google Analytics</span>
</div>
row: 19
col: 0
width: 10
height: 1
- name: Non Fx Downloads
title: Non Fx Downloads
note_state: collapsed
note_display: hover
note_text: Number of those visits that resulted in a download (counted via GA)
merged_queries:
- model: duet
explore: dev_desktop_session
type: table
fields: [dev_desktop_session.join_field, dev_desktop_session.non_fx_downloads]
filters:
dev_desktop_session.join_field: 'yes'
dev_desktop_session.funnel_derived: mozorg windows funnel
dev_desktop_session.week4_reported_date: ''
limit: 500
column_limit: 50
join_fields: []
- model: duet
explore: dev_desktop_session
type: table
fields: [dev_desktop_session.join_field, dev_desktop_session.non_fx_downloads]
filters:
dev_desktop_session.join_field: 'yes'
dev_desktop_session.funnel_derived: mozorg windows funnel
dev_desktop_session.week4_reported_date: ''
dev_desktop_session.year_over_year: 'Yes'
limit: 500
column_limit: 50
join_fields:
- field_name: dev_desktop_session.join_field
source_field_name: dev_desktop_session.join_field
custom_color_enabled: true
show_single_value_title: true
show_comparison: true
comparison_type: change
comparison_reverse_colors: false
show_comparison_label: true
comparison_label: YOY
enable_conditional_formatting: true
conditional_formatting: [{type: equal to, value: !!null '', background_color: "#3FE1B0",
font_color: !!null '', color_application: {collection_id: mozilla, palette_id: mozilla-sequential-0},
bold: false, italic: false, strikethrough: false, fields: !!null ''}]
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
type: single_value
series_types: {}
hidden_fields: [q1_dev_desktop_session.non_fx_sessions, q1_dev_desktop_session.non_fx_downloads]
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: "(${dev_desktop_session.non_fx_downloads} - ${q1_dev_desktop_session.non_fx_downloads})\
\ / \n ${q1_dev_desktop_session.non_fx_downloads}"
label: change
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: change
_type_hint: number
listen:
- Analysis Period: dev_desktop_session.analysis_period
Countries: dev_desktop_session.normalized_country_code_subset
Include Dates Where: dev_desktop_session.week4_reported_date_described
- Analysis Period: dev_desktop_session.analysis_period
Countries: dev_desktop_session.normalized_country_code_subset
Include Dates Where: dev_desktop_session.week4_reported_date_described
row: 20
col: 5
width: 5
height: 4
- name: New Installs
title: New Installs
note_state: collapsed
note_display: hover
note_text: 'Number of successful, new (no older Firefox install found) installs '
merged_queries:
- model: duet
explore: dev_desktop_install
type: table
fields: [dev_desktop_install.join_field, dev_desktop_install.new_installs]
filters:
dev_desktop_install.join_field: 'yes'
dev_desktop_install.funnel_derived: mozorg windows funnel
sorts: [dev_desktop_install.new_installs desc]
limit: 500
column_limit: 50
join_fields: []
- model: duet
explore: dev_desktop_install
type: table
fields: [dev_desktop_install.join_field, dev_desktop_install.new_installs]
filters:
dev_desktop_install.join_field: 'yes'
dev_desktop_install.funnel_derived: mozorg windows funnel
dev_desktop_install.year_over_year: 'Yes'
sorts: [dev_desktop_install.new_installs desc]
limit: 500
column_limit: 50
join_fields:
- field_name: dev_desktop_install.join_field
source_field_name: dev_desktop_install.join_field
custom_color_enabled: true
show_single_value_title: true
show_comparison: true
comparison_type: change
comparison_reverse_colors: false
show_comparison_label: true
comparison_label: YOY
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
series_types: {}
type: single_value
hidden_fields: [q1_dev_desktop_install.new_installs]
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: "(${dev_desktop_install.new_installs} - ${q1_dev_desktop_install.new_installs})\
\ / \n ${q1_dev_desktop_install.new_installs}"
label: Change
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: change
_type_hint: number
listen:
- Analysis Period: dev_desktop_install.analysis_period
Countries: dev_desktop_install.normalized_country_code_subset
Include Dates Where: dev_desktop_install.week4_reported_date_described
- Analysis Period: dev_desktop_install.analysis_period
Countries: dev_desktop_install.normalized_country_code_subset
Include Dates Where: dev_desktop_install.week4_reported_date_described
row: 20
col: 10
width: 5
height: 4
- name: " (4)"
type: text
title_text: ''
body_text: |-
<div style="background-color: #9059FF; height: 20px; width: 250px; display: flex; align-items: center; padding-left: 100px;">
<span style="color: white;">Installer Ping</span>
</div>
row: 19
col: 10
width: 5
height: 1
- name: New Profiles
title: New Profiles
note_state: collapsed
note_display: hover
note_text: Number of new profiles created as a result of a Firefox firstrun
merged_queries:
- model: duet
explore: dev_desktop_new_profiles
type: table
fields: [dev_desktop_new_profiles.join_field, dev_desktop_new_profiles.new_profiles]
filters:
dev_desktop_new_profiles.join_field: 'yes'
dev_desktop_new_profiles.funnel_derived: mozorg windows funnel
sorts: [dev_desktop_new_profiles.new_profiles desc]
limit: 500
column_limit: 50
join_fields: []
- model: duet
explore: dev_desktop_new_profiles
type: table
fields: [dev_desktop_new_profiles.join_field, dev_desktop_new_profiles.new_profiles]
filters:
dev_desktop_new_profiles.join_field: 'yes'
dev_desktop_new_profiles.funnel_derived: mozorg windows funnel
dev_desktop_new_profiles.year_over_year: 'Yes'
limit: 500
join_fields:
- field_name: dev_desktop_new_profiles.join_field
source_field_name: dev_desktop_new_profiles.join_field
custom_color_enabled: true
show_single_value_title: true
show_comparison: true
comparison_type: change
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
series_types: {}
type: single_value
hidden_fields: [q1_dev_desktop_new_profiles.new_profiles]
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: "(${dev_desktop_new_profiles.new_profiles} - ${q1_dev_desktop_new_profiles.new_profiles})\
\ / \n ${q1_dev_desktop_new_profiles.new_profiles}"
label: YOY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: yoy
_type_hint: number
listen:
- Analysis Period: dev_desktop_new_profiles.analysis_period
Countries: dev_desktop_new_profiles.normalized_country_code_subset
Include Dates Where: dev_desktop_new_profiles.week4_reported_date_described
- Analysis Period: dev_desktop_new_profiles.analysis_period
Countries: dev_desktop_new_profiles.normalized_country_code_subset
Include Dates Where: dev_desktop_new_profiles.week4_reported_date_described
row: 25
col: 0
width: 5
height: 4
- name: " (5)"
type: text
title_text: ''
body_text: |-
<div style="background-color: #FF2A8A; height: 20px; width: 800px; display: flex; align-items: center; padding-left: 400px;">
<span style="color: white;">Telemetry</span>
</div>
row: 24
col: 0
width: 15
height: 1
- name: Returned Second Day
title: Returned Second Day
note_state: collapsed
note_display: hover
note_text: Number of new profiles that returned for a second session within their
first 28 days
merged_queries:
- model: duet
explore: dev_desktop_usage
type: table
fields: [dev_desktop_usage.join_field, dev_desktop_usage.returned_second_day]
filters:
dev_desktop_usage.join_field: 'yes'
dev_desktop_usage.funnel_derived: mozorg windows funnel
dev_desktop_usage.week4_reported_date: 'yes'
sorts: [dev_desktop_usage.returned_second_day desc]
limit: 500
column_limit: 50
join_fields: []
- model: duet
explore: dev_desktop_usage
type: table
fields: [dev_desktop_usage.join_field, dev_desktop_usage.returned_second_day]
filters:
dev_desktop_usage.join_field: 'yes'
dev_desktop_usage.funnel_derived: mozorg windows funnel
dev_desktop_usage.week4_reported_date: 'yes'
dev_desktop_usage.year_over_year: 'Yes'
limit: 500
join_fields:
- field_name: dev_desktop_usage.join_field
source_field_name: dev_desktop_usage.join_field
custom_color_enabled: true
show_single_value_title: true
single_value_title: Repeat Users
show_comparison: true
comparison_type: change
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
type: single_value
series_types: {}
hidden_fields: [q1_dev_desktop_usage.returned_second_day]
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: "(${dev_desktop_usage.returned_second_day} - ${q1_dev_desktop_usage.returned_second_day})\
\ / \n ${q1_dev_desktop_usage.returned_second_day}"
label: YOY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: yoy
_type_hint: number
listen:
- Analysis Period: dev_desktop_usage.analysis_period
Countries: dev_desktop_usage.normalized_country_code_subset
- Analysis Period: dev_desktop_usage.analysis_period
Countries: dev_desktop_usage.normalized_country_code_subset
row: 25
col: 5
width: 5
height: 4
- name: Week 4 Retained
title: Week 4 Retained
note_state: collapsed
note_display: hover
note_text: "Number of new profiles that were still active 21 to 28 days after\
\ they first appeared. \n"
merged_queries:
- model: duet
explore: dev_desktop_usage
type: table
fields: [dev_desktop_usage.join_field, dev_desktop_usage.retained_week4]
filters:
dev_desktop_usage.join_field: 'yes'
dev_desktop_usage.funnel_derived: mozorg windows funnel
dev_desktop_usage.week4_reported_date: 'yes'
limit: 500
column_limit: 50
join_fields: []
- model: duet
explore: dev_desktop_usage
type: table
fields: [dev_desktop_usage.join_field, dev_desktop_usage.retained_week4]
filters:
dev_desktop_usage.join_field: 'yes'
dev_desktop_usage.funnel_derived: mozorg windows funnel
dev_desktop_usage.week4_reported_date: 'yes'
dev_desktop_usage.year_over_year: 'Yes'
limit: 500
column_limit: 50
join_fields:
- field_name: dev_desktop_usage.join_field
source_field_name: dev_desktop_usage.join_field
custom_color_enabled: true
show_single_value_title: true
single_value_title: Week 4 Retained
show_comparison: true
comparison_type: change
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
type: single_value
series_types: {}
hidden_fields: [q1_dev_desktop_usage.returned_second_day, q1_dev_desktop_usage.retained_week4]
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: "(${dev_desktop_usage.retained_week4} - ${q1_dev_desktop_usage.retained_week4})\
\ / \n ${q1_dev_desktop_usage.retained_week4}"
label: YOY
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: yoy
_type_hint: number
listen:
- Analysis Period: dev_desktop_usage.analysis_period
Countries: dev_desktop_usage.normalized_country_code_subset
- Analysis Period: dev_desktop_usage.analysis_period
Countries: dev_desktop_usage.normalized_country_code_subset
row: 25
col: 10
width: 5
height: 4
- title: Days Waiting Wk4 Results
name: Days Waiting Wk4 Results
model: duet
explore: dev_desktop_dates
type: single_value
fields: [dev_desktop_dates.days_waiting_results]
filters:
dev_desktop_dates.join_field: 'yes'
limit: 500
column_limit: 50
custom_color_enabled: true
show_single_value_title: true
show_comparison: false
comparison_type: value
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
comparison_label: Waiting Wk4 Results
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: false
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
defaults_version: 1
note_state: collapsed
note_display: hover
note_text: Repeat Users and Week 4 Retained require 28 days of data from an acquisition
date in order to calculate. So for more recent data, we may be missing data.
To exclude dates where we're still waiting for data to arrive, click "Yes" on
"Exclude Days Awaiting Wk4 Results"
listen:
Analysis Period: dev_desktop_dates.analysis_period
Include Dates Where: dev_desktop_dates.week4_reported_date_described
row: 2
col: 19
width: 5
height: 2
- name: Funnel Counts
title: Funnel Counts
note_state: collapsed
note_display: hover
note_text: 'Counts per day. 7 days smoothing applied. '
merged_queries:
- model: duet
explore: dev_desktop_session
type: table
fields: [dev_desktop_session.submission_date, dev_desktop_session.non_fx_sessions_smoothed,
dev_desktop_session.non_fx_downloads_smoothed]
fill_fields: [dev_desktop_session.submission_date]
filters:
dev_desktop_session.year_over_year: 'No'
dev_desktop_session.join_field: 'yes'
dev_desktop_session.funnel_derived: mozorg windows funnel
sorts: [dev_desktop_session.submission_date desc]
limit: 5000
column_limit: 50
hidden_pivots: {}
join_fields: []
- model: duet
explore: dev_desktop_install
type: table
fields: [dev_desktop_install.submission_date, dev_desktop_install.new_installs_smoothed]
fill_fields: [dev_desktop_install.submission_date]
filters:
dev_desktop_install.join_field: 'yes'
dev_desktop_install.funnel_derived: mozorg windows funnel
limit: 500
column_limit: 50
hidden_pivots: {}
join_fields:
- field_name: dev_desktop_install.submission_date
source_field_name: dev_desktop_session.submission_date
- model: duet
explore: dev_desktop_new_profiles
type: table
fields: [dev_desktop_new_profiles.submission_date, dev_desktop_new_profiles.new_profiles_smoothed]
fill_fields: [dev_desktop_new_profiles.submission_date]
filters:
dev_desktop_new_profiles.join_field: 'yes'
dev_desktop_new_profiles.funnel_derived: mozorg windows funnel
limit: 500
column_limit: 50
hidden_pivots: {}
join_fields:
- field_name: dev_desktop_new_profiles.submission_date
source_field_name: dev_desktop_session.submission_date
- model: duet
explore: dev_desktop_usage
type: table
fields: [dev_desktop_usage.submission_date, dev_desktop_usage.returned_second_day_smoothed,
dev_desktop_usage.retained_week4_smoothed]
fill_fields: [dev_desktop_usage.submission_date]
filters:
dev_desktop_usage.join_field: 'yes'
dev_desktop_usage.funnel_derived: mozorg windows funnel
dev_desktop_usage.week4_reported_date: 'yes'
sorts: [dev_desktop_usage.submission_date desc]
limit: 500
column_limit: 50
hidden_pivots: {}
join_fields:
- field_name: dev_desktop_usage.submission_date
source_field_name: dev_desktop_session.submission_date
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
y_axes: [{label: '', orientation: left, series: [{axisId: dev_desktop_session.non_fx_sessions,
id: dev_desktop_session.non_fx_sessions, name: Non Fx Sessions}, {axisId: dev_desktop_session.non_fx_downloads,
id: dev_desktop_session.non_fx_downloads, name: Non Fx Downloads}, {axisId: dev_desktop_install.new_installs,
id: dev_desktop_install.new_installs, name: New Installs}, {axisId: dev_desktop_new_profiles.new_profiles,
id: dev_desktop_new_profiles.new_profiles, name: New Profiles}, {axisId: dev_desktop_usage.returned_second_day,
id: dev_desktop_usage.returned_second_day, name: Returned Second Day},
{axisId: dev_desktop_usage.retained_week4, id: dev_desktop_usage.retained_week4,
name: Retained Week4}], showLabels: true, showValues: true, unpinAxis: false,
tickDensity: default, tickDensityCustom: 5, type: linear}]
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
x_axis_label: ''
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
x_axis_zoom: true
y_axis_zoom: true
trellis: ''
stacking: ''
limit_displayed_rows: false
limit_displayed_rows_values:
show_hide: hide
first_last: first
num_rows: 0
legend_position: center
series_types: {}
point_style: none
series_colors:
dev_desktop_session.non_fx_downloads: "#005E5D"
dev_desktop_new_profiles.new_profiles: "#FF2A8A"
dev_desktop_usage.returned_second_day: "#FFA537"
dev_desktop_usage.retained_week4: "#A7341F"
dev_desktop_session.non_fx_downloads_smoothed: "#005E5D"
dev_desktop_new_profiles.new_profiles_smoothed: "#FF2A8A"
dev_desktop_usage.returned_second_day_smoothed: "#FFA537"
dev_desktop_usage.retained_week4_smoothed: "#A7341F"
series_labels:
dev_desktop_usage.returned_second_day_smoothed: Repeat Users
dev_desktop_usage.retained_week4_smoothed: Week 4 Retained
dev_desktop_session.non_fx_sessions_smoothed: Non Fx Sessions
dev_desktop_session.non_fx_downloads_smoothed: Non Fx Downloads
dev_desktop_install.new_installs_smoothed: New Installs
dev_desktop_new_profiles.new_profiles_smoothed: New Profiles
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
ordering: none
show_null_labels: false
column_spacing_ratio: 0
column_group_spacing_ratio: 0
show_dropoff: true
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
type: looker_line
hidden_fields: []
column_limit: 50
listen:
- Analysis Period: dev_desktop_session.analysis_period
Countries: dev_desktop_session.normalized_country_code_subset
Include Dates Where: dev_desktop_session.week4_reported_date_described
- Analysis Period: dev_desktop_install.analysis_period
Countries: dev_desktop_install.normalized_country_code_subset
Include Dates Where: dev_desktop_install.week4_reported_date_described
- Analysis Period: dev_desktop_new_profiles.analysis_period
Countries: dev_desktop_new_profiles.normalized_country_code_subset
Include Dates Where: dev_desktop_new_profiles.week4_reported_date_described
- Analysis Period: dev_desktop_usage.analysis_period
Countries: dev_desktop_usage.normalized_country_code_subset
row: 13
col: 15
width: 9
height: 8
- name: YOY Change
title: YOY Change
note_state: collapsed
note_display: hover
note_text: 'Year of year comparison per day. 7 days smoothing applied. '
merged_queries:
- model: duet
explore: dev_desktop_session
type: table
fields: [dev_desktop_session.non_fx_downloads_smoothed, dev_desktop_session.non_fx_sessions_smoothed,
dev_desktop_session.submission_date]
fill_fields: [dev_desktop_session.submission_date]
filters:
dev_desktop_session.join_field: 'yes'
dev_desktop_session.funnel_derived: mozorg windows funnel
sorts: [dev_desktop_session.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: 'substring(to_string(${dev_desktop_session.submission_date}),
6, 5) '
label: dt
value_format:
value_format_name:
_kind_hint: dimension
table_calculation: dt
_type_hint: string
join_fields: []
- model: duet
explore: dev_desktop_session
type: table
fields: [dev_desktop_session.non_fx_downloads_smoothed, dev_desktop_session.non_fx_sessions_smoothed,
dev_desktop_session.submission_date]
fill_fields: [dev_desktop_session.submission_date]
filters:
dev_desktop_session.join_field: 'yes'
dev_desktop_session.funnel_derived: mozorg windows funnel
dev_desktop_session.year_over_year: 'Yes'
sorts: [dev_desktop_session.submission_date]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: 'substring(to_string(${dev_desktop_session.submission_date}),
6, 5) '
label: dt
value_format:
value_format_name:
_kind_hint: dimension
table_calculation: dt
_type_hint: string
join_fields:
- field_name: dt
source_field_name: dt
- model: duet
explore: dev_desktop_install
type: table
fields: [dev_desktop_install.new_installs_smoothed, dev_desktop_install.submission_date]
fill_fields: [dev_desktop_install.submission_date]
filters:
dev_desktop_install.join_field: 'yes'
dev_desktop_install.funnel_derived: mozorg windows funnel
sorts: [dev_desktop_install.submission_date]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: 'substring(to_string(${dev_desktop_install.submission_date}),
6, 5) '
label: dt
value_format:
value_format_name:
_kind_hint: dimension
table_calculation: dt
_type_hint: string
join_fields:
- field_name: dt
source_field_name: dt
- model: duet
explore: dev_desktop_install
type: table
fields: [dev_desktop_install.new_installs_smoothed, dev_desktop_install.submission_date]
fill_fields: [dev_desktop_install.submission_date]
filters:
dev_desktop_install.join_field: 'yes'
dev_desktop_install.funnel_derived: mozorg windows funnel
dev_desktop_install.year_over_year: 'Yes'
sorts: [dev_desktop_install.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: 'substring(to_string(${dev_desktop_install.submission_date}),
6, 5) '
label: dt
value_format:
value_format_name:
_kind_hint: dimension
table_calculation: dt
_type_hint: string
join_fields:
- field_name: dt
source_field_name: dt
- model: duet
explore: dev_desktop_new_profiles
type: table
fields: [dev_desktop_new_profiles.submission_date, dev_desktop_new_profiles.new_profiles_smoothed]
fill_fields: [dev_desktop_new_profiles.submission_date]
filters:
dev_desktop_new_profiles.join_field: 'yes'
dev_desktop_new_profiles.funnel_derived: mozorg windows funnel
sorts: [dev_desktop_new_profiles.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: 'substring(to_string(${dev_desktop_new_profiles.submission_date}),
6, 5) '
label: dt
value_format:
value_format_name:
_kind_hint: dimension
table_calculation: dt
_type_hint: string
join_fields:
- field_name: dt
source_field_name: dt
- model: duet
explore: dev_desktop_new_profiles
type: table
fields: [dev_desktop_new_profiles.submission_date, dev_desktop_new_profiles.new_profiles_smoothed]
fill_fields: [dev_desktop_new_profiles.submission_date]
filters:
dev_desktop_new_profiles.join_field: 'yes'
dev_desktop_new_profiles.funnel_derived: mozorg windows funnel
dev_desktop_new_profiles.year_over_year: 'Yes'
sorts: [dev_desktop_new_profiles.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: 'substring(to_string(${dev_desktop_new_profiles.submission_date}),
6, 5) '
label: dt
value_format:
value_format_name:
_kind_hint: dimension
table_calculation: dt
_type_hint: string
join_fields:
- field_name: dt
source_field_name: dt
- model: duet
explore: dev_desktop_usage
type: table
fields: [dev_desktop_usage.submission_date, dev_desktop_usage.returned_second_day_smoothed,
dev_desktop_usage.retained_week4_smoothed]
fill_fields: [dev_desktop_usage.submission_date]
filters:
dev_desktop_usage.join_field: 'yes'
dev_desktop_usage.funnel_derived: mozorg windows funnel
dev_desktop_usage.week4_reported_date: 'Yes'
sorts: [dev_desktop_usage.submission_date]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: 'substring(to_string(${dev_desktop_usage.submission_date}), 6,
5) '
label: dt
value_format:
value_format_name:
_kind_hint: dimension
table_calculation: dt
_type_hint: string
join_fields:
- field_name: dt
source_field_name: dt
- model: duet
explore: dev_desktop_usage
type: table
fields: [dev_desktop_usage.returned_second_day_smoothed, dev_desktop_usage.retained_week4_smoothed,
dev_desktop_usage.submission_date]
fill_fields: [dev_desktop_usage.submission_date]
filters:
dev_desktop_usage.join_field: 'yes'
dev_desktop_usage.funnel_derived: mozorg windows funnel
dev_desktop_usage.week4_reported_date: 'Yes'
dev_desktop_usage.year_over_year: 'Yes'
sorts: [dev_desktop_usage.submission_date desc]
limit: 500
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: 'substring(to_string(${dev_desktop_usage.submission_date}), 6,
5) '
label: dt
value_format:
value_format_name:
_kind_hint: dimension
table_calculation: dt
_type_hint: string
join_fields:
- field_name: dt
source_field_name: dt
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
y_axes: [{label: '', orientation: left, series: [{axisId: non_fx_sessions, id: non_fx_sessions,
name: non_fx_sessions}, {axisId: non_fx_downloads, id: non_fx_downloads,
name: non_fx_downloads}, {axisId: new_installs, id: new_installs, name: new_installs},
{axisId: new_profiles, id: new_profiles, name: new_profiles}, {axisId: returned_second_day,
id: returned_second_day, name: returned_second_day}, {axisId: retained_week4,
id: retained_week4, name: retained_week4}], showLabels: true, showValues: true,
maxValue: !!null '', minValue: !!null '', unpinAxis: false, tickDensity: default,
type: linear}]
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
x_axis_zoom: true
y_axis_zoom: true
trellis: ''
stacking: ''
limit_displayed_rows: false
legend_position: center
series_types: {}
point_style: none
series_colors:
non_fx_downloads: "#005E5D"
new_profiles: "#FF2A8A"
returned_second_day: "#FFA537"
retained_week4: "#A7341F"
series_labels:
non_fx_sessions: Non Fx Sessions
non_fx_downloads: Non Fx Downloads
new_installs: New Installs
new_profiles: New Profiles
returned_second_day: Repeat Users
retained_week4: Week 4 Retained
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
reference_lines: [{reference_type: line, range_start: max, range_end: min, margin_top: deviation,
margin_value: mean, margin_bottom: deviation, label_position: right, color: "#000000",
line_value: '0', label: No Change, value_format: 0.00%}]
show_null_points: false
interpolation: linear
hidden_fields: [q1_dev_desktop_session.submission_date, dev_desktop_session.non_fx_downloads_smoothed,
dev_desktop_session.non_fx_sessions_smoothed, q1_dev_desktop_session.non_fx_downloads_smoothed,
q1_dev_desktop_session.non_fx_sessions_smoothed, dev_desktop_install.new_installs_smoothed,
q3_dev_desktop_install.new_installs_smoothed, dev_desktop_install.submission_date,
q3_dev_desktop_install.submission_date, dev_desktop_new_profiles.submission_date,
q5_dev_desktop_new_profiles.submission_date, dev_desktop_new_profiles.new_profiles_smoothed,
q5_dev_desktop_new_profiles.new_profiles_smoothed, dt, dev_desktop_usage.submission_date,
q7_dev_desktop_usage.submission_date, dev_desktop_usage.returned_second_day_smoothed,
dev_desktop_usage.retained_week4_smoothed, q7_dev_desktop_usage.returned_second_day_smoothed,
q7_dev_desktop_usage.retained_week4_smoothed]
hidden_pivots: {}
type: looker_line
sorts: [dev_desktop_session.submission_date]
column_limit: 50
dynamic_fields:
- category: table_calculation
expression: "(${dev_desktop_session.non_fx_sessions_smoothed} - ${q1_dev_desktop_session.non_fx_sessions_smoothed})/${q1_dev_desktop_session.non_fx_sessions_smoothed}"
label: non_fx_sessions
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: non_fx_sessions
_type_hint: number
- category: table_calculation
expression: "(${dev_desktop_session.non_fx_downloads_smoothed} - ${q1_dev_desktop_session.non_fx_downloads_smoothed})/${q1_dev_desktop_session.non_fx_downloads_smoothed}"
label: non_fx_downloads
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: non_fx_downloads
_type_hint: number
- category: table_calculation
expression: "(${dev_desktop_install.new_installs_smoothed} - ${q3_dev_desktop_install.new_installs_smoothed})/${q3_dev_desktop_install.new_installs_smoothed} "
label: new_installs
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: new_installs
_type_hint: number
- category: table_calculation
expression: "(${dev_desktop_new_profiles.new_profiles_smoothed} - ${q5_dev_desktop_new_profiles.new_profiles_smoothed})/${q5_dev_desktop_new_profiles.new_profiles_smoothed}"
label: new_profiles
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: new_profiles
_type_hint: number
- category: table_calculation
expression: "(${dev_desktop_usage.returned_second_day_smoothed} - ${q7_dev_desktop_usage.returned_second_day_smoothed})/${q7_dev_desktop_usage.returned_second_day_smoothed}"
label: returned_second_day
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: returned_second_day
_type_hint: number
- category: table_calculation
expression: "(${dev_desktop_usage.retained_week4_smoothed} - ${q7_dev_desktop_usage.retained_week4_smoothed})/${q7_dev_desktop_usage.retained_week4_smoothed}"
label: retained_week4
value_format:
value_format_name: percent_1
_kind_hint: measure
table_calculation: retained_week4
_type_hint: number
listen:
- Analysis Period: dev_desktop_session.analysis_period
Countries: dev_desktop_session.normalized_country_code_subset
Include Dates Where: dev_desktop_session.week4_reported_date_described
- Analysis Period: dev_desktop_session.analysis_period
Countries: dev_desktop_session.normalized_country_code_subset
Include Dates Where: dev_desktop_session.week4_reported_date_described
- Analysis Period: dev_desktop_install.analysis_period
Countries: dev_desktop_install.normalized_country_code_subset
Include Dates Where: dev_desktop_install.week4_reported_date_described
- Analysis Period: dev_desktop_install.analysis_period
Countries: dev_desktop_install.normalized_country_code_subset
Include Dates Where: dev_desktop_install.week4_reported_date_described
- Analysis Period: dev_desktop_new_profiles.analysis_period
Countries: dev_desktop_new_profiles.normalized_country_code_subset
Include Dates Where: dev_desktop_new_profiles.week4_reported_date_described
- Analysis Period: dev_desktop_new_profiles.analysis_period
Countries: dev_desktop_new_profiles.normalized_country_code_subset
Include Dates Where: dev_desktop_new_profiles.week4_reported_date_described
- Analysis Period: dev_desktop_usage.analysis_period
Countries: dev_desktop_usage.normalized_country_code_subset
- Analysis Period: dev_desktop_usage.analysis_period
Countries: dev_desktop_usage.normalized_country_code_subset
row: 21
col: 15
width: 9
height: 8
filters:
- name: Analysis Period
title: Analysis Period
type: field_filter
default_value: 90 day
allow_multiple_values: true
required: true
ui_config:
type: relative_timeframes
display: inline
options: []
model: duet
explore: dev_desktop_session
listens_to_filters: []
field: dev_desktop_session.analysis_period
- name: Countries
title: Countries
type: field_filter
default_value: US,GB,DE,FR,CA,BR,MX,CN,IN,AU,NL,ES,RU,ROW
allow_multiple_values: true
required: false
ui_config:
type: tag_list
display: popover
options:
- US
- GB
- DE
- FR
- CA
- BR
- MX
- CN
- IN
- AU
- NL
- ES
- RU
- ROW
model: duet
explore: dev_desktop_install
listens_to_filters: []
field: dev_desktop_install.normalized_country_code_subset
- name: Include Dates Where
title: Include Dates Where
type: field_filter
default_value: data complete
allow_multiple_values: true
required: false
ui_config:
type: checkboxes
display: inline
options:
- data complete
- awaiting wk4 results
model: duet
explore: dev_desktop_session
listens_to_filters: []
field: dev_desktop_session.week4_reported_date_described