One annoying idiosyncrasy of pivot tables is that all of the headings are prepended with a label indicating how the data is summarized. The most … [Read more...]
Archives for November 2012
Do Math On The Fly In Paste Options
One annoyance with using the Google Analytics API is that it doesn't format percentages correctly. Instead of coming in as fractions that you just … [Read more...]
How To Convert Google Analytics’ Funky Month of Year Format In Excel
UPDATE: Since I've had a couple questions about how to display the date as just the month and year, I created a Google Sheet demonstrating several … [Read more...]
See What Social Networks Drive Traffic To Your Site
Want to know which social networks are driving traffic to your site in Google Analytics? You can find out a couple different ways: Navigate to … [Read more...]
Sites Google Analytics Includes In Social Reports
UPDATE: According to a Google Analytics webinar on Aug 29, 2012 (at the 25:48 mark), there are roughly 400 social networks. So, even as obscure as … [Read more...]