This past week I have been studying the Google Analytics data to determine the best topics to discuss in the upcoming month and to prepare the SAS Glo Fo 2012 conference. Google Analytics allows me to measure which posts get the most hits when posted and continue to be popular or referenced. I’ll unveil my little known, but highly coveted analytics process. How’s that for some hype? Getting the Google Analytics Data In a past article, I discussed how I extracted the data from Google Analytics using Excellent Analytics. The following figure shows my query in the Excellent Analytics tool, the data results, and the results in SAS Enterprise Guide. The data consists of the date, post path and title (with URL), source (how person came to site), and visitor type. It’s probably obvious why I would want the date, post, and source but what is not so obvious is visitor type. Visitor Type allows me analyze what topics bring new visitors to the site as well as the topics that retain visitors. Cleaning Up the Data My original plan was to use MS Excel to complete this analysis since I thought it would be simple. However, I realized that […]
Tag: reporting
Popular Posts, Stats, and Other Musings from 2011
Since September, Angela and I have been actively posting on this blog about the SAS Business Intelligence toolset. It has been a lot of fun and thanks to all of your encouragement and kind comments. I’ll share some stats with you data geeks t…