A reader made a special request via this comment for a tutorial that will replicate SEOmoz’s Historical Domain Analysis report. Although I try to keep my blog posts brief, I will go longer for special requests like this. 🙂 Without further adieu, let’s get going here … Export Report Step 1: After logging in to […]
Search Results for: excel
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 common one you’ll see is “Sum of” [original heading], although “Count of” is the default with non-numerical values. When you combine that with the wonky labeling the Google Analytics API […]
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 format as a percentage, they export as whole numbers. Sure, you could create a new column next to your data where you divide the number by 100 and then format as […]