Sunday, October 30, 2011

Export as CSV for Excel bug in new Google Analytics

Exporting data as "CSV for Excel" is providing data in improper format.
When opened in excel, the data shows up in single column like the below screenshot.

Notice how the data appears in a single column.
To fix this bug in Excel, select the column, then goto the Data tab.Then Click on the "Text to Columns" button as in screenshot.

Text to Columns feature in Excel for fixing the Google Analytics new version bug
Then follow the steps as in screenshots. Click Next on the first window.

Select comma as the delimiter and click Finish.
Select Ok in the confirmation box that opens.
The text will all be sorted out as in below screenshot.

Thats all.

For those who cannot follow all these steps, simply select "CSV" in the export option instead of "CSV for Excel". The CSV version does not club the columns in excel!

View and export more than 500 rows of data in Google Analytics

Google Analytics provides a maximum of 500 rows of data per page. This applies to all data within Google Analytics, such as , keywords, referrers, content pages etc.  Sometimes, the need comes to view and export more than 500 rows of data in a single page.

Google says that full data can be exported when we export as CSV.
But, sometimes, we need to see the maximum data in the web interface itself.

More than 500 rows can be fetched easily.Even Google officially recommends this for advanced users.
Remember that this trick no longer works in the older GA version. This will only work out in the newer GA version.
First,we need to get to the report page where we want more than 500 rows.Then change the row count from the default 10 to 500.

Screenshot of Google Analytics Keywords Page - Address bar parameter is highlighted in green
Notice the green highlighted area, it contains the parameter called explorer-table.rowCount%3D500

Change this 500 number to any number that is needed.Here, i am changing it into 600. You can change it into 6000, if your analytics profile has that much data.
Dont forget to press "Enter" after modifying this number.

Now, the page will display 600 rows, as in below screenshot.

Friday, October 28, 2011

Design update

Today, gets its latest design update.
This is the latest design.
Latest (2011 October) design of

Previous (2009  to 2011) design of

Lets see how this site looked in earlier years.

2006 Design of

2007 Design of

2008 to 2009 design of