Country Dimension

[Devin Wyngard]

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]

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]

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]

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

  origin = 'https://developers.google.com'

ORDER BY

  country_code,

  device

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

[Rick Viscomi]

Let's try the image again:

[Ajay Solleti]

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]

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]

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]

+1 for supporting country dimension in the CrUX API

[Rick Viscomi]

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]

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]

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]

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]

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]

+1 for adding the country dimension to the CRuX API

[Jens Oliver Meiert]

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.