AutomateAnalytics.com

New report types available in GA Data Grabber

2013-05-14T16:15:00.002+03:00

Producing great-looking reports automatically is one of the big benefits of using GA Data Grabber: you don't need to spend time formatting the data and creating charts, as GADG does all this for you. Still, we've noticed that in addition to the built-in GADG report formats, many people also build their own dashboards and visualizations that use the GA Data Grabber reports as data source. To make this easier, we're releasing a new report type in GA Data Grabber: unformatted raw data reports. These contain the data in a simple, unformatted table that can be used as a source for dashboards, pivot tables, charts etc. See screenshots below of a raw data report and a regular formatted report.

Raw data report

Formatted report

We've also added the option to run "summed" reports. If you select more than one Google Analytics profile/AdWords account/Bing Ads account/YouTube video to the report, GA Data Grabber will ask whether you prefer to see stats for each of them separetely or all summed up. This new feature makes it easy to run reports that sum metrics from many sites.

Report type selection

Both of these new features are available in the newest GA Data Grabber version in Google Analytics, AdWords, Bing Ads and YouTube reports (they are not yet available in Facebook reports), and work in both Windows and Mac Excel. You can get the latest version here.

Upload cost data from any source into Google Analytics

2013-04-17T11:29:00.000+03:00

We're happy to announce a new feature in GA Data Uploader: you can now use it to upload CSV files containing ad cost data into Google Analytics. This lets you get cost data from any source, for example Facebook Ads, LinkedIn Ads or Yahoo, into GA.

GA Data Uploader automatically guesses which CSV columns contain
what data, and converts the file to the format Google accepts

We've made the tool super simple to use. There are two important features that set GA Data Uploader apart from other similar tools, and make it much faster and easier to run uploads:

GA Data Uploader does not require that the CSV files conform to a specific format. Just upload any CSV (or TSV), and GADU automatically converts it to the format that is accepted by Google. This can save you a huge amount of time, as you don't need to manually tinker with the file to get it into the correct format.
When using GA Data Uploader, each CSV file you upload can contain data for multiple dates. The only limit is the max file size of 2 MB. Other tools require that you split the data to separate files each containing just a single day's data, which can mean a lot of work.

After Google has processed your file, the cost data will be visible in Google Analytics in the Traffic Sources: Cost Analysis report. The big benefit you get from this is, of course, that you can then see the ROI of your campaigns directly in GA, as GA can calculate this based on the advertising cost and ecommerce revenue metrics.

GA Data Uploader lets you upload up to 5 files for free. Additional uploads are available for $0.99 per file. In addition to CSV uploads, you can use GA Data Uploader to schedule an automatic daily upload from Bing Ads into Google Analytics.

Get started using GA Data Uploader here

Introducing the YouTube Module for GA Data Grabber

2013-02-11T17:33:00.002+02:00

When we ask GA Data Grabber users which new data source they'd most like to see added to the tool, YouTube has consistently been one of the top answers. We've heard your wishes and have now added a YouTube Module. This new module lets you fetch statistics for any number of YouTube channels and videos into one report, so you can easily monitor all your YouTube activity. As with all GA Data Grabber modules, reports can be created very flexibly: you can freely choose which metrics to include, and how to split the data. Metrics you can get include:

Video views
Unique viewers
Time viewed
Average % of video viewed
Subscriptions to your channel
Likes
Favorites
Shares

You can get the total figures, or split by time, country, gender, age, traffic source, or playback location. Compared to using YouTube Analytics, GA Data Grabber offers many benefits, mainly:

Getting metrics for many channels in one place
Seeing the developments for many videos simultaneously
Automatic calculation of how the metrics have changed compared to the previous period of same length, or the same period a year earlier
Combining the data with other data sources available in GA Data Grabber, such as your site statistics from Google Analytics and your Facebook page metrics
Having all the data in Excel, where you can add your own charts and calculations
One-click PowerPoint report creation

As with all GA Data Grabber modules, the YouTube Module has a free 14 day trial with full functionality. You can get it here. In addition to GA Data Grabber, you can also fetch YouTube data into Excel and Google Docs using our AutomateAnalytics Functions.

Total video views and time watched

Channel totals: video views and average time watched by month

Views by month for multiple videos in one report

AutomateAnalytics Functions can now fetch AdWords & YouTube data into Excel & Google Spreadsheet

2013-01-25T14:51:00.001+02:00

Last summer we published a new version of our Google Analytics VBA functions, when the old 2009 version was broken by changes Google did to their API. We're now releasing the first major update to this, with two major changes:

In addition to Excel, the functions now work in Google Docs. The usage is just the same in GD as it is in Excel. To get started, get the template spreadsheet here (you need to be logged into a Google Account for the link to work). You can transfer dashboards created in Excel into Google Docs following the instructions here.
In addition to Google Analytics, the functions can now fetch data from AdWords and YouTube (the latter is still in beta). There are tabs for these new data sources in the Excel and Google Docs template spreadsheets.

We hope you like these changes! We're going to add more data sources in the coming months, starting with Bing Ads and Facebook Insights. And very soon, we're going to add the YouTube capability to our flagship GA Data Grabber tool.

For more information on this tool, see here.

Get your Bing Ads cost data into Google Analytics

2012-12-10T16:35:00.000+02:00

At the Google Analytics Conference in October, Google published a new cost import API, which allows importing cost data into Google Analytics. This API has now been rolled out to all GA users, so we're ready to introduce our new tool, GA Data Uploader, which uses the new API to link your Bing Ads accounts with GA.

Our aim with GA Data Uploader was to create a tool that makes it as simple as possible to use the new API, without needing to worry about any of the technical details. With our tool, it won't make more than 5 minutes to get your automatic daily upload running! The only steps you need to take are:

Log into Google Analytics & Bing Ads
Pick which Bing Ads account is the data source
Pick which Google Analytics web property is the target
Add a custom data source into the GA web property, if you haven't added one yet
Press "Schedule uploads"

After you've scheduled the upload, it runs automatically every day, and you can see your Bing Ads cost data in GA's Traffic Sources: Cost Analysis report:

The data can also be accessed with Google Analytics custom reports, as well as any reporting tools that use the Google Analytics API, such as our GA Data Grabber.

Having Bing Ads cost data in GA brings two big benefits:

You can measure Bing Ads ROI: compare ad cost with GA's ecommerce and goal conversion metrics
You can see all cpc data in one place, no need to log into Bing to check how the campaigns are doing

Get started now at GADataUploader.com

GA Data Grabber at the Google Analytics Conference

2012-11-07T09:10:00.000+02:00

We were really happy to be one of only five tool vendors that Google invited to have a booth at the Google Analytics Conference held last week in Mountain View, California. The conference was attended by 400 Google Analytics Certified Partners and Google Analytics Premium clients from over the world.

Lots of great new stuff were announced by Google, including the cost import API, which allows you to import cost data from other data sources into Google Analytics. We received early access to this new API and for the conference, we released a new tool, GA Data Uploader, which uses this new API to import Bing Ads data into GA. In our booth, we did of course also display GA Data Grabber, the #1 reporting tool for GA. Both tools got a lot of attention from conference attendees, and we're sure we will be getting many new customers soon! It was also great meeting many of our existing customers in person for the first time.

Some photos from our booth:

Lots of new data available via the Analytics API

2012-09-19T10:38:00.001+03:00

Google has just published an update of the Google Analytics API, which adds lots of new data fields, including detailed information on mobile devices and social interactions. We've included the new data in version 1.64 of GA Data Grabber, which is now available for download. Users of our Google Analytics VBA Functions can also start using these new fields immediately, simply by typing the field names as function parameters. A full list of available metrics and dimensions can be found here.

GA Data Grabber report on mobile devices:

GA Data Grabber report on social actions:

Multi-segment reports in GA Data Grabber: branded vs non-branded keywords

2012-08-30T09:52:00.003+03:00

We've just uploaded version 1.63 of GA Data Grabber, with a great new feature: the ability to pick several Google Analytics segments into one report. This opens up the possibility to do all kinds of analyses that would've previously required running several reports and combining the results. One useful example is comparing branded vs. non-branded search keywords. Just create these segments in Analytics, and they will be visible in GA Data Grabber's segment list. You can then pick them into a report, for example splitting by month to see the developments on a monthly level:

Of course, this is just one example, and there are many other useful reports you can now run. You can get the new version here. As always, the upgrade is free for everyone having a valid GA Data Grabber license.

Google Analytics VBA Functions for Excel - new version available

2012-08-23T11:12:00.000+03:00

UPDATE: Now also available for Google Docs, see more information here

One of the most popular solutions for fetching Google Analytics data into Excel has been my set of VBA functions that can be used on an Excel worksheet just like any of Excel's built-in functions. Shortly after the Analytics API was released three years ago, Google mentioned it as the #1 way for accessing the API from Excel. There are several other tools for fetching Analytics data into Excel (such as our GA Data Grabber and FasterMetrics tools), but nothing can match the flexibility of the VBA functions.

Now after three years, due to changes Google has made to the Analytics API, the original functions have become nearly unusable, and will break completely when the ClientLogin authentication method is removed. As many companies rely on the functions for their reporting, we have decided to publish a new version that works with the new Analytics API.

The new version of the Google Analytics VBA functions for Excel can be downloaded here. From a user perspective, we have kept the new version as close to possible to the old one, to make it easy to migrate existing reports. The functions have the same names (getGAdata, getGAaccountData), and accept the same parameters. This means you can simply copy the new VBA code from the file linked above into your old report files.

There are some changes though, the biggest being that instead of the getGAauthenticationToken function, you need to visit analyticsvba.com to get an authentication token. These tokens will not expire like the old ones, so you only need to do this once. With this new OAuth authentication method, you don't need to enter your Google account password to the Excel sheet, which makes this much better from a security point of view. The token you place on the sheet only gives access to Google Analytics data, not other parts of your Google Account, and it can be revoked at any time from your Google dashboard.

There are some other improvements as well:

You can fetch data for multiple profiles with a single query, just combine the profiles IDs with an ampersand (&). This is much faster than the old way of typing a separate getGAdata query for each profile.
You can fetch an unlimited number for metrics in a single query
You can fetch more than 10000 results with a single query, using the new maxResults parameter
You can specify that the dimension values are not shown in the results using the new includeDimensionColumns parameter (this is handy, for example, if you want to fetch data on monthly level for multiple segments side by side, and don't want each query to return the month numbers)
The authentication token will not expire, unless you choose to revoke it (with the old version, the tokens expired after 30 days)

To justify the development and maintenance work required for this new version, it comes with a small annual price of € 99. You get a free trial at first, and if you want to continue using the functions, you can make the payment at analyticsvba.com. What you get for this price is a reliable solution that we will guarantee to keep working despite changes Google makes to the API, and support through our help forum.

If you are new to the functions, to get started take a look at this tutorial. You can find a reference for all the function parameters here. The functions work in Windows Excel 2003 and later. For Mac users, we offer GA Data Grabber and FasterMetrics.

Let us know if you have any feedback of the new version!

Check out our new excellent analytics tool, now in beta

2012-07-11T10:39:00.000+03:00

We're happy to introduce our new Google Analytics tool for Excel users, FasterMetrics. It's an easy-to-use plugin that gets your Google Analytics data into Excel, and works on both Mac and Windows Excel. It's similar to a tool called Excellent Analytics, but it also works in Mac OS X, is faster, and lets you set all your query parameters dynamically using Excel functions - this makes it possible to automate complex reporting dashboards. Compared to GA Data Grabber, FasterMetrics has more limited functionality, as it lacks some features like automatic data visualization and exporting to PowerPoint, but for some purposes, a simple tool like this can be more convenient.

FasterMetrics is currently in beta: you can download the beta version here. After opening the file, on Windows Excel 2007/2010 you will see the button to launch it in the Add-ins tab. In Mac Excel 2011, you will see a custom toolbar pop up.

You can use the full version FasterMetrics for 30 days for free. After that, you can choose to pay for the full version, or continue to use the tool for free, with limited functionality.

We're still developing the tool, with the aim to get it out of beta in August. If you have any feature suggestions or problems with the tool, please post these to our help forum. Thanks.

Google Analytics Account Overview report with GA Data Grabber

2012-04-23T15:30:00.001+03:00

The old Google Analytics interface is being deprecated, and even though the new one is in many ways an improvement, it lack some features of the old interface. One of these is the Account Overview, which displays on one page certain core metrics for all of the profiles of an Analytics account, and also shows how these have changed from the previous period of the same length. Luckily, with GA Data Grabber it's very simple to make a report with the same information - just watch the video below to see:

Account Overview in the old Google Analytics interface:

Account overview report in GA Data Grabber:

Get GA Data Grabber here

GA Data Grabber featured in the Google Analytics Blog

2012-01-27T09:30:00.000+02:00

The official Google Analytics blog has a new article out that shows how useful GA Data Grabber can be for automating multi-site Google Analytics reporting. The American TV network PBS is featured as a case study. Check out the article here.

Lots of thanks to Amy Sample from PBS for agreeing to the case study, and to the Google Analytics API team for releasing the article!

New Facebook page & app analytics tool now available

2012-01-13T12:18:00.000+02:00

We're happy to announce a new Facebook Module for GA Data Grabber, the #1 reporting tool for Google Analytics, AdWords & MS adCenter! The Facebook Module makes it easy to keep track of a large number of fan pages and applications, as it can fetch the numbers for dozens of pages/apps into an Excel sheet in a matter of seconds. But it's not just a data fetching tool, it also visualizes the data, automatically calculates comparisons to previous year figures, creates PowerPoint reports by the push of a button, and much more.

More information of GA Data Grabber & free trial download can be found here. Information specifically on the Facebook Module can be found here.

Check out the video and screenshots below:

Get the beta of the new GA Data Grabber

2011-12-14T17:15:00.000+02:00

Update: the new version has been released and can now be downloaded from http://www.gadatagrabbertool.com/pages/download-trial

We've been working on a big update to GA Data Grabber. We're now at the beta stage - you can download the beta version here.

I'll write a more detailed post on the new features once this version comes out of beta, but some main feature included:

A new Facebook module: gets the metrics for your Facebook fan pages and applications into Excel, making it easy to analyze. You'll get many metrics not available elsewhere.
Much easier filtering
Exporting reports to a separate Excel file
Option to use a template with the PowerPoint export feature
Improvements to the automatically created charts

There are many other changes too. But there may be some bugs left too - if you notice any, please let us know (info@automateanalytics.com). Of course, other feedback on the new features, and especially the Facebook module, is also welcome.

More information on GA Data Grabber can be found here.

We hope you enjoy the new version!

Translation Tool for Excel

2011-10-24T17:50:00.001+03:00

Two years ago, I published a small script I made for using Google Translate in Excel (http://www.automateanalytics.com/2009/09/excel-function-for-translating-text.html). I didn't give it much attention since, but apparently it's grown quite popular. Unfortunately, Google is now shutting down the free translation API that my script used, so it will stop functioning very soon. Many people contacted me regarding the issue, so I decided to make a new Excel tool for the new, paid Google Translate API.

This new tool is now available at http://translationtool.automateanalytics.com/.

The new tool is not completely free, but the usage cost is very low. It's also much faster (up to 40 times) than the old solution, can translate much longer phrases, and is more reliable. There's a free trial, so you can fully test the tool before buying. This tool is very simple to use, just select a cell range and the language you want to translate it to, press a button and the tool will conduct the translation in matter of seconds.

Warning: I've noticed someone is selling a tool called "Google Translate for Excel". This is not my tool; it looks like someone's just copied my earlier free script (which will stop functioning very soon), and put a price tag on it.

New version of the AdWords Addin for Excel

2011-10-19T13:18:00.000+03:00

We've just uploaded a new version of the AdWords Addin for Excel. This new version uses the new AdWords API version, which means you don't need to pay by usage anymore - the only cost is the annual license price (currently $199 USD per MCC). When using the functions, you no longer input an AdWords developer token as a parameter.

We've also simplified usage so that you no longer need to select a report type. Just select which fields you wish to fetch, and the tool will automatically determine the optimal report type in the background. The field names are also no longer case-sensitive. All this makes usage of the tool much easier.

Download a demo worksheet here. (Type your AdWords login credentials and the tool will automatically fetch some data for you. You can see how the functions are used and modify the parameters, and add new instances of the functions)

For more information and pricing, visit http://analyticsfunctions.automateanalytics.com/

(Using this tool requires learning some basics of array function usage in Excel. For an easier tool, you should check out GA Data Grabber)

Usage of GA Data Grabber AdWords module is now free!

2011-10-10T17:14:00.000+03:00

Google has published a new version of the AdWords API: with this new version, it's no longer necessary to purchase AdWords API units in order to run reports. We have just uploaded a new version of GA Data Grabber that takes advantage of the new API version, you can get it here. This means that from now on, the only expense of using the AdWords module is the small annual GA Data Grabber license fee (currently at $199) - no extra fee for running reports anymore! If you haven't bought a license yet, testing the AdWords module is now also much easier, as you can run as many reports as you wish during the 7 day trial period.

The old API version will be shut down at the end of February 2012. As the update includes some major changes to reporting, all existing users of GA Data Grabber AdWords module must upgrade to a newer GADG version before that date in order to be able to run new reports.

Note that using the GA Data Grabber Keyword Tool (included in the price of the AdWords module) still requires buying API units.

This update makes using GA Data Grabber as an AdWords reporting & analysis tool much more convenient, as there's no more uncertainty related to the usage cost of the tool. In addition to this, we also wanted to improve the user experience of the AdWords module. In the latest version of GADG, you no longer need to select an AdWords report type when creating a report - GADG now does the selection automatically in the background. Tbis makes creating report much easier, as you no longer need to look through different report types to find which of them include the field combination you wish to include in your report. We've also updated the list of available report fields to match the new API version.

Download the latest version of GA Data Grabber with these improvements here.

New Microsoft AdCenter reporting tool

2011-09-28T10:39:00.000+03:00

After the transition of Yahoo Search Marketing to Microsoft AdCenter (formerly known as MSN AdCenter) last year, AdCenter now serves ads to both Bing and Yahoo search engines, and currently has around 30 % of the US market. To help advertisers working with AdCenter, we are now introducing a new tool, GA Data Grabber AdCenter Module, which makes it easy to see how your ad campaigns are doing.

To test for yourself, download GA Data Grabber and log into the AdCenter module.

The simple interface of the tools makes it easy to run reports, but it's also very flexible, allowing to conduct analyses not possible via the AdCenter web interface. You can freely specify which metrics to include in a report and how to split them (for example, by time, by campaign, ad, keyword etc). Running reports for many campaigns is very fast, and you can easily duplicate reports for multiple accounts, if you are managing more than one. GA Data Grabber automatically creates charts out of the results, and you can export them to PowerPoint by the press of a button. GA Data Grabber works in MS Excel, making it easy to modify the reports and do additional calculations with the data.

GA Data Grabber is a huge time saver for anyone working with search engine marketing. The very low annual cost is easily outweighed by the time you save when using this tool to track campaign performance. And there's a free trial with full functionality, so you can test that this is true before buying.

Screenshots: report builder interface; report with campaign data on date level. Click to enlarge.

In addition to Microsoft AdCenter, GA Data Grabber can access Google Analytics and AdWords data. Click here for more information on GA Data Grabber. We're also marketing the AdCenter module separately as AdCenter Data Grabber.

If you're working with AdCenter, give GA Data Grabber a try straight away!

8 new metrics available in GA Data Grabber

2011-09-14T15:47:00.000+03:00

We're happy to announce the addition of 8 new metrics into GA Data Grabber! Google hasn't updated their API, but GA Data Grabber now uses existing dimension fields to calculate new interesting metrics, which are not available via the Analytics web interface nor through other tools that use the Analytics API. The new metrics are listed below. To start testing immediately, get the latest version from http://gadatagrabber.automateanalytics.com/.

Ecommerce, 2 new metrics:

Average number of days to transaction: how many days from the first visit does it on average take for a visitor to purchase? The bigger the average is, the more days the visitors take before making the purchase. The day of the first visit is counted as zero; if the average is zero, this means all transactions are done immediately on the day the visitor first arrives on the site.

The Google Analytics web interface does provide a simple distribution for this (in the new GA interface: Conversions -> E-commerce -> Time to purchase), but it doesn't show how this develops over time, or relative to other factors such as marketing campaigns. See for example the attached screenshot of a report showing the development of this metric by month and by traffic source - changes on the site and in campaign emails can have a significant effect on how fast visitors are converted to buyers.
Average number of visit to transaction: same as above, but counts how many visits it on average takes for a visitor to purchase.

SEO, 3 new metrics

# of referring domains with visits: shows how many different domains are sending traffic to your site. Great metric for assessing link-building efforts. Attached example screenshot shows how the number of domains linking to AutomateAnalytics.com has developed over the last two years.
# of keywords with visits: displays how many different keywords are sending traffic to your site. When plotted over time, this can be used to evaluate the success of search engine optimization. Note that to exclude PPC keywords from reports with this metric, you can use the advanced segment "Non-paid Search Traffic", or a filter string: medium==organic
# of landing pages with entrances: measures how many different pages draw visitors to the site. Query strings (starting with "?") and fragment identifiers (starting with "#") are stripped from the URLs before counting how many unique landing page addresses are found.

Content, 1 new metric:

# of pages with pageviews: how many different pages have been visited on the site? This metric can be used to evaluate how much different content is being viewed and how this develops over time. Each unique URL that has received pageviews is counted, but query strings (starting with "?") and fragment identifiers (starting with "#") are automatically stripped.

Location, 2 new metrics:

# of countries with visits: from how many countries has the site received visits? Can be used to evaluate the geographical spread of traffic.
# of cities with visits: same as above, but counts cities.

These are all included in the latest version of GA Data Grabber. You can download it here: http://gadatagrabber.automateanalytics.com/

These new metrics open up many new opportunities for using GA Data Grabber. We hope you find them useful.

GA Data Grabber now groups site content by directory

2011-08-24T16:20:00.001+03:00

One popular report of Google Analytics is Content Drilldown, which lets you see the metrics per content on different directory levels, instead of by individual URL. This report isn't available through the Analytics API directly, but we have now managed to add it into GA Data Grabber, by parsing it from the available data. There are four new dimensions available in GA Data Grabber: page directory levels 1 to 4 (you'll find these in the "Split by" dropdown menus under "Content"). These dimensions range from a more general to more detailed categorization of your content. For instance, for the URL "http://www.automateanalytics.com/2011/03/google-analytics-adwords-tool-for-mac.html", the values for these dimensions would be:

Page directory level 1: /2011/
Page directory level 2: /2011/03/
Page directory level 3: /2011/03/google-analytics-adwords-tool-for-mac.html
Page directory level 4: /2011/03/google-analytics-adwords-tool-for-mac.html

If the URL has less directory levels than specified in the dimension, then GA Data Grabber will return the full URL, but query strings (starting with "?") and fragment identifiers (starting with "#") are automatically stripped. You can of course still also access the complete URL by using the Page path dimension.

The new dimensions make it easy and fast to get a view of how the different site sections are performing. For example, take a look at this screenshot of a report that plots pageviews for directory level 1 by week:

To get your hands on the new features, go download the latest version of GA Data Grabber. There's a free 7 day trial, and with the annual price for the full version at just $139, you'd be crazy not buy it!

New free Analytics tool available: metrics by hour of day

2011-06-22T11:29:00.001+03:00

UPDATE: Due to changes by Google, this tool no longer works. Instead, you should check out the AutomateAnalytics Functions, which you can use to create a report similar to this, and countless others - it's the most flexible way of getting Google Analytics and AdWords data into Excel and Google Spreadsheet.

It's been some time since I've last released anything free of charge, but now's the time! By following this link, you can download an Excel tool which fetches Google Analytics metrics by hour of day, and splits that by day of week and by date. Once logged in, you can pick any of your Analytics profiles, and filter the results by an advanced segment. You can freely set a date range, and pick one of many metrics.

This works using my Analytics VBA functions, is completely free to use and does not require installing a plugin! The only thing it requires is that you enable macros in Excel's security settings (see instructions). (Currently works on Windows only - if someone's interested in contributing to the development cost, I can adapt it to Mac Excel too.)

The inspiration for this comes from an episode of Google's Web Analytics TV, where someone asked if it's possible to create a report like this, and was pointed to use a paid solution, which requires a plugin installation. In general, any dashboards like these can easily be created using my VBA functions for free with a few minutes of work (though it did take me almost an hour and half to build this one, since I wanted to add a nice interface too). It's even easier with our GA Data Grabber tool, which you can use to quickly create any of these reports, and which is not restricted to a predefined set of dashboards.

Automate Snoobi reporting in Excel

2011-05-20T13:40:00.002+03:00

Today we're happy to announce a new product, Snoobi for Excel. It's an analysis tool working in MS Excel that automatically fetches and visualizes your Snoobi data. Snoobi for Excel creates in a matter of seconds reports that would take hours to set up manually. With this tool, you can put your time into interpreting the numbers rather than waste it on manual copy-paste work. It even automatically puts together PowerPoint presentations of your reports. To read more and to download a free trial, visit SnoobiForExcel.com.

For those who've never heard of Snoobi, it's a popular web analytics tool in many parts of Europe. (Note that Snoobi is a whole separate web analytics tool and not connected to Google Analytics. For GA users, we recommend GA Data Grabber.)

GA Data Grabber now supports multiple logins and OAuth

2011-05-18T09:51:00.002+03:00

We have recently added several major new features to GA Data Grabber. Here's a brief overview of the most important ones. To test them for yourself, download the latest version here.

Support for multiple Analytics logins

GA Data Grabber now lets you log in with multiple Analytics users (Google Accounts) simultaneously. This is a handy feature if you don't have a single user account that has access to all the Analytics accounts you need to follow, for example, if you have a separate user account for each of your clients. When you log in with multiple users, the accounts and profiles these users have access to are all consolidated into a single profile list, and you can run reports that combine data between profiles from different users

Support for OAuth authentication

When you log into the Analytics module of GA Data Grabber, authenticating with Google Analytics is now done with OAuth. This means that authenticating happens in your Internet browser on a Google webpage, and you never need to enter your login credentials to GA Data Grabber. GA Data Grabber will never have access to your full login credentials, and its access rights are restricted to your Google Analytics data (GA Data Grabber cannot access other parts of your Google Account). You can revoke this access right at any time from your Google Account's control panel. To provide extra security, GA Data Grabber also uses SSL encrypted HTTPS connections for data transfer. These elements guarantee the your privacy and the safety of your data, and are especially important considering recent reports of vulnerabilities in Google's ClientLogin authentication, which is used by many other Analytics API tools. See GA Data Grabber's full privacy policy here.

Reports with dynamic date ranges

In addition to using fixed date ranges, you can now run reports for a dynamic date range, such as the previous full month, year to date, or last 7 days. Whenever you refresh a report that has a dynamic date range, the dates will be automatically updated to cover the chosen period. This makes it even easier to run your periodic reports with GA Data Grabber.

To test these new feature, download the latest version of GA Data Grabber here

GA Data Grabber AdWords module no longer requires a developer token

2011-04-05T14:41:00.002+03:00

With the latest version of GA Data Grabber (available here), you no longer need to have an AdWords developer token in order to use the AdWords module. This means that anyone with an AdWords account can now use this great reporting tool! When you have a GA Data Grabber subscription, you can buy AdWords API units through this page, and then use those units to run reports in GA Data Grabber.

(If you have your own AdWords developer token, you can still use that with GA Data Grabber if you wish. In this case, AdWords API usage will be directly billed by Google to your AdWords MCC account. You can enter your own developer token when logging into the AdWords module of GA Data Grabber.)

Google Analytics & AdWords tool for Mac OS X Excel

2011-03-15T09:52:00.000+02:00

Since I published the Google Analytics VBA functions for Windows Excel in 2009, lots of people have contacted me hoping to find a similar solution for Mac Excel. After several months of development and testing, we now have this solution ready: Google Analytics and AdWords data can now be fetched directly to an Excel spreadsheet on Mac Office 2011!

We have currently implemented this technology in GA Data Grabber, our sophisticated tool for fetching and visualizing Google Analytics and AdWords data in Excel. You can download the demo version here. GA Data Grabber works with the Mac Excel 2011 (Mac Excel 2004/2008 are not supported), and of course, Windows Excel 2003 and later. All the Windows functionality is available also on Mac, but fetching data is somewhat slower, due to restrictions in Mac Excel.

If you have any questions regarding our Google Analytics solution for Mac Excel, please contact us at info@automateanalytics.com.

Screenshots of GA Data Grabber working in Mac Excel