Love the Pivot.
I flipped on my computer to give a quick glance at my clients’ analytics when I noticed a new option in the view bar:
Well, as soon as I saw that – my heart stopped.
Could it be the new pivot table feature I’ve been waiting on? Only one way to find out….
It keeps getting better.
I want to show you everything, but I also don’t want to be up all night writing this so I’m going to rip through some screenshots and then hopefully you can run along and experiment for yourself (assuming you’ve got access to this as well….)
Have you looked at the map location view by city and wondered ” I wish I could see which source brought the most visitors from that city…” only to realize that you’d have to create some advanced segment report to get that info? Not anymore you don’t.
Or how about this –
Which referring source sends the most engaged visitors from your top cities? This is a job for the pivot feature!
And it works on the goal conversions tabs as well….
Maybe I’m just way more geeky than most people, but I get giddy with this stuff.
So this is how it works from what I’ve messed with so far:
- The 2 gray drop-down boxes above the table are the Metrics you can choose from (don’t shoot me if I’m wrong. my brain is a little fuzzy right now…) – both boxes contain the same selections, but it doesn’t really matter too much because…
- The real attraction here is the pivot box (in blue – above the left column). It populates a row above the metrics you’re displaying – this brings the awesomeness.
- yes – you can export as well, but it may take a little more tweaking on my side to figure that out properly. Selecting a pivot dropdown for keywords for example, creates a long list of columns- but it appeared that on export I only got the columns visible on the screen. Maybe it’s best to use the API for those type of queries..
…and that’s all I know so far. OH – except that it appears that you have some really cool grouping features in your advanced segments as well. Advanced segments with pivot table features – all without leaving the browser. How could you NOT think this is awesome?