How To Use The Google Analytics API In Plain English

The data is exported into Excel in a range with headers that’s perfect for pivot tables and charts. (Excel 2011 for Mac still doesn’t support pivot charts. Too much lame, too little time.) You can also create regular, static charts from the data, too, if you’re on a Mac, but it’s better to create even static charts from a pivot table because you can easily change the headings in pivot tables. If you’re using Excellent Analytics for monthly reports, once you hit the first of the new month, you can update each data set by just clicking on the header, choosing Update Query, and clicking Execute. If you’ve built pivot tables and/or charts, you can choose Refresh All (under Data > Connections), and all of your tables and charts should update to match the new month’s data. It’s pretty slick. With the exception of dividing all rate values by 100, I don’t touch any of the raw data...