Normally, in Google Analytics, if you create a custom report and you need more than one dimension, you create drill-down dimensions like this: However, if you want to export that, you’re only going to see in the export whatever you see on your screen, i.e., a list of landing pages or a list of keywords […]
Search Results for: excel
How To Replicate An Moz Historical Domain Analysis Report
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 […]
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 […]