Adoption Report

[maceto]

Could you describe the origin/source of this data?

[
	{
		date: '2020-01-01',
		technology: 'Wordpress',
		adoption: {
			mobile: 10,
			desktop: 10,
			across_dataset: 20,
		},
	}
]

The goal is to create a script to query this data from BQ transform and save it in Firestore.

[rviscomi]

Query

CREATE TEMPORARY FUNCTION GET_ADOPTION(
  records ARRAY<STRUCT<
      client STRING,
      origins INT64
  >>
) RETURNS STRUCT<
  desktop INT64,
  mobile INT64
> LANGUAGE js AS '''
return Object.fromEntries(records.map(({client, origins}) => {
  return [client, origins];
}));
''';

SELECT
  date,
  app AS technology,
  rank,
  geo,
  GET_ADOPTION(ARRAY_AGG(STRUCT(
    client,
    origins
  ))) AS adoption
FROM
  `httparchive.core_web_vitals.technologies`
WHERE
  date = '2023-07-01'
GROUP BY
  date,
  app,
  rank,
  geo

Example record

{
  "date": "2023-07-01",
  "technology": "WordPress",
  "rank": "ALL",
  "geo": "ALL",
  "adoption": {
    "desktop": "2040628",
    "mobile": "3422903"
  }
}

[maceto]

@rviscomi, should we have any mandatory param for this endpoint?

[rviscomi]

Maybe just:

• technology
• rank
• geo

@sarahfossheim WDYT?

[maceto]

Example of how to consume this endpoint

curl --request GET \
  --url 'https://dev-gw-2vzgiib6.ue.gateway.dev/v1/adoption?geo=Mexico&technology=["Blueshift","GoCache"]&rank=ALL'

[rviscomi]

Per our chat, try reformatting in the Python to this structure:

{
  "Blueshift": [{"date": ...}],
  "GoCache": []
}

[maceto]

@rviscomi @sarahfossheim, all the changes discussed are already deployed.

New URL https://dev-gw-2vzgiib6.uk.gateway.dev/v1/adoption

Documentation: https://github.com/HTTPArchive/tech-report-apis#get-adoption