5 reasons To Download Google Analytics Data to Your Own Database

Your company uses services: CRM, HR, Ads, Marketing and many more services. Knowing this, management demands reports that blend the data from all these sources, including data from web and social media companies. You are the web analyst. That means you are knowledgable in the free reporting that’s available from Google, Facebook, Twitter, Instagram, [...]

5 reasons To Download Google Analytics Data to Your Own Database 2018-03-29T07:06:01+00:00

Use Windows Task Scheduler to Refresh the Data in a Google Sheet or Excel Spreadsheet

Windows Task Scheduler will run applications that do not need human interaction. Nothing needs to be clicked, there is no text to be entered. It’s perfect for when you want the data to be downloaded before you arrive at work. It can also be used to refresh data without using Excel on your computer. [...]

Use Windows Task Scheduler to Refresh the Data in a Google Sheet or Excel Spreadsheet 2017-11-30T08:22:20+00:00

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

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

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

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

Handle High-Volume Downloads by Saving to a File 2017-04-07T10:22:31+00:00

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

What can you do with Un-Sampled Google Analytics Data? 2017-03-16T12:52:57+00:00

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

It takes just ten minutes to setup a personal database using free MYSQL 2017-03-15T15:19:26+00:00