Our Twitter download now supports full text extended tweets

Do you want to see more than 140 characters of a Tweet? The new version 7.82.0.0 shows longer tweets. For background, see this: https://dev.twitter.com/overview/api/upcoming-changes-to-tweets If you want this, just download a new version. It's available to everyone, even the free users. If you already have an installation, you will need to upgrade your Twitter spreadsheets. You [...]

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

Avoid Google Analytics Data Sampling

This blog describes an easy and free technique to avoid Google Analytics Data Sampling without having to pay for Google Analytics 360 (aka Premium).  If you have Premium, it might save you from the two step process described here. Sampled data is wrong data. There's a lot at stake, if you are publishing wrong data! [...]

Handle High-Volume Downloads by Saving to a File

To handle high-volume downloads, NEXT Analytics saves to a file. Having data in a file lets you easily work in other applications or import the data into a database for use in a business intelligence data warehouse. This sample video shows how to download Twitter Followers of any Twitter user, even ones with millions of [...]

What can you do with Un-Sampled Google Analytics Data?

Download un-sampled google analytics data and store it in a personal or corporate database.  This gives you a full range of options for best-in-class tools that convert raw data into business intelligence. Microsoft, Tableau, Qliktech, IBM, SAP, and many other business intelligence tools. You probably have your favourites, or tools that you already own and are [...]

It takes just ten minutes to setup a personal database using free MYSQL

The install (including downloads) will probably take 10 minutes.  It pertains to software that's freely downloaded as of March 10, 2017.  Start by clicking this link and following it’s instructions. Accept all the defaults. https://www.python.org/ftp/python/3.4.0/python-3.4.0.amd64.msi Next, click this link and accept any prompts for Developer or any other default. https://cdn.mysql.com//Downloads/MySQLInstaller/mysql-installer-community-5.7.17.0.msi These steps take only about [...]

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