Follow along for 30 seconds and you will be well-rewarded!
Learn how to connect to Google Analytics from within Excel.
In this example, you’ll see how to request visitor type and Page Views. And then you are ten seconds away from seeing the trend of visitor types over the last few days.
Step 1: Start Nextanalytics’ Google Analytics Connector
Step 2: Login to Google Analytics (you need to know your google userid and Google Analytics password)
Step 3: Choose which Google Analytics dimsions and metrics you want. Hint: Keep any one report simple, use multiple specialized reports if you have broad analytical needs).
Step 4: The dates go on the columns automatically — the trend of each type of visit just leaps out at you
Step 5: See it as a chart… You can see for each day when the balance between new and repeat visitors shifted. What happened on those days? Was it a blog update? New graphics? A Press Release?
DONE — And it took less than 15 seconds! And I have valuable data sitting right here in Excel for me to do anything I want with it.