duet/mr1DEVELOPMENT/dashboards/desktop_mozorg_funnel_mac.dashboard.lookml (653 lines of code) (raw):

--- - dashboard: desktop_moz_org_funnel_mac title: Desktop Moz.org Funnel (Mac) layout: newspaper preferred_viewer: dashboards-next description: '' preferred_slug: cSbF2kH9JVJMa9PnKY5If6 elements: - name: '' type: text title_text: '' subtitle_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; 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; border: 1px solid white; 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: desktop_funnels_dates type: single_value fields: [desktop_funnels_dates.max_date, desktop_funnels_dates.min_date] filters: desktop_funnels_dates.submission_date: after 2024/03/01 limit: 500 column_limit: 50 dynamic_fields: - category: table_calculation expression: "concat(\nto_string(${desktop_funnels_dates.min_date}), \n \" to\ \ \" ,\nto_string(${desktop_funnels_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: [desktop_funnels_dates.max_date, desktop_funnels_dates.min_date] note_state: collapsed note_display: hover note_text: MacOS funnel data only available starting March 1st 2024 listen: Analysis Period: desktop_funnels_dates.analysis_period row: 2 col: 0 width: 15 height: 2 - title: Days Reporting name: Days Reporting model: duet explore: desktop_funnels_dates type: single_value fields: [desktop_funnels_dates.days] filters: desktop_funnels_dates.submission_date: after 2024/03/01 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 defaults_version: 1 note_state: collapsed note_display: hover note_text: MacOS funnel data only available starting March 1st 2024 listen: Analysis Period: desktop_funnels_dates.analysis_period row: 2 col: 15 width: 9 height: 2 - title: Non Fx Sessions name: Non Fx Sessions model: duet explore: desktop_funnels_web type: single_value fields: [desktop_funnels_web.non_fx_sessions] filters: desktop_funnels_web.funnel_derived: mozorg mac funnel desktop_funnels_web.submission_date: after 2024/03/01 limit: 500 column_limit: 50 dynamic_fields: - category: table_calculation expression: "(${desktop_funnels_web.non_fx_sessions} - ${desktop_funnels_web.non_fx_sessions_prev_year})/${desktop_funnels_web.non_fx_sessions_prev_year}" label: YOY value_format: value_format_name: percent_1 _kind_hint: measure table_calculation: yoy _type_hint: number is_disabled: true custom_color_enabled: true show_single_value_title: true show_comparison: false comparison_type: change comparison_reverse_colors: false show_comparison_label: true enable_conditional_formatting: true conditional_formatting_include_totals: false conditional_formatting_include_nulls: false 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 ''}] 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 hidden_fields: [] hidden_pivots: {} listen: Countries: desktop_funnels_web.normalized_country_code_subset Analysis Period: desktop_funnels_web.analysis_period row: 14 col: 0 width: 5 height: 4 - title: Non Fx Downloads name: Non Fx Downloads model: duet explore: desktop_funnels_web type: single_value fields: [desktop_funnels_web.non_fx_downloads] filters: desktop_funnels_web.funnel_derived: mozorg mac funnel desktop_funnels_web.submission_date: after 2024/03/01 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 defaults_version: 1 listen: Countries: desktop_funnels_web.normalized_country_code_subset Analysis Period: desktop_funnels_web.analysis_period row: 14 col: 5 width: 5 height: 4 - name: " (2)" type: text title_text: '' subtitle_text: '' body_text: Installs not measured on MacOS row: 14 col: 10 width: 5 height: 4 - title: Repeat Users name: Repeat Users model: duet explore: desktop_funnels_telemetry type: single_value fields: [desktop_funnels_telemetry.returned_second_day] filters: desktop_funnels_telemetry.funnel_derived: mozorg mac funnel desktop_funnels_telemetry.submission_date: after 2024/03/01 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 defaults_version: 1 listen: Countries: desktop_funnels_telemetry.normalized_country_code_subset Analysis Period: desktop_funnels_telemetry.analysis_period row: 19 col: 5 width: 5 height: 4 - title: New Profiles name: New Profiles model: duet explore: desktop_funnels_telemetry type: single_value fields: [desktop_funnels_telemetry.new_profiles] filters: desktop_funnels_telemetry.funnel_derived: mozorg mac funnel desktop_funnels_telemetry.submission_date: after 2024/03/01 limit: 500 column_limit: 50 dynamic_fields: - category: table_calculation expression: "(${desktop_funnels_telemetry.new_profiles} - ${desktop_funnels_telemetry.new_profiles_prev_year})\ \ / \n ${desktop_funnels_telemetry.new_profiles_prev_year}" label: YOY value_format: value_format_name: percent_1 _kind_hint: measure table_calculation: yoy _type_hint: number is_disabled: true 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 defaults_version: 1 hidden_fields: [] hidden_pivots: {} listen: Countries: desktop_funnels_telemetry.normalized_country_code_subset Analysis Period: desktop_funnels_telemetry.analysis_period row: 19 col: 0 width: 5 height: 4 - title: Week 4 Retained name: Week 4 Retained model: duet explore: desktop_funnels_telemetry type: single_value fields: [desktop_funnels_telemetry.retained_week4] filters: desktop_funnels_telemetry.funnel_derived: mozorg mac funnel desktop_funnels_telemetry.submission_date: after 2024/03/01 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 defaults_version: 1 listen: Countries: desktop_funnels_telemetry.normalized_country_code_subset Analysis Period: desktop_funnels_telemetry.analysis_period row: 19 col: 10 width: 5 height: 4 - name: Funnel Overview title: Funnel Overview merged_queries: - model: duet explore: desktop_funnels_web type: table fields: [desktop_funnels_web.non_fx_sessions, desktop_funnels_web.non_fx_downloads, desktop_funnels_web.join_field] filters: desktop_funnels_web.funnel_derived: mozorg mac funnel desktop_funnels_web.submission_date: after 2024/03/01 desktop_funnels_web.join_field: 'Yes' sorts: [desktop_funnels_web.non_fx_sessions desc] limit: 500 column_limit: 50 hidden_pivots: {} - model: duet explore: desktop_funnels_telemetry type: table fields: [desktop_funnels_telemetry.new_profiles, desktop_funnels_telemetry.returned_second_day, desktop_funnels_telemetry.retained_week4, desktop_funnels_telemetry.join_field] filters: desktop_funnels_telemetry.funnel_derived: mozorg mac funnel desktop_funnels_telemetry.submission_date: after 2024/03/01 desktop_funnels_telemetry.join_field: 'Yes' sorts: [desktop_funnels_telemetry.new_profiles desc] limit: 500 column_limit: 50 join_fields: - field_name: desktop_funnels_telemetry.join_field source_field_name: desktop_funnels_web.join_field 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 x_axis_zoom: true y_axis_zoom: true trellis: '' stacking: '' limit_displayed_rows: false legend_position: center point_style: none series_colors: desktop_funnels_web.non_fx_downloads: "#005E5D" desktop_funnels_telemetry.new_profiles: "#FF2A8A" desktop_funnels_telemetry.returned_second_day: "#FFA537" desktop_funnels_telemetry.retained_week4: "#A7341F" series_labels: desktop_funnels_telemetry.returned_second_day: Repeat Users desktop_funnels_telemetry.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 show_dropoff: true show_totals_labels: false show_silhouette: false totals_color: "#808080" type: looker_column listen: - Countries: desktop_funnels_web.normalized_country_code_subset Analysis Period: desktop_funnels_web.analysis_period - Countries: desktop_funnels_telemetry.normalized_country_code_subset Analysis Period: desktop_funnels_telemetry.analysis_period row: 4 col: 0 width: 24 height: 9 - name: Funnel Counts title: Funnel Counts merged_queries: - model: duet explore: desktop_funnels_web type: table fields: [desktop_funnels_web.submission_date, desktop_funnels_web.non_fx_sessions_smoothed, desktop_funnels_web.non_fx_downloads_smoothed] fill_fields: [desktop_funnels_web.submission_date] filters: desktop_funnels_web.funnel_derived: mozorg mac funnel sorts: [desktop_funnels_web.submission_date desc] limit: 500 column_limit: 50 hidden_pivots: {} - model: duet explore: desktop_funnels_telemetry type: table fields: [desktop_funnels_telemetry.submission_date, desktop_funnels_telemetry.new_profiles_smoothed, desktop_funnels_telemetry.returned_second_day_smoothed, desktop_funnels_telemetry.retained_week4_smoothed] fill_fields: [desktop_funnels_telemetry.submission_date] filters: desktop_funnels_telemetry.funnel_derived: mozorg mac funnel sorts: [desktop_funnels_telemetry.submission_date desc] limit: 500 column_limit: 50 join_fields: - field_name: desktop_funnels_telemetry.submission_date source_field_name: desktop_funnels_web.submission_date x_axis_gridlines: false y_axis_gridlines: true show_view_names: false y_axes: [{label: '', orientation: left, series: [{axisId: desktop_funnels_web.non_fx_sessions_smoothed, id: desktop_funnels_web.non_fx_sessions_smoothed, name: Non Fx Sessions}, {axisId: desktop_funnels_web.non_fx_downloads_smoothed, id: desktop_funnels_web.non_fx_downloads_smoothed, name: Non Fx Downloads}, {axisId: desktop_funnels_telemetry.new_profiles_smoothed, id: desktop_funnels_telemetry.new_profiles_smoothed, name: New Profiles}, {axisId: desktop_funnels_telemetry.returned_second_day_smoothed, id: desktop_funnels_telemetry.returned_second_day_smoothed, name: Repeat Users}, {axisId: desktop_funnels_telemetry.retained_week4_smoothed, id: desktop_funnels_telemetry.retained_week4_smoothed, name: Week 4 Retained}], showLabels: true, showValues: true, minValue: 0, 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 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 label_value_format: "#,###" point_style: none series_colors: desktop_funnels_web.non_fx_downloads_smoothed: "#005E5D" desktop_funnels_telemetry.new_profiles_smoothed: "#FF2A8A" desktop_funnels_telemetry.returned_second_day_smoothed: "#FFA537" desktop_funnels_telemetry.retained_week4_smoothed: "#A7341F" non_fx_downloads: "#005E5D" new_profiles: "#FF2A8A" returned_second_day: "#FFA537" retained_week4: "#A7341F" series_labels: desktop_funnels_web.non_fx_sessions_smoothed: Non Fx Sessions desktop_funnels_web.non_fx_downloads_smoothed: Non Fx Downloads desktop_funnels_telemetry.new_profiles_smoothed: New Profiles desktop_funnels_telemetry.returned_second_day_smoothed: Repeat Users desktop_funnels_telemetry.retained_week4_smoothed: Week 4 Retained non_fx_sessions: Non Fx Sessions non_fx_downloads: Non Fx Downloads 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 show_null_points: false interpolation: linear type: looker_line hidden_fields: [cutoff, desktop_funnels_web.non_fx_sessions_smoothed, desktop_funnels_web.non_fx_downloads_smoothed, desktop_funnels_telemetry.new_profiles_smoothed, desktop_funnels_telemetry.returned_second_day_smoothed, desktop_funnels_telemetry.retained_week4_smoothed] hidden_points_if_no: [cutoff] sorts: [desktop_funnels_web.submission_date] dynamic_fields: - category: table_calculation expression: ${desktop_funnels_web.submission_date} >= to_date("2024-03-01") label: cutoff value_format: value_format_name: _kind_hint: dimension table_calculation: cutoff _type_hint: yesno - category: table_calculation expression: if(${cutoff}, ${desktop_funnels_web.non_fx_sessions_smoothed}, null) label: non_fx_sessions value_format: value_format_name: decimal_0 _kind_hint: measure table_calculation: non_fx_sessions _type_hint: number - category: table_calculation expression: if(${cutoff}, ${desktop_funnels_web.non_fx_downloads_smoothed}, null) label: non_fx_downloads value_format: value_format_name: decimal_0 _kind_hint: measure table_calculation: non_fx_downloads _type_hint: number - category: table_calculation expression: if(${cutoff}, ${desktop_funnels_telemetry.new_profiles_smoothed}, null) label: new_profiles value_format: value_format_name: decimal_0 _kind_hint: measure table_calculation: new_profiles _type_hint: number - category: table_calculation expression: if(${cutoff}, ${desktop_funnels_telemetry.returned_second_day_smoothed}, null) label: returned_second_day value_format: value_format_name: decimal_0 _kind_hint: measure table_calculation: returned_second_day _type_hint: number - category: table_calculation expression: if(${cutoff}, ${desktop_funnels_telemetry.retained_week4_smoothed}, null) label: retained_week4 value_format: value_format_name: decimal_0 _kind_hint: measure table_calculation: retained_week4 _type_hint: number listen: - Countries: desktop_funnels_web.normalized_country_code_subset Analysis Period: desktop_funnels_web.analysis_period - Countries: desktop_funnels_telemetry.normalized_country_code_subset Analysis Period: desktop_funnels_telemetry.analysis_period row: 13 col: 15 width: 9 height: 10 - name: " (3)" type: text title_text: '' subtitle_text: '' body_text: '[{"type":"p","children":[{"text":"The Desktop Moz.org Mac Funnel consists of MacOS users who acquired Firefox via our website ("},{"type":"a","url":"https://www.mozilla.org/","children":[{"text":"https://www.mozilla.org/"}],"id":"r30m4"},{"text":"). Documentation is available in the "},{"type":"a","url":"https://docs.google.com/document/d/1W0FwfsaI8mO3ONuSKmoSqvwjEqiyEYTf2MIls-q9zJU/edit#heading=h.tq5vvx6c592z","children":[{"text":"Dashboard Manual: Desktop Moz.org Funnel (Mac)"}],"id":"3fa71"},{"text":". For questions, contact @shong. "}],"id":"053qw"},{"type":"p","children":[{"bold":true,"text":"Metrics"},{"text":" listed blow: "}],"id":"p2oj9"},{"type":"p","children":[{"text":"","bold":true}],"id":"8bmap"},{"type":"p","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)"}],"id":"ktk2z"},{"type":"p","children":[{"text":"New Installs","bold":true,"strikethrough":true},{"bold":true,"text":":"},{"text":" "},{"text":"Not available for MacOS","color":"hsl(0, 100%, 50%)"},{"text":" "},{"text":" New Profiles: ","bold":true},{"text":"Number of new profiles created as a result of a Firefox firstrun"}],"id":"6ldvn"},{"type":"p","children":[{"text":"Repeat Users:","bold":true},{"text":" Number of new profiles that returned for a second session within their first 28 days"}],"id":"6e7uu"},{"type":"p","children":[{"text":"Week 4 Retained: ","bold":true},{"text":"Number of new profiles that were still active 21 to 28 days after they first appeared. "}],"id":"agmup"},{"type":"p","id":"uhjyq","children":[{"text":""}]},{"type":"h3","id":"rgh0y","children":[{"text":"Important Cavets for this Dashboard: "}]},{"type":"p","children":[{"text":""}],"id":"dwgl2"},{"type":"ol","children":[{"type":"li","children":[{"type":"lic","id":"6tnsb","children":[{"text":"MacOS attribution only landed in Q1 of 2024. Therefore, all data in this dashboard is restricted to "},{"text":"after","italic":true},{"text":" March 1st 2024. "}]}],"id":"chmrk"},{"type":"li","children":[{"type":"lic","children":[{"text":"YOY numbers will not be available until Q2 of 2025. "}],"id":"r622e"}],"id":"p42bl"},{"type":"li","children":[{"type":"lic","children":[{"text":"We expect Download "},{"text":"→ New Profile conversion to be worse then Windows, and New Profile → Repeat User conversion to be better, because, unlike Windows, where Firefox automatically runs for the first time upon installation, Mac users need to personally open the newly installed browser in order to become a New Profile. ","fontSize":"10pt","backgroundColor":"transparent","color":"rgb(0, 0, 0)"}],"id":"4nsde"}],"id":"tpgxi"}],"id":"nlwoa"}]' rich_content_json: '{"format":"slate"}' row: 23 col: 0 width: 24 height: 9 - name: " (4)" type: text title_text: '' subtitle_text: '' body_text: |- <div style="background-color: #3FE1B0; height: 16px; width: 545px; display: flex; align-items: center; padding-left: 200px;"> <span style="color: white;">mozilla.org / Google Analytics</span> </div> row: 13 col: 0 width: 10 height: 1 - name: " (5)" type: text title_text: '' subtitle_text: '' body_text: |- <div style="background-color: #FF2A8A; height: 16px; width: 820px; display: flex; align-items: center; padding-left: 400px;"> <span style="color: white;">Telemetry</span> </div> row: 18 col: 0 width: 15 height: 1 - name: " (6)" type: text title_text: '' subtitle_text: '' body_text: |- <div style="background-color: black; height: 16px; width: 250px; display: flex; align-items: center; padding-left: 100px;"> <span style="color: white;">No Measurements</span> </div> row: 13 col: 10 width: 5 height: 1 filters: - name: Analysis Period title: Analysis Period type: field_filter default_value: 90 day allow_multiple_values: true required: false ui_config: type: advanced display: popover options: [] model: duet explore: desktop_funnels_dates listens_to_filters: [] field: desktop_funnels_dates.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: desktop_funnels_web listens_to_filters: [] field: desktop_funnels_web.normalized_country_code_subset