I want know about Effective Connection Type data of my website? Is it possible?

[Jitendra Vyas]

I'm talking about this

Effective Connection Type

Defined by the Network Information API and available in Chrome M62+:

“Provides the effective connection type (“slow-2g”, “2g”, “3g”, “4g”, or “offline”) as determined by round-trip and bandwidth values based on real user measurement observations.”

https://developers.google.com/web/tools/chrome-user-experience-report/

[Rick Viscomi]

Yes, you can use a query like this to get the total densities of each effective connection type:

#standardSQL

SELECT

  effective_connection_type.name AS ect,

  ROUND(SUM(bin.density), 4) AS density

FROM

  `chrome-ux-report.all.201711`,

  UNNEST(first_contentful_paint.histogram.bin) AS bin

WHERE

  origin = 'https://news.ycombinator.com'

GROUP BY

  ect

You can run the query here. The example was taken from this blog post.

Hope that helps!

Rick

[Jitendra Vyas]

Thanks. I rant it and it worked and I got this

Row	ect	density
1	4G	0.905
2	3G	0.2945

But I don't know what does it tell. How to interpert it to make sense of it?

What I wanted to know that, In total how many times (since it was launched)  my website have been accessd on 4G vs 3G.

[Rick Viscomi]

Those results look off to me. The density values should sum to 1.0 Would you mind sharing your query?

Anyway, the results are saying that 90.5% of page views to the origin had an effective connection type of 4G, while 29.45% had 3G. It doesn't make sense to me because their combined density exceeds 100%.

[Rick Viscomi]

Also, I should note that the Chrome UX Report only gives relative proportions of densities (eg 90%) as opposed to absolute values (eg 25,000). Additionally, you mention "since it was launched", but this data is only collected on a monthly basis. For example, the 201711 table only contains data for November 2017.

[Jitendra Vyas]

Sorry the number of results I had modified thinking I might not have permission to share it publically. Now I think there is nothing wrong or secert in it because I guess anyone can ran query on any url.

Actual query I ran was this

#standardSQL
SELECT
  effective_connection_type.name AS ect,
  ROUND(SUM(bin.density), 4) AS density
FROM
  `chrome-ux-report.all.201711`,
  UNNEST(first_contentful_paint.histogram.bin)

AS bin
WHERE
  origin = 'https://vwo.com'
GROUP BY
  ect

[Rick Viscomi]

Ah ok thanks. Yeah the results look normal to me:

80% 4G and 20% 3G

--
You received this message because you are subscribed to the Google Groups "chrome-ux-report" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chrome-ux-report+unsubscribe@chromium.org.
To post to this group, send email to chrome-u...@chromium.org.
To view this discussion on the web visit https://groups.google.com/a/chromium.org/d/msgid/chrome-ux-report/cefdcbeb-cb78-402b-b7dd-96efdee89f4b%40chromium.org.

[Jitendra Vyas]

So does it mean that

In November 2011 my website got 80% traffic from 4G and 20% 3G from all mobile users? If a user came from laptop but he/she was using data via mobile hotspot included in it too?

Is non mobile data traffic excluded from it?

To unsubscribe from this group and stop receiving emails from it, send an email to chrome-ux-repo...@chromium.org.

To post to this group, send email to chrome-u...@chromium.org.

[Rick Viscomi]

So 4G is an "effective connection type", which in this case means "connections over 4G-like speeds". Not necessarily over a literal 4G network like a cell phone. So this data encompasses all device types. If needed, the data could also be split by desktop/phone/tablet to get an idea of those speeds individually.

Hope that helps.

[Jitendra Vyas]

OK. Is this data (traffic) only from Google Chrome stable version of all OS (Mac, Windows, iOS, Android) or all versions (Canary, Beta) ? and does it also includes data from all chromium/webkit based browser?

[Bryan McQuade]

The data is collected from a subset of Chrome users as described here: https://developers.google.com/web/tools/chrome-user-experience-report/

It includes all Chrome platforms except iOS, and all channels (Stable/Beta/Dev/Canary).

No data is collected from other chromium/webkit browsers, only Chrome.

Thanks,
Bryan