Adwords Update: May 2017, Latest Reports

During May 2017, Google released a new version of their Adwords interface. You can browse the reports that are now available, as well as the data columns that you can download using the Custom Query option. Data can be used in Excel, Google Data Studio, Power BI, and many other query and reporting tools. [...]

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

Our review of google data studio

You can quickly publish nicely laid out dashboards The primary benefit is the rapid delivery of working dashboards. It is a time saver for a web analyst, and gets web data into the hands of the business user. Someone who uses Google Data Studio can produce a dashboard with only a few hours of effort. Google Data [...]

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

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

Unlocking Cohorts in Web and Social Media Analytics

You don’t need to be Houdini to escape the limitations of your Analytics Service. You just need NEXT Analytics Free or PRO Excel Addin. Although this works equally well for PIWIK , consider this example using Google Analytics. NEXT Analytics can create a cohort much more powerful than Google Analytics, even using Google Analytics’ [...]

YouTube Minutes by Traffic Source

Which Traffic Sources drive the most YouTube minutes? This easy-to-understand YouTube Minutes by Traffic Source dashboard from NEXT Analytics gives you important data about where your most-avid viewers are coming from and how many minutes of your video they watch from that traffic source. YouTube search, suggested videos, annotation, YouTube playlist page, YouTube channel, advertising, [...]