Last week I did a tweet with this image in it:
It shows a Google Sheet with some data per AdWords campaign and a little sparkline next to the numbers. It got much attention, and I got many requests to explain what I did there. So here it goes, I will explain some things about the Google Analytics API, how you use it in a Google Sheet and how to extract and query data from it. And last but not least: how to create the little sparklines.
One of the things I look at when I get a fresh new site to analyse is the linkstructure. All sites, and I repeat: all sites, should have a basic structure that looks like a simple tree diagram:
All pages link to one or more pages below them. This is the basis of your site's structure. I don't say it's the only structure, you could also interlink between different categories or products, but it's the main structure. It has the following advantages: