About Ward Yaternick

Founder of NEXT Analytics Corporation

Support for Version 4 of Google Analytics Reporting API 

Version 4 of the API lets you access the following new features: Multiple Date Ranges Show both for comparison; or Google will automatically subtract metrics to show the delta Histogram Buckets     "dimensions":[     {       "name":"ga:sessionCount",       "histogramBuckets":["1","10","100","200","400"]     }], Metric Expressions "metrics":[ {   "expression":"ga:goal1Completions/ga:goal1Starts",   [...]

Support for Version 4 of Google Analytics Reporting API  2017-12-19T08:49:25+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

Data Studio Connector

Nextanalytics gives access to data from Facebook, Instagram, Twitter, Google Analytics, Adwords, Bing, and Facebook Ads and more. The service is free, but there are additional options and capacity available to paying customers. The following paragraphs describe how to configure and then connect to the service from Google Data Studio. Configure Your Accounts and Default Profiles [...]

Data Studio Connector 2017-09-05T14:53:13+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 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

An Alternative Way to Create a Google Analytics segment

NEXT Analytics presents An Alternative Way to Create a Google Analytics Segment! A segment created by NEXT Analytics is just as powerful as one created using Google Analytics. In many ways it is more versatile and easier to administer. Perhaps you need a segment that doesn't exist, and you only need it for one query. Perhaps [...]

An Alternative Way to Create a Google Analytics segment 2017-05-08T14:07:23+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

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

Our review of google data studio 2017-04-25T03:27:43+00:00