One nice option you have in Excel is the ability to drag series values down, saving you the time of entering individual values for well-known lists. … [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...]
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...]
- « Previous Page
- 1
- …
- 10
- 11
- 12
- 13
- 14
- …
- 16
- Next Page »