Top posts of 2018

2018-12-25 1 min read
    2018 Google Analytics blog stats

    In the usual end-of-year tradition I want to share the top posts of 2018 - including both the posts that were written in 2018 as well as the posts that may have been written in prior years but viewed in 2018. Given the fact that I’ve been extremely behind in writing this year and am only catching up now it’s clear that 2018 was a weaker year than previous ones. Sorting all pages viewed in 2018 by descending pageviews the first post written in 2018 is in the 57th spot - every other post was written in prior years. That bodes well to the concept of evergreen content but it’s still disappointing that I didn’t have any noteworthy posts in 2018. The lesson for 2019 is to actually write on time and spend the time going into depth versus the more superficial and shorter posts I wrote in 2018. On a positive note it’s good to see that my blog does get a healthy flow of organic traffic despite the weak 2018 showing.

    PagePageviewsUnique PageviewsAvg. Time on PageEntrancesBounce Rate% Exit
    /2018/02/20/analyzing-aws-elb-logs/7162114.385694.64%81.69%
    /2018/08/15/google-calendar-constantly-shipping/676681.255898.28%88.06%
    /2018/03/03/hunting-for-my-old-geocities-site/6356181.675188.24%80.95%
    /2018/04/28/rise-of-microbrands/4745105.103591.43%78.72%
    /2018/07/21/class-action-settlement-emails/424227.6739100.00%92.86%
    /2018/11/24/code-without-online-help/4141141.003997.44%95.12%
    /2018/11/25/aggressive-code-deprecation/3939432.253892.11%89.74%
    /2018/11/19/computer-history-books/37370.0036100.00%100.00%
    /2018/08/21/incognito-mode-chrome-vs-safari/363425.102386.96%72.22%
    /2018/01/16/phonetic-distance/3428319.222479.17%73.53%
    /2018/06/05/alb-and-elb-access-log-schemas-for-redshift/292614.441989.47%68.97%
    /2018/07/22/bulk-discounts-hurt-competition/292936.832391.30%79.31%
    /2018/07/07/mysql-foreign-keys/251021.102100.00%16.00%
    /2018/02/03/my-follower-factory/181681.67366.67%16.67%
    /2018/05/12/curse-of-the-early-adopter/161656.0010100.00%87.50%
    /2018/01/03/learning-docker/151555.295100.00%53.33%
    /2018/04/25/connect-four-bot-competition/151313.509100.00%73.33%
    /2018/01/28/moviepass-a-fascinating-business-model/141393.146100.00%50.00%
    /2018/05/14/memory-as-a-stack/141418.501100.00%28.57%
    /2018/03/11/crowdsourced-data/1313118.009100.00%92.31%
    /2018/02/09/making-the-most-of-the-subway-commute/121229.504100.00%66.67%
    /2018/06/01/type-1-and-type-2-tech-specs/121189.50580.00%50.00%
    /2018/06/28/using-personal-aws-credentials-in-production/111141.502100.00%45.45%
    /2018/03/18/facebooks-breach/101033.254100.00%60.00%
    /2018/05/26/power-of-shell-commands/101060.003100.00%40.00%
    /2018/07/29/privacy-vs-user-experience/10842.001100.00%40.00%
    /2018/08/18/yahoo-fantasy-football-stats-2018-2019-edition/109199.20366.67%50.00%
    /2018/07/10/in-a-software-world-humanity-comes-first/9920.004100.00%66.67%
    /2018/11/21/superhuman-review/9838.506100.00%77.78%
    /2018/04/12/load-testing/8853.752100.00%50.00%
    /2018/04/17/secure-at-the-network-level/8828.603100.00%37.50%
    /2018/10/13/equity-in-the-gig-economy/8745.603100.00%37.50%
    /2018/10/29/gmails-autocomplete/8725.003100.00%62.50%
    /2018/01/13/calendar-query-language/7716.334100.00%57.14%
    /2018/03/25/protecting-data-ouside-of-a-terms-of-service/7728.006100.00%85.71%
    /2018/04/03/open-sourcing-self-driving-car-data/7719.252100.00%42.86%
    /2018/01/23/design-anti-pattern-tab-switching-autosave/662.003100.00%83.33%
    /2018/02/25/retrieving-kindle-highlights/6493.502100.00%33.33%
    /2018/11/23/electronic-goods-are-cheaper-than-ever/660.005100.00%100.00%
    /2018/11/26/an-ad-on-the-google-search-homepage/6319.331100.00%50.00%
    /2018/11/20/my-dataengconf-2018-talk/5512.001100.00%80.00%
    /2018/02/10/optimize-for-keyboard-shortcuts/445.0000.00%50.00%
    /2018/10/25/just-ship-it/4424.0000.00%25.00%
    /2018/11/16/python-3-and-aiohttp/433.001100.00%75.00%
    /2018/12/11/the-price-of-aws-vs-github/4421.002100.00%50.00%
    /2018/11/12/social-security-administration-spoofing-scam/330.002100.00%100.00%
    /2018/11/13/a-ux-gem-in-google-slides/337.002100.00%66.67%
    /2018/11/22/historys-largest-empires/3350.001100.00%66.67%
    /2018/11/25/exploring-my-backlinks/330.003100.00%100.00%
    /2018/11/30/tragedy-of-the-commons-apartment-edition/3350.002100.00%66.67%
    /2018/12/03/overcoming-writing-rustiness/3236.5000.00%33.33%
    /2018/12/10/emr-vs-databricks-costs/3336.002100.00%66.67%
    /2018/12/13/counting-the-number-of-lines-of-code-in-a-github-account/3237.001100.00%66.67%
    /2018/11/14/what-messaging-war/222.0000.00%50.00%
    /2018/11/18/falling-behind-my-2018-blogging-goal/2248.00250.00%50.00%
    /2018/11/24/adding-optionality-to-products/220.002100.00%100.00%
    /2018/11/28/shell-history-2018-edition/220.001100.00%100.00%
    /2018/12/01/fat-specs-light-stories/2212.001100.00%50.00%
    /2018/12/06/conference-call-echoes/2221.0000.00%0.00%
    /2018/12/07/speech-recognition-and-a-bunch-of-apis/220.002100.00%100.00%
    /2018/12/14/state-of-tech-in-2018/220.0000.00%100.00%
    /2018/12/23/quoras-revenue-model/220.002100.00%100.00%
    /2018/11/15/limiting-tracking-in-email/1117.0000.00%0.00%
    /2018/11/17/random-quotes/110.001100.00%100.00%
    /2018/11/27/privacy-in-a-face-detection-world/110.001100.00%100.00%
    /2018/12/04/how-many-wifi-devices-do-we-have/1137.0000.00%0.00%
    /2018/12/05/the-golden-age-of-browsers/110.0000.00%100.00%
    /2018/12/08/automatic-login/116.0000.00%0.00%
    /2018/12/09/avoiding-content-overload/110.001100.00%100.00%
    /2018/12/09/the-modern-economy-relies-on-information/1123.0000.00%0.00%
    /2018/12/12/scenepeek/117.0000.00%0.00%
    /2018/12/15/new-code-is-not-a-linear-increase-in-complexity/117.0000.00%0.00%
    /2018/12/16/stuck-on-a-problem-take-a-break/110.001100.00%100.00%
    /2018/12/17/the-new-company-town/110.001100.00%100.00%
    /2018/12/18/i-finally-tried-an-electric-scooter/110.001100.00%100.00%
    /2018/12/19/facebooks-latest-hit/110.001100.00%100.00%
    /2018/12/19/new-iteration-of-devops/1157.0000.00%0.00%
    /2018/12/21/global-roaming/110.0000.00%100.00%
    /2018/12/22/hackerrank/110.001100.00%100.00%
    /2018/12/24/open-public-electronic-and-necessary-government-data-act/110.001100.00%100.00%
    PagePageviewsUnique PageviewsAvg. Time on PageEntrancesBounce Rate% Exit
    /2013/08/26/extract-info-from-a-web-page-using-javascript/74927104424.76709594.56%93.95%
    /2013/06/21/where-are-you-on-the-sales-matrix/30052727279.80272791.24%90.68%
    /2015/05/26/dealing-with-a-stripped-screw/14651413341.42141296.67%96.38%
    /2015/09/24/mapping-the-jersey-city-parking-zones-ii/1325103693.95103275.48%77.74%
    /2017/04/02/slacks-channel-exit-anti-pattern/972948229.5094897.36%97.12%
    /2015/04/23/adding-columns-in-postgresql-and-redshift/924886288.6188695.37%95.24%
    /2014/02/10/using-virtualenv-in-production/816789324.1278696.18%95.96%
    /2016/01/10/cleanest-way-to-read-a-csv-file-with-python/778732484.6973194.39%93.70%
    /2017/08/08/google-docs-vs-confluence/584572346.0657197.20%96.92%
    /2016/01/03/paris-versus-new-york-city/511494297.6049496.36%96.09%
    /2014/02/05/visualizing-gps-data-in-r/428379166.7037588.00%87.38%
    /2014/10/01/normalizing-a-csv-file-using-mysql/381358291.8835694.10%93.18%
    /2016/08/24/writing-scrapers-as-apis/32325962.9625652.73%56.04%
    /2016/08/21/downloading-your-turo-ride-history/318278181.6317988.83%77.99%
    /2017/11/07/spark-s-read-jdbc/276261320.7525793.00%91.30%
    /2013/01/09/web-scraping-like-a-pro/271260242.1425795.72%94.83%
    /2017/05/04/security-across-multiple-aws-regions/271266137.6026698.12%98.15%
    /2017/10/09/downloading-your-aim-buddy-list/221213420.2221396.24%95.93%
    /2016/02/15/design-your-database-for-flexibility/219214382.2221296.23%95.89%
    /2014/09/20/dealing-with-an-rds-replication-issue/212202180.2720295.05%94.81%
    /2016/03/10/the-mysql-enum-type/195191256.7118897.87%96.41%
    /2013/06/07/fun-with-prolog-priceonomics-puzzle/163150403.2015091.33%90.80%
    /2014/05/03/gap-fills-and-cross-joins-in-excel/161155468.5715596.13%95.65%
    /2016/10/10/setting-up-secor-for-kafka-010/153147231.5614693.84%94.12%
    /2016/05/11/identifying-unused-database-tables/150143305.2514295.07%94.67%
    /2016/07/17/coding-puzzle-word-transformation-through-valid-words/146134195.9213491.04%91.10%
    /2013/08/24/splitting-an-aws-account/143140201.8013598.52%96.50%
    /2013/05/17/adding-attachments-to-django-postman/140128299.3812692.86%90.71%
    /2017/06/30/send-private-messages-to-all-members-of-a-slack-channel/134111186.3410978.90%78.36%
    /2013/07/17/scraping-yahoo-fantasy-football-stats-with-scrapy/133131132.0013096.92%96.24%
    /2017/04/16/amp-and-subscription-paywalls/127120146.6011794.02%92.13%
    /2011/01/08/fun-developer-interview-question/124114412.4211489.47%90.32%
    /2016/12/31/amazons-peer-to-peer-marketplace/117111157.6711093.64%92.31%
    /2017/07/08/yahoo-fantasy-football-stats-2017-2018-edition/114101161.1310089.00%86.84%
    /2013/04/12/why-dont-cellphones-have-a-dialtone/113108343.2010895.37%95.58%
    /2017/06/20/getting-amp-into-rss/110102227.4310192.08%87.27%
    /2017/12/01/measuring-sprint-efficiency/110108301.8310696.23%94.55%
    /2014/07/15/set-up-https-on-ec2-running-nginx-without-elb/10710487.3310497.12%97.20%
    /2014/01/04/visualizing-runkeeper-data-in-r/10490357.768984.27%83.65%
    /2016/09/13/supporting-disqus-in-amp/1037577.107372.60%70.87%
    /2013/12/23/getting-a-sim-card-in-india/9896253.509596.84%95.92%
    /2015/04/26/aws-service-limits/928779.228396.39%90.22%
    /2014/12/31/redirect-recursion/9190143.008998.88%98.90%
    /2016/12/24/comparing-public-transit-systems-new-york-vs-london/9188506.338897.73%96.70%
    /2014/05/02/migrating-from-linode-to-digital-ocean/8580294.178092.50%92.94%
    /2017/02/21/advice-for-coding-bootcamp-graduates/8483808.508297.56%97.62%
    /2016/08/29/food-identification-with-googles-cloud-vision/8374109.707489.19%87.95%
    /2016/11/13/recursive-redirects-with-aws-lambda/8275237.007493.24%89.02%
    /2016/12/10/word-clouds-and-text-similarity/7873422.337391.78%92.31%
    /2015/11/22/why-are-netflix-and-spotify-so-different/7674516.007497.30%97.37%
    /2017/04/23/the-golden-age-of-big-data-tools/7466251.566689.39%87.84%
    /2018/02/20/analyzing-aws-elb-logs/7162114.385694.64%81.69%
    /2014/09/16/top-down-vs-bottom-up-coding/686729.506797.01%97.06%
    /2016/04/03/ben-thompsons-laddering-up-and-building-bigger-moats/686072.205986.44%85.29%
    /2018/08/15/google-calendar-constantly-shipping/676681.255898.28%88.06%
    /2013/08/28/simplicity-vs-power-in-product-design/666453.891283.33%46.97%
    /2016/05/21/analyzing-imdb-data-step-1-cleaning-and-qa/656476.545490.74%80.00%
    /2017/01/26/shame-on-united-and-bank-of-america/646337.006398.41%98.44%
    /2018/03/03/hunting-for-my-old-geocities-site/6356181.675188.24%80.95%
    /2015/02/01/mysql-vs-postgresql-sort-order/6156394.605592.73%91.80%
    /2014/05/16/examining-ssh-login-requests/5954657.205490.74%91.53%
    /2016/05/22/analyzing-imdb-data-actors-vs-actresses/585146.634967.35%67.24%
    /2016/11/27/visualizing-your-aws-costs/585358.505292.31%89.66%
    /2017/03/19/refactor-driven-development/5650104.335090.00%89.29%
    /2017/04/11/sql-is-the-perfect-interface/504530.004182.93%78.00%
    /2016/09/05/visualizing-fantasy-football-stats/4946126.334493.18%93.88%
    /2015/06/09/a-mysql-group-by-nuance/484717.004495.45%95.83%
    /2016/06/22/messaging-app-fragmentation/484081.334087.50%81.25%
    /2017/05/10/using-options-to-play-snapchats-quarterly-results/4746146.004597.78%97.87%
    /2018/04/28/rise-of-microbrands/4745105.103591.43%78.72%
    /2014/03/18/goodbye-gmail/4644647.204488.64%89.13%
    /2016/12/13/automatically-taking-screenshots-of-html-elements/4645157.674593.33%93.48%
    /2017/11/23/improving-jekyll-generation-speed-for-amp-pages/4642118.574283.33%84.78%
    /2016/03/05/aws-ec2-instance-arbitrage/4441137.004192.68%90.91%
    /2016/06/18/aws-stripe-and-wework/444356.004297.62%95.45%
    /2017/04/08/quality-over-quantity-nextdoor-vs-craigslist/444199.004092.50%88.64%
    /2013/11/15/rds-and-r/4240901.504095.00%95.24%
    /2014/04/04/postgresql-fibonacci/4239607.003992.31%92.86%
    /2018/07/21/class-action-settlement-emails/424227.6739100.00%92.86%
    /2018/11/24/code-without-online-help/4141141.003997.44%95.12%
    /2015/04/06/redshift-meets-excel/40407.0039100.00%97.50%
    /2015/04/19/dont-scrape-into-a-dropbox-folder/4039196.003997.44%97.50%
    /2016/06/11/following-up-on-a-website-optimization-offer/4032174.223278.13%77.50%
    /2018/11/25/aggressive-code-deprecation/3939432.253892.11%89.74%
    /2013/08/02/a-brief-history-of-manufacturing/3838186.003797.30%97.37%
    /2015/05/26/dealing-with-a-stripped-screw/?usqp=mq331AQECAEYAQ==38380.0038100.00%100.00%
    /2018/11/19/computer-history-books/37370.0036100.00%100.00%
    /2013/06/21/where-are-you-on-the-sales-matrix/?usqp=mq331AQECAEYAQ==3631364.803183.87%86.11%
    /2018/08/21/incognito-mode-chrome-vs-safari/363425.102386.96%72.22%
    /2017/02/09/traffic-efficiency/353456.503494.12%94.29%
    /2017/10/20/schedule-automation-using-google-spreadsheets-and-slack/352934.552875.00%68.57%
    /2018/01/16/phonetic-distance/3428319.222479.17%73.53%
    /2015/05/30/date-range-generation/312835.402692.31%83.87%
    /2016/04/05/the-best-code-is-no-code/3029715.002996.55%96.67%
    /2014/08/30/managing-settings-files-in-django-projects/2929713.002996.55%96.55%
    /2016/06/06/word-clouds-in-r/292890.002696.15%89.66%
    /2018/06/05/alb-and-elb-access-log-schemas-for-redshift/292614.441989.47%68.97%
    /2018/07/22/bulk-discounts-hurt-competition/292936.832391.30%79.31%
    /2013/11/23/im-joining-triplelift/282616.502568.00%64.29%
    /2017/09/09/apartment-rental-arbitrage/282692.502692.31%92.86%