Google Analytics

Five Google Tools You Should Know

Google Adwords keyword tool: Generates search volumes and variations of your keywords. https://adwords.google.co.uk/o/Targeting/Explorer

Google AdWordsSearch Based Keyword Tool: See what keywords are on your site that people are already searching with on Google with this tool that compares your website content to actual search queries. Now part of Google Adwords keyword tool.

Google Insights for Search: Reports search trends over time. www.google.com/insights/search

Google AdWords AdPreview Tool: Preview your ads in real time as they appear on the search results. https://adwords.google.co.uk/d/AdPreview

Google Website Optimiser: Optimize your landing pages by evenly splitting web traffic between multiple pages to compare performance. www.google.com/websiteoptimizer

The latest version of Google Analytics have been live for some time now and the main advantage is speed! The graphs load fastr and the new menu is a lot more user friendly. Something that changed last week and I personally think is a great new addition is the Map Overlay. You can now see region level maps of over 170 countries! In order to access the map go to Visitors > Demographics > Location report. You can then see the regions for the country you are interested.

To go a level deeper to cities, just click “City”.  Another great feature that Google Analytics rolled out recently — a magnifying glass that appears when cities are clustered closely together. Great addition as in the old interface it was very hard to differentiate areas. For example when looking into London it was almost impossible to see the different areas.

When working in Google Analytics and trying to export more than 500 you face a problem where you cant export more than 500 rows of data. This is a problem for user with no access to Google Analytics tools for keyword expansion. A quick and easy way around this is by changing the URL.  This is very useful if you want to export for example a large number of non-paid keywords and adding them to your PPC campaigns.

If you have thousands of rows that require multiple exports, you can use the convenient workaround below to export all your rows in one go.

1. Navigate to keyword report
2. Change the query parameter ‘limit’ to the url, and hit enter to reload the report.
   For example: https://www.google.com/analytics/reporting/keywords?……………..&limit=5000
3. Hit ‘Enter’ and confirm that the report now has the new parameter appended to it. Please note there will not be any visible difference in user interface.
4. Select the Export tab, and click ‘CSV’ (remember not the option that says ‘CSV for Excel’).
5. The exported CSV should now contain all the rows from your keywords table.

This should give you 5000 rows of data in the CSV file.

Adwords Editor is a great tool for anyone spending more than an hour on PPC every day. The latest version makes it even easier to manage multiple accounts. Some of the features that I found great time savers:

• Ability to manage sitelinks, this is a time saver
• MCC features saving time to download and work with multiple accounts
• Targeting for high-end mobile devices (iPhone, iPad, Android and Palm) (Finally)
• Improved the management of spreadsheet uploads
• Keywords are all now on one tab with filters for “positives” and “negatives”
• Ability to remember your password for feature use

I believe at this stage Editor has most of the features as in the web interface. The only few minors things missing are the Impression share stats (for some reason they are not included). Maybe in the feature the ability to link Google Analytics with Editor (it would be great to be able to see bounce rate/page views).