Changes to the Google Analytics API Coming
Friday, 18 May 2012 07:43

Google is making changes in the coming month that will affect users of older versions of Next Analytics for Excel. If you are still running Next Analytics with the old account/password combination (as opposed to the new Google Account login), we strongly recommend that you upgrade to the latest release.

Reference: http://analytics.blogspot.ca/2012/05/reminder-migrate-to-new-core-reporting.html

Late in 2011, Google changed the programming interface to their Google Analytics servers as part of the integration of the accounts across all of Google’s services. Next Analytics has continued to track and adapt to these changes, and our current release is fully compliant with Google’s preferred authentication methods. 

Upgrading to Next Analytics for Excel 4.3 gives you:

  • Backward compatibility with previous releases so all your existing reports will continue to refresh
  • Widget approach lets you quickly build custom reports in Excel without complicated formulas
  • Over 50 widgets included and everything you need to make your own
  • With the Google Analytics option:
    • Full compliance with the new Google Account authentication methods
    • Access to all the Google Analytics dimensions and metrics available (more are coming ‘soon’)
    • New for-each date capability lets you minimize ‘fast access mode’ data sampling
  • With the Facebook option:
    • Full access to all of the latest Facebook Insights metrics
    • New widgets let you download posts and comments from any fan page

Go to our Upgrade page for instructions and to download this latest release at your earliest convenience. Upgrades are free if you purchased within the past 12 months. Renewal discounts are available for existing customers.

 
Next Analytics for Excel 4.3.1 Update
Friday, 18 May 2012 07:31

Now the most impressive web and social media reporting add-in for Microsoft Excel continues to lead the pack! Next Analytics for Excel 4.3.1, available as a free upgarde to all licensed users, includes the ability to compare Google Analytics current period measures to the previous period or year-ago period in one step! A simple check of the box is all it takes.

For you Facebook fans, it also lets you pull in Facebook Insights metrics for multiple fan pages all at once. Just pick from the list of your fan pages listed, and Next Analytics does all the work. Speed up your reports and get rid of the distraction of daily variations with week-to-week reporting. Download all your fan page messages and comments -- we have a widget for that (and many, many more)! 

Licensed users can always get the latest release from our Upgrade page. Stay current with the latest widgets and API changes.

 
Next Analytics for Excel 4.3 Release
Friday, 11 May 2012 10:50

Over 2 years of refinement and evolution - Next Analytics for Excel 4.3 continues to solve your reporting challenges.

Build your own custom report or dashboard inside Excel without tedious downloading or complicated Excel formulas. Our exclusive widget approach makes it easy to build reports that show the metrics you want for your web site, and just as easily include metrics for other websites, Facebook Insights, Twitter and more! 

In this release:

  • added new for-each period query for Google Analytics to reduce sampling errors
  • for-each also enables weekly queries that start on Mondays!
  • improved Facebook Insights queries
  • improved Facebook query fault tolerance
  • new widget included downloads Facebook wall posts and comments for any fan page

Available free to all licensed customers that purchased or renewed in the past 12 months.

 
Next Analytics for Excel 4.2.2 Update
Tuesday, 01 May 2012 18:51

The best Microsoft Excel add-in for web and social media reporting just got better! Next Analytics for Excel 4.2.2, available to all licensed users, includes new widgets for the analysis of Facebook wall content. Now you can see how your posts have been talked about by others over time. See which posts got the most attention, and how different types of posts fared. Use the widgets with your competitors fan pages for a comparative analysis.

Licensed users can always get the latest release from our Upgrade page. Stay current with the latest widgets and API changes.

 
Next Analytics for Excel 4.2 Release
Wednesday, 11 April 2012 16:30

The best Microsoft Excel add-in for web and social media reporting just got better! Next Analytics for Excel 4.2 makes it even easier to build your own custom report or dashboard inside Excel without tedious downloading or complicated Excel formulas. Our exclusive widget approach makes it easy to build reports that show the metrics you want for your web site, and just as easily include metrics for other websites, Facebook Insights, Twitter and more!

In this release:

  • improved handling of your goals and custom variables
  • reporting is easier with default Facebook page, application and domain settings
  • new widget preview tab makes adding widgets even easier
  • widgets are now in folders to make it easier to find and organize
  • can now save multiple queries to a single worksheet
  • many usability improvements based on user feedback

With these changes, we are also making available a low cost version specifically for single web site owners.

Available free to all licensed customers that purchased or renewed in the past 12 months.

 
New Google Analytics Widgets Released
Tuesday, 20 March 2012 11:17

We are releasing a whole new series of widgets for Google Analytics reporting in Microsoft Excel. These Next Analytics widgets provide a wide coverage of all the 'usual' reporting elements you find in Google Analytics:

  • Visitors overview
  • Visitors trend
  • Visitors frequency and recency
  • Sources search engines
  • Sources referring sites
  • Sources keywords
  • Goal conversions summary
  • Ecommerce product performance
  • Content landing pages
  • and many, many more...

The new widget package also includes a number of only-from-Next-Analytics specials liike:

  • Screen resolution grid showing % of visits in an easy to read width x height format
  • Visitors scorecard with previous month and year ago comparisons
  • Time-of-day versus Day-of-week report
  • Trend charts for each of your top referring sites
  • Events actions by category report
  • Landing page performance for direct, search and referral sources

Multiple widgets can added to your existing Excel workbooks and refreshed with a single click. Next Analytics automates both the data download and the analytic transformations, giving you simple dashboards that don't use complex formulas or Excel pivot tables.

Download the whole set: ga-widgets-20120320.zip.

 
New Web Analytics Widgets Released
Tuesday, 21 February 2012 16:35

Next Analytics widgets make it easy to produce professional web analytics Excel dashboards in minutes. Pick from a growing selection of widgets to suit your custom reporting needs, now including:  

Google Analytics Any Metric Over Any Time Period - a commonly used widget showing a trend curve as well as numbers for the current, previous and year ago periods.

Google Analytics Any Dimension Any Metric Any Time Period - a commonly used widget showing the top values for any dimension along with the percentage of total.

Facebook FQL Queries - pick from a number of common Facebook queries and refresh for interactive updates.

YouTube Top Videos By Location - see which videos are most popular in which countries.

YouTube Audience by Gender and Age - see the appeal of your videos by gender and age demographics.

 
Surprise Facebook API Changes May Affect Your Reporting
Friday, 10 February 2012 10:36

Facebook is “deprecating” 53 Insights metrics on Feb. 15th. For those of you that don’t speak API, that means they don’t want you to use them anymore. To make matters worse, due to a series of bumbles on their end*, we get a week’s notice.

What does that mean to Next Analytics users? Well, first, it’s time to upgrade. Our latest release, v4.1, now includes all the new Facebook Insights metrics like People Talking About This (page_storytellers) and Reach (page_impressions). You should also get a fresh copy of our Facebook Insights dashboards and widgets with the new metrics. These include:

Fan Page Visitor Demographics (updated)

Fan Page activity, likes & dislikes (updated)

If you have built your own custom report with Next Analytics, I suggest the following changes:

  • If you have used page_active_users, change it to page_impressions (reach). The numbers will be slightly higher, but this is a closer fit than the much smaller number found in page_engaged_users.
  • Be aware that if you were looking at age and gender metrics separately, you may have to use the combined …_by_age_gender metrics (page_storytellers_by_age_gender).
  • Many page content metrics like comments, likes, photos or videos are now combined into a few …_by_type metrics, and you will have to filter for the type of interest (page_stories_by_action_type).
  • And just to mix things up a bit, if you used to report monthly numbers, you will find the period ‘month’ has been changed to ‘days_28’ for all the new metrics.

If in doubt, drop us an email and we’ll help you navigate the conversion for your specific reporting needs.

* Facebook admitted that they did not follow their own "breaking change policy" and failed to post the change in their Platform Roadmap. The admission was in their Jan.25th Platform Updates newsletter, but that newsletter was not delivered until Feb.8th because of a problem with the subscription service.

 
Facebook Insights problems since Jan.24th, 2012
Tuesday, 07 February 2012 14:22

Facebook Insights Data has problems. As reported on AllFacebook.com, Facebook Page Insights has been disrupted since Jan. 24th.