A blog article with an example of how the idea or concept can be used in practice.

How to Get a Simple and Efficient Data Refresh Solution

Attended Downloads Watch it working, but you can do other things at the same time. The first is a program that runs outside of Excel and it refreshes your spreadsheets.  We call this program "Standalone" and you can install it quite easily.   Download NEXT Analytics Standalone here. After you run setup, [...]

Adwords Campaigns Overview Top 10 by Spend Clicks Value

Adwords Campaigns Overview Top 10 by Spend, Clicks, and Value This fully automated report runs inside Microsoft Excel and helps you recognize which campaigns are your best and worst performers. It automatically fills in the report with data from your Adwords Account and publishes the result as an attractive PDF file or Excel file. Files can [...]

Example Dashboard shows 12 month trend for all Adwords Metrics available in Google Analytics in an Excel spreadsheet

How effective is your Adwords spend? Get a complete 12 month overview of everything that happened relating to Adwords. This easily customizable Dashboard runs inside Excel and is free for users of NEXT Analytics. Just download it, and one click later, you'll know how well your pay per click campaigns are doing. Download it Download [...]

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 [...]