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.
Most popular posts written in 2017
| 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% |
Most popular posts viewed in 2017
| 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% |