Create a gist now

Instantly share code, notes, and snippets.

@igrigorik /igvita.md Secret
Created Mar 25, 2012

What would you like to do?

igvita.com

Pageviews: 5740, Exit rate: 47.75%, Clickthroughs: 2098, Path: /

  7.68% - 441 pv : /2012/02/29/work-stealing-and-recursive-partitioning-with-fork-join/
  5.40% - 310 pv : /2012/01/18/building-a-modern-web-stack-for-the-realtime-web/
  4.91% - 282 pv : /archives/
  2.58% - 148 pv : /2012/02/06/sstable-and-log-structured-storage-leveldb/
  2.54% - 146 pv : /2011/12/19/dont-push-your-pull-requests/
  1.59% -  91 pv : /2012/01/05/google-web-toolkit-gwt-closure-nacl-dart-js/
  1.13% -  65 pv : /2011/08/16/rails-3-asset-pipeline-google-closure/
  1.05% -  60 pv : /2011/10/04/optimizing-http-keep-alive-and-pipelining/
  0.99% -  57 pv : /2011/10/20/faster-web-vs-tcp-slow-start/
  0.91% -  52 pv : /2008/11/13/concurrency-is-a-myth-in-ruby/

Pageviews: 3562, Exit rate: 79.67%, Clickthroughs: 431, Path: /2012/02/29/work-stealing-and-recursive-partitioning-with-fork-join/

  6.40% - 228 pv : /
  1.91% -  68 pv : /2012/02/06/sstable-and-log-structured-storage-leveldb/
  1.29% -  46 pv : /2012/01/18/building-a-modern-web-stack-for-the-realtime-web/
  0.48% -  17 pv : /2011/10/04/optimizing-http-keep-alive-and-pipelining/
  0.39% -  14 pv : /archives/
  0.36% -  13 pv : /2011/12/19/dont-push-your-pull-requests/
  0.25% -   9 pv : /2012/01/05/google-web-toolkit-gwt-closure-nacl-dart-js/
  0.11% -   4 pv : /2011/12/01/web-vpn-secure-proxies-with-spdy-chrome/
  0.08% -   3 pv : /2011/08/01/protocol-buffers-avro-thrift-messagepack/
  0.08% -   3 pv : /2011/10/20/faster-web-vs-tcp-slow-start/

Pageviews: 3093, Exit rate: 72.32%, Clickthroughs: 23, Path: /2008/04/14/custom-putty-color-themes/

  0.45% -  14 pv : /
  0.10% -   3 pv : /2012/02/29/work-stealing-and-recursive-partitioning-with-fork-join/
  0.06% -   2 pv : /download.php?file=http://www.igvita.com/downloads/igvita-light.reg
  0.03% -   1 pv : /2011/01/14/handlersocket-the-nosql-mysql-ruby/
  0.03% -   1 pv : /2011/12/19/dont-push-your-pull-requests/
  0.03% -   1 pv : /2012/01/18/building-a-modern-web-stack-for-the-realtime-web/
  0.03% -   1 pv : /archives/

Pageviews: 2204, Exit rate: 69.46%, Clickthroughs: 520, Path: /2012/01/18/building-a-modern-web-stack-for-the-realtime-web/

  7.21% - 159 pv : /
  3.13% -  69 pv : /2011/04/07/life-beyond-http-11-googles-spdy/
  2.99% -  66 pv : /2011/12/01/web-vpn-secure-proxies-with-spdy-chrome/
  1.41% -  31 pv : /2012/02/06/sstable-and-log-structured-storage-leveldb/
  1.32% -  29 pv : /2011/12/19/dont-push-your-pull-requests/
  1.18% -  26 pv : /2012/01/05/google-web-toolkit-gwt-closure-nacl-dart-js/
  1.09% -  24 pv : /2010/09/03/zeromq-modern-fast-networking-stack/
  0.91% -  20 pv : /archives/
  0.86% -  19 pv : /2009/12/22/ruby-websockets-tcp-for-the-browser/
  0.77% -  17 pv : /2012/02/29/work-stealing-and-recursive-partitioning-with-fork-join/

Pageviews: 1772, Exit rate: 87.47%, Clickthroughs: 52, Path: /2008/02/11/nginx-and-memcached-a-400-boost/

  1.19% -  21 pv : /
  0.51% -   9 pv : /2008/12/02/zero-downtime-restarts-with-haproxy/
  0.34% -   6 pv : /2012/02/06/sstable-and-log-structured-storage-leveldb/
  0.28% -   5 pv : /archives/
  0.11% -   2 pv : /2008/04/22/mysql-conf-memcached-internals/
  0.11% -   2 pv : /2008/10/07/asynchronous-http-cache-validations/
  0.11% -   2 pv : /2011/10/04/optimizing-http-keep-alive-and-pipelining/
  0.11% -   2 pv : /2012/01/18/building-a-modern-web-stack-for-the-realtime-web/
  0.06% -   1 pv : /2008/05/13/load-balancing-qos-with-haproxy/
  0.06% -   1 pv : /2012/02/29/work-stealing-and-recursive-partitioning-with-fork-join/

Pageviews: 1751, Exit rate: 73.50%, Clickthroughs: 301, Path: /2012/02/06/sstable-and-log-structured-storage-leveldb/

  5.94% - 104 pv : /
  2.80% -  49 pv : /2012/02/29/work-stealing-and-recursive-partitioning-with-fork-join/
  2.40% -  42 pv : /2012/01/18/building-a-modern-web-stack-for-the-realtime-web/
  2.17% -  38 pv : /2009/06/23/measuring-optimizing-io-performance/
  1.48% -  26 pv : /2011/08/01/protocol-buffers-avro-thrift-messagepack/
  0.63% -  11 pv : /archives/
  0.40% -   7 pv : /2008/02/11/nginx-and-memcached-a-400-boost/
  0.23% -   4 pv : /2011/10/04/optimizing-http-keep-alive-and-pipelining/
  0.23% -   4 pv : /2011/12/01/web-vpn-secure-proxies-with-spdy-chrome/
  0.23% -   4 pv : /2011/12/19/dont-push-your-pull-requests/

Pageviews: 1520, Exit rate: 75.79%, Clickthroughs: 183, Path: /2009/12/22/ruby-websockets-tcp-for-the-browser/

  3.49% -  53 pv : /2009/06/29/http-pubsub-webhooks-pubsubhubbub/
  1.91% -  29 pv : /2009/11/10/consuming-xmpp-pubsub-in-ruby/
  1.38% -  21 pv : /
  0.92% -  14 pv : /2009/10/08/advanced-messaging-routing-with-amqp/
  0.79% -  12 pv : /2012/01/18/building-a-modern-web-stack-for-the-realtime-web/
  0.59% -   9 pv : /2011/04/07/life-beyond-http-11-googles-spdy/
  0.46% -   7 pv : /2008/05/27/ruby-eventmachine-the-speed-demon/
  0.46% -   7 pv : /2009/08/18/smart-clients-reversehttp-websockets/
  0.46% -   7 pv : /2009/10/21/nginx-comet-low-latency-server-push/
  0.33% -   5 pv : /2011/08/26/server-sent-event-notifications-with-html5/

Pageviews: 1426, Exit rate: 79.10%, Clickthroughs: 154, Path: /2011/08/26/server-sent-event-notifications-with-html5/

  2.66% -  38 pv : /2011/03/08/goliath-non-blocking-ruby-19-web-server/
  2.38% -  34 pv : /
  1.05% -  15 pv : /2011/06/02/0-60-deploying-goliath-on-heroku-cedar/
  0.91% -  13 pv : /2009/12/22/ruby-websockets-tcp-for-the-browser/
  0.70% -  10 pv : /archives/
  0.49% -   7 pv : /2012/01/05/google-web-toolkit-gwt-closure-nacl-dart-js/
  0.42% -   6 pv : /2012/01/18/building-a-modern-web-stack-for-the-realtime-web/
  0.35% -   5 pv : /2011/10/04/optimizing-http-keep-alive-and-pipelining/
  0.28% -   4 pv : /2011/12/01/web-vpn-secure-proxies-with-spdy-chrome/
  0.21% -   3 pv : /2010/03/22/untangling-evented-code-with-ruby-fibers/

Pageviews: 1314, Exit rate: 75.72%, Clickthroughs: 172, Path: /2011/03/08/goliath-non-blocking-ruby-19-web-server/

  2.97% -  39 pv : /
  2.05% -  27 pv : /2011/06/02/0-60-deploying-goliath-on-heroku-cedar/
  1.90% -  25 pv : /2010/03/22/untangling-evented-code-with-ruby-fibers/
  1.52% -  20 pv : /2009/05/13/fibers-cooperative-scheduling-in-ruby/
  1.07% -  14 pv : /2011/08/26/server-sent-event-notifications-with-html5/
  0.38% -   5 pv : /2008/05/27/ruby-eventmachine-the-speed-demon/
  0.38% -   5 pv : /2011/10/04/optimizing-http-keep-alive-and-pipelining/
  0.30% -   4 pv : /2010/04/15/non-blocking-activerecord-rails/
  0.23% -   3 pv : /2008/12/27/scalable-datasets-bloom-filters-in-ruby/
  0.23% -   3 pv : /2009/12/22/ruby-websockets-tcp-for-the-browser/

Pageviews: 1288, Exit rate: 79.11%, Clickthroughs: 114, Path: /2011/08/01/protocol-buffers-avro-thrift-messagepack/

  2.56% -  33 pv : /
  2.10% -  27 pv : /2010/02/16/data-serialization-rpc-with-avro-ruby/
  0.85% -  11 pv : /archives/
  0.70% -   9 pv : /2012/02/29/work-stealing-and-recursive-partitioning-with-fork-join/
  0.62% -   8 pv : /2012/02/06/sstable-and-log-structured-storage-leveldb/
  0.47% -   6 pv : /2007/11/30/ruby-web-services-with-facebooks-thrift/
  0.31% -   4 pv : /2012/01/18/building-a-modern-web-stack-for-the-realtime-web/
  0.23% -   3 pv : /2009/06/23/measuring-optimizing-io-performance/
  0.23% -   3 pv : /2011/08/16/rails-3-asset-pipeline-google-closure/
  0.16% -   2 pv : /2011/04/20/intuition-data-driven-machine-learning/
require 'garb'
require 'pp'
#
# $> gem install garb
# $> ruby query.rb login@gmail.com pass UA-XXXXX-X
#
user, pass, property = ARGV
class TopPages
extend Garb::Model
metrics :pageviews, :visits, :exitrate
dimensions :page_path
end
class Destinations
extend Garb::Model
metrics :pageviews
dimensions :page_path
end
Garb::Session.login(user, pass)
profile = Garb::Management::Profile.all.detect {|p| p.web_property_id == property}
top = TopPages.results(profile, :limit => 10, :sort => :pageviews.desc)
top.each do |page|
destinations = Destinations.results(profile, {
:filters => {:previouspagepath.eql => page.page_path},
:limit => 100, :sort => :pageviews.desc
}).reject {|d| d.page_path == page.page_path }
total = destinations.reduce(0) {|t,v| t+=v.pageviews.to_i}
puts
puts sprintf("Pageviews: %d, Exit rate: %.2f%%, Clickthroughs: %d, **Path: %s**\n\n",
page.pageviews, page.exit_rate.to_f, total, page.page_path)
destinations.first(10).each do |dest|
prob = (dest.pageviews.to_f / page.pageviews.to_f) * 100
puts sprintf("%10.2f%% - %3s pv : %s", prob, dest.pageviews, dest.page_path)
end
end

vimgolf.com

Pageviews: 5418, Exit rate: 35.71%, Clickthroughs: 3001, Path: /

 10.21% - 553 pv : /challenges/4f438739f5a8d70001000019
  3.78% - 205 pv : /challenges/4f6144f46938f20001000061
  3.77% - 204 pv : /challenges/4f0720c8f037090001000007
  3.47% - 188 pv : /challenges/4f2be242779cbc000100000c
  3.10% - 168 pv : /top
  3.06% - 166 pv : /challenges/4f081a4ef037090001000074
  2.23% - 121 pv : /challenges/4ef209ef78702b0001000019
  2.05% - 111 pv : /challenges/4f026d9b50582b000100002e
  1.75% -  95 pv : /about
  1.35% -  73 pv : /clvv42

Pageviews: 891, Exit rate: 31.31%, Clickthroughs: 447, Path: /challenges/4f438739f5a8d70001000019

 34.90% - 311 pv : /
  5.16% -  46 pv : /about
  2.13% -  19 pv : /challenges/4f2be242779cbc000100000c
  1.46% -  13 pv : /federicogalassi
  0.67% -   6 pv : /top
  0.56% -   5 pv : /challenges/4f081a4ef037090001000074
  0.45% -   4 pv : /challenges/4ed3d247a745c1000100002a
  0.45% -   4 pv : /challenges/4f0720c8f037090001000007
  0.45% -   4 pv : /challenges/new
  0.34% -   3 pv : /JiriChara

Pageviews: 499, Exit rate: 51.70%, Clickthroughs: 200, Path: /about

 18.24% -  91 pv : /
  4.61% -  23 pv : /top
  3.61% -  18 pv : /challenges/4f438739f5a8d70001000019
  1.40% -   7 pv : /challenges/4f0720c8f037090001000007
  1.20% -   6 pv : /challenges/4ef209ef78702b0001000019
  1.20% -   6 pv : /challenges/4f2be242779cbc000100000c
  1.00% -   5 pv : /challenges/4f081a4ef037090001000074
  0.80% -   4 pv : /challenges/4dddc7c1ed7380000100000d
  0.60% -   3 pv : /challenges/4d1a1c36567bac34a9000002
  0.60% -   3 pv : /challenges/4d1a34ccfa85f32065000004

Pageviews: 386, Exit rate: 22.54%, Clickthroughs: 284, Path: /top

 25.65% -  99 pv : /
  8.81% -  34 pv : /Korvin79
  7.51% -  29 pv : /clvv42
  4.40% -  17 pv : /about
  2.33% -   9 pv : /federicogalassi
  2.07% -   8 pv : /yslinnctu
  1.81% -   7 pv : /h_east
  1.55% -   6 pv : /john_ababa
  1.30% -   5 pv : /_Balkoth_
  1.30% -   5 pv : /challenges/4e9edef5cef4c50001000007

Pageviews: 353, Exit rate: 25.50%, Clickthroughs: 188, Path: /challenges/4f0720c8f037090001000007

 35.69% - 126 pv : /
  5.38% -  19 pv : /about
  2.27% -   8 pv : /challenges/4f026d9b50582b000100002e
  1.13% -   4 pv : /challenges/4ef209ef78702b0001000019
  1.13% -   4 pv : /challenges/4f081a4ef037090001000074
  1.13% -   4 pv : /top
  0.57% -   2 pv : /captain_morgan
  0.57% -   2 pv : /challenges/4d716c76919202611400002b
  0.57% -   2 pv : /challenges/4ed3d247a745c1000100002a
  0.57% -   2 pv : /challenges/4f438739f5a8d70001000019

Pageviews: 306, Exit rate: 32.68%, Clickthroughs: 184, Path: /challenges/4f6144f46938f20001000061

 43.46% - 133 pv : /
  4.90% -  15 pv : /about
  2.61% -   8 pv : /challenges/4f438739f5a8d70001000019
  1.31% -   4 pv : /challenges/4f081a4ef037090001000074
  1.31% -   4 pv : /gumnos
  0.98% -   3 pv : /challenges/4f2be242779cbc000100000c
  0.98% -   3 pv : /top
  0.65% -   2 pv : /JiriChara
  0.65% -   2 pv : /challenges/4ddbd92898957e0001000016
  0.65% -   2 pv : /yoyoyojomo

Pageviews: 286, Exit rate: 28.32%, Clickthroughs: 180, Path: /challenges/4f2be242779cbc000100000c

 41.26% - 118 pv : /
  6.64% -  19 pv : /about
  3.85% -  11 pv : /challenges/4f081a4ef037090001000074
  2.45% -   7 pv : /top
  2.10% -   6 pv : /challenges/4f438739f5a8d70001000019
  1.40% -   4 pv : /challenges/4f026d9b50582b000100002e
  1.05% -   3 pv : /challenges/4ed3d247a745c1000100002a
  0.70% -   2 pv : /challenges/4ef209ef78702b0001000019
  0.70% -   2 pv : /challenges/4f0720c8f037090001000007
  0.70% -   2 pv : /challenges/4f6144f46938f20001000061

Pageviews: 235, Exit rate: 29.36%, Clickthroughs: 157, Path: /challenges/4f081a4ef037090001000074

 46.81% - 110 pv : /
  5.96% -  14 pv : /challenges/4f0720c8f037090001000007
  3.83% -   9 pv : /about
  2.55% -   6 pv : /top
  2.13% -   5 pv : /Korvin79
  1.70% -   4 pv : /challenges/4f026d9b50582b000100002e
  0.85% -   2 pv : /challenges/4e379f2fdfb67a000100002e
  0.43% -   1 pv : /Arton0306
  0.43% -   1 pv : /challenges/4ddbd92898957e0001000016
  0.43% -   1 pv : /challenges/4dddc7c1ed7380000100000d

Pageviews: 217, Exit rate: 29.95%, Clickthroughs: 66, Path: /challenges/4d1a34ccfa85f32065000004

 17.05% -  37 pv : /
  3.69% -   8 pv : /about
  1.38% -   3 pv : /igrigorik
  1.38% -   3 pv : /top
  0.92% -   2 pv : /challenges/4d1a4d82a860b7447200008d
  0.46% -   1 pv : /DarrenSFirth
  0.46% -   1 pv : /antonyscriven
  0.46% -   1 pv : /challenges/4d1a1c36567bac34a9000002
  0.46% -   1 pv : /challenges/4d1a522ea860b7447200010b
  0.46% -   1 pv : /challenges/4d1bdde3b2c3e0646800007f

Pageviews: 208, Exit rate: 30.77%, Clickthroughs: 112, Path: /challenges/4ef209ef78702b0001000019

 35.10% -  73 pv : /
  5.29% -  11 pv : /about
  3.85% -   8 pv : /challenges/4ed3d247a745c1000100002a
  0.96% -   2 pv : /challenges/4e5ec5851836e0000100003e
  0.96% -   2 pv : /challenges/4ea9bc988b36f70001000008
  0.96% -   2 pv : /challenges/4f0720c8f037090001000007
  0.96% -   2 pv : /ypcatw
  0.48% -   1 pv : /challenges/4d28637c4bcd032f1c00003d
  0.48% -   1 pv : /challenges/4dab05bff1161c5a78000011
  0.48% -   1 pv : /challenges/4ddbd92898957e0001000016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment