Can I access to raw results of Web Almanac markup query from google BigQuery?

1

Hi,
I want to know the adoption of details, summary and dialog html elements, ideally with change over years.
And maybe it’s bit too early, but popover and invoker commands-related attributes.

I did try to create a query for this and run over google BigQuery, but it seems it’s far outside of something I can do for free.
Any way access this data without paying?
I was trying set up free tier or something but go nowhere, google demand billing and don’t accept my cards for some reason.

Regards. Anton Nemtsev.

2

Hi,

You can view the query that was used in the Web Almanac by clicking on the three dots beside any chart or table.

Screenshot of Web Almanac Markup chapter showing the table with the Top Elements and a small select with View data and View query options
Screenshot of Web Almanac Markup chapter showing the table with the Top Elements and a small select with View data and View query options810×713 41.6 KB

In the preceding screenshot, clicking View Data will take you to the Results sheet and View Query will take you to the SQL query. dialog, details, and summary are all present in the full result set.

client name pages total_pages pct_pages
mobile summary 1,065,277 30,046,933 3.5%
desktop summary 807,844 24,167,800 3.3%
mobile details 1,063,591 30,046,933 3.5%
desktop details 805,687 24,167,800 3.3%
mobile dialog 76,293 30,046,933 0.3%
desktop dialog 69,877 24,167,800 0.3%

Let me know if that helps.

3

Was it helpful you ask?
You just make my day a whole lot better!
I love you @imkevdev!
Thank you very much!

1 Like