Power Tools for the Analyst – Desktop Products2019-02-06T16:36:43-04:00

Power Tools for the Analyst – Desktop Products

NEXT Analytics desktop software, both macOS and Windows Excel, is the most powerful Excel Addin on the market today for downloading data from Google Analytics, Adwords, YouTube, Facebook,  Twitter, and more.

The data is downloaded directly from the data service to your desktop computer without an intermediate service, so your data is secure and you are not restricted to a certain number of accounts, volume or update frequency.

Techhnical users enjoy the ability to create powerful queries.

  • Google Analytics, you can produce multi-segment, multi-view reports quite easily. Data is downloadable in such a way as to avoid data sampling in many cases.
  • Facebook Posts, you can download a fan page’s posts and comments as well as valuable statistics. If you are the administrator of the page, you can see user information.
  • Facebook Ads gives you a thorough picture of campaigns, adsets, and ads.  You can get data at eany of those levels for: age, country, dma, gender, frequency, hourly stats by time zone, device, place, publisher_platform, platform position, device platform, product id, region, ad format, body, call to action, description, image, link, title, and video.
  • Adwords includes the fuil suit of reports available from Google. Within each one, you can picka nd choose which columns you want to download for.
  • Twitter followers and tweets of any user.
  • Youtube channels, playlists, and videos.

If you don’t want to build your own queries, we supply over 150 usable pre-built reports if you just want to use it without learning very much. We also offer a full-service consultancy.

If you build a spreadsheet, it can be uploaded to a Google Spreadsheet for data refresh and distribution there, or you can upload it to your Daily Refresh Service or Daily Database Update.

Download Desktop Products

Download the macOS Application
Download the Windows Excel Addin
Download Free Excellent Analytics PRO
Due to virus blockers, sometimes you need to download some files from Microsoft.

Subscribe to Desktop Products

Desktop Social

Social Media Only Edition $19.95, Billed Monthly

Facebook, YouTube and Twitter Only

Desktop Full Version – Monthly and Annual Subscriptions

Annual Subscription for 1 license – $440
Monthly Subscription for 1 license – $40
Annual Subscription for 5 licenses – $995
Monthly Subscription for 5 licenses – $95

Your credit card purchase is completed by Fastspring, a global eCommerce company based in California. No employee of Nextanalytics Corporation will ever see or handle your credit card number.

How to update the automated refresher program: “nxacmd”

Background: nxacmd is a Windows Console program that Windows Task Scheduler can start. This is all you need to have zero-touch fully automated data refreshes. INSTRUCTIONS to update NXACMD Lets assume the person who installed nxacmd created a directory named: c:\NEXT on your computer. Within that directory, there is a a subdirectory named NEXTFiles. Altogether, it is c:\NEXT\NEXTFiles. Within NEXTFiles, if you have one, that's where you old version of the program named nxacmd is. Step 1: Rename that folder [...]

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",   "formattingType":"FLOAT",   "alias":"Metric Expression" }] Segment Improvements, including Dynamic derived using sets of complex filter expressions, Sequences, where sequential conditions must be met, to analyze [...]

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. Windows Task Scheduler lets you choose which programs to run, and when to run them. You can use a program provided by NEXT Analytics [...]

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 Files. They will be uploaded into a new Google Folder. You can rename the Google Folder later by using Google Drive.   During the upload, [...]

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 Visit http://app.nextanalytics.com Register a new account Email ID Password You will need to know these values when you add a Data Source in Google Data [...]

Our Twitter download now supports full text extended tweets

Do you want to see more than 140 characters of a Tweet? The new version 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 can download new ones from the support page.