How To Customize a Google Analytics Script

Explanation You can edit NEXT Analytics script directly. Many people find this faster, easier and even a bit fun. To get started, we will explain the following popular requirements: dimensions metrics change the numeric filters change the text filters change the numeric sort The advantage of doing this with NEXT Scripting is that it gets [...]

Dimensional Aggregation and Rollup Made Easy

To get the answers we want, sometimes it's desirable to rolled up or aggregate a overly detailed dimension. This can apply to any data source including Google Analytics, PIWIK, Facebook, Instagram, Twitter, YouTube, SQL Queries and more. To demonstrate the value of rolling up detailed dimensions, a good example would be web site referers. Referers [...]

Monthly Trend of Ecommerce Metrics (a Customizable Dashboard)

All of the metrics relating to Ecommerce, conveniently in one screen. Shows the trend of values for every metric over a 12 month period. Get the spreadsheet here:google-analytics-ecommerce-metrics Click the Refresh Data button on the ribbon bar. Your own data will show. Customize It Open the worksheet named “_actions”. Change the year and month to [...]

Google Adwords – Ad Group Analytics – Top Ranking and Long Tail Views

This sample spreadsheet lets you see the top ranking Ad Groups by month over one year. When you can see which months and which Ad Groups were performing better, you can imitate the winners and drop the losers. For each Ad Group, in each Month, you get the following data. Impressions aka ga:impressinos Ad Clicks aka ga:adClicks Ad Cost [...]

Re-Introducing Action Scripting

In response to customer requests, we've re-enabled and will support subscribers who wish to edit their actions scripts directly. This will be great news to a large portion of our user base and will greatly simplify the work involved for those people who want to build sophisticated dashboarding solutions. Up until August 25 2014, prior versions [...]