How to use Google Analytics Excel Plugin by Tatvic ?

by Dipali on October 8, 2009 · 1 comment

in Google Analytics,Web Analytics

I’m happy to announce that in next some couple days you’ll be visting website instead blog.  In my previous blog post described  about How to create google analytics custom reports ?, which is first blog post of customization of google analytics reports. today i am going to illustrated regarding Google Analytics Excel Plugin by Tatvic

I’ve been using this plugin since last month for data export and found it very useful. It has pretty useful features i.e. easy to use & install.

Another power full feature is you can export your analytics data in excel sheet for preparing web analytics report easier way.

Step 1: Register here for using Google Analytics Excel Plugin.

Step 2: Install  google analytics excel plugin on system, you may like to  visit how to install it ?

Step 3: After Installing GA Excel Plugin , you are ready for exporting your analytics data into Excel sheet for that you need to login in plugin from excel sheet. see below image for more information.

google-analytics-excel-plugin-login

Step4: After log in into your analytics account, you need to choose date range from which date to which date you need google analytics data.choose data range by week, by day or by month.

google-analytics-excel-plugin-date-range

Step 5: Choose dimensions and metrics  from given dimensions like keywords, Entrance paths and Exit paths and metrics like bounces, time on page and Entrances etc. as illustrated in below image.

google-analytics-excel-plugin-select-metrics

Step6:After choosing dimensions and metrics now you can it export it into your excel sheet by Selecting Output data as shown in below image.

google-analytics-excel-plugin-export-data

After selecting output data, all your analytics data will be exported in selected rows and columns.

I hope this information will help you out for customization of google analytics reports.

Suggestions and feedback are welcome for improving your reading experience on this blog. :)

You can ask any question related to Anil(Co founder of Tatvic Solutions) on Google Analytics Excel Plugin by commenting here.

If you enjoyed this post, I would be very grateful if you leave a quick comment below or subscribe via email or RSS or follow me on Twitter. Don't miss out on Web Analytics tips! - Dipali Thakkar

Related posts:

  1. Webinar -Google Analytics’ Newest Features
  2. Google Analytics come up with new feature Spot Light for Mobile App
  3. How to create google analytics custom reports ?
  4. Track iphone traffic through google analytics
  5. Have u noticed changes in Google Analytics?

{ 1 comment… read it below or add one }

1 Anil October 8, 2009 at 9:20 am

Dipali
Great write up! is’nt it easy to use tool!
Thanks for the write up! look forward for more feedback from you and your blog readers

[Reply]

Leave a Comment

Previous post:

Next post:

Get Adobe Flash playerPlugin by wpburn.com wordpress themes