Importing Google Analytics data in Excel can be done with Excellent Analytics excel plugin. Already we had discussed about displaying Google Analytics data inside WordPress dashboard using Analytics 360 plugin, now to compare with your work details on Excel spreadsheet, you can import Google Analytics data. You can customize fully and get all the values.
Importing Google Analytics data in to Microsoft Excel can be done using a small addon named ‘Excellent Analytics’. First install Microsoft .Net framework 3.5 or 4, if you’ve installed already, then go to Excellent analytics page and download the plugin for your Microsoft Excel. You need Microsoft Excel 2007 and minimum of Windows XP or higher operating system.
Imported data is stored in the spreadsheet so you can sort, manipulate, and distribute data to anyone using Microsoft Excel. Use Microsoft Excel to combine web analytics data from Google Analytics with offline data from any other source. Excellent Analytics makes this easy.
Why should one import Google analytics data into Excel ? You can use this data and compare datas from multiple offline sources, use excel formulas, charts and pivot tables. You can also share workbook with other users.
To setup this Excellent Analytics plugin to your Microsoft Excel, you can look up here for the detailed tutorial.
Download Excellent Analytics Plugin
Similar : Alternative to Google Analytics
Liked this post? Got something to say? Share/Comment below. You can also Get Regular Updates. Subscribe to Free RSS Feeds or Email Updates. Follow us on Twitter @madrasgeek and Like us on Facebook.
{ 2 comments… read them below or add one }
Nice tutorial :)
Very fascinating, I have just written some Excel Training top tips, I hope they can help you.