I use Google Analytics on my blog and now that the year is almost over it’s time for the annual tradition of sharing the top posts of the year. The total number of pageviews in 2017 was a remarkable 36,410, around the same I received in 2015 and 2016 but below those of 2013 and 2014 when I was both more lucky in the popularity of my posts while and more aggressive in promoting my writing on Hacker News. While I feel my writing has improved over the years I feel my content has atrophied and is something I’d like to correct in 2018. What’s interesting is that out of all the views this year, 17% were from posts written in 2017, 74% were from posts written in previous years, and the remaining 9% were from non post pages. One argument is that as I build up a larger stable of content it will keep growing in percentage every year. At the same time I should start seeing an overall growth in views which hasn’t happened over the past few years. A worthy goal is to keep growing the total number of views of previous years’ posts while also making sure the current year’s are driving even more views and become the evergreen content for the future.

On that note here are the most popular posts of 2017 - both written and viewed.

Page Pageviews Unique Pageviews Avg. Time on Page Entrances Bounce Rate % Exit
/2017/04/11/sql-is-the-perfect-interface/ 2559 2481 169.74 2474 97.01% 96.64%
/2017/03/26/fulfillment-by-amazon-counterfeiting/ 328 319 84.93 315 97.14% 95.73%
/2017/04/02/slacks-channel-exit-anti-pattern/ 296 291 46.00 288 96.18% 95.61%
/2017/06/20/getting-amp-into-rss/ 233 36 75.60 36 72.22% 14.59%
/2017/06/26/rss-finally-fixed/ 213 19 71.31 18 55.56% 8.92%
/2017/02/21/advice-for-coding-bootcamp-graduates/ 203 193 84.26 184 91.85% 88.67%
/2017/10/09/downloading-your-aim-buddy-list/ 166 147 408.00 144 90.97% 84.94%
/2017/04/16/amp-and-subscription-paywalls/ 155 135 67.48 133 94.74% 86.45%
/2017/05/04/security-across-multiple-aws-regions/ 99 99 104.00 96 96.88% 94.95%
/2017/05/10/using-options-to-play-snapchats-quarterly-results/ 99 97 64.50 97 95.88% 93.94%
/2017/08/08/google-docs-vs-confluence/ 90 90 107.38 84 96.43% 91.11%
/2017/01/26/shame-on-united-and-bank-of-america/ 77 75 171.25 69 95.65% 89.61%
/2017/02/28/lessons-learned-from-todays-s3-failure/ 75 70 80.33 60 88.33% 84.00%
/2017/01/16/powering-our-devices-using-the-human-body/ 72 67 41.25 66 83.33% 83.33%
/2017/07/04/thoughtful-code/ 59 44 79.55 40 90.00% 62.71%
/2017/07/23/the-wild-world-of-online-trackers/ 58 32 25.41 30 93.33% 53.45%
/2017/03/19/refactor-driven-development/ 56 54 186.00 52 94.23% 94.64%
/2017/02/04/identifying-product-weaknesses-using-google-autocomplete/ 51 51 2.00 49 100.00% 98.04%
/2017/02/19/math-is-incredible/ 51 36 71.23 25 76.00% 49.02%
/2017/02/26/my-snapchat-investment-strategy/ 45 37 192.47 26 88.46% 62.22%
Page Pageviews Unique Pageviews Avg. Time on Page Entrances Bounce Rate % Exit
/2013/08/26/extract-info-from-a-web-page-using-javascript/ 6964 6576 379.93 6564 94.65% 94.10%
/2017/04/11/sql-is-the-perfect-interface/ 2559 2481 169.74 2474 97.01% 96.64%
/2015/09/24/mapping-the-jersey-city-parking-zones-ii/ 1602 1411 154.03 1377 88.96% 87.64%
/2015/05/26/dealing-with-a-stripped-screw/ 1335 1287 272.61 1285 96.42% 96.33%
/2014/02/10/using-virtualenv-in-production/ 968 935 442.22 932 96.46% 96.28%
/2015/04/23/adding-columns-in-postgresql-and-redshift/ 964 930 255.42 929 96.56% 96.27%
/2013/01/09/web-scraping-like-a-pro/ 886 854 154.84 854 95.67% 95.82%
/2014/07/15/set-up-https-on-ec2-running-nginx-without-elb/ 849 819 412.23 819 96.83% 96.47%
/2013/06/21/where-are-you-on-the-sales-matrix/ 797 734 251.21 732 92.08% 91.72%
/2014/02/05/visualizing-gps-data-in-r/ 689 610 211.50 609 88.18% 88.10%
/2013/12/23/getting-a-sim-card-in-india/ 448 400 586.48 400 94.25% 88.84%
/2017/03/26/fulfillment-by-amazon-counterfeiting/ 328 319 84.93 315 97.14% 95.73%
/2015/05/26/dealing-with-a-stripped-screw/?usqp=mq331AQCCAE= 320 312 522.44 312 97.12% 97.19%
/2014/10/01/normalizing-a-csv-file-using-mysql/ 318 306 480.83 302 96.36% 96.23%
/2015/04/06/redshift-meets-excel/ 311 307 33.50 305 98.36% 97.43%
/2017/04/02/slacks-channel-exit-anti-pattern/ 296 291 46.00 288 96.18% 95.61%
/2015/04/26/aws-service-limits/ 271 265 546.78 263 97.34% 96.68%
/2015/09/24/mapping-the-jersey-city-parking-zones-ii/?usqp=mq331AQCCAE= 270 216 106.56 216 69.91% 69.63%
/2014/09/20/dealing-with-an-rds-replication-issue/ 244 234 452.00 234 96.15% 95.90%
/2016/01/10/cleanest-way-to-read-a-csv-file-with-python/ 238 229 384.55 228 96.49% 95.38%

Read more!