USA Map Overlay for Google Analytics in Excel
I made a quick little modification to the Map Overlay dashboard I described in our popular blog article, and produced the same dashboard, but focussed specifically on that USA market.
I made a quick little modification to the Map Overlay dashboard I described in our popular blog article, and produced the same dashboard, but focussed specifically on that USA market.
I was really disappointed this week when Hootsuite stopped telling me what Twitter messages were ‘new’ since the last time I looked. That was the number one reason I used it, and the Twitter interface is missing this valuable feature. Well, there were a few things that bugged me about both Hootsuite and even the [...]
Next Analytics has a growing list (over 40) of free Excel dashboards and reports that work with our product. Each was created to report on a specific time period, be it 3 days or 13 months, that moves with the calendar so all you have to do is click Refresh and the time period is [...]
Many of the free Excel dashboards available from Next Analytics combine the results from multiple Google Analytics queries into the various elements of one Excel “dashboard” worksheet, but it may not be obvious how you would build such a combination report from the user interface. It is actually quite easy, and in this article, I will [...]
This is the Microsoft Excel report element you’ve always wanted – showing a map of the world, highlighted to show where your website visitors come from. It is included in this week’s free dashboard, and Next Analytics will automatically create and update it. To learn more about the dashboard, see our Product pages. In this [...]
There are a surprising number of people that are tracking multiple web sites with Google Analytics, and they often want to see a report or dashboard comparing and contrasting their performance. Next Analytics is one of the few products that makes this a simple task – here’s how.
In this week’s Excel dashboard, we look at website landing pages – which ones are your most effective and how different visitor groups treat them. Four major segments are shown side-by-side: direct traffic, visits from search engines, visits from referring web sites, and clicks from paid advertising. Leveraging Excel’s conditional formatting makes it easy to [...]
Most of the templates and sample reports that I’ve posted simply demonstrate that Nextanalytics can produce all the same web reports you have seen elsewhere. But Nextanalytics can go so much further; we’re not just another quick and easy reporting tool – we can run with the big dogs.
In this example, we not only create [...]
Stephane Hamel of Immeria created a sample dashboard in Excel (link) that took off virally, becoming a popular starting point for others (link) (link) to create their own solutions. I applaud his work and his creativity. In the comments to his blog, though, a number of people found the complexity daunting. I am a strong [...]
Using the unique capabilities of the Nextanalytics add-in for Excel 2007 (2003 version also available), we whipped up a quick dashboard that combines many of the key visitor-tracking metrics from Google Analytics all on one page, and it’s all yours, in a Microsoft Excel workbook. Use it as-is or customize to suit your distinctive needs. [...]