Is there any way to download daily historical data about website performance (1 year period) in CSV or Excel format for different websites?

My name is Imran and I am currently in the last term of my master’s degree and writing my master’s thesis regarding website performance, SEO, and customer engagement. In terms of my thesis topic, I need the below daily historical data (1 year period, for example, the dates between 01.01.2021 - 01.01.2022) for the several websites that I am not the owner of.

  1. Page size
  2. Load time
  3. Page speed
  4. Time to First Byte (TTFB)
  5. Speed index
  6. Google desktop score
  7. Google mobile score
  8. First Contentful Paint
  9. Largest Contentful Paint
  10. Number of requests
  11. Time to Interactive
  12. Cumulative Layout Shift
  13. Total Blocking time
  14. Performance Score
  15. First Input Delay

Could you please kindly advise whether I could download daily historical data about website performance (1 year period) in CSV or Excel format in any way?

Thank you.

Hi, we have this data for millions of websites only on a monthly basis, not daily. If that’s still of use to you, I can point you in the right direction.

Hi Rick, many thanks for your comment. Yes, that would also be great to reach out to this data on a monthly basis. I would be more than happy to have your point.

Sure. What are the websites you’re interested in?

Do you mean what websites will I test for historical data? If yes, I would like to test 3 news websites and 3 university websites at first.

Hi again Rick, initial websites that I need to test are as follows:

  1. https://www.hurriyet.com.tr/
  2. https://www.milliyet.com.tr/
  3. sozcu.com.tr
  4. https://ku.edu.tr/
  5. https://www.sabanciuniv.edu/
  6. https://www.bilkent.edu.tr/

Your help is much appreciated.

Hi @imranmehmet. Here’s a query that can get you most of the stats you’re looking for. Note that running this query consumes 22.2 TB, which is well beyond the 1 TB of free monthly quota, so proceed with caution.

DECLARE URLs ARRAY<STRING> DEFAULT [
  'https://www.hurriyet.com.tr/',
  'https://www.milliyet.com.tr/',
  'https://www.sozcu.com.tr/',
  'https://www.ku.edu.tr/',
  'https://www.sabanciuniv.edu/',
  'https://www.bilkent.edu.tr/'
];

SELECT
  _TABLE_SUFFIX AS month_client,
  url,
  JSON_VALUE(payload, '$._bytesIn') AS page_size,
  JSON_VALUE(payload, '$._loadTime') AS load_time,
  NULL AS page_speed,
  JSON_VALUE(payload, '$._TTFB') AS ttfb,
  JSON_VALUE(payload, '$._SpeedIndex') AS speed_index,
  NULL AS google_score,
  JSON_VALUE(payload, '$."_chromeUserTiming.firstContentfulPaint"') AS fcp,
  JSON_VALUE(payload, '$."_chromeUserTiming.LargestContentfulPaint"') AS lcp,
  JSON_VALUE(payload, '$._requests') AS requests,
  JSON_VALUE(payload, '$._TTIMeasurementEnd') AS tti,
  JSON_VALUE(payload, '$._chromeUserTiming.CumulativeLayoutShift') AS cls,
  JSON_VALUE(payload, '$._TotalBlockingTime') AS tbt,
  NULL AS performance_score,
  NULL AS fid
FROM
  `httparchive.pages.2021_*`
WHERE
  url IN UNNEST(URLs)
ORDER BY
  month_client

There were a few fields that I left NULL because I wasn’t sure what you were looking for:

  • Page speed: is this a different metric from load_time?
  • Google [desktop, mobile] score: do you mean the Lighthouse score? Also all metrics are provided for desktop and mobile when available.
  • Performance score: do you mean the Lighthouse score?
  • FID: this metric isn’t available in the lab since we don’t simulate any clicks. We would need to query the CrUX dataset instead, but I’m not sure if that’s what you want.

Here are the results in CSV format:

month_client,url,page_size,load_time,page_speed,ttfb,speed_index,google_score,fcp,lcp,requests,tti,cls,tbt,performance_score,fid
01_01_desktop,https://www.ku.edu.tr/,4726659,10240,,1554,5837,,3397,4581,94,13038,,886,,
01_01_desktop,https://www.sabanciuniv.edu/,4280120,10622,,1467,4867,,3376,5143,144,14395,,1501,,
01_01_desktop,https://www.hurriyet.com.tr/,5447172,41903,,438,13465,,1231,3097,667,48002,,21567,,
01_01_desktop,https://www.sozcu.com.tr/,3226816,9095,,340,6842,,1897,5247,153,11702,,1658,,
01_01_desktop,https://www.milliyet.com.tr/,3565356,15849,,435,4727,,1614,2447,232,20359,,4621,,
01_01_mobile,https://www.sozcu.com.tr/,2588009,25163,,1482,11147,,4485,5901,178,34378,,2091,,
01_01_mobile,https://www.hurriyet.com.tr/,3876501,38971,,2284,6276,,5375,7375,234,50998,,6816,,
01_01_mobile,https://www.sabanciuniv.edu/,5165902,34178,,2525,9690,,6541,11791,161,45509,,2025,,
01_01_mobile,https://www.milliyet.com.tr/,2408947,26542,,3284,13244,,5123,6039,204,105130,,3881,,
01_01_mobile,https://www.ku.edu.tr/,4704397,34175,,1613,7987,,3709,5225,93,34192,,449,,
02_01_desktop,https://www.milliyet.com.tr/,3325695,17836,,326,3374,,1431,2297,246,23471,,5103,,
02_01_desktop,https://www.sabanciuniv.edu/,4366838,9544,,839,3804,,2414,4114,141,12816,,1134,,
02_01_desktop,https://www.ku.edu.tr/,4621328,9705,,636,4326,,2215,3199,71,9711,,229,,
02_01_desktop,https://www.sozcu.com.tr/,2923680,7846,,294,4601,,1515,3115,154,10327,,849,,
02_01_desktop,https://www.hurriyet.com.tr/,4881087,19235,,329,3381,,581,2914,377,27414,,8468,,
02_01_mobile,https://www.hurriyet.com.tr/,3202764,38232,,2178,6041,,5145,7192,239,48934,,6654,,
02_01_mobile,https://www.milliyet.com.tr/,2663085,32120,,3444,8376,,5406,6473,250,112316,,6472,,
02_01_mobile,https://www.sabanciuniv.edu/,4908312,31616,,2023,9479,,5758,11208,158,42430,,2179,,
02_01_mobile,https://www.sozcu.com.tr/,2376077,23513,,1497,9963,,4862,6362,148,31257,,2162,,
02_01_mobile,https://www.ku.edu.tr/,4605433,28399,,1636,11444,,3829,11229,72,28428,,326,,
03_01_desktop,https://www.hurriyet.com.tr/,5013859,14675,,559,3363,,951,2057,302,21120,,4318,,
03_01_desktop,https://www.milliyet.com.tr/,3829119,17577,,510,4324,,1624,2853,271,22752,,4912,,
03_01_desktop,https://www.ku.edu.tr/,4606229,11403,,1734,4969,,3684,5765,73,12474,,124,,
03_01_desktop,https://www.sabanciuniv.edu/,4543326,9482,,818,3022,,2255,3042,143,12809,,443,,
03_01_desktop,https://www.sozcu.com.tr/,3027434,8630,,288,5196,,1720,3638,167,11272,,1650,,
03_01_mobile,https://www.ku.edu.tr/,3212056,21111,,1575,10267,,3933,5111,72,21121,,321,,
03_01_mobile,https://www.sabanciuniv.edu/,4982970,32664,,2011,7774,,5781,7900,159,43500,,2145,,
03_01_mobile,https://www.hurriyet.com.tr/,3097691,35938,,2320,7098,,5218,6999,201,46185,,3888,,
03_01_mobile,https://www.milliyet.com.tr/,2612379,29812,,3417,12244,,5238,6243,241,120680,,4487,,
03_01_mobile,https://www.sozcu.com.tr/,2717846,26926,,1425,14788,,4453,5848,164,35151,,2015,,
04_01_desktop,https://www.hurriyet.com.tr/,4567550,16726,,489,1707,,1022,2381,251,20118,,3404,,
04_01_desktop,https://www.sozcu.com.tr/,3273797,10492,,458,6564,,2292,3539,171,13068,,1557,,
04_01_desktop,https://www.milliyet.com.tr/,3965555,15986,,454,3609,,1452,2004,254,23454,,3628,,
04_01_desktop,https://www.sabanciuniv.edu/,4015790,8931,,877,3289,,2451,3355,143,12249,,368,,
04_01_desktop,https://www.ku.edu.tr/,3295167,6503,,429,3057,,1724,3473,73,10604,,263,,
04_01_mobile,https://www.sabanciuniv.edu/,4559424,30140,,2111,9234,,5743,10734,160,40864,,1085,,
04_01_mobile,https://www.hurriyet.com.tr/,4427964,40246,,1788,5781,,3398,6743,240,53318,,4739,,
04_01_mobile,https://www.milliyet.com.tr/,2604126,36121,,2175,8381,,4354,5256,655,120427,,4333,,
04_01_mobile,https://www.ku.edu.tr/,3343999,23718,,3042,11454,,5122,7547,72,23808,,378,,
04_01_mobile,https://www.sozcu.com.tr/,3030914,27324,,1451,12456,,4585,6396,157,34983,,1741,,
05_01_desktop,https://www.sozcu.com.tr/,3175599,9329,,368,5118,,1735,2902,175,11904,,1389,,
05_01_desktop,https://www.bilkent.edu.tr/,3171884,10410,,2079,6282,,4021,7380,97,12676,,1433,,
05_01_desktop,https://www.hurriyet.com.tr/,4796414,14803,,434,5027,,874,2060,263,19570,,2947,,
05_01_desktop,https://www.milliyet.com.tr/,3471680,10686,,504,3754,,1354,2460,225,24857,,2576,,
05_01_desktop,https://www.ku.edu.tr/,3386643,8751,,1834,5061,,3734,6717,73,13009,,145,,
05_01_desktop,https://www.sabanciuniv.edu/,5570769,11596,,818,3210,,2373,4047,150,14699,,307,,
05_01_mobile,https://www.sabanciuniv.edu/,6296849,41055,,2134,10928,,5804,14933,167,51515,,1503,,
05_01_mobile,https://www.hurriyet.com.tr/,3170188,33853,,2309,4766,,4106,6007,185,44720,,3217,,
05_01_mobile,https://www.milliyet.com.tr/,2276999,27115,,2297,9142,,4344,5261,206,120260,,2381,,
05_01_mobile,https://www.bilkent.edu.tr/,2839412,29011,,5565,17163,,9472,18115,92,36783,,4046,,
05_01_mobile,https://www.ku.edu.tr/,3326655,22309,,1591,10303,,4637,8154,72,22321,,382,,
05_01_mobile,https://www.sozcu.com.tr/,2688331,26212,,1580,10661,,4691,6064,160,34056,,2063,,
06_01_desktop,https://www.sabanciuniv.edu/,4741623,10031,,829,2974,,2463,3277,147,13000,,175,,
06_01_desktop,https://www.milliyet.com.tr/,4183851,10790,,328,3113,,1152,15312,245,19479,,2290,,
06_01_desktop,https://www.bilkent.edu.tr/,2919623,11202,,2434,7450,,5309,7651,102,13583,,1117,,
06_01_desktop,https://www.sozcu.com.tr/,3391478,8085,,349,5178,,1566,2553,176,15101,,1454,,
06_01_desktop,https://www.ku.edu.tr/,3292347,6888,,404,3716,,1919,4987,74,11389,,111,,
06_01_desktop,https://www.hurriyet.com.tr/,5063672,14303,,762,3695,,1163,2953,281,17822,,2944,,
06_01_mobile,https://www.ku.edu.tr/,3232357,21935,,1638,10906,,5301,6083,73,22006,,1569,,
06_01_mobile,https://www.hurriyet.com.tr/,3769099,40291,,2384,13869,,4442,6280,210,52872,,11046,,
06_01_mobile,https://www.bilkent.edu.tr/,2751945,30865,,5611,21147,,9920,18200,98,41351,,8398,,
06_01_mobile,https://www.milliyet.com.tr/,2472318,31045,,2458,17394,,4338,6979,179,113110,,10100,,
06_01_mobile,https://www.sabanciuniv.edu/,5288774,34952,,2055,8985,,6022,8756,164,46914,,4092,,
06_01_mobile,https://www.sozcu.com.tr/,2660149,26890,,1955,12533,,5739,8246,159,38406,,5496,,
07_01_desktop,https://www.bilkent.edu.tr/,3252247,11804,,2184,10925,,4317,9771,103,16238,,1536,,
07_01_desktop,https://www.milliyet.com.tr/,3001080,11161,,469,4086,,1180,1439,221,17657,,3044,,
07_01_desktop,https://www.sabanciuniv.edu/,3986765,8699,,857,2800,,2387,2729,147,13833,,456,,
07_01_desktop,https://www.hurriyet.com.tr/,3154225,10004,,413,3467,,826,1668,242,13598,,1861,,
07_01_desktop,https://www.sozcu.com.tr/,3255963,8467,,335,5962,,1719,2743,179,13749,,719,,
07_01_desktop,https://www.ku.edu.tr/,3384298,6262,,409,2655,,1335,4104,71,7532,,229,,
07_01_mobile,https://www.sabanciuniv.edu/,5488153,35642,,1900,8611,,5765,8518,165,47229,,3422,,
07_01_mobile,https://www.ku.edu.tr/,3324383,22367,,1657,10670,,4012,5676,70,22385,,1325,,
07_01_mobile,https://www.bilkent.edu.tr/,2752005,32890,,5848,25883,,10414,21143,98,44381,,10615,,
07_01_mobile,https://www.milliyet.com.tr/,1946397,26211,,2224,26233,,4097,6714,162,111904,,7355,,
07_01_mobile,https://www.hurriyet.com.tr/,2251550,35927,,2240,19249,,4663,6907,177,52854,,12220,,
07_01_mobile,https://www.sozcu.com.tr/,2583466,28077,,1365,12868,,5137,7164,164,39361,,5359,,
08_01_desktop,https://www.hurriyet.com.tr/,3160043,12393,,369,5838,,824,1770,255,16423,,3499,,
08_01_desktop,https://www.ku.edu.tr/,3280068,6724,,673,3309,,2273,3001,71,10675,,271,,
08_01_desktop,https://www.bilkent.edu.tr/,2946900,11876,,1934,10590,,4080,7144,103,16143,,1626,,
08_01_desktop,https://www.sozcu.com.tr/,3261991,7469,,345,4350,,1180,2537,122,14384,,1262,,
08_01_desktop,https://www.sabanciuniv.edu/,4062598,9299,,889,3089,,2593,3331,143,13683,,270,,
08_01_desktop,https://www.milliyet.com.tr/,3269435,11968,,347,4869,,1969,1969,237,19840,,3146,,
08_01_mobile,https://www.sabanciuniv.edu/,5668864,38756,,2118,12195,,6378,13950,160,51084,,4815,,
08_01_mobile,https://www.bilkent.edu.tr/,2778820,35698,,5708,29067,,9953,17730,99,44657,,7165,,
08_01_mobile,https://www.ku.edu.tr/,3276839,21798,,1629,11306,,4463,6966,72,23323,,1571,,
08_01_mobile,https://www.sozcu.com.tr/,3174955,28495,,1387,18654,,4135,27146,133,39549,,4284,,
08_01_mobile,https://www.hurriyet.com.tr/,2705264,35293,,2461,19577,,4628,6351,254,65369,,11223,,
08_01_mobile,https://www.milliyet.com.tr/,1936417,26394,,2170,18770,,4033,6550,161,110048,,6952,,
09_01_desktop,https://www.sabanciuniv.edu/,5811163,12354,,864,3025,,2219,4932,147,15416,,197,,
09_01_desktop,https://www.ku.edu.tr/,3213133,6668,,429,3365,,1937,5301,71,8191,,44,,
09_01_desktop,https://www.milliyet.com.tr/,3049906,13428,,379,4761,,2086,2086,205,18728,,3673,,
09_01_desktop,https://www.bilkent.edu.tr/,2772782,10840,,2374,7332,,3662,6819,102,15260,,1711,,
09_01_desktop,https://www.sozcu.com.tr/,3481789,7206,,360,4072,,1181,2579,155,13972,,1177,,
09_01_desktop,https://www.hurriyet.com.tr/,3380558,13311,,582,5292,,942,2145,679,23257,,5246,,
09_01_mobile,https://www.ku.edu.tr/,3209890,22755,,2685,10558,,5464,8225,72,22808,,1476,,
09_01_mobile,https://www.hurriyet.com.tr/,2637992,32977,,2259,17365,,4311,6066,175,51316,,9582,,
09_01_mobile,https://www.sabanciuniv.edu/,6224402,39237,,1911,9710,,5828,17635,164,51215,,3680,,
09_01_mobile,https://www.bilkent.edu.tr/,2779828,32782,,5995,29426,,8882,17814,97,42242,,621,,
09_01_mobile,https://www.sozcu.com.tr/,3440571,29408,,1360,17869,,3907,27022,149,40725,,3513,,
09_01_mobile,https://www.milliyet.com.tr/,1992544,29016,,2433,19225,,4391,6380,174,111944,,8772,,
10_01_desktop,https://www.bilkent.edu.tr/,2463583,11138,,3133,7040,,4921,7185,100,15400,,1626,,
10_01_desktop,https://www.sabanciuniv.edu/,3992263,8994,,922,2850,,2427,2989,146,13066,,513,,
10_01_desktop,https://www.ku.edu.tr/,3167474,7652,,1539,4072,,2800,6040,71,11891,,108,,
10_01_desktop,https://www.milliyet.com.tr/,4058338,11448,,597,5840,,2996,2996,261,16283,,2458,,
10_01_desktop,https://www.hurriyet.com.tr/,2696117,9020,,427,2697,,878,1585,184,12463,,2154,,
10_01_desktop,https://www.sozcu.com.tr/,3457059,7038,,290,3670,,1002,3328,128,13699,,773,,
10_01_mobile,https://www.sabanciuniv.edu/,4883880,31807,,1960,10027,,5635,12124,165,42682,,2925,,
10_01_mobile,https://www.milliyet.com.tr/,1937556,22894,,2470,22807,,4180,6863,149,110245,,4680,,
10_01_mobile,https://www.hurriyet.com.tr/,2534265,26894,,1802,12004,,3331,5284,179,37339,,5736,,
10_01_mobile,https://www.ku.edu.tr/,3164225,20795,,1551,9902,,4117,5126,72,20807,,804,,
10_01_mobile,https://www.bilkent.edu.tr/,2563150,29333,,6168,20748,,9005,15944,96,37140,,6283,,
10_01_mobile,https://www.sozcu.com.tr/,3387018,30272,,1481,20579,,3785,27229,128,40079,,2456,,
11_01_desktop,https://www.hurriyet.com.tr/,2572401,10384,,361,4605,,1036,1388,183,13976,,2831,,
11_01_desktop,https://www.sozcu.com.tr/,2664663,7530,,362,5415,,1143,2428,117,13898,,733,,
11_01_desktop,https://www.sabanciuniv.edu/,4344324,9346,,823,2973,,2335,3123,148,14783,,538,,
11_01_desktop,https://www.milliyet.com.tr/,2736318,12477,,612,8388,,2454,2454,205,18051,,2199,,
11_01_desktop,https://www.bilkent.edu.tr/,2545446,10710,,2819,6481,,4134,6809,99,14954,,1342,,
11_01_desktop,https://www.ku.edu.tr/,3203945,6208,,708,3077,,1674,2886,70,10187,,89,,
11_01_mobile,https://www.sabanciuniv.edu/,5002261,32552,,1981,8134,,5770,8176,165,43892,,2947,,
11_01_mobile,https://www.milliyet.com.tr/,4391992,39693,,3442,22253,,11010,11010,303,83445,,9461,,
11_01_mobile,https://www.ku.edu.tr/,3200701,21487,,2416,11147,,4878,6162,71,21490,,988,,
11_01_mobile,https://www.hurriyet.com.tr/,2082955,26255,,1802,8852,,4344,7227,144,45129,,6618,,
11_01_mobile,https://www.bilkent.edu.tr/,2646577,28436,,6108,21394,,8998,17400,96,37810,,6758,,
11_01_mobile,https://www.sozcu.com.tr/,2731358,24373,,1400,17342,,3828,23562,118,33671,,3374,,
12_01_desktop,https://www.bilkent.edu.tr/,2773340,10911,,3589,8837,,4845,7956,98,16615,,1420,,
12_01_desktop,https://www.milliyet.com.tr/,3071857,10030,,359,6870,,2168,2168,211,16040,,2753,,
12_01_desktop,https://www.hurriyet.com.tr/,2561861,8745,,298,2181,,868,1686,186,12083,,2433,,
12_01_desktop,https://www.sozcu.com.tr/,2831141,7295,,474,6053,,1779,3656,117,10822,,843,,
12_01_desktop,https://www.sabanciuniv.edu/,4537306,9887,,802,3003,,2426,2982,147,13299,,311,,
12_01_desktop,https://www.ku.edu.tr/,4428789,9151,,515,3923,,2054,5734,71,13154,,165,,
12_01_mobile,https://www.ku.edu.tr/,4425963,27061,,1627,10252,,3306,7084,72,34283,,8,,
12_01_mobile,https://www.sabanciuniv.edu/,5256603,34019,,1913,10728,,5192,11766,166,43845,,278,,
12_01_mobile,https://www.hurriyet.com.tr/,2297033,27027,,1895,15295,,4206,12163,162,37061,,481,,
12_01_mobile,https://www.sozcu.com.tr/,3074641,23859,,1461,18768,,3976,24406,121,32641,,199,,
12_01_mobile,https://www.bilkent.edu.tr/,2417905,24859,,6686,17818,,9119,17086,97,33415,,1347,,
12_01_mobile,https://www.milliyet.com.tr/,2555429,28869,,3427,29143,,6264,9914,179,113288,,5874,,

I haven’t gone through each row but it’s possible that some URLs are unavailable for specific month/client combinations due to them having insufficient popularity in the source corpus (CrUX).

Hope this helps!

1 Like

Hi Rick,

Many thanks for the stats and data you provided, much appreciated. I will check all of them very shortly.

While I am very new to HTTP Archive, unfortunately, I was not aware that the free monthly quota is 1 TB, I will proceed these stats with caution.

  • Page speed: This is a Google performance score, sorry for repeating.
  • Google [desktop, mobile] score: Yes exactly, I mean the Lighthouse score by [desktop, mobile] score. Many thanks for providing all metrics for both desktop and mobile.
  • Performance score: Yes, I mean the Lighthouse score by performance score.
  • FID: No problem at all, thanks a lot.

I will shortly send you a few queries through message.

Best wishes

Thanks for clarifying. Here’s the updated query:

DECLARE URLs ARRAY<STRING> DEFAULT [
  'https://www.hurriyet.com.tr/',
  'https://www.milliyet.com.tr/',
  'https://www.sozcu.com.tr/',
  'https://www.ku.edu.tr/',
  'https://www.sabanciuniv.edu/',
  'https://www.bilkent.edu.tr/'
];

SELECT
  _TABLE_SUFFIX AS month_client,
  url,
  JSON_VALUE(payload, '$._bytesIn') AS page_size,
  JSON_VALUE(payload, '$._loadTime') AS load_time,
  JSON_VALUE(payload, '$._TTFB') AS ttfb,
  JSON_VALUE(payload, '$._SpeedIndex') AS speed_index,
  JSON_VALUE(payload, '$."_chromeUserTiming.firstContentfulPaint"') AS fcp,
  JSON_VALUE(payload, '$."_chromeUserTiming.LargestContentfulPaint"') AS lcp,
  JSON_VALUE(payload, '$._requests') AS requests,
  JSON_VALUE(payload, '$._TTIMeasurementEnd') AS tti,
  JSON_VALUE(payload, '$._chromeUserTiming.CumulativeLayoutShift') AS cls,
  JSON_VALUE(payload, '$._TotalBlockingTime') AS tbt,
  JSON_VALUE(report, '$.categories.performance.score') AS performance_score
FROM
  `httparchive.pages.2021_*`
LEFT JOIN
  `httparchive.lighthouse.2021_*`
USING
  (_TABLE_SUFFIX, url)
WHERE
  url IN UNNEST(URLs)
ORDER BY
  month_client

Note that to get the Lighthouse score we need to also query the lighthouse dataset, which brings the total query cost to 50 TB.

Also, we only test mobile pages in Lighthouse, so the score will not be available for desktop pages.

month_client,url,page_size,load_time,ttfb,speed_index,fcp,lcp,requests,tti,cls,tbt,performance_score
01_01_desktop,https://www.ku.edu.tr/,4726659,10240,1554,5837,3397,4581,94,13038,,886,
01_01_desktop,https://www.sozcu.com.tr/,3226816,9095,340,6842,1897,5247,153,11702,,1658,
01_01_desktop,https://www.milliyet.com.tr/,3565356,15849,435,4727,1614,2447,232,20359,,4621,
01_01_desktop,https://www.sabanciuniv.edu/,4280120,10622,1467,4867,3376,5143,144,14395,,1501,
01_01_desktop,https://www.hurriyet.com.tr/,5447172,41903,438,13465,1231,3097,667,48002,,21567,
01_01_mobile,https://www.hurriyet.com.tr/,3876501,38971,2284,6276,5375,7375,234,50998,,6816,0.2
01_01_mobile,https://www.sozcu.com.tr/,2588009,25163,1482,11147,4485,5901,178,34378,,2091,0.28
01_01_mobile,https://www.sabanciuniv.edu/,5165902,34178,2525,9690,6541,11791,161,45509,,2025,0.07
01_01_mobile,https://www.ku.edu.tr/,4704397,34175,1613,7987,3709,5225,93,34192,,449,0.42
01_01_mobile,https://www.milliyet.com.tr/,2408947,26542,3284,13244,5123,6039,204,105130,,3881,0.23
02_01_desktop,https://www.milliyet.com.tr/,3325695,17836,326,3374,1431,2297,246,23471,,5103,
02_01_desktop,https://www.ku.edu.tr/,4621328,9705,636,4326,2215,3199,71,9711,,229,
02_01_desktop,https://www.hurriyet.com.tr/,4881087,19235,329,3381,581,2914,377,27414,,8468,
02_01_desktop,https://www.sozcu.com.tr/,2923680,7846,294,4601,1515,3115,154,10327,,849,
02_01_desktop,https://www.sabanciuniv.edu/,4366838,9544,839,3804,2414,4114,141,12816,,1134,
02_01_mobile,https://www.hurriyet.com.tr/,3202764,38232,2178,6041,5145,7192,239,48934,,6654,
02_01_mobile,https://www.sabanciuniv.edu/,4908312,31616,2023,9479,5758,11208,158,42430,,2179,
02_01_mobile,https://www.milliyet.com.tr/,2663085,32120,3444,8376,5406,6473,250,112316,,6472,0.16
02_01_mobile,https://www.sozcu.com.tr/,2376077,23513,1497,9963,4862,6362,148,31257,,2162,0.22
02_01_mobile,https://www.ku.edu.tr/,4605433,28399,1636,11444,3829,11229,72,28428,,326,0.42
03_01_desktop,https://www.hurriyet.com.tr/,5013859,14675,559,3363,951,2057,302,21120,,4318,
03_01_desktop,https://www.milliyet.com.tr/,3829119,17577,510,4324,1624,2853,271,22752,,4912,
03_01_desktop,https://www.sabanciuniv.edu/,4543326,9482,818,3022,2255,3042,143,12809,,443,
03_01_desktop,https://www.sozcu.com.tr/,3027434,8630,288,5196,1720,3638,167,11272,,1650,
03_01_desktop,https://www.ku.edu.tr/,4606229,11403,1734,4969,3684,5765,73,12474,,124,
03_01_mobile,https://www.sozcu.com.tr/,2717846,26926,1425,14788,4453,5848,164,35151,,2015,0.3
03_01_mobile,https://www.sabanciuniv.edu/,4982970,32664,2011,7774,5781,7900,159,43500,,2145,0.12
03_01_mobile,https://www.ku.edu.tr/,3212056,21111,1575,10267,3933,5111,72,21121,,321,0.34
03_01_mobile,https://www.milliyet.com.tr/,2612379,29812,3417,12244,5238,6243,241,120680,,4487,
03_01_mobile,https://www.hurriyet.com.tr/,3097691,35938,2320,7098,5218,6999,201,46185,,3888,
04_01_desktop,https://www.milliyet.com.tr/,3965555,15986,454,3609,1452,2004,254,23454,,3628,
04_01_desktop,https://www.sozcu.com.tr/,3273797,10492,458,6564,2292,3539,171,13068,,1557,
04_01_desktop,https://www.sabanciuniv.edu/,4015790,8931,877,3289,2451,3355,143,12249,,368,
04_01_desktop,https://www.hurriyet.com.tr/,4567550,16726,489,1707,1022,2381,251,20118,,3404,
04_01_desktop,https://www.ku.edu.tr/,3295167,6503,429,3057,1724,3473,73,10604,,263,
04_01_mobile,https://www.hurriyet.com.tr/,4427964,40246,1788,5781,3398,6743,240,53318,,4739,0.25
04_01_mobile,https://www.sabanciuniv.edu/,4559424,30140,2111,9234,5743,10734,160,40864,,1085,0.2
04_01_mobile,https://www.ku.edu.tr/,3343999,23718,3042,11454,5122,7547,72,23808,,378,0.35
04_01_mobile,https://www.milliyet.com.tr/,2604126,36121,2175,8381,4354,5256,655,120427,,4333,0.3
04_01_mobile,https://www.sozcu.com.tr/,3030914,27324,1451,12456,4585,6396,157,34983,,1741,0.35
05_01_desktop,https://www.hurriyet.com.tr/,4796414,14803,434,5027,874,2060,263,19570,,2947,
05_01_desktop,https://www.ku.edu.tr/,3386643,8751,1834,5061,3734,6717,73,13009,,145,
05_01_desktop,https://www.sozcu.com.tr/,3175599,9329,368,5118,1735,2902,175,11904,,1389,
05_01_desktop,https://www.sabanciuniv.edu/,5570769,11596,818,3210,2373,4047,150,14699,,307,
05_01_desktop,https://www.bilkent.edu.tr/,3171884,10410,2079,6282,4021,7380,97,12676,,1433,
05_01_desktop,https://www.milliyet.com.tr/,3471680,10686,504,3754,1354,2460,225,24857,,2576,
05_01_mobile,https://www.hurriyet.com.tr/,3170188,33853,2309,4766,4106,6007,185,44720,,3217,0.26
05_01_mobile,https://www.ku.edu.tr/,3326655,22309,1591,10303,4637,8154,72,22321,,382,0.47
05_01_mobile,https://www.milliyet.com.tr/,2276999,27115,2297,9142,4344,5261,206,120260,,2381,0.32
05_01_mobile,https://www.bilkent.edu.tr/,2839412,29011,5565,17163,9472,18115,92,36783,,4046,0.02
05_01_mobile,https://www.sabanciuniv.edu/,6296849,41055,2134,10928,5804,14933,167,51515,,1503,0.08
05_01_mobile,https://www.sozcu.com.tr/,2688331,26212,1580,10661,4691,6064,160,34056,,2063,0.38
06_01_desktop,https://www.milliyet.com.tr/,4183851,10790,328,3113,1152,15312,245,19479,,2290,
06_01_desktop,https://www.sozcu.com.tr/,3391478,8085,349,5178,1566,2553,176,15101,,1454,
06_01_desktop,https://www.hurriyet.com.tr/,5063672,14303,762,3695,1163,2953,281,17822,,2944,
06_01_desktop,https://www.bilkent.edu.tr/,2919623,11202,2434,7450,5309,7651,102,13583,,1117,
06_01_desktop,https://www.ku.edu.tr/,3292347,6888,404,3716,1919,4987,74,11389,,111,
06_01_desktop,https://www.sabanciuniv.edu/,4741623,10031,829,2974,2463,3277,147,13000,,175,
06_01_mobile,https://www.milliyet.com.tr/,2472318,31045,2458,17394,4338,6979,179,113110,,10100,
06_01_mobile,https://www.sabanciuniv.edu/,5288774,34952,2055,8985,6022,8756,164,46914,,4092,0.08
06_01_mobile,https://www.hurriyet.com.tr/,3769099,40291,2384,13869,4442,6280,210,52872,,11046,
06_01_mobile,https://www.sozcu.com.tr/,2660149,26890,1955,12533,5739,8246,159,38406,,5496,0.28
06_01_mobile,https://www.ku.edu.tr/,3232357,21935,1638,10906,5301,6083,73,22006,,1569,0.26
06_01_mobile,https://www.bilkent.edu.tr/,2751945,30865,5611,21147,9920,18200,98,41351,,8398,0.01
07_01_desktop,https://www.ku.edu.tr/,3384298,6262,409,2655,1335,4104,71,7532,,229,
07_01_desktop,https://www.milliyet.com.tr/,3001080,11161,469,4086,1180,1439,221,17657,,3044,
07_01_desktop,https://www.sabanciuniv.edu/,3986765,8699,857,2800,2387,2729,147,13833,,456,
07_01_desktop,https://www.sozcu.com.tr/,3255963,8467,335,5962,1719,2743,179,13749,,719,
07_01_desktop,https://www.bilkent.edu.tr/,3252247,11804,2184,10925,4317,9771,103,16238,,1536,
07_01_desktop,https://www.hurriyet.com.tr/,3154225,10004,413,3467,826,1668,242,13598,,1861,
07_01_mobile,https://www.hurriyet.com.tr/,2251550,35927,2240,19249,4663,6907,177,52854,,12220,
07_01_mobile,https://www.sozcu.com.tr/,2583466,28077,1365,12868,5137,7164,164,39361,,5359,
07_01_mobile,https://www.sabanciuniv.edu/,5488153,35642,1900,8611,5765,8518,165,47229,,3422,0.07
07_01_mobile,https://www.milliyet.com.tr/,1946397,26211,2224,26233,4097,6714,162,111904,,7355,
07_01_mobile,https://www.ku.edu.tr/,3324383,22367,1657,10670,4012,5676,70,22385,,1325,0.29
07_01_mobile,https://www.bilkent.edu.tr/,2752005,32890,5848,25883,10414,21143,98,44381,,10615,0.01
08_01_desktop,https://www.sabanciuniv.edu/,4062598,9299,889,3089,2593,3331,143,13683,,270,
08_01_desktop,https://www.milliyet.com.tr/,3269435,11968,347,4869,1969,1969,237,19840,,3146,
08_01_desktop,https://www.ku.edu.tr/,3280068,6724,673,3309,2273,3001,71,10675,,271,
08_01_desktop,https://www.sozcu.com.tr/,3261991,7469,345,4350,1180,2537,122,14384,,1262,
08_01_desktop,https://www.hurriyet.com.tr/,3160043,12393,369,5838,824,1770,255,16423,,3499,
08_01_desktop,https://www.bilkent.edu.tr/,2946900,11876,1934,10590,4080,7144,103,16143,,1626,
08_01_mobile,https://www.sabanciuniv.edu/,5668864,38756,2118,12195,6378,13950,160,51084,,4815,0.05
08_01_mobile,https://www.bilkent.edu.tr/,2778820,35698,5708,29067,9953,17730,99,44657,,7165,0.01
08_01_mobile,https://www.sozcu.com.tr/,3174955,28495,1387,18654,4135,27146,133,39549,,4284,0.28
08_01_mobile,https://www.ku.edu.tr/,3276839,21798,1629,11306,4463,6966,72,23323,,1571,0.3
08_01_mobile,https://www.milliyet.com.tr/,1936417,26394,2170,18770,4033,6550,161,110048,,6952,
08_01_mobile,https://www.hurriyet.com.tr/,2705264,35293,2461,19577,4628,6351,254,65369,,11223,
09_01_desktop,https://www.bilkent.edu.tr/,2772782,10840,2374,7332,3662,6819,102,15260,,1711,
09_01_desktop,https://www.sabanciuniv.edu/,5811163,12354,864,3025,2219,4932,147,15416,,197,
09_01_desktop,https://www.ku.edu.tr/,3213133,6668,429,3365,1937,5301,71,8191,,44,
09_01_desktop,https://www.milliyet.com.tr/,3049906,13428,379,4761,2086,2086,205,18728,,3673,
09_01_desktop,https://www.sozcu.com.tr/,3481789,7206,360,4072,1181,2579,155,13972,,1177,
09_01_desktop,https://www.hurriyet.com.tr/,3380558,13311,582,5292,942,2145,679,23257,,5246,
09_01_mobile,https://www.sozcu.com.tr/,3440571,29408,1360,17869,3907,27022,149,40725,,3513,0.24
09_01_mobile,https://www.ku.edu.tr/,3209890,22755,2685,10558,5464,8225,72,22808,,1476,0.32
09_01_mobile,https://www.bilkent.edu.tr/,2779828,32782,5995,29426,8882,17814,97,42242,,621,0.01
09_01_mobile,https://www.sabanciuniv.edu/,6224402,39237,1911,9710,5828,17635,164,51215,,3680,
09_01_mobile,https://www.milliyet.com.tr/,1992544,29016,2433,19225,4391,6380,174,111944,,8772,0.28
09_01_mobile,https://www.hurriyet.com.tr/,2637992,32977,2259,17365,4311,6066,175,51316,,9582,
10_01_desktop,https://www.sabanciuniv.edu/,3992263,8994,922,2850,2427,2989,146,13066,,513,
10_01_desktop,https://www.ku.edu.tr/,3167474,7652,1539,4072,2800,6040,71,11891,,108,
10_01_desktop,https://www.sozcu.com.tr/,3457059,7038,290,3670,1002,3328,128,13699,,773,
10_01_desktop,https://www.bilkent.edu.tr/,2463583,11138,3133,7040,4921,7185,100,15400,,1626,
10_01_desktop,https://www.milliyet.com.tr/,4058338,11448,597,5840,2996,2996,261,16283,,2458,
10_01_desktop,https://www.hurriyet.com.tr/,2696117,9020,427,2697,878,1585,184,12463,,2154,
10_01_mobile,https://www.hurriyet.com.tr/,2534265,26894,1802,12004,3331,5284,179,37339,,5736,0.31
10_01_mobile,https://www.bilkent.edu.tr/,2563150,29333,6168,20748,9005,15944,96,37140,,6283,0.01
10_01_mobile,https://www.sozcu.com.tr/,3387018,30272,1481,20579,3785,27229,128,40079,,2456,0.24
10_01_mobile,https://www.ku.edu.tr/,3164225,20795,1551,9902,4117,5126,72,20807,,804,0.39
10_01_mobile,https://www.milliyet.com.tr/,1937556,22894,2470,22807,4180,6863,149,110245,,4680,
10_01_mobile,https://www.sabanciuniv.edu/,4883880,31807,1960,10027,5635,12124,165,42682,,2925,
11_01_desktop,https://www.hurriyet.com.tr/,2572401,10384,361,4605,1036,1388,183,13976,,2831,
11_01_desktop,https://www.sozcu.com.tr/,2664663,7530,362,5415,1143,2428,117,13898,,733,
11_01_desktop,https://www.sabanciuniv.edu/,4344324,9346,823,2973,2335,3123,148,14783,,538,
11_01_desktop,https://www.milliyet.com.tr/,2736318,12477,612,8388,2454,2454,205,18051,,2199,
11_01_desktop,https://www.bilkent.edu.tr/,2545446,10710,2819,6481,4134,6809,99,14954,,1342,
11_01_desktop,https://www.ku.edu.tr/,3203945,6208,708,3077,1674,2886,70,10187,,89,
11_01_mobile,https://www.sabanciuniv.edu/,5002261,32552,1981,8134,5770,8176,165,43892,,2947,0.07
11_01_mobile,https://www.milliyet.com.tr/,4391992,39693,3442,22253,11010,11010,303,83445,,9461,0.15
11_01_mobile,https://www.ku.edu.tr/,3200701,21487,2416,11147,4878,6162,71,21490,,988,0.34
11_01_mobile,https://www.hurriyet.com.tr/,2082955,26255,1802,8852,4344,7227,144,45129,,6618,0.15
11_01_mobile,https://www.sozcu.com.tr/,2731358,24373,1400,17342,3828,23562,118,33671,,3374,0.14
11_01_mobile,https://www.bilkent.edu.tr/,2646577,28436,6108,21394,8998,17400,96,37810,,6758,0.01
12_01_desktop,https://www.bilkent.edu.tr/,2773340,10911,3589,8837,4845,7956,98,16615,,1420,
12_01_desktop,https://www.sozcu.com.tr/,2831141,7295,474,6053,1779,3656,117,10822,,843,
12_01_desktop,https://www.milliyet.com.tr/,3071857,10030,359,6870,2168,2168,211,16040,,2753,
12_01_desktop,https://www.sabanciuniv.edu/,4537306,9887,802,3003,2426,2982,147,13299,,311,
12_01_desktop,https://www.hurriyet.com.tr/,2561861,8745,298,2181,868,1686,186,12083,,2433,
12_01_desktop,https://www.ku.edu.tr/,4428789,9151,515,3923,2054,5734,71,13154,,165,
12_01_mobile,https://www.ku.edu.tr/,4425963,27061,1627,10252,3306,7084,72,34283,,8,0.33
12_01_mobile,https://www.hurriyet.com.tr/,2297033,27027,1895,15295,4206,12163,162,37061,,481,0.15
12_01_mobile,https://www.sabanciuniv.edu/,5256603,34019,1913,10728,5192,11766,166,43845,,278,0.07
12_01_mobile,https://www.bilkent.edu.tr/,2417905,24859,6686,17818,9119,17086,97,33415,,1347,0.01
12_01_mobile,https://www.milliyet.com.tr/,2555429,28869,3427,29143,6264,9914,179,113288,,5874,0.15
12_01_mobile,https://www.sozcu.com.tr/,3074641,23859,1461,18768,3976,24406,121,32641,,199,0.14
1 Like

Hi Rick, thank you very much for all these stats, much appreciated. Have a great day!

Hi Rick, could you please rerun the query for the below websites as well?

  1. sabah.com.tr
  2. mynet.com
  3. haberturk.com
  4. cumhuriyet.com.tr
  5. metu.edu.tr
  6. boun.edu.tr
  7. itu.edu.tr
  8. ankara.edu.tr
  9. hacettepe.edu.tr

Your help is much appreciated!

Sure, here’s the CSV for the new URLs

month_client,url,page_size,load_time,ttfb,speed_index,fcp,lcp,requests,tti,cls,tbt,performance_score
01_01_desktop,https://www.itu.edu.tr/,10345913,20448,1018,9374,3081,17014,155,23841,,1214,
01_01_desktop,https://www.mynet.com/,1352315,6756,401,2619,1115,2165,122,12033,,2137,
01_01_desktop,http://boun.edu.tr/,489799,2786,712,2064,1631,2515,27,2809,,21,
01_01_desktop,https://www.cumhuriyet.com.tr/,4527197,20717,1509,8445,1982,6165,406,25049,,8217,
01_01_desktop,https://hacettepe.edu.tr/,3669666,10659,1575,4267,2998,5148,70,13317,,122,
01_01_desktop,https://www.metu.edu.tr/,5156919,13457,1213,7449,3481,4198,97,14154,,569,
01_01_desktop,https://www.haberturk.com/,3995198,10183,1077,5825,1881,3847,222,20371,,4544,
01_01_desktop,https://www.ankara.edu.tr/,8122380,20452,2485,12828,7747,19229,174,25098,,4795,
01_01_desktop,https://www.sabah.com.tr/,3016640,14324,252,5449,2298,3748,227,20731,,7279,
01_01_mobile,https://www.metu.edu.tr/,5138508,35879,2675,11460,7062,8779,99,38843,,759,0.09
01_01_mobile,https://www.ankara.edu.tr/,6938132,49997,3575,18181,16828,42661,180,60440,,6169,0
01_01_mobile,https://www.mynet.com/,1883169,14547,1839,9899,4212,8029,107,119202,,1963,0.18
01_01_mobile,https://www.itu.edu.tr/,8501710,50301,2135,12242,6263,14779,139,58255,,1102,0.05
01_01_mobile,https://hacettepe.edu.tr/,3574659,25958,2910,7854,5926,10093,65,33169,,143,0.45
01_01_mobile,https://www.haberturk.com/,1193718,13000,2465,12811,3209,16109,112,32109,,1798,0.17
01_01_mobile,https://www.cumhuriyet.com.tr/,4421565,47726,1489,6828,3196,6213,322,57184,,8118,0.16
01_01_mobile,http://boun.edu.tr/,1060981,8260,1546,7718,3714,5080,40,100650,,27,0.67
01_01_mobile,https://www.sabah.com.tr/,5188024,47084,2818,13926,6245,7662,243,62659,,13047,
02_01_desktop,https://www.metu.edu.tr/,5493597,13095,1248,7419,3597,4597,99,14546,,523,
02_01_desktop,https://www.mynet.com/,1155496,6117,456,3281,1247,1797,123,10958,,2085,
02_01_desktop,https://www.sabah.com.tr/,2061257,8161,459,3366,2014,3214,171,17012,,1682,
02_01_desktop,https://hacettepe.edu.tr/,4087688,12383,2356,6796,3763,5030,70,15115,,137,
02_01_desktop,https://www.cumhuriyet.com.tr/,4040110,17238,474,7967,1331,5397,262,21852,,6962,
02_01_desktop,http://boun.edu.tr/,441091,2425,582,1843,1497,2114,27,2426,,54,
02_01_desktop,https://www.ankara.edu.tr/,8390627,19466,2408,11475,7329,18028,174,23765,,1327,
02_01_desktop,https://www.haberturk.com/,3355798,4577,418,2823,898,2081,200,13303,,2954,
02_01_desktop,https://www.itu.edu.tr/,12444390,24382,1038,7802,3418,10468,160,27240,,1585,
02_01_mobile,http://boun.edu.tr/,1003891,8196,1609,7208,4066,5466,40,100996,,93,0.66
02_01_mobile,https://www.cumhuriyet.com.tr/,4414756,43890,1630,7271,3380,7980,376,52951,,5246,0.15
02_01_mobile,https://www.haberturk.com/,1221520,13873,2445,12133,3313,15846,115,33521,,1697,0.2
02_01_mobile,https://hacettepe.edu.tr/,4501991,58812,2776,8385,5498,8398,67,65824,,0,0.4
02_01_mobile,https://www.metu.edu.tr/,5347377,35453,2442,9806,6378,12295,95,38516,,1372,0.12
02_01_mobile,https://www.mynet.com/,1117991,15274,1982,5996,4442,7042,125,28118,,3248,
02_01_mobile,https://www.sabah.com.tr/,4470899,28172,2810,11431,5979,6782,195,43021,,2680,
02_01_mobile,https://www.ankara.edu.tr/,8413811,56704,3721,17154,15861,49559,173,70440,,6182,0
02_01_mobile,https://www.itu.edu.tr/,10641305,64722,2263,12793,6761,15094,146,72721,,942,0.06
03_01_desktop,https://www.itu.edu.tr/,8355450,27782,803,6438,2295,9455,162,30379,,430,
03_01_desktop,http://boun.edu.tr/,474292,2870,729,2019,1899,2273,27,2886,,0,
03_01_desktop,https://www.cumhuriyet.com.tr/,3627913,10217,575,4650,1226,4336,159,13984,,3519,
03_01_desktop,https://www.sabah.com.tr/,1985425,6410,407,2466,2031,2702,170,13392,,1124,
03_01_desktop,https://www.haberturk.com/,3535023,5052,625,2540,1112,2269,195,12293,,1053,
03_01_desktop,https://hacettepe.edu.tr/,4953419,12578,2318,6818,3671,6729,78,14952,,106,
03_01_desktop,https://www.metu.edu.tr/,6480304,14844,1170,6739,3387,7246,99,17432,,307,
03_01_desktop,https://www.mynet.com/,1217380,3721,315,1768,755,1702,124,8011,,1131,
03_01_desktop,https://www.ankara.edu.tr/,6845194,17850,2951,11320,7603,16669,175,21734,,2348,
03_01_mobile,https://www.itu.edu.tr/,8427197,49823,1989,12346,6170,15020,142,57404,,1099,0.02
03_01_mobile,https://www.mynet.com/,8936683,46907,1690,4622,3638,38215,229,120302,,1526,0.17
03_01_mobile,https://www.metu.edu.tr/,5869157,38930,2390,9892,6155,9590,95,47005,,951,0.12
03_01_mobile,https://www.ankara.edu.tr/,6814247,46644,4268,18095,16858,41744,168,54621,,3430,0
03_01_mobile,http://boun.edu.tr/,1254278,8764,1604,6252,3950,4779,42,106809,,51,0.79
03_01_mobile,https://www.sabah.com.tr/,2755531,30759,3046,10250,6561,7233,161,42634,,756,0.24
03_01_mobile,https://www.cumhuriyet.com.tr/,5322252,35045,1515,6471,3087,7257,173,44377,,4475,0.17
03_01_mobile,https://www.haberturk.com/,1254267,13695,2565,11955,3404,15597,118,33230,,1679,0.2
03_01_mobile,https://hacettepe.edu.tr/,1455882,45406,2586,11355,5257,8170,72,52745,,0,0.41
04_01_desktop,https://www.metu.edu.tr/,7075883,15507,1158,9289,3168,11225,99,17602,,145,
04_01_desktop,https://www.ankara.edu.tr/,7235740,17498,1851,11154,6438,15598,175,20000,,541,
04_01_desktop,https://www.haberturk.com/,4484218,6426,546,2753,1035,1843,197,14063,,1341,
04_01_desktop,http://boun.edu.tr/,502718,2910,785,2063,1712,2838,27,2921,,26,
04_01_desktop,https://www.itu.edu.tr/,6325165,12870,976,7436,2818,8640,170,15798,,752,
04_01_desktop,https://www.cumhuriyet.com.tr/,8702813,18898,612,5200,923,5553,249,22919,,3614,
04_01_desktop,https://hacettepe.edu.tr/,1777115,6492,1147,2927,2356,3690,77,8531,,29,
04_01_desktop,https://www.sabah.com.tr/,1915892,6766,474,3204,1702,3189,164,12638,,988,
04_01_desktop,https://www.mynet.com/,1185774,4513,314,1048,724,1683,135,8519,,1034,
04_01_mobile,https://www.metu.edu.tr/,7851886,49831,2393,8432,6448,17792,96,55765,,1173,0.09
04_01_mobile,https://www.ankara.edu.tr/,8084360,54769,2864,17745,15821,48249,171,61518,,1988,0
04_01_mobile,https://www.cumhuriyet.com.tr/,9014416,55663,1593,5943,3178,8476,195,65704,,4446,0.18
04_01_mobile,https://www.sabah.com.tr/,2250851,23694,3011,9815,6720,8656,158,35608,,2163,0.22
04_01_mobile,https://www.itu.edu.tr/,6374092,38139,2130,14970,6205,16781,142,45674,,1218,0.04
04_01_mobile,https://www.mynet.com/,6122288,26028,1976,12062,4072,19473,232,120431,,1397,0.18
04_01_mobile,http://boun.edu.tr/,1175099,8020,1472,6680,3702,5112,41,106502,,13,0.84
04_01_mobile,https://hacettepe.edu.tr/,1801093,17766,2750,9753,5663,8463,72,23995,,71,0.46
04_01_mobile,https://www.haberturk.com/,990511,11017,2445,4620,3064,3957,103,30090,,1036,0.61
05_01_desktop,https://www.itu.edu.tr/,6140861,12558,927,6300,2693,7972,168,15234,,368,
05_01_desktop,https://www.sabah.com.tr/,1980468,7027,512,2420,1852,2789,166,11922,,854,
05_01_desktop,https://www.ankara.edu.tr/,7708033,17900,1693,11090,6414,16668,172,20270,,710,
05_01_desktop,http://boun.edu.tr/,494400,2300,593,1742,1346,2252,27,2317,,6,
05_01_desktop,https://www.haberturk.com/,4255178,6152,531,3797,1180,1776,225,15532,,2171,
05_01_desktop,https://www.metu.edu.tr/,5739309,13881,1209,7979,3438,11853,100,14951,,114,
05_01_desktop,https://hacettepe.edu.tr/,3555894,10988,1210,9089,2573,5550,51,13710,,105,
05_01_desktop,https://www.mynet.com/,1157409,4095,340,1342,1185,1763,127,8298,,995,
05_01_desktop,https://www.cumhuriyet.com.tr/,10453694,18845,475,5754,759,9160,306,28947,,3640,
05_01_mobile,https://www.haberturk.com/,1016257,11004,2289,4406,2860,3962,109,30566,,809,0.61
05_01_mobile,https://www.ankara.edu.tr/,7730084,53335,2787,17812,16098,48339,171,60194,,2654,0
05_01_mobile,https://www.itu.edu.tr/,6193024,37196,1998,8053,6020,9831,141,44706,,822,0.15
05_01_mobile,http://boun.edu.tr/,1294021,8957,2425,8214,4664,6072,41,107633,,14,0.65
05_01_mobile,https://www.mynet.com/,6116895,34837,1528,15638,3909,20401,264,120325,,1635,0.19
05_01_mobile,https://www.metu.edu.tr/,5159178,35427,2413,10417,6356,12606,96,38095,,662,0.15
05_01_mobile,https://www.sabah.com.tr/,2437498,23476,3072,9451,6288,7111,159,35313,,559,
05_01_mobile,https://www.cumhuriyet.com.tr/,9471709,60283,1491,6005,3119,8371,495,120188,,6857,
05_01_mobile,https://hacettepe.edu.tr/,6614169,33302,2848,19265,5897,10908,51,43342,,0,0.28
06_01_desktop,https://www.ankara.edu.tr/,8326520,18440,1364,9274,6009,16982,176,20877,,1273,
06_01_desktop,https://www.mynet.com/,1505700,4983,581,1592,1319,3255,120,9703,,1196,
06_01_desktop,https://www.itu.edu.tr/,5803970,11658,812,5552,2380,7204,170,14295,,439,
06_01_desktop,https://www.metu.edu.tr/,5027591,11160,1069,8277,2925,11057,100,13113,,103,
06_01_desktop,http://boun.edu.tr/,457725,3618,1610,2817,2511,3412,27,3624,,33,
06_01_desktop,https://hacettepe.edu.tr/,4171698,9806,1639,4601,3135,5315,49,12985,,44,
06_01_desktop,https://www.cumhuriyet.com.tr/,8058882,13682,444,1931,1118,4256,382,27128,,3463,
06_01_desktop,https://www.haberturk.com/,5147443,7605,532,2789,1088,2046,237,17092,,1922,
06_01_desktop,https://www.sabah.com.tr/,2075938,6999,445,2387,1652,2905,165,12821,,1503,
06_01_mobile,https://www.haberturk.com/,1746362,16860,2317,5441,3434,4441,127,38110,,4495,0.45
06_01_mobile,https://www.ankara.edu.tr/,11099708,58612,2540,46349,14882,50299,220,78419,,6673,
06_01_mobile,https://hacettepe.edu.tr/,2903411,22624,4022,21693,7253,14484,49,30758,,1026,0.22
06_01_mobile,http://boun.edu.tr/,1095959,8089,1405,18697,3861,4949,41,106810,,82,0.76
06_01_mobile,https://www.cumhuriyet.com.tr/,8646102,52825,1578,7298,3419,5979,380,116824,,20413,
06_01_mobile,https://www.metu.edu.tr/,4968946,33769,2349,14879,6403,14942,96,38556,,1749,0.09
06_01_mobile,https://www.mynet.com/,12291050,50765,1744,33519,3863,45385,231,120372,,3186,0.18
06_01_mobile,https://www.sabah.com.tr/,2495899,24821,2945,10780,6544,8028,161,37106,,3577,
06_01_mobile,https://www.itu.edu.tr/,5970935,35657,2069,10061,6245,14699,143,43789,,2468,0.03
07_01_desktop,https://www.itu.edu.tr/,34813447,78454,1014,7430,2732,8496,130,88659,,221,
07_01_desktop,https://www.ankara.edu.tr/,7837935,17358,1279,10778,5599,15839,176,19692,,2605,
07_01_desktop,https://www.mynet.com/,2687173,17823,587,3085,1405,2852,440,22006,,4965,
07_01_desktop,https://www.metu.edu.tr/,4669484,11326,989,8132,2749,10889,100,12921,,101,
07_01_desktop,http://boun.edu.tr/,460619,2909,736,2136,1952,2436,27,2917,,0,
07_01_desktop,https://www.haberturk.com/,5019386,6056,329,2677,817,4073,235,15305,,1927,
07_01_desktop,https://www.sabah.com.tr/,2001365,6482,444,2182,1629,2773,162,11574,,1093,
07_01_desktop,https://www.cumhuriyet.com.tr/,16603750,29870,552,7476,1026,16605,1046,82856,,9051,
07_01_desktop,https://hacettepe.edu.tr/,3860468,8278,1437,6492,2653,4847,52,11479,,74,
07_01_mobile,https://hacettepe.edu.tr/,5080303,26457,3360,14710,6263,9131,50,35597,,995,
07_01_mobile,https://www.cumhuriyet.com.tr/,11348706,70154,1560,24155,3588,6964,413,120710,,22927,
07_01_mobile,https://www.haberturk.com/,1592000,13155,1985,5461,3330,4714,112,34404,,3359,
07_01_mobile,https://www.sabah.com.tr/,2390634,24420,3239,9485,6524,7388,156,36794,,3882,
07_01_mobile,https://www.metu.edu.tr/,4945990,33561,2745,11880,7195,12678,96,39548,,2542,0.09
07_01_mobile,http://boun.edu.tr/,834501,8777,1530,11900,4223,5674,34,65007,,212,0.65
07_01_mobile,https://www.ankara.edu.tr/,7825714,56104,2427,31477,15135,47460,173,63305,,8359,0.01
07_01_mobile,https://www.mynet.com/,6502945,25055,1975,23087,4041,23071,239,120590,,5844,
08_01_desktop,https://www.mynet.com/,2479576,13762,595,4164,1352,2505,288,18717,,3678,
08_01_desktop,https://www.cumhuriyet.com.tr/,13073941,26372,498,4447,1072,16305,973,60095,,10576,
08_01_desktop,https://www.haberturk.com/,4644898,5374,370,2180,870,1632,213,15067,,1480,
08_01_desktop,https://www.sabah.com.tr/,1919729,6704,469,2368,1973,2886,162,11837,,1047,
08_01_desktop,http://boun.edu.tr/,498477,2491,609,1888,1526,2366,27,2497,,0,
08_01_desktop,https://www.itu.edu.tr/,40850911,83492,979,9578,2453,12077,144,92710,,549,
08_01_desktop,https://hacettepe.edu.tr/,6757233,10927,1142,6476,2345,3950,52,14003,,122,
08_01_desktop,https://www.metu.edu.tr/,4633680,11302,983,7809,2671,3932,120,13912,,210,
08_01_desktop,https://www.ankara.edu.tr/,8029206,16981,1316,12981,5672,13498,186,19649,,2493,
08_01_mobile,https://www.cumhuriyet.com.tr/,11697859,69948,1547,21032,3399,5213,540,121021,,24798,
08_01_mobile,https://hacettepe.edu.tr/,4547293,38135,4016,14296,7572,24727,49,38146,,877,0.31
08_01_mobile,https://www.haberturk.com/,1564998,11834,1969,5684,3615,4662,113,33755,,5254,0.54
08_01_mobile,https://www.itu.edu.tr/,20235357,61344,1969,17150,7400,20384,149,120582,,10654,0.03
08_01_mobile,https://www.mynet.com/,6335108,30208,1950,24538,4236,24873,266,120763,,5859,
08_01_mobile,https://www.sabah.com.tr/,2296339,23098,3065,8527,6514,7819,151,36108,,4304,0.21
08_01_mobile,http://boun.edu.tr/,889462,8363,1440,12665,3721,5077,32,52509,,237,0.71
08_01_mobile,https://www.ankara.edu.tr/,8016026,54018,2842,38483,16400,44666,183,61316,,8268,
08_01_mobile,https://www.metu.edu.tr/,5807453,38396,2428,13622,6468,13892,91,46853,,2270,0.17
09_01_desktop,http://boun.edu.tr/,542869,2348,566,1665,1299,2322,27,2354,,0,
09_01_desktop,https://www.metu.edu.tr/,5587443,13059,1056,8231,2884,4253,106,17665,,414,
09_01_desktop,https://www.mynet.com/,1311211,5192,573,1554,1406,2504,130,9045,,651,
09_01_desktop,https://www.sabah.com.tr/,1811914,5411,407,2057,1569,2972,155,11089,,785,
09_01_desktop,https://hacettepe.edu.tr/,5152148,11429,1251,3979,2536,10126,48,11436,,21,
09_01_desktop,https://www.ankara.edu.tr/,11935035,19160,1475,15749,6072,16781,216,25467,,1247,
09_01_desktop,https://www.itu.edu.tr/,39537618,83122,961,7686,2530,8975,160,92498,,948,
09_01_desktop,https://www.haberturk.com/,4658295,5983,373,2413,837,1586,215,15357,,1867,
09_01_mobile,https://www.mynet.com/,6395431,26910,1737,30828,3714,21565,242,120705,,7076,0.23
09_01_mobile,http://boun.edu.tr/,1272244,8561,1512,16289,3815,6326,39,94859,,156,0.65
09_01_mobile,https://hacettepe.edu.tr/,5122011,44590,2653,8177,6100,15008,48,44608,,588,0.44
09_01_mobile,https://www.itu.edu.tr/,10404713,59927,2167,13810,6827,19430,135,72401,,3991,0.04
09_01_mobile,https://www.sabah.com.tr/,2190530,22578,2782,8365,6204,7247,146,34884,,3659,0.25
09_01_mobile,https://www.ankara.edu.tr/,8370807,58745,2639,50945,16014,48006,186,67027,,8661,0.01
09_01_mobile,https://www.metu.edu.tr/,5129070,35511,2726,13541,6765,9678,102,44681,,2193,
09_01_mobile,https://www.haberturk.com/,1642902,12919,1752,5553,3520,4544,112,33874,,3610,0.56
10_01_desktop,https://hacettepe.edu.tr/,4470042,8004,1151,6807,2468,4785,46,10701,,13,
10_01_desktop,https://www.haberturk.com/,5006382,7780,566,4078,1282,2057,219,18104,,2189,
10_01_desktop,https://www.ankara.edu.tr/,9058323,20797,1531,12907,6893,19538,177,23300,,755,
10_01_desktop,http://boun.edu.tr/,472674,2631,683,1961,1567,2651,27,2668,,0,
10_01_desktop,https://www.itu.edu.tr/,39702693,81686,796,6761,2461,8437,170,91179,,788,
10_01_desktop,https://www.metu.edu.tr/,5358275,11784,1010,7027,2711,3939,106,14175,,375,
10_01_desktop,https://www.cumhuriyet.com.tr/,6282200,26555,395,5604,1089,3063,587,33203,,8519,
10_01_desktop,https://www.sabah.com.tr/,1735542,7021,400,2753,2457,3455,151,11951,,1028,
10_01_desktop,https://www.mynet.com/,2150381,13898,913,2767,1852,3171,381,17822,,2250,
10_01_mobile,https://hacettepe.edu.tr/,3395020,20807,2596,20041,5390,10281,46,28984,,303,0.36
10_01_mobile,http://boun.edu.tr/,1229606,8307,1416,12406,3815,5081,39,94667,,196,0.72
10_01_mobile,https://www.haberturk.com/,2433911,16276,1960,6792,3607,4645,162,37998,,3322,0.54
10_01_mobile,https://www.metu.edu.tr/,5297785,34867,2435,13796,6323,9218,102,43997,,1607,0.14
10_01_mobile,https://www.cumhuriyet.com.tr/,4966939,39799,1716,16238,3445,6323,285,63331,,8844,0.11
10_01_mobile,https://www.ankara.edu.tr/,9035929,59060,2459,32372,16212,53346,174,66104,,3768,0.01
10_01_mobile,https://www.mynet.com/,7058331,34396,1828,26676,3982,25806,272,120526,,5520,0.22
11_01_desktop,https://www.haberturk.com/,5545116,7822,535,3210,1179,2122,251,18272,,2106,
11_01_desktop,https://www.metu.edu.tr/,5600824,12955,1024,10709,2836,3886,111,17010,,247,
11_01_desktop,https://www.itu.edu.tr/,49277227,100362,959,12734,2628,9267,163,111974,,1069,
11_01_desktop,https://www.mynet.com/,1325599,5079,561,1488,1252,2612,125,9902,,1554,
11_01_desktop,https://www.ankara.edu.tr/,22844124,43884,1414,22731,6553,43323,179,49440,,1236,
11_01_desktop,http://boun.edu.tr/,2225728,5746,684,2639,1665,6280,28,10334,,60,
11_01_desktop,https://www.sabah.com.tr/,1588656,5998,354,2144,1671,2618,151,11271,,888,
11_01_desktop,https://www.cumhuriyet.com.tr/,6662422,15883,570,3773,964,3642,456,28184,,5508,
11_01_desktop,https://hacettepe.edu.tr/,5651356,8206,820,5065,1802,3855,48,11332,,73,
11_01_mobile,https://www.itu.edu.tr/,12711429,70773,2139,9543,5855,12264,144,81353,,373,0.05
11_01_mobile,https://www.haberturk.com/,2323792,15765,2017,5919,3307,4296,158,38195,,118,0.11
11_01_mobile,https://www.sabah.com.tr/,2210619,22187,3313,9702,6976,8673,151,34144,,2675,0.29
11_01_mobile,http://boun.edu.tr/,10029891,11950,1581,20397,3641,9791,39,95195,,0,0.59
11_01_mobile,https://www.mynet.com/,7311281,46255,1971,27879,4262,31304,327,120725,,5230,0.22
11_01_mobile,https://www.metu.edu.tr/,5541753,37923,2751,15399,7142,8801,107,47054,,1371,0.17
11_01_mobile,https://www.cumhuriyet.com.tr/,6190012,42467,1509,18428,3361,7849,464,118390,,14614,
11_01_mobile,https://hacettepe.edu.tr/,11591193,69801,2202,38972,5313,7737,49,76222,,544,0.4
11_01_mobile,https://www.ankara.edu.tr/,8267972,54133,2430,29021,15020,48775,176,61772,,216,0.02
12_01_desktop,http://boun.edu.tr/,4096949,5685,722,3487,1784,5849,28,13397,,58,
12_01_desktop,https://www.metu.edu.tr/,5723823,13412,1054,7999,2885,4833,106,16406,,264,
12_01_desktop,https://www.itu.edu.tr/,5619308,11446,979,7161,2604,9870,144,15849,,444,
12_01_desktop,https://hacettepe.edu.tr/,13359657,22508,899,11968,1952,3741,50,24542,,118,
12_01_desktop,https://www.mynet.com/,16728025,58955,377,5909,1022,2502,470,63821,,2816,
12_01_desktop,https://www.sabah.com.tr/,1683787,5849,252,2123,1642,3243,147,15507,,440,
12_01_desktop,https://www.cumhuriyet.com.tr/,6239034,24750,463,5720,1166,2336,481,33667,,7971,
12_01_desktop,https://www.haberturk.com/,5516476,7522,610,4327,1102,1983,249,27467,,1283,
12_01_desktop,https://www.ankara.edu.tr/,8395115,18080,1303,10364,5895,16936,176,20540,,656,
12_01_mobile,https://www.haberturk.com/,2426999,14089,1904,5711,3343,4219,145,36985,,264,0.55
12_01_mobile,https://www.metu.edu.tr/,5664634,37417,2437,14125,6442,13590,102,47792,,148,0.14
12_01_mobile,https://www.ankara.edu.tr/,8397854,53699,2365,29454,14834,48332,173,61157,,819,0.01
12_01_mobile,http://boun.edu.tr/,17135968,11832,3434,27203,5935,8733,39,104914,,101,0.61
12_01_mobile,https://www.cumhuriyet.com.tr/,5468449,53042,1986,14824,3911,8841,360,96267,,18639,
12_01_mobile,https://hacettepe.edu.tr/,12147561,81425,2129,8921,4908,15381,45,89243,,584,0.37
12_01_mobile,https://www.sabah.com.tr/,2163470,21260,3035,8536,6854,7686,148,35439,,123,0.27
12_01_mobile,https://www.mynet.com/,6628892,37043,1816,28296,3593,23426,285,120156,,407,0.15
12_01_mobile,https://www.itu.edu.tr/,7384430,44505,2064,9506,5752,12475,132,51828,,297,0.06
1 Like

Many thanks for this data Rick, I really appreciate it!

Hi Rick, further to my previous comment, I want to thank you once again for the queries that you run so far. Since I need more historical data (for the wider time range and further websites) in order to get more reliable academic research results for my thesis, could you please advise whether it would be possible to get the historical data by June 2017 for below websites?

  1. sozcu.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  2. hurriyet.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  3. milliyet.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  4. sabah.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  5. mynet.com (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  6. haberturk.com (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  7. cumhuriyet.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  8. haber7.com
  9. sondakika.com
  10. haberler.com
  11. ku.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  12. sabanciuniv.edu (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  13. metu.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  14. bilkent.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  15. boun.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  16. itu.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  17. ankara.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  18. hacettepe.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great)
  19. istanbul.edu.tr
  20. anadolu.edu.tr

Thank you very much.

FWIW, it’s pretty easy to extract this information yourself from the CSV files provided on legacy.httparchive.org

Charlie

1 Like

It looks like none of these URLs were available in the dataset until July 2018, which is when we stopped using the Alexa top 1M and switched to the Chrome UX Report. Also note that many of the metrics weren’t measured until 2019 or later, like LCP and CLS.

In any case, hope this helps.

Query:

DECLARE URLs ARRAY<STRING> DEFAULT [
  'https://www.hurriyet.com.tr/',
  'https://www.milliyet.com.tr/',
  'https://www.sozcu.com.tr/',
  'https://www.ku.edu.tr/',
  'https://www.sabanciuniv.edu/',
  'https://www.bilkent.edu.tr/',
  'https://www.sabah.com.tr/',
  'https://www.mynet.com/',
  'https://www.haberturk.com/',
  'https://www.cumhuriyet.com.tr/',
  'https://www.haber7.com/',
  'https://www.sondakika.com/',
  'https://www.haberler.com/',
  'https://www.metu.edu.tr/',
  'http://boun.edu.tr/',
  'https://www.itu.edu.tr/',
  'https://www.ankara.edu.tr/',
  'https://hacettepe.edu.tr/',
  'https://www.istanbul.edu.tr/',
  'https://anadolu.edu.tr/'
];

SELECT
  _TABLE_SUFFIX AS date_client,
  url,
  JSON_VALUE(payload, '$._bytesIn') AS page_size,
  JSON_VALUE(payload, '$._loadTime') AS load_time,
  JSON_VALUE(payload, '$._TTFB') AS ttfb,
  JSON_VALUE(payload, '$._SpeedIndex') AS speed_index,
  JSON_VALUE(payload, '$."_chromeUserTiming.firstContentfulPaint"') AS fcp,
  JSON_VALUE(payload, '$."_chromeUserTiming.LargestContentfulPaint"') AS lcp,
  JSON_VALUE(payload, '$._requests') AS requests,
  JSON_VALUE(payload, '$._TTIMeasurementEnd') AS tti,
  JSON_VALUE(payload, '$._chromeUserTiming.CumulativeLayoutShift') AS cls,
  JSON_VALUE(payload, '$._TotalBlockingTime') AS tbt,
  JSON_VALUE(report, '$.categories.performance.score') AS performance_score
FROM
  `httparchive.pages.*`
LEFT JOIN
  `httparchive.lighthouse.*`
USING
  (_TABLE_SUFFIX, url)
WHERE
  SUBSTR(_TABLE_SUFFIX, 0, 10) BETWEEN '2017_06_01' AND '2021_03_01' AND
  url IN UNNEST(URLs)
ORDER BY
  date_client

The results are too big to share here, so here’s a Drive link:

Hi Rick, thank you ever so much for the queries that you run. This is really really much appreciated and I will definitely mention HTTP Archive to explain the source of the data in the methodology section of my master’s thesis :slight_smile:

1 Like