AdWords API solution for Excel now available

I’m excited to publish a great new solution for fetching AdWords figures to Excel through the AdWords APIsomething that many people have been asking for.
We’ve created two products based on this technology:
1. AdWords module for GA Data Grabber

With our popular report automation tool for Googla Analytics, GA Data Grabber, you now have the option to include an AdWords reporting module in addition to the regular Google Analytics module. All the advanced features of the tool, such as automated charting and PPT creation, can be used also with AdWords reporting. And the best thing is, as the data is already in Excel, it’s very easy to modify the charts, do additional calculations and so on – making this a much more flexible analysis tool than anything else currently in the market. There are few screenshots on the left – click to enlarge.

To download a demo version GA Data Grabber and to purchase the full version, visit the GA Data Grabber site: http://supermetrics.com/
2. AutomateAnalytics Functions
If you love our Google Analytics VBA functions, then this is for you: you can buy a blank workbook that has the VBA code for the AdWords functions embedded, so you can use them to build your own reports, just like with the Analytics functions. More information regarding this solution can be found here. These functions work both in Excel and in Google Spreadsheet.

3 Responses to “AdWords API solution for Excel now available”

  1. TonyRiver

    No way man! Seriously, you rock. Just bookmarked your site and plan on coming back often. These are some kick as scripts, amazing stuff. Thanks for taking the time to write them, and for giving them to the general public.

    Reply
  2. Trond

    Hi,
    Any plans adding keyword research & analysis into your excellent spreadsheets? Would love to add search volumes and rankings into them as well, automated (API).

    Reply
  3. Mikael Thuneberg

    Hi Trond,

    Actually we just published a new version of GA Data Grabber with a keyword research tool yesterday. You can download it at http://gadatagrabber.automateanalytics.com/download-demo. Log into the AdWords module and a sheet called KeywordTool will appear. It will fetch search volumes, a trend metrics showing how the volumes have developed over the last 12 months, and a competition metric showing competition for the keyword with a figure between 0 and 100. The tool does not yet fetch rankings.

    Note that to use the tool, you either need your own AdWords developer token, or some API units that you can buy at http://apiunits.automateanalytics.com/. For testing, I can give some free units if you let me know the AdWords username you’re logging in with.

    Reply

Leave a Comment

  • (will not be published)