Question:
What are Next Analytics limits for queries? How many accounts or profiles can be used? How many rows of data can it get?
Answer:
Next Analytics imposes no limits to what you can do with the Google Analytics API. You can use as many accounts and profiles as you have access to. You can make as many [...]

The secret sauce of Facebook Excel is FQL
Facebook Query Language, FQL, lets you send queries to the Facebook data servers. And Next Analytics lets you send FQL queries and get the results into Excel.
Next Analytics’ Facebook Excel provides a very convenient environment to analyze Facebook and Facebook Insights.
If you have Next Analytics, it is a [...]

Next Analytics was already the best Excel add-in for automating your Google Analytics reporting, but with the release of version 3,1, we have included a Batch Scheduler and a Command Line Utility that take things to a whole new level of automation. And with 3.1, you can also get Facebook, Twitter, LinkedIn and even SQL [...]

When making weekly reports from the Google Analytics API, it is most efficient to download your data using Google’s year and week dimensions. This produces a row of data for each calendar week in the report, but it leaves you with a report that contains no dates — just week numbers. Most people don’t think [...]

Many businesses and consultants manage more than one Fan Page.
For example, if you own a group of restaurants, each one might have its own page, and you want to compare the activities and performance of their Facebook marketing efforts.
What’s important is that Next Analytics let’s you get any Facebook Insights metric, for a set of [...]

Question:
I refreshed the Visitor Overview workbook with the map, but the map is not updating.
Answer:
This workbook uses Visual Basic for Applications code to refresh the map. In Excel 2007/2010, there is a setting that needs to be enabled for the code to run.
In Excel Options, select Trust Center – Settings…
On the Macros Settings panel, check [...]

Question:
In the Traffic Source Trends dashboard you have “source/medium”. How did you concatenate the separate source and medium columns?
Answer:
The concatenated Medium/Source column is created the same way as the Year-Month combination for the chart horizontal axis in the same workbook — use the Analyze tab, (check the Advanced box at the bottom), and select the [...]

Facebook Query Language, FQL, lets you send queries to the Facebook data servers.
You query the Facebook Server using Facebook Query (FQL). For example:

SELECT metric, value FROM insights WHERE object_id=117899624927110 AND metric=’page_like_adds’ AND end_time=end_time_date(‘2010-11-15′) AND period=period(‘day’)

This is out of reach of most users.  One of the main things you need is a convenient environment to send [...]

Next Analytics has an extensive search and replace capability (“Fix” tab)  that includes regular expressions as well as partial and exact match functions. These expressions are saved into comma-separated-value (CSV) files in the user’s Documents directory structure, making them reusable from multiple spreadsheet reports. By referencing files in the file system, though, each workbook is [...]

Some businesses and consultants manage more than one Fan Page.
Management wants to compare and see which ones are the biggest and least contributors i.e. the winners and losers, or to see which pages were affected by marketing campaigns.
Next Analytics let’s you use any Facebook Insight metric in any combination of Pages.
This lets you visualize and compare the [...]