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 When you refresh spreadsheets with Excel, you can't do very much else with that computer while it is processing the data. That's why we offer a supplemental program that runs outside of Excel. You can refresh spreadsheets and download data with it and it won't lock up your computer during the downloads. The [...]

How to Get a Simple and Efficient Data Refresh Solution 2018-04-07T12:04:54+00:00

Google Analytics Goals Scorecard

Web analysts must create and maintain reports which show the how well a web site or app is achieving the business' objectives. This sample Google Analytics Goals Report shows goals data for current period, previous period and same period a year ago. This Google Analytics Goals report makes it easy to see if things are improving [...]

Google Analytics Goals Scorecard 2017-02-12T13:04:51+00:00

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

Adwords Campaigns Overview Top 10 by Spend Clicks Value 2017-02-12T13:05:55+00:00

Google Analytics Custom Events Dashboard and Reporting

Google allows you to store information about what a web visitor does while they are using your web site. By default, it gives you a wealth of information, but often you want to track things that are unique to your organization. They provide a couple of ways for you to store your own specific data [...]

Google Analytics Custom Events Dashboard and Reporting 2017-02-12T13:05:55+00:00

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

Example Dashboard shows 12 month trend for all Adwords Metrics available in Google Analytics in an Excel spreadsheet 2017-02-12T13:05:56+00:00

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

Monthly Trend of Ecommerce Metrics (a Customizable Dashboard) 2017-02-12T13:05:56+00:00

Reduce Google Analytics Page Bounces with Excel

How I Use Excel to Reduce Page Bounces and Improve My Conversions In my role as CTO of NEXT Analytics, I see a lot of dashboards going through my inbox. Over the years, I've seen literally thousands of dashboards, all built by experts from all over the world. I have a confession to make :), I don’t actually use [...]

Reduce Google Analytics Page Bounces with Excel 2017-02-12T13:05:59+00:00

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

Google Adwords – Ad Group Analytics – Top Ranking and Long Tail Views 2017-02-12T13:06:00+00:00

Google Analytics – All-in-one Dashboard

Get started in Analytics with this easy to use, easy to customize all-in-one dashboard it already has every single metric plotted for the past twelve months. Just click a button, and all your data shows up. It's easy to customize. There are three flavors of it, take your pick and customize one of them: [...]

Google Analytics – All-in-one Dashboard 2017-02-12T13:06:01+00:00