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 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

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

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

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

Unlocking Cohorts in Web and Social Media Analytics 2017-03-16T12:53:28+00:00

The One Common Social Media Oversight Everybody Makes

Success has always been about listening to customers. In the old days, product and messaging was done by word of mouth and a personal touch. Nowadays, you can analyze the content of Fan Pages comments and Group Discussions. Social Media Users Are a Gold Mine of Information With social [...]

The One Common Social Media Oversight Everybody Makes 2017-03-16T12:53:47+00:00

Competitive Analysis of Facebook Fan Pages

Gather marketing intelligence by Analyzing Facebook Fan Pages Anything visible on someone's fan page is available to NEXT Analytics for data mining. You can get valuable information about almost anyone or anything: competitors markets brands individual properties Filter, pivot, and sort using any publicly available metric... Page [...]

Competitive Analysis of Facebook Fan Pages 2017-02-12T13:04:53+00:00