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…

Gettin’ Certified: Google Analytics & AdWords

Observations on Google Analytics IQ and Google Advertising Professional Qualified Individual Exams In the search marketing business we all work hard to deliver the goods and continuously improve our skills – we need to in order to  stay relevant in a rapidly changing environment and to demonstrate our value to our employers/clients.  We can let…