Third-party 2024 queries

[Yash-Vekaria]

Analysis plan details

Queries

Third-party queries migrated from 2022:

• [x] a11y_overall_tech_usage_by_rank.sql
• [x] a11y_technology_usage.sql
• [x] a11y_technology_usage_by_rank.sql
• [x] compressed_images_by_3p.sql
• [x] content_encoding.sql
• [x] content_encoding_by_content_type.sql
• [x] csp_allowed_host_frequency.sql
• [x] distribution_of_3XX_response_body_size.sql
• [x] distribution_of_lighthouse_unminified_css_by_3p.sql
• [x] distribution_of_lighthouse_unminified_js_by_3p.sql
• [x] distribution_of_lighthouse_unused_css_by_3p.sql
• [x] distribution_of_lighthouse_unused_js_by_3p.sql
• [x] distribution_of_lighthouse_uses_optimized_images_by_3p.sql
• [x] distribution_of_size_and_time_by_third_parties.sql
• [x] distribution_of_third_parties_by_number_of_websites.sql
• [x] distribution_of_websites_by_number_of_third_parties.sql
• [x] distribution_of_websites_by_number_of_third_party_providers.sql
• [x] iframe_allow_attribute.sql
• [x] iframe_attribute_popular_hosts.sql
• [x] lighthouse_average_unminified_css_by_3p.sql
• [x] lighthouse_average_unminified_js_by_3p.sql
• [x] lighthouse_third_party_facades.sql
• [x] lighthouse_unminified_css_by_3p.sql
• [x] lighthouse_unminified_js_by_3p.sql
• [x] lighthouse_unminified_js_by_3p_by_url.sql
• [x] lighthouse_unminified_uses_optimized_images_by_3p.sql
• [x] lighthouse_unused_css_bytes_by_3p.sql
• [x] lighthouse_unused_js_bytes_by_3p.sql
• [x] number_of_third_parties_by_rank.sql
• [x] number_of_third_parties_by_rank_and_category.sql
• [x] number_of_third_party_providers_by_rank.sql
• [x] number_of_third_party_requests_by_rank.sql
• [x] number_of_third_party_providers_by_rank_and_category.sql
• [x] percent_of_third_parties_by_content_type.sql
• [x] percent_of_third_parties_using_document_write.sql
• [x] percent_of_third_parties_using_legacy_javascript.sql
• [x] percent_of_third_parties_using_legacy_javascript_by_url.sql
• [x] ~~percent_of_third_parties_using_unload_listener.sql~~ (Doesn't generate output)
• [x] percent_of_third_party_cache.sql
• [x] percent_of_third_party_requests_and_bytes_by_category_and_content_type.sql
• [x] percent_of_third_party_with_security_headers.sql
• [x] percent_of_websites_with_third_party.sql
• [x] percent_of_websites_with_third_party_by_ranking.sql
• [x] scripts_using_async_defer.sql
• [x] scripts_using_async_defer_by_3p.sql
• [x] tao_by_third_party.sql
• [x] third_parties_blocking_main_thread.sql
• [x] third_parties_blocking_main_thread_percentiles.sql
• [x] third_parties_blocking_main_thread_percentiles_by_host.sql
• [x] third_parties_blocking_rendering.sql
• [x] third_parties_blocking_rendering_percentiles.sql
• [x] third_parties_using_legacy_javascript.sql
• [x] top100_third_parties_by_median_body_size_and_time.sql
• [x] top100_third_parties_by_number_of_websites.sql
• [x] ~~trends_content_encoding.sql~~ (Difficult to port)
• [x] ~~trends_content_encoding_by_type.sql~~ (Difficult to port)
• [x] ~~trends_of_third_parties_using_legacy_javascript_by_url.sql~~ (Difficult to port)
• [x] usage_of_lite_youtube_embed.sql
• [x] usage_of_partytown.sql

New queries added for this year's chapter

• [x] distribution_of_third_parties_by_frame.sql
• [x] top20_third_parties_by_client_and_frame_location.sql