dataops-ci-bot
commented
1 month ago Integration report for "feat: make changes to generate retention and engagement for focus and klar products also"
sql.diff
Click to expand!
```diff Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/user_characteristics: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_update/use_counters: schema.yaml Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android: engagement Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android: engagement_clients Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android: retention Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android: retention_clients Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android_derived: engagement_v1 Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android_derived: retention_v1 Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_ios: engagement Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_ios: engagement_clients Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_ios: retention Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_ios: retention_clients Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_ios_derived: engagement_v1 Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_ios_derived: retention_v1 Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android: engagement Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android: engagement_clients Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android: retention Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android: retention_clients Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android_derived: engagement_v1 Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android_derived: retention_v1 Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_ios: engagement Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_ios: engagement_clients Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_ios: retention Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_ios: retention_clients Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_ios_derived: engagement_v1 Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_ios_derived: retention_v1 Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus_beta/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus_nightly/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_klar/use_counters: schema.yaml Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/pine/use_counters: schema.yaml diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/event_monitoring_live_v1/materialized_view.sql 2024-06-03 10:44:10.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/event_monitoring_live_v1/materialized_view.sql 2024-06-03 10:46:15.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-31" + DATE(submission_timestamp) >= "2024-06-03" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/event_monitoring_live_v1/materialized_view.sql 2024-06-03 10:44:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/event_monitoring_live_v1/materialized_view.sql 2024-06-03 10:46:15.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-31" + DATE(submission_timestamp) >= "2024-06-03" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/bedrock_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/bedrock_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/bedrock_derived/event_monitoring_live_v1/materialized_view.sql 2024-06-03 10:44:10.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/bedrock_derived/event_monitoring_live_v1/materialized_view.sql 2024-06-03 10:46:16.000000000 +0000 @@ -50,7 +50,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.bedrock_live.events_v1` + `moz-fx-data-shared-prod.bedrock_live.interaction_v1` UNION ALL SELECT submission_timestamp, @@ -60,7 +60,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.bedrock_live.interaction_v1` + `moz-fx-data-shared-prod.bedrock_live.non_interaction_v1` UNION ALL SELECT submission_timestamp, @@ -70,7 +70,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.bedrock_live.non_interaction_v1` + `moz-fx-data-shared-prod.bedrock_live.events_v1` ) CROSS JOIN UNNEST(events) AS event, @@ -80,7 +80,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-31" + DATE(submission_timestamp) >= "2024-06-03" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml 2024-06-03 10:43:28.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml 2024-06-03 10:53:03.000000000 +0000 @@ -1,49 +1,49 @@ fields: -- mode: NULLABLE - name: submission_date +- name: submission_date type: DATE -- mode: NULLABLE - name: source + mode: NULLABLE +- name: source type: STRING -- mode: NULLABLE - name: event_type + mode: NULLABLE +- name: event_type type: STRING -- mode: NULLABLE - name: form_factor + mode: NULLABLE +- name: form_factor type: STRING -- mode: NULLABLE - name: country + mode: NULLABLE +- name: country type: STRING -- mode: NULLABLE - name: subdivision1 + mode: NULLABLE +- name: subdivision1 type: STRING -- mode: NULLABLE - name: advertiser + mode: NULLABLE +- name: advertiser type: STRING -- mode: NULLABLE - name: release_channel + mode: NULLABLE +- name: release_channel type: STRING -- mode: NULLABLE - name: position + mode: NULLABLE +- name: position type: INTEGER -- mode: NULLABLE - name: provider + mode: NULLABLE +- name: provider type: STRING -- mode: NULLABLE - name: match_type + mode: NULLABLE +- name: match_type type: STRING -- mode: NULLABLE - name: normalized_os + mode: NULLABLE +- name: normalized_os type: STRING -- mode: NULLABLE - name: suggest_data_sharing_enabled + mode: NULLABLE +- name: suggest_data_sharing_enabled type: BOOLEAN -- mode: NULLABLE - name: event_count + mode: NULLABLE +- name: event_count type: INTEGER -- mode: NULLABLE - name: user_count + mode: NULLABLE +- name: user_count type: INTEGER -- mode: NULLABLE - name: query_type + mode: NULLABLE +- name: query_type type: STRING + mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml 2024-06-03 10:43:28.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml 2024-06-03 10:53:03.000000000 +0000 @@ -1,40 +1,40 @@ fields: -- mode: NULLABLE - name: submission_date +- name: submission_date type: DATE -- mode: NULLABLE - name: form_factor + mode: NULLABLE +- name: form_factor type: STRING -- mode: NULLABLE - name: country + mode: NULLABLE +- name: country type: STRING -- mode: NULLABLE - name: advertiser + mode: NULLABLE +- name: advertiser type: STRING -- mode: NULLABLE - name: normalized_os + mode: NULLABLE +- name: normalized_os type: STRING -- mode: NULLABLE - name: release_channel + mode: NULLABLE +- name: release_channel type: STRING -- mode: NULLABLE - name: position + mode: NULLABLE +- name: position type: INTEGER -- mode: NULLABLE - name: provider + mode: NULLABLE +- name: provider type: STRING -- mode: NULLABLE - name: match_type + mode: NULLABLE +- name: match_type type: STRING -- mode: NULLABLE - name: suggest_data_sharing_enabled + mode: NULLABLE +- name: suggest_data_sharing_enabled type: BOOLEAN -- mode: NULLABLE - name: impression_count + mode: NULLABLE +- name: impression_count type: INTEGER -- mode: NULLABLE - name: click_count + mode: NULLABLE +- name: click_count type: INTEGER -- mode: NULLABLE - name: query_type + mode: NULLABLE +- name: query_type type: STRING + mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/debug_ping_view_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/debug_ping_view_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/debug_ping_view_derived/event_monitoring_live_v1/materialized_view.sql 2024-06-03 10:44:10.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/debug_ping_view_derived/event_monitoring_live_v1/materialized_view.sql 2024-06-03 10:46:16.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-31" + DATE(submission_timestamp) >= "2024-06-03" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/engagement_clients/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/engagement_clients/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/engagement_clients/view.sql 2024-06-03 10:44:09.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/engagement_clients/view.sql 2024-06-03 10:46:14.000000000 +0000 @@ -26,19 +26,19 @@ client_id, sample_id, channel AS normalized_channel, + NULLIF(play_store_attribution_campaign, "") AS play_store_attribution_campaign, + NULLIF(play_store_attribution_medium, "") AS play_store_attribution_medium, + NULLIF(play_store_attribution_source, "") AS play_store_attribution_source, + NULLIF(meta_attribution_app, "") AS meta_attribution_app, + NULLIF(install_source, "") AS install_source, NULLIF(adjust_ad_group, "") AS adjust_ad_group, - NULLIF(adjust_creative, "") AS adjust_creative, - NULLIF(adjust_network, "") AS adjust_network, CASE WHEN adjust_network IN ('Google Organic Search', 'Organic') THEN 'Organic' ELSE NULLIF(adjust_campaign, "") END AS adjust_campaign, - NULLIF(play_store_attribution_campaign, "") AS play_store_attribution_campaign, - NULLIF(play_store_attribution_medium, "") AS play_store_attribution_medium, - NULLIF(play_store_attribution_source, "") AS play_store_attribution_source, - NULLIF(meta_attribution_app, "") AS meta_attribution_app, - NULLIF(install_source, "") AS install_source, + NULLIF(adjust_creative, "") AS adjust_creative, + NULLIF(adjust_network, "") AS adjust_network, FROM `moz-fx-data-shared-prod.fenix_derived.firefox_android_clients_v1` ) @@ -57,15 +57,15 @@ is_wau, is_mau, is_mobile, - attribution.adjust_ad_group, - attribution.adjust_campaign, - attribution.adjust_creative, - attribution.adjust_network, attribution.play_store_attribution_campaign, attribution.play_store_attribution_medium, attribution.play_store_attribution_source, attribution.meta_attribution_app, attribution.install_source, + attribution.adjust_ad_group, + attribution.adjust_campaign, + attribution.adjust_creative, + attribution.adjust_network, CASE WHEN active_users.submission_date = first_seen_date THEN 'new_profile' diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml 2024-06-03 10:43:28.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml 2024-06-03 10:52:28.000000000 +0000 @@ -26,6 +26,9 @@ - name: adjust_network type: STRING mode: NULLABLE +- name: install_source + type: STRING + mode: NULLABLE - name: retained_week_2 type: BOOLEAN mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml 2024-06-03 10:43:28.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml 2024-06-03 10:52:28.000000000 +0000 @@ -48,6 +48,10 @@ description: 'The type of source of a client installation. ' +- name: install_source + type: STRING + mode: NULLABLE + description: null - name: new_profiles type: INTEGER mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/retention_clients/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/retention_clients/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/retention_clients/view.sql 2024-06-03 10:44:09.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/retention_clients/view.sql 2024-06-03 10:46:14.000000000 +0000 @@ -22,19 +22,19 @@ client_id, sample_id, channel AS normalized_channel, + NULLIF(play_store_attribution_campaign, "") AS play_store_attribution_campaign, + NULLIF(play_store_attribution_medium, "") AS play_store_attribution_medium, + NULLIF(play_store_attribution_source, "") AS play_store_attribution_source, + NULLIF(meta_attribution_app, "") AS meta_attribution_app, + NULLIF(install_source, "") AS install_source, NULLIF(adjust_ad_group, "") AS adjust_ad_group, - NULLIF(adjust_creative, "") AS adjust_creative, - NULLIF(adjust_network, "") AS adjust_network, CASE WHEN adjust_network IN ('Google Organic Search', 'Organic') THEN 'Organic' ELSE NULLIF(adjust_campaign, "") END AS adjust_campaign, - NULLIF(play_store_attribution_campaign, "") AS play_store_attribution_campaign, - NULLIF(play_store_attribution_medium, "") AS play_store_attribution_medium, - NULLIF(play_store_attribution_source, "") AS play_store_attribution_source, - NULLIF(meta_attribution_app, "") AS meta_attribution_app, - NULLIF(install_source, "") AS install_source, + NULLIF(adjust_creative, "") AS adjust_creative, + NULLIF(adjust_network, "") AS adjust_network, FROM `moz-fx-data-shared-prod.fenix_derived.firefox_android_clients_v1` ) @@ -56,6 +56,10 @@ attribution.play_store_attribution_source, attribution.meta_attribution_app, attribution.install_source, + attribution.adjust_ad_group, + attribution.adjust_campaign, + attribution.adjust_creative, + attribution.adjust_network, -- ping sent retention active_users.retention_seen.day_27.active_on_metric_date AS ping_sent_metric_date, ( @@ -79,10 +83,6 @@ -- Looking back at 27 days to support the official definition of repeat_profile (someone active between days 2 and 28): AND BIT_COUNT(mozfun.bits28.range(active_users.days_active_bits, -26, 27)) > 0 ) AS repeat_profile, - attribution.adjust_ad_group, - attribution.adjust_campaign, - attribution.adjust_creative, - attribution.adjust_network, active_users.days_seen_bits, active_users.days_active_bits, CASE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/engagement_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/engagement_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/engagement_v1/query.sql 2024-06-03 10:44:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/engagement_v1/query.sql 2024-06-03 10:46:14.000000000 +0000 @@ -8,15 +8,15 @@ country, locale, is_mobile, - adjust_ad_group, - adjust_campaign, - adjust_creative, - adjust_network, play_store_attribution_campaign, play_store_attribution_medium, play_store_attribution_source, meta_attribution_app, install_source, + adjust_ad_group, + adjust_campaign, + adjust_creative, + adjust_network, COUNTIF(is_dau) AS dau, COUNTIF(is_wau) AS wau, COUNTIF(is_mau) AS mau @@ -33,12 +33,12 @@ country, locale, is_mobile, - adjust_ad_group, - adjust_campaign, - adjust_creative, - adjust_network, play_store_attribution_campaign, play_store_attribution_medium, play_store_attribution_source, meta_attribution_app, - install_source + install_source, + adjust_ad_group, + adjust_campaign, + adjust_creative, + adjust_network diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/engagement_v1/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/engagement_v1/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/engagement_v1/schema.yaml 2024-06-03 10:44:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/engagement_v1/schema.yaml 2024-06-03 10:46:14.000000000 +0000 @@ -39,50 +39,50 @@ mode: NULLABLE description: Indicates if this specific entry is used towards calculating mobile DAU. -- name: adjust_ad_group +- name: play_store_attribution_campaign type: STRING mode: NULLABLE - description: Adjust Ad Group the profile is attributed to. + description: Play store campaign the profile is attributed to. -- name: adjust_campaign +- name: play_store_attribution_medium type: STRING mode: NULLABLE - description: Adjust Campaign the profile is attributed to. + description: Play store Medium the profile is attributed to. -- name: adjust_creative +- name: play_store_attribution_source type: STRING mode: NULLABLE - description: Adjust Creative the profile is attributed to. + description: Play store source the profile is attributed to. -- name: adjust_network +- name: meta_attribution_app type: STRING mode: NULLABLE - description: Adjust Network the profile is attributed to. + description: Facebook app linked to paid marketing. -- name: play_store_attribution_campaign +- name: install_source type: STRING mode: NULLABLE - description: Play store campaign the profile is attributed to. + description: The source of a profile installation. -- name: play_store_attribution_medium +- name: adjust_ad_group type: STRING mode: NULLABLE - description: Play store Medium the profile is attributed to. + description: Adjust Ad Group the profile is attributed to. -- name: play_store_attribution_source +- name: adjust_campaign type: STRING mode: NULLABLE - description: Play store source the profile is attributed to. + description: Adjust Campaign the profile is attributed to. -- name: meta_attribution_app +- name: adjust_creative type: STRING mode: NULLABLE - description: Facebook app linked to paid marketing. + description: Adjust Creative the profile is attributed to. -- name: install_source +- name: adjust_network type: STRING mode: NULLABLE - description: The source of a profile installation. + description: Adjust Network the profile is attributed to. - name: dau type: INTEGER diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/retention_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/retention_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/retention_v1/query.sql 2024-06-03 10:44:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/retention_v1/query.sql 2024-06-03 10:46:14.000000000 +0000 @@ -8,15 +8,15 @@ app_version, locale, is_mobile, - adjust_ad_group, - adjust_campaign, - adjust_creative, - adjust_network, play_store_attribution_campaign, play_store_attribution_medium, play_store_attribution_source, meta_attribution_app, install_source, + adjust_ad_group, + adjust_campaign, + adjust_creative, + adjust_network, COUNTIF(ping_sent_metric_date) AS ping_sent_metric_date, COUNTIF(ping_sent_week_4) AS ping_sent_week_4, COUNTIF(active_metric_date) AS active_metric_date, @@ -38,12 +38,12 @@ app_version, locale, is_mobile, - adjust_ad_group, - adjust_campaign, - adjust_creative, - adjust_network, play_store_attribution_campaign, play_store_attribution_medium, play_store_attribution_source, meta_attribution_app, - install_source + install_source, + adjust_ad_group, + adjust_campaign, + adjust_creative, + adjust_network diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/retention_v1/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/retention_v1/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/retention_v1/schema.yaml 2024-06-03 10:44:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix_derived/retention_v1/schema.yaml 2024-06-03 10:46:14.000000000 +0000 @@ -1,5 +1,4 @@ fields: - - mode: NULLABLE name: metric_date type: DATE @@ -40,50 +39,50 @@ mode: NULLABLE description: Indicates if this specific entry is used towards calculating mobile DAU. -- name: adjust_ad_group +- name: play_store_attribution_campaign type: STRING mode: NULLABLE - description: Adjust Ad Group the profile is attributed to. + description: Play store campaign the profile is attributed to. -- name: adjust_campaign +- name: play_store_attribution_medium type: STRING mode: NULLABLE - description: Adjust Campaign the profile is attributed to. + description: Play store Medium the profile is attributed to. -- name: adjust_creative +- name: play_store_attribution_source type: STRING mode: NULLABLE - description: Adjust Creative the profile is attributed to. + description: Play store source the profile is attributed to. -- name: adjust_network +- name: meta_attribution_app type: STRING mode: NULLABLE - description: Adjust Network the profile is attributed to. + description: Facebook app linked to paid marketing. -- name: play_store_attribution_campaign +- name: install_source type: STRING mode: NULLABLE - description: Play store campaign the profile is attributed to. + description: The source of a profile installation. -- name: play_store_attribution_medium +- name: adjust_ad_group type: STRING mode: NULLABLE - description: Play store Medium the profile is attributed to. + description: Adjust Ad Group the profile is attributed to. -- name: play_store_attribution_source +- name: adjust_campaign type: STRING mode: NULLABLE - description: Play store source the profile is attributed to. + description: Adjust Campaign the profile is attributed to. -- name: meta_attribution_app +- name: adjust_creative type: STRING mode: NULLABLE - description: Facebook app linked to paid marketing. + description: Adjust Creative the profile is attributed to. -- name: install_source +- name: adjust_network type: STRING mode: NULLABLE - description: The source of a profile installation. + description: Adjust Network the profile is attributed to. - name: ping_sent_metric_date type: INTEGER diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/metrics/schema.yaml 2024-06-03 10:44:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/metrics/schema.yaml 2024-06-03 10:45:16.000000000 +0000 @@ -2538,7 +2538,7 @@ mode: NULLABLE description: 'Counts how often we purge trackers. Giving a high level overview about the effectivness of bounce tracking protection. Allows determining error - rate with failed/success label. When in dry mode, we count the purges that + rate with failure/success label. When in dry mode, we count the purges that would have happened under the dry label. ' diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/use_counters/schema.yaml 2024-06-03 10:44:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/use_counters/schema.yaml 1970-01-01 00:00:00.000000000 +0000 @@ -1,18056 +0,0 @@ -fields: -- name: additional_properties - type: STRING - mode: NULLABLE - description: A JSON string containing any payload properties not present in the - schema -- name: client_info - type: RECORD - mode: NULLABLE - fields: - - name: android_sdk_version - type: STRING - mode: NULLABLE - description: The optional Android specific SDK version of the software running - on this hardware device. - - name: app_build - type: STRING - mode: NULLABLE - description: The build identifier generated by the CI system (e.g. "1234/A"). - For language bindings that provide automatic detection for this value, (e.g. - Android/Kotlin), in the unlikely event that the build identifier can not be - retrieved from the OS, it is set to "inaccessible". For other language bindings, - if the value was not provided through configuration, this metric gets set to - `Unknown`. - - name: app_channel - type: STRING - mode: NULLABLE - description: The channel the application is being distributed on. - - name: app_display_version - type: STRING - mode: NULLABLE - description: The user visible version string (e.g. "1.0.3"). In the unlikely - event that the display version can not be retrieved, it is set to "inaccessible". - - name: architecture - type: STRING - mode: NULLABLE - description: The architecture of the device, (e.g. "arm", "x86"). - - name: build_date - type: STRING - mode: NULLABLE - description: The date & time the application was built - - name: client_id - type: STRING - mode: NULLABLE - description: A UUID uniquely identifying the client. - - name: device_manufacturer - type: STRING - mode: NULLABLE - description: The manufacturer of the device the application is running on. Not - set if the device manufacturer can't be determined (e.g. on Desktop). - - name: device_model - type: STRING - mode: NULLABLE - description: The model of the device the application is running on. On Android, - this is Build.MODEL, the user-visible marketing name, like "Pixel 2 XL". Not - set if the device model can't be determined (e.g. on Desktop). - - name: first_run_date - type: STRING - mode: NULLABLE - description: The date of the first run of the application. - - name: locale - type: STRING - mode: NULLABLE - description: The locale of the application during initialization (e.g. "es-ES"). - If the locale can't be determined on the system, the value is ["und"](https://unicode.org/reports/tr35/#Unknown_or_Invalid_Identifiers), - to indicate "undetermined". - - name: os - type: STRING - mode: NULLABLE - description: 'The name of the operating system. Possible values: Android, iOS, - Linux, Darwin, Windows, FreeBSD, NetBSD, OpenBSD, Solaris, unknown' - - name: os_version - type: STRING - mode: NULLABLE - description: The user-visible version of the operating system (e.g. "1.2.3"). - If the version detection fails, this metric gets set to `Unknown`. - - name: telemetry_sdk_build - type: STRING - mode: NULLABLE - description: The version of the Glean SDK - - name: windows_build_number - type: INTEGER - mode: NULLABLE - description: The optional Windows build number, reported by Windows (e.g. 22000) - and not set for other platforms - - name: session_count - type: INTEGER - mode: NULLABLE - description: An optional running counter of the number of sessions for a client. - - name: session_id - type: STRING - mode: NULLABLE - description: An optional UUID uniquely identifying the client's current session. -- name: document_id - type: STRING - mode: NULLABLE - description: The document ID specified in the URI when the client sent this message -- name: events - type: RECORD - mode: REPEATED - fields: - - name: category - type: STRING - mode: NULLABLE - - name: extra - type: RECORD - mode: REPEATED - fields: - - name: key - type: STRING - mode: NULLABLE - - name: value - type: STRING - mode: NULLABLE - - name: name - type: STRING - mode: NULLABLE - - name: timestamp - type: INTEGER - mode: NULLABLE -- name: metadata - type: RECORD - mode: NULLABLE - fields: - - name: geo - type: RECORD - mode: NULLABLE - fields: - - name: city - type: STRING - mode: NULLABLE - - name: country - type: STRING - mode: NULLABLE - description: An ISO 3166-1 alpha-2 country code - - name: db_version - type: STRING - mode: NULLABLE - description: The specific geo database version used for this lookup - - name: subdivision1 - type: STRING - mode: NULLABLE - description: First major country subdivision, typically a state, province, or - county - - name: subdivision2 - type: STRING - mode: NULLABLE - description: Second major country subdivision; not applicable for most countries - description: Results of a geographic lookup based on the client's IP address - - name: header - type: RECORD - mode: NULLABLE - fields: - - name: date - type: STRING - mode: NULLABLE - description: Date HTTP header - - name: dnt - type: STRING - mode: NULLABLE - description: DNT (Do Not Track) HTTP header - - name: x_debug_id - type: STRING - mode: NULLABLE - description: X-Debug-Id HTTP header - - name: x_foxsec_ip_reputation - type: STRING - mode: NULLABLE - description: X-Foxsec-IP-Reputation header - - name: x_lb_tags - type: STRING - mode: NULLABLE - description: X-LB-Tags HTTP header - - name: x_pingsender_version - type: STRING - mode: NULLABLE - description: X-PingSender-Version HTTP header - - name: x_source_tags - type: STRING - mode: NULLABLE - description: X-Source-Tags HTTP header - - name: x_telemetry_agent - type: STRING - mode: NULLABLE - description: X-Telemetry-Agent HTTP header - - name: parsed_date - type: TIMESTAMP - mode: NULLABLE - - name: parsed_x_source_tags - type: STRING - mode: REPEATED - - name: parsed_x_lb_tags - type: RECORD - mode: NULLABLE - fields: - - name: tls_version - type: STRING - mode: NULLABLE - - name: tls_cipher_hex - type: STRING - mode: NULLABLE - description: Headers included in the client's HTTP request - - name: isp - type: RECORD - mode: NULLABLE - fields: - - name: db_version - type: STRING - mode: NULLABLE - description: The specific geo ISP database version used for this lookup - - name: name - type: STRING - mode: NULLABLE - description: The name of the ISP associated with the client's IP address - - name: organization - type: STRING - mode: NULLABLE - description: The name of a specific business entity associated with the client's - IP address when available; otherwise the ISP name - description: Results of ISP lookup based on the client's IP address - - name: user_agent - type: RECORD - mode: NULLABLE - fields: - - name: browser - type: STRING - mode: NULLABLE - - name: os - type: STRING - mode: NULLABLE - - name: version - type: STRING - mode: NULLABLE - description: Parsed components of the client's user agent string -- name: metrics - type: RECORD - mode: NULLABLE - fields: - - name: counter - type: RECORD - mode: NULLABLE - fields: - - name: use_counter_content_documents_destroyed - type: INTEGER - mode: NULLABLE - description: 'A count of how many content documents were destroyed. Used to - turn document use counters'' counts into rates. Excludes documents for which - we do not count use counters (See `Document::ShouldIncludeInTelemetry`). - - ' - - name: use_counter_css_doc_alignment_baseline - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the (unknown, counted) CSS property alignment-baseline. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_background_repeat_x - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the (unknown, counted) CSS property background-repeat-x. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_background_repeat_y - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the (unknown, counted) CSS property background-repeat-y. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_baseline_shift - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the (unknown, counted) CSS property baseline-shift. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_buffered_rendering - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the (unknown, counted) CSS property buffered-rendering. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_color_rendering - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the (unknown, counted) CSS property color-rendering. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_accent_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property accent-color. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_align_content - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property align-content. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_align_items - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property align-items. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_align_self - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property align-self. Compare against - `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_align_tracks - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property align-tracks. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_all - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property all. Compare against - `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_animation - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation. Compare against - `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_animation_composition - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-composition. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_animation_delay - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-delay. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_animation_direction - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-direction. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_animation_duration - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-duration. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_animation_fill_mode - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-fill-mode. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_animation_iteration_count - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-iteration-count. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_animation_name - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-name. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_animation_play_state - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-play-state. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_animation_timeline - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-timeline. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_animation_timing_function - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property animation-timing-function. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_appearance - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property appearance. Compare against - `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_aspect_ratio - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property aspect-ratio. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_backdrop_filter - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property backdrop-filter. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_backface_visibility - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property backface-visibility. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_background - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background. Compare against - `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_background_attachment - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-attachment. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_background_blend_mode - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-blend-mode. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_background_clip - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-clip. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_background_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-color. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_background_image - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-image. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_background_origin - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-origin. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_background_position - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-position. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_background_position_x - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-position-x. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_background_position_y - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-position-y. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_background_repeat - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-repeat. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_background_size - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property background-size. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_baseline_source - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property baseline-source. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_block_size - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property block-size. Compare against - `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border. Compare against - `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_block - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_block_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-color. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_block_end - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-end. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_block_end_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-end-color. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_block_end_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-end-style. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_block_end_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-end-width. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_block_start - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-start. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_block_start_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-start-color. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_block_start_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-start-style. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_block_start_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-start-width. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_block_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-style. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_block_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-block-width. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_bottom - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-bottom. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_bottom_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-bottom-color. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_bottom_left_radius - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-bottom-left-radius. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_bottom_right_radius - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-bottom-right-radius. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_bottom_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-bottom-style. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_bottom_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-bottom-width. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_collapse - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-collapse. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-color. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_end_end_radius - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-end-end-radius. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_end_start_radius - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-end-start-radius. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_image - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-image. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_image_outset - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-image-outset. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_image_repeat - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-image-repeat. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_image_slice - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-image-slice. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_image_source - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-image-source. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_image_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-image-width. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_inline - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_inline_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-color. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_inline_end - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-end. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_inline_end_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-end-color. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_inline_end_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-end-style. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_inline_end_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-end-width. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_inline_start - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-start. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_inline_start_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-start-color. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_inline_start_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-start-style. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_inline_start_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-start-width. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_inline_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-style. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_inline_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-inline-width. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_left - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-left. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_left_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-left-color. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_left_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-left-style. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_left_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-left-width. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_radius - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-radius. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_right - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-right. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_right_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-right-color. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_right_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-right-style. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_right_width - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-right-width. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_spacing - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-spacing. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_start_end_radius - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-start-end-radius. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_start_start_radius - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-start-start-radius. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-style. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_top - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-top. Compare against - `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_top_color - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-top-color. Compare - against `use.counter.content_documents_destroyed` to calculate the rate. - - ' - - name: use_counter_css_doc_css_border_top_left_radius - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-top-left-radius. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_top_right_radius - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-top-right-radius. - Compare against `use.counter.content_documents_destroyed` to calculate the - rate. - - ' - - name: use_counter_css_doc_css_border_top_style - type: INTEGER - mode: NULLABLE - description: 'Whether a document used the CSS property border-top-style. Compare - against `use.counter.content_documents_dest ```⚠️ Only part of the diff is displayed.
feat: make changes to generate retention and engagement for focus and klar products also
The current version only generates
retentionandengagementartifacts forfirefox_iosandfenix. This change aims to introduce these artifacts to the following mobile products:klar_iosfocus_iosklar_androidfocus_androidChecklist for reviewer:
<username>:<branch>of the fork as parameter. The parameter will also show up in the logs of themanual-trigger-required-for-forkCI task together with more detailed instructions.For modifications to schemas in restricted namespaces (see
CODEOWNERS):┆Issue is synchronized with this Jira Task