Is the price a one-time payment or annual?

A one-time payment. Future upgrades and extended service plans are extra, and optional.

What about new dashboards and reports?

New dashboard packages are posted on our web site, free for anyone to download at any time.

Is there a service component to your offering? Is my account secure?

Once installed, you communicate direct with Google’s servers. We have no service component. The only time you communicate with Nextanalytics’ servers is to get the product initially installed, and we require only a valid email address. We never need to see your Google Analytics credentials.

The install doesn’t seem to work

Our setup program needs to download additional files from our server and needs access to the internet. If you have a personal firewall running, you need to permit this traffic through.

After the install, a Windows warning pops up

This is expected – our Registration application is trying to start, and it MUST write to your system registry (that’s how Excel finds it’s add-ins), so it is asking for elevated privileges. See our Installation Guide for click-by-click instructions and screen captures.

I run your setup, but some Microsoft software wants to be installed

It’s OK, there are a few prerequisites needed to run add-ins in Excel, and we’re just triggering those updates from Microsoft. Verify that the code is a ll signed by Microsoft before proceeding (all our code is digitally signed by Nextanalytics).

The Nextanalytics menu appears, but nothing works

The application must be registered first. Close and re-open Excel. A Windows warning prompt will appear. In Vista, click Allow. In Windows XP, UNcheck the box for Protect my computer (i.e. turn it OFF so you are NOT protecting your computer).

I get a registration panel that asks for my email, but nothing happens when I click Submit

The application is trying to get to our registration server on the internet. Is your personal firewall blocking the request?

When you save my password, is it secure?

We use full RSA encryption with saved passwords (if you choose to save them). Our application can use the encrypted password, which means saved workbooks can be refreshed, but they cannot be used to change any of your account settings.

How does the application work?

We provide a User Guide in your installation. See your Windows Start – All Programs – Nextanalytics menu for a link to it. We also have a walk through document on our download page.

How does it compare to other Google Analytics plug-ins and web services?

Nextanalytics is a lot more than just a query tool. It leverages an embedded analytics engine with a powerful command set to make it really easy for you to perform trends, segmentation and much deeper analysis of your web traffic without having to resort to complicated and fragile Excel formulas.

How do I get more than 10,000 rows? Do I have to make multiple queries?

One query is all you need. When you start making your query, just below the Date Range, you’ll see a box with the Maximum Number of Rows with the number 10000 in it. Just enter a larger number and proceed building your query. If you have already built a query and saved it to a *_actions sheet, you can easily modify it. Find the script command that starts with “uiGetGoogleAnalyticsData”, and modify the parameter for “&max-results=10000″ to a higher number.

I am an advanced user. Can I modify my queries manually?

Absolutely. With Nextanalytics, all the query parameters are available in a simple script command. Simply modify the command as you see fit, adding dynamic segments, advanced filtering or sorting. You can even ‘build’ the commands dynamically with Excel formulas, allowing you to build dashboards with drop-down selections that modify the query. See Google’s API Guide for more information.

I want to query the past 30 days, but the selection only provides ‘Past 28 days’

Use 28 days to build your query, then edit the script command after you have saved it. Look on the worksheet tab that ends with “_actions”, and you will see the script we use. Find the row that starts with uiGetGoogleAnalyticsData. Simply change the 28 to 30. You can pick any combination of ‘Past # days’, ‘Past # weeks’, ‘Past # months’ or ‘Past # years’. [By the way, we picked 28 since most web traffic has a strong weekly cycle. Using 30 days will result in metrics that go up or down a little depending on what day of the week it is.]

Template error: The remote server returned an error: (401) Unauthorized.

If your template gives you this error, you are probably not using the correct profile ID number. Google Analytics has an account ID (the UA-xxxxxx-x number) and below that level, there is a collection of profile IDs. You can have multiple profiles for the same web property, allowing you to segment or process the traffic in different ways. The Google Analytics API uses the profile ID for it’s access, not the account ID. Unfortunately, they make it hard to find your profile ID in the web interface. There is a simpler way….

Using the Nextanalytics – Google Analytics data connector (menu item), login to your account. You will be presented with several drop-down selection lists. One of them lists your accounts (the UA-xxxxxx-x numbers are shown as well). Once you select that, the list immediately below it is your available profiles, with the profile ID number in brackets — you may have only one for each account; some people have several.

Enter that profile number into the template, and you should be OK.

Date/Time format codes

To figure out what codes you need to enter, you first have to identify the various components of the dates you have been given, and then place the corresponding codes in the correct order. For example:

1/23/10  would be represented as  M/d/yy

5 JAN 10  would be  d MMM yy

2010-01-23  would be  yyyy-MM-dd

1997-07-16T19:20:30.45+01:00  would be  yyyy-MM-dd’T’HH:mm:ss.ffzzz

�
For more information, reference:
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx