Using PadiTrack to Measure Site Navigation

PadiTrack is an easy to use, free tool that enables you to extend Google Analytics with more flexible goal funnels and other navigation path tracking. PadiTrack offers several advantages over Google Analytics for setting up goal funnels: 1. Historical data – with Google Analytics, setting up a goal funnel means the data is reported starting…

New Ways to See AdWords Search Query Terms

As part of Google’s phasing out of the AdWords Report Center, the traditional ‘Search Query Performance’ report is no longer available. But there are new and better ways to get this critical data! Using Google AdWords reports to track performance of the keywords you are bidding on is fundamental to search marketing success, and the…

Pulling Data from Google Analytics API, Pt. 2: Tatvic

Part II in a series looking at getting data from Google Analytics into Excel via the API Part 1: VBA macros Tatvic GA Excel Plug-in The Tatvic GA Excel Plugin requires users to download and install a plugin in order to extract data from the Google Analytics API, unlike the VBA macro approach.  In exchange…

Pulling Data from Google Analytics API, Pt 1: VBA Macros

As mentioned back in April, the release of the Google Analytics Data Export API was bound to lead to a variety of options for accessing/manipulating GA data without going through the interface.  More recently, the Google Analytics Blog did a quick list of some of the approaches that are now available for extracting GA data…

Breaking the 500-Row Barrier in Google Analytics

Google Analytics has many strengths as an analytics tool, but it has its limitations. A major one has been the restriction of only being able to export 500 rows of a report at a time.  For example, the screenshot below shows that the report for Site Search Terms has over 22,000 rows, yet we can…