{"id":2725,"date":"2017-03-13T22:02:10","date_gmt":"2017-03-14T02:02:10","guid":{"rendered":"http:\/\/www.leucht.com\/blog\/?p=2725"},"modified":"2017-03-13T22:34:16","modified_gmt":"2017-03-14T02:34:16","slug":"normalizing-google-analytics-data","status":"publish","type":"post","link":"http:\/\/www.leucht.com\/blog\/2017\/03\/normalizing-google-analytics-data\/","title":{"rendered":"Normalizing Google Analytics Data"},"content":{"rendered":"<p><a href=\"http:\/\/analytics.google.com\" target=\"_blank\">Google Analytics<\/a> is really awesome! \u00a0It tracks all the visitors to my website and gives me nice reports about the audience, the pages they are viewing, and the means they used to get to my site. \u00a0It&#8217;s completely invaluable for website owners and administrators!<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/analytics.google.com\" target=\"_blank\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-2727 size-full\" src=\"http:\/\/www.leucht.com\/blog\/wp-content\/uploads\/2017\/03\/google-analytics.png\" alt=\"\" width=\"705\" height=\"344\" srcset=\"http:\/\/www.leucht.com\/blog\/wp-content\/uploads\/2017\/03\/google-analytics.png 705w, http:\/\/www.leucht.com\/blog\/wp-content\/uploads\/2017\/03\/google-analytics-400x195.png 400w\" sizes=\"(max-width: 705px) 100vw, 705px\" \/><\/a><\/p>\n<p>BUT &#8230; the pageview data is not normalized. \u00a0Google lets me choose the date range and then it shows me all pageviews for that entire date range. \u00a0Even for pages and blog posts that didn&#8217;t exist during part of the date range. \u00a0This un-normalized pageview data is totally unfair to the newer content! \u00a0It&#8217;s not fair to compare 1,000 pageviews for a page that&#8217;s been around for 5 years to 1,000 pageviews for a second page that&#8217;s only been around for 5 months! \u00a0But this is how Google Analytics displays the data.<\/p>\n<p>While looking at the all-time top content on my personal leucht.com website recently, these were the all-time top pages or posts:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.leucht.com\/kurt\/shed\/\" target=\"_blank\">My Yard Shed<\/a> (static page) (19,914 views)<\/li>\n<li><a href=\"http:\/\/www.leucht.com\/seuss\/\" target=\"_blank\">Dr Seuss Nursery<\/a> (static page) (15,978 views)<\/li>\n<li><a href=\"http:\/\/www.leucht.com\/blog\/2009\/02\/gravity-boots-on-the-cheap\/\" target=\"_blank\">Gravity Boots on the Cheap<\/a> (blog post) (13,655 views)<\/li>\n<li><a href=\"http:\/\/www.leucht.com\/blog\/2013\/09\/vob-file-fixer-quickly-and-easily-fixes-incorrect-video-length\/\" target=\"_blank\">VOB File Fixer<\/a> (blog post) (11,444 views)<\/li>\n<li><a href=\"http:\/\/www.leucht.com\/annie\/\" target=\"_blank\">Annie 2001 at Cocoa Village Playhouse<\/a> (static page) (10,632 views)<\/li>\n<\/ul>\n<p>But when I took into account the birth date of each page, I got different results. \u00a0These are actually my most popular pages. \u00a0Not the list above.<\/p>\n<ul>\n<li><a href=\"http:\/\/www.leucht.com\/blog\/2013\/09\/vob-file-fixer-quickly-and-easily-fixes-incorrect-video-length\/\" target=\"_blank\">VOB File Fixer<\/a> (blog post) (8.9 views per day since created)<\/li>\n<li><a href=\"http:\/\/www.leucht.com\/blog\/2015\/02\/how-to-build-an-awesome-batmobile-pinewood-derby-car\/\" target=\"_blank\">Batmobile Pinewood Derby Car<\/a> (blog post) (7.2 views per day since created)<\/li>\n<li><a href=\"http:\/\/www.leucht.com\/blog\/2009\/02\/gravity-boots-on-the-cheap\/\" target=\"_blank\">Gravity Boots on the Cheap<\/a> (blog post) (4.6 views per day since created)<\/li>\n<li><a href=\"http:\/\/www.leucht.com\/blog\/2013\/05\/fix-your-loose-shifter-with-booger-bushings\/\" target=\"_blank\">Booger Bushings For Your Car<\/a> (blog post) (4.2 views per day since created)<\/li>\n<li><a href=\"http:\/\/www.leucht.com\/kurt\/shed\/\" target=\"_blank\">My Yard Shed<\/a> (static page) (3.1 views per day since created)<\/li>\n<\/ul>\n<p>I&#8217;m not surprised by the VOB blog post being in the number one spot. \u00a0I get a lot of feedback and people thanking me for posting that one. \u00a0But I&#8217;m really stoked about the Batmobile Pinewood Derby post being my 2nd most popular post! \u00a0That one was not on the radar in the initial Google Analytics report!<\/p>\n<p>So please, Google &#8230; please figure out a way to decide when each page got created (by looking at the first hit, maybe?) and then show me the pageviews per day over the life of each page. \u00a0That way, I can see the all-time velocity or all-time popularity of each and every page on my site as a fair comparison regardless of the age of the content.<\/p>\n<p>Thanks for listening,<\/p>\n<p>Kurt<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Analytics is really awesome! \u00a0It tracks all the visitors to my website and gives me nice reports about the audience, the pages they are viewing, and the means they used to get to my site. \u00a0It&#8217;s completely invaluable for website owners and administrators! BUT &#8230; the pageview data is not normalized. \u00a0Google lets me [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[109],"tags":[201],"_links":{"self":[{"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/posts\/2725"}],"collection":[{"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/comments?post=2725"}],"version-history":[{"count":10,"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/posts\/2725\/revisions"}],"predecessor-version":[{"id":2736,"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/posts\/2725\/revisions\/2736"}],"wp:attachment":[{"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/media?parent=2725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/categories?post=2725"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.leucht.com\/blog\/wp-json\/wp\/v2\/tags?post=2725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}