Country Dimension

352 views
Skip to first unread message

Devin Wyngard

unread,
Mar 13, 2019, 2:59:55 PM3/13/19
to chrome-ux-report
I love the connector! It would be great to get a country dimension as well like BigQuery data set has. Our data outside of the US skews our performance pretty significantly and we have seperate sites for our international traffic so it isn't relevant for this origin.

Rick Viscomi

unread,
Mar 21, 2019, 12:48:36 PM3/21/19
to chrome-ux-report
Hi Devin,

Thanks for the feature suggestion! This isn't something currently on our roadmap for the CrUX Dashboard but I'd be happy to help you write a query to get this data manually, if you'd like.


Rick

Ajay Solleti

unread,
Aug 16, 2019, 3:10:15 AM8/16/19
to chrome-ux-report
Were you able to identify how to get the country?

for the metrics, I'd like to group by country. Would you have the query handy?

Rick Viscomi

unread,
Aug 16, 2019, 11:39:18 AM8/16/19
to chrome-ux-report
Sure. Using the materialized `country_summary` table, it's a relatively short query:


#standardSQL
SELECT
  *
FROM
  `chrome-ux-report.materialized.country_summary`
WHERE
  yyyymmdd = '2019-07-01' AND
ORDER BY
  country_code,
  device

You can export to sheets and generate a visualization like this:

Rick Viscomi

unread,
Aug 16, 2019, 11:41:14 AM8/16/19
to chrome-ux-report

Let's try the image again:


4kZG8VyXGzw.png

Ajay Solleti

unread,
Aug 17, 2019, 1:05:47 PM8/17/19
to chrome-ux-report
Oh WOW!!!

Thank you Rick! I was able to the get the representation wrt to FCP
I'll try for onLoad metric by running another query similar to `chrome-ux-report.materialized.country_summary` by unsetting `onload.histogram.bin`  

Thanks
Ajay

gheisse...@gmail.com

unread,
Aug 19, 2020, 11:07:12 AM8/19/20
to Chrome UX Report (Discussions)
Hi, 

I am trying to get Crux country data for a specific URL (not origin.) I think using the API https://chromeuxreport.googleapis.com I can get URL specific, but not country. Using BigQuery, I can get country data but not page specific. Is there anyway I can get country specific data for a URL and not Origin?

Rick Viscomi

unread,
Aug 19, 2020, 12:32:40 PM8/19/20
to Chrome UX Report (Discussions)
I am trying to get Crux country data for a specific URL (not origin.) I think using the API https://chromeuxreport.googleapis.com I can get URL specific, but not country. Using BigQuery, I can get country data but not page specific. Is there anyway I can get country specific data for a URL and not Origin?

The CrUX API does not currently support the country dimension, so there is not currently a way to get URL data for a particular country. I'll pass your feedback along to the CrUX API team.

Aleksey Kulikov

unread,
Aug 19, 2020, 12:34:22 PM8/19/20
to Chrome UX Report (Discussions), Rick Viscomi
+1 for supporting country dimension in the CrUX API

Rick Viscomi

unread,
Aug 19, 2020, 1:12:22 PM8/19/20
to Chrome UX Report (Discussions), rvis...@google.com
gheissenberger@ and Aleksey,

To help us prioritize this feature, is there any more context you could provide on how country-level data in the API would be useful to you?

Greta Heissenberger

unread,
Aug 19, 2020, 1:46:00 PM8/19/20
to Chrome UX Report (Discussions), Rick Viscomi
Sure, I'm trying to create a report that shows a map showing how a specific page does in various different countries. However it's looking like we will have to settle for origin. Which is okay... it's just not exactly the same data as we will be showing in the rest of the report. 

Aleksey Kulikov

unread,
Aug 21, 2020, 4:18:56 AM8/21/20
to Chrome UX Report (Discussions), gheisse...@gmail.com, Rick Viscomi
Hey Rick. We're integrating the new CrUX API for the next version of Treo Sites.
The API already provides form-factor/connection-type dimensions (which is excellent), and to **match CrUX data exactly**, it would be useful to have a country dimension. I understand that data will be sparse, but it is similar to non-frequent connection types like 3g/2g/slow-2g.

Guille Paz

unread,
Aug 22, 2020, 10:11:56 AM8/22/20
to Chrome UX Report (Discussions), alekseys...@gmail.com, gheisse...@gmail.com, Rick Viscomi
Hi! 👋

+1 for supporting country dimension in the API. I currently work at e-commerce company and we have a lot of domains, one for each country (.com.br, .com.mx, .com.ar, etc). It would really useful know the metrics fo each domain in a specific country. 

Thanks!

Rick Viscomi

unread,
Aug 25, 2020, 5:03:50 PM8/25/20
to Chrome UX Report (Discussions), alekseys...@gmail.com, gheisse...@gmail.com
Thanks for all the feedback everyone! Having this supporting information is really helpful for me to relay developer needs back to the relevant teams. Stay subscribed to the CrUX Announce group for any updates related to country support in the CrUX API.

Aaron Peters

unread,
Sep 15, 2020, 7:57:44 AM9/15/20
to Chrome UX Report (Discussions), Rick Viscomi, alekseys...@gmail.com, gheisse...@gmail.com
+1 for adding the country dimension to the CRuX API

Jens Oliver Meiert

unread,
Aug 18, 2024, 2:06:17 AMAug 18
to Chrome UX Report (Discussions), Aaron Peters, Rick Viscomi, alekseys...@gmail.com, gheisse...@gmail.com
If this is still open for feedback, another +1 to have countries (or continents!) in the CrUX API. As the API is helpful for quick checks, having this option here would be fantastic to gauge regional differences.
Reply all
Reply to author
Forward
0 new messages