Skip to content

Instantly share code, notes, and snippets.

Simon Hearne simonhearne

Block or report user

Report or block simonhearne

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View publisher_retention.json
{
"$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"
View publishers.tsv
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
View cloudtest_map.json
{
"$schema": "https://vega.github.io/schema/vega/v5.json",
"width": 900,
"height": 500,
"autosize": "none",
"padding": 0,
"title": {
"text": "Akamai CloudTest Locations",
"zindex": 10
},
View vega_bar_chart.json
{
"$schema": "https://vega.github.io/schema/vega/v5.json",
"width": 500,
"height": 200,
"padding": 5,
"data": [
{
"name": "table",
"values": [
View 3pdb.sql
This file has been truncated, but you can view the full file.
INSERT IGNORE INTO thirdpartydb.group (name) VALUES ('Advertising'),
('Other'),
('Dynamic Content'),
('User Interaction'),
('Content Provision'),
('Analytics'),
('Financial Services'),
('Hosted Media'),
('Fraud & Security'),
View sessionlength.txt
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
View fcp_support.tsv
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
View fcp.tsv
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
View device_matrix.tsv
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
View ttvr_sessionlength_data.tsv
TTVR DEVICETYPENAME SESSIONPAGES FREQUENCY
19200 Tablet 5.634 35393
23400 Tablet 5.734 20884
44100 Desktop 4.306 15032
52200 Mobile 2.888 11555
47900 Tablet 4.155 2208
48900 Tablet 3.706 2158
25600 Mobile 3.634 78223
25400 Mobile 3.465 79474
19900 Mobile 3.739 159413
You can’t perform that action at this time.