How to Upload Excel files to Google Sheets so that their data can be refreshed by NEXT Analytics

Step 1 – start the relationship between Google Drive and your installation of NEXT Analytics   Step 2 – Tell Google that you give permission for your installation of NEXT Analytics for it to access your Google Drive   Step 3 – Click the upload button. You will be prompted for one or more Excel [...]

How to Upload Excel files to Google Sheets so that their data can be refreshed by NEXT Analytics 2017-11-28T18:28:15+00:00

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

Our Twitter download now supports full text extended tweets 2017-06-19T11:09:10+00:00

How to download Youtube Channels, Playlists, and Videos to Excel and BI databases

Download the data from public YouTube Channels, Playlists, and Videos. After installing the Excel Addin, click Custom then Click YouTube Data Choose where the data goes to. By default, it will put the data into a worksheet. You can change it later to put it into [...]

How to download Youtube Channels, Playlists, and Videos to Excel and BI databases 2017-06-16T16:17:30+00:00

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

Adwords Update: May 2017, Latest Reports 2017-06-04T06:33:58+00:00

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

How to Get a Simple and Efficient Data Refresh Solution 2017-06-01T09:20:03+00:00

How to Implement Unsampled Data Access using Analytics 360

After you have purchased Analytics 360, it is very convenient to continue with the interactive dashboards. But sometimes your requests result in sampling conditions (greater than 500,000) sessions. Click the button that appears on your ribbon bar (in Windows), and you can get more detail which query is being sampled. At that point, you need to [...]

How to Implement Unsampled Data Access using Analytics 360 2017-05-08T06:01:26+00:00

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

Avoid Google Analytics Data Sampling 2017-05-08T05:58:36+00:00

Google Analytics Multi-View Analysis

Main Reason to do Multi-View Analysis It's very common to hit the maximum number of goals that a View supports.  Web analysts will create additional Views as new Goals are introduced. They do this because they don't want to delete or re-use old goals because they are still historically relevant. Many people therefore would like [...]

Google Analytics Multi-View Analysis 2017-05-08T09:35:15+00:00

How To Avoid Google Data Sampling — For Free

Has your analytics run aground because you've started seeing Google Data Sampling appear? GOOGLE DATA SAMPLING - WHAT IS IT? When a web site experiences more than 500,000 sessions that covers the same time range as what you’re querying, then GA ignores some of your data. Google refers to this “sampled data”. The elimination of [...]

How To Avoid Google Data Sampling — For Free 2017-03-16T12:53:06+00:00

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

Dimensional Aggregation and Rollup Made Easy 2017-03-16T12:53:14+00:00