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 […]
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:
Dark themed charts
Light themed charts
All the charts on one worksheet
There’s nothing to learn. Just is delete […]
Example Dashboard shows 12 month trend for all Adwords Metrics available in Google Analytics in an Excel spreadsheet
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.
It’s a simple Excel spreadsheet, so it’s easy […]
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.
Open the worksheet named “_actions”.
Change the year and month to a 12 month range […]
Google Analytics allows you to create subsets of your web site data; each one is known as a PROFILE. It’s quite common for companies to create a PROFILE for each operational division of their business. For example, this might mean each country unit has its own PROFILE. Alternatively, it might be something other than […]
After running setup, the software will guide you through authorizing data access, and choosing your default profile.
From then on, many reports will always use that default.
Changing the Default Profile
If you would like to change the default profile, simply select it from the profiles list and click “Save Default”
A dashboard with multiple profiles on it:
Frustrated that Google Analytics displays weekly metrics starting on Sunday? With NEXT Analytics, querying weekly data that starts on Mondays is easy—like “you’ve got to be kidding me” easy. In fact, you can tell NEXT to fetch weekly data starting on any day of the week. With NEXT Analytics, you’re in control.
Microsoft Excel: The Perfect Tool for Custom Reports and Dashboards
Excel is a useful tool for preparing and presenting data to managers in an organization.
Working in Excel means one less tool to keep track of
Excel is a familiar interface
Excel lets you combine data from multiple data sources
Use Excel formulas, charts, and pivot tables
Excel lets you […]
Why upgrade From Excellent Analytics?
Excellent Analytics is a free Excel Addin that brings Google Analytics directly into a spreadsheet. People love it and it’s free.
The problem is that it was last updated in 2012. The Google Analytics team has expanded what it provides, but the users of Excellent Analytics are still working with only the […]
Our new video showcases the speed and power of NEXT’s built-in custom queries tools. The 10-minute video showcases the NEXT Analytics Addin for Microsoft® Excel, covering how to build custom Web analytics and social media queries with Google® Analytics, Facebook®, Twitter, and YouTube™.