If you have to run a report in Google Analytics that shows traffic over time, you'll need to use a custom report. Custom reports allow you to choose … [Read more...]
Change Dashes To Zeroes In Excel
I might be alone in this, but I hate seeing hyphens in lieu of 0's in tables and charts. Here's what it looks like: To change these … [Read more...]
Clean Up Data Labels From The GA API
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...]
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...]
Formatting Dates in Excel
You're not limited to the date formats built into Excel. You can format them however your heart desires. The underlying value (the exact date) will … [Read more...]