How-to use Analytics

March 31, 2010

Anybody can be a Google Analyst !

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.


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Blog at

%d bloggers like this: