Skip to content

Instantly share code, notes, and snippets.

View simonhearne's full-sized avatar

Simon Hearne simonhearne

112 followers · 6 following
View GitHub Profile
@simonhearne
simonhearne / countrydata.csv
Last active November 28, 2019 21:04
Continent_Name Continent_Code Country_Name Two_Letter_Country_Code Three_Letter_Country_Code Country_Number
Asia AS Afghanistan, Islamic Republic of AF AFG 4
Europe EU Albania, Republic of AL ALB 8
Antarctica AN Antarctica (the territory South of 60 deg S) AQ ATA 10
Africa AF Algeria, People's Democratic Republic of DZ DZA 12
Oceania OC American Samoa AS ASM 16
Europe EU Andorra, Principality of AD AND 20
Africa AF Angola, Republic of AO AGO 24
North America NA Antigua and Barbuda AG ATG 28
Europe EU Azerbaijan, Republic of AZ AZE 31
@simonhearne
simonhearne / countrycodes.tsv
Created November 28, 2019 18:21
name code
Afghanistan AF
Åland Islands AX
Albania AL
Algeria DZ
American Samoa AS
AndorrA AD
Angola AO
Anguilla AI
Antarctica AQ
@simonhearne
simonhearne / publisher_retention.json
Last active May 24, 2019 14:57
{
"$schema": "https://vega.github.io/schema/vega/v4.json",
"width": 1000,
"height": 500,
"padding": 5,
"autosize": "pad",
"config": {
"text": {
"font": "Ideal Sans, Avenir Next, Helvetica"
@simonhearne
simonhearne / publishers.tsv
Last active May 24, 2019 13:47
We can't make this file beautiful and searchable because it's too large.
website pagegroupname devicetypename goalcomplete bucket session_loadtime sticky_beacons session_persistence session_persistence_25 session_persistence_50 session_persistence_75 avg_page_homepage avg_page_position page_beacons page_timer session_length sessions beacons non_bounce_sessions bounces page_visit_time session_duration bounce_rate session_duration_minutes bucket_label retention_rate beacon_pc
1 article Desktop 0 100 15.5 0 0 0 0 0 1 1 6 2.5 1 6 6 0 6 2 2 100 0.03 0 - 100 ms 0 0.439516812
1 article Desktop 0 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100 - 200 ms 0 0.439516812
1 article Desktop 0 300 309 1 1 1 1 1 2.5 0.9 2 277 3 2 6 0 1 2 10 50 0.17 200 - 300 ms 0.5 0.439516812
1 article Desktop 0 400 887.6666667 0 0 0 0 0 3 1 1 399 3 1 3 0 0 10 29 0 0.48 300 - 400 ms 0 0.439516812
1 article Desktop 0 500 3325.666667 0 0 0 0 0 3 1 1 448 3 1 3 0 0 56 167 0 2.78 400 - 500 ms 0 0.439516812
1 article Desktop 0 600 2831.90129 2 2.5 1 1 4 4.25 0.940476166 12 558 4.666 12 52 2 1 77 343 10 5.72 500 - 600 ms
@simonhearne
simonhearne / cloudtest_map.json
Created May 22, 2019 15:57
{
"$schema": "https://vega.github.io/schema/vega/v5.json",
"width": 900,
"height": 500,
"autosize": "none",
"padding": 0,
"title": {
"text": "Akamai CloudTest Locations",
"zindex": 10
},
@simonhearne
simonhearne / vega_bar_chart.json
Last active April 8, 2019 21:27
{
"$schema": "https://vega.github.io/schema/vega/v5.json",
"width": 500,
"height": 200,
"padding": 5,
"data": [
{
"name": "table",
"values": [
@simonhearne
simonhearne / sessionlength.txt
Last active March 29, 2019 21:20
VALUE SESSIONLENGTH TIMEONPAGE FREQUENCY TIMER
1080 3.918 85967.68707 2893654 TTFB
130 3.565 55284.25907 6415567 TTFB
350 4.502 67985.82523 6540911 TTFB
3130 3.742 132983.3557 279583 TTFB
28250 2.664 109160.1052 734 TTFB
14040 3.436 224013.4462 4529 TTFB
23880 2.714 97144.72013 1083 TTFB
25410 2.862 112053.5454 946 TTFB
5820 3.351 85697.03011 51065 TTFB
@simonhearne
simonhearne / fcp_support.tsv
Created February 8, 2019 11:53
DEVICETYPENAME USERAGENTNAME USERAGENTVERSION OPERATINGSYSTEMNAME OPERATINGSYSTEMVERSION FCP_RATE ALL_COUNT
Mobile Mobile Safari 12 iOS 12 0.000015 265208957
Desktop Chrome 71 Windows 10 0.629841 109272185
Mobile Chrome Mobile 71 Android OS 8 0.606442 69121453
Mobile Chrome Mobile 72 Android OS 8 0.611726 61060262
Desktop Chrome 71 Windows 7 0.618671 52793481
Tablet Mobile Safari 12 iOS 12 0.000017 39392428
Desktop Chrome 71 Mac OS X 10 0.645654 36916187
Mobile Mobile Safari 11 iOS 11 0.003606 36858629
Mobile Chrome Mobile 63 Android OS 8 0.602324 34716913
@simonhearne
simonhearne / fcp.tsv
Last active February 7, 2019 20:57
DEVICETYPENAME FCP SESSIONLENGTH FREQUENCY
Tablet 24890 4.000 279
Mobile 2140 5.000 2626250
Tablet 4070 7.000 74741
Mobile 23960 2.000 2760
Desktop 13330 6.000 19258
Mobile 1630 7.000 3822063
Desktop 27680 8.000 5174
Mobile 8670 3.000 58813
Desktop 21040 7.000 9159
@simonhearne
simonhearne / device_matrix.tsv
Last active January 29, 2019 16:45
DEVICETYPENAME USERAGENTNAME OPERATINGSYSTEMNAME TTVR FREQUENCY
Tablet Pinterest iOS 4956.000 62592
Desktop Chrome Ubuntu 1588.000 264695
Mobile Cocolyzebot Android OS 7201.500 2780
Tablet Pinterest Android OS 6353.000 82400
Desktop IE Windows RT 7360.000 18983
Tablet Amazon Silk Android OS 6042.000 3779774
Tablet Puffin Linux 2470.000 27487
Desktop Spotify Mac OS X 487.000 3165
Tablet Firefox iOS iOS 4353.000 24962