Creating a top sites list

[Vladimir Prelovac]

I am looking for a query to produce the list of top sites by traffic similar to Alexa top 1M list.

Thanks!

[Rick Viscomi]

Hi Vladimir,

Try something like this:

SELECT

rank,

origin

FROM

`chrome-ux-report.materialized.metrics_summary`

WHERE

date = '2022-08-01' AND

rank <= 1000000

ORDER BY

rank,

origin

Note that the rank field is experimental and at log10 granularity: top 1k, 10k, 100k, etc.

Let me know if that's what you're looking for.

Rick

On Fri, Sep 23, 2022 at 7:09 PM Vladimir Prelovac <vpre...@gmail.com> wrote:

I am looking for a query to produce the list of top sites by traffic similar to Alexa top 1M list.

Thanks!

--
You received this message because you are subscribed to the Google Groups "Chrome UX Report (Discussions)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chrome-ux-repo...@chromium.org.
To view this discussion on the web visit https://groups.google.com/a/chromium.org/d/msgid/chrome-ux-report/2c75bf08-a121-46ec-a71a-0d5919f6023en%40chromium.org.

[Vladimir Prelovac]

Thanks but it is not.

I am expecting to see a list like

google.com

youtube.com

netflix.com

...

so sorted in real popularity (traffic/visits) terms. Not sure if Crux has data at this level of granularity?

[Rick Viscomi]

Ah, no CrUX doesn't provide an exact ranking of sites relative to each other, only these coarse buckets of ranks, with the smallest being the top 1k.