almanac.httparchive.org icon indicating copy to clipboard operation
almanac.httparchive.org copied to clipboard

Published 20 hours ago • verified publisher icon HTTPArchive

Ecommerce 2022 queries

Open jrharalson opened this issue 3 years ago • 7 comments
trafficstars

Progress on #2897

eComm Platforms

  • [x] Top platforms - top_vendors.sql
  • [x] Top platforms growth - pct_ecommsites_bydevice_compare20202122.sql
  • [x] Top platforms by 1M, 100k, 10k - top_vendors_crux_rank.sql
  • [x] Top Enterprise targetted platforms - top_vendors.sql filtered

Growth trends - overall

  • [x] eComm growth - ecomm_growth.sql
  • [x] platform growth - ecomm_vendors_growth.sql

Server Stack

  • [x] CDN Provider - top_cdn_bydevice_vendor_cdn.sql top_cdn_bydevice_vendor_wapp.sql

Frontend Tech

  • [x] JS Frameworks - top_jslibs_by_device.sql
  • [x] JS Libraries - top_jsframework_providers_by_device.sql

User Experience

  • [x] CWV - Platform - Passing grade 10k vs 100k vendor - core_web_vitals_passingmetrics_byvendor_bydevice.sql
  • [x] CWV - Top x Platforms - CLS, FCP, LCP, FID, TTFB - core_web_vitals_distribution_byvendor_bydevice.sql
  • [x] Lighthouse - Top x Platforms - 5 scores - median_lighthouse_score_ecommsites.sql

Page Anatomy

  • [x] Page Reqs and Weight - pagestats_percentiles_bydevice.sql
  • [x] Page Weight - HTML payload - pagestats_html_bydevice.sql
  • [x] Page Reqs and Weight - images - pagestats_image_bydevice.sql
  • [x] Page Weight - 3rd party domain reqs and weight - pct_3pusage_bydevice.sql

Tools and Misc

  • [x] Analytics usage - top_analytics_providers_bydevice_wapp.sql
  • [x] Tag Manager usage - percent_of_ecommsites_using_each_tag_managers.sql
  • [x] AMP usage - pct_ampusage_bydevice_vendor.sql
  • [x] Consent Management usage - percent_of_ecommsites_using_cmp.sql
  • [x] CSP usage - review latest security query
  • [x] Web Push usage - webpushstats_ecommsites.sql

jrharalson avatar Jun 06 '22 15:06 jrharalson

Thanks for starting this @jrharalson. Could you update this PR to use similar formatting as https://github.com/HTTPArchive/almanac.httparchive.org/pull/2937 in terms of having a trackable metric checklist in the PR description itself?

rviscomi avatar Jun 06 '22 15:06 rviscomi

@jrharalson did you see @rviscomi 's comment above about tracking the list in this PR, instead of in the README?

This makes it easier for us to see the progress as they are ticked off. It will also allow @amandeepsinghvirdi to tick off Milestone 2 in #2897 - gotta love ticking off milestones! 😁

tunetheweb avatar Jun 10 '22 11:06 tunetheweb

Hey @jrharalson how's this going? Have you finished all your edits and is this good to review now so we can merge and run?

Could you tick off the queries you think are good to go in first comment?

tunetheweb avatar Jul 15 '22 15:07 tunetheweb

Hi @tunetheweb - Took a hot minute - buried with several huge client platform migrations. All sqls should be set. Added extracted data in the XLS worksheet.

@rviscomi Any chance I gain access to 2021 XLS worksheet?

jrharalson avatar Jul 19 '22 02:07 jrharalson

@rviscomi Any chance I gain access to 2021 XLS worksheet?

Easiest thing is to open it and request access. Rick will approve then.

tunetheweb avatar Jul 19 '22 10:07 tunetheweb

Yes, just request access

rviscomi avatar Jul 19 '22 15:07 rviscomi

How are we going on this @jrharalson ? Did you get access to the sheet? Did you see my review comment above? If that's the only thing outstanding then are you happy to accept that change and merge this PR?

tunetheweb avatar Aug 07 '22 11:08 tunetheweb

Yes, just request access

I can’t seem to find the 2021 Sheet link. Can you share and then I’ll request from there

jrharalson avatar Aug 11 '22 03:08 jrharalson

Easiest way is to see link at the bottom of the published chapter: https://almanac.httparchive.org/en/2021/ecommerce#explore-results

tunetheweb avatar Aug 11 '22 06:08 tunetheweb