Comments

1. Ian Bowden July 27, 2011 at 9:45 pm

   Thanks. Can’t wait to have some free time to play around with this. Had similar thoughts to create such a tool, but to release it for free is pretty awesome. Some sort of extension that mashes it up with Hitwise and Majestic would send me over the edge.
2. Dee July 28, 2011 at 2:33 am

   Looks very interesting. Still confused about setting it up and actually what it does.

   Any chances of a video tutorial?
3. Paul July 28, 2011 at 10:57 am

   I have looked at applying for an API key but it looks like there may well be costs involved for using it, as there is a mention about rates of US$0.25 per 1000 API units, it this correct?
4. Ian Bowden July 28, 2011 at 10:59 am

   Yep you have to pay for calls on the API, but there are agency rates.
5. Tolumi Adamson July 28, 2011 at 12:46 pm

   Great plugin and thanks for releasing it to the community for free. Ironically just finished up a whole load of keyword research for which this plugin would have been very handy.
6. Inken H. July 28, 2011 at 1:22 pm

   Sounds interessting! Maybe I’ll give it a try…
7. Paul R July 28, 2011 at 5:17 pm

   This is amazing – have wanted this for ages!! Where can I get the developer token from?

   Paul
8. richardbaxterseo Post author Follow July 28, 2011 at 5:57 pm

   Hi Paul, try here:

   https://adwords.google.com/support/aw/adwordsapi/bin/answer.py?hl=en-GB&answer=15104

   Hope that helps!
9. Kevin Barnes July 28, 2011 at 6:50 pm

   Thanks for the share Rich..
10. Elizabeth July 28, 2011 at 6:52 pm

    This is awesome. Thanks so much for sharing and in time for the holiday season!
11. Dee July 28, 2011 at 7:06 pm

    Let’s get a webinar or video tutorial, Richard! This has big potential for SEO guys.
12. Dan July 28, 2011 at 7:17 pm

    I read that it takes 5 API units per call and 0.1 API units per result. Just wondering if anyone has tested this out yet to see what the real costs of using this plugin are?

    It sounds as if you run this frequently and dependent on if you are charged units for each individual result displayed, this could add up to a lot.
13. richardbaxterseo Post author Follow July 28, 2011 at 7:43 pm

    Hi Dan

    1000 api units costs 25 cents. The arraygetadwords functions page the requests (800 rows per api call) so you can get data for 800 keywords for .025 cents

    The standard functions – that’s one api call per query, so 1000 keywords will cost you 25 cents.

    Hope that helps – Richard
14. Dan July 29, 2011 at 1:12 am

    Thanks Richard, that helps greatly. Now I have a better grasp of the costs, which actually sounds really reasonable with your explanation.
15. Innes July 29, 2011 at 10:37 am

    Being fairly new to the seo game and also trying to get my website further up the road, this will be of no end of help to me. I think this could be a great tool to help me monitor what to do with my seo.
16. Wayne Barker July 29, 2011 at 8:20 pm

    Oh Mr Baxter, you spoil us with your ferrero rocher.

    This looks like it is going to be super helpful and kudos for making it free – you gotta love it when people share such tools with the community. It is what makes the SEO field such a vibrant place to work in.

    You can be sure that this will distracting me next week!
17. SEO Coach August 2, 2011 at 2:09 pm

    Hi Richard

    Many thanks for this, the costs certainly sound reasonable and I’ve put of playing with the APIs way to long

    Cheers
    Bruce
18. Clicks August 5, 2011 at 1:26 pm

    I heve installed it and it works fine. Special thanks guys!
19. Ethan August 10, 2011 at 8:53 pm

    Hey Richard,

    Is there a way to get global search volume instead of local search volume with the getAdWordIdeas() function? For instance, “membership management software” has 1,600 exact US English global monthly searches on desktops and laptops in the US on the AdWords web site, but with the =getAdWordsIdeas(), it has 880 monthly visits — which is the same as the local results on the AdWords website.

    Is there a way to pull in global monthly searches into the getAdWordsIdeas() function?

    Feel free to email me.

    Thanks!

    - Ethan
20. richardbaxterseo Post author Follow August 11, 2011 at 10:22 am

    Hi Ethan

    Nice! Let me see what we can do
21. Chad Summerhill August 11, 2011 at 7:22 pm

    Can this be used with a proxy server? Thanks!
22. Dipanjan August 16, 2011 at 11:38 am

    I am not able to run the setup.xls on MAC platform.
23. Brian Bluff August 16, 2011 at 1:33 pm

    Any solution for us mac guys running excel for mac 2011… except of course buying a PC.

    Great job!

    Thanks
24. Ravi Pathak August 16, 2011 at 2:33 pm

    Richard,

    Thanks for sharing this great tool, I played with it and it performs very nicely. I also wanted to point to others that there is little more mature tool that we’ve developeed at Tatvic Excel Add-in for Adwords API . This plugin ,apart from search volume & competition data, it also extracts all your adwords data in excel. I’d love to invite people to check it out and share their opinion.
25. richardbaxterseo Post author Follow August 16, 2011 at 3:38 pm

    Hi Ravi – thanks for sharing. Your tools seems to have some interesting features, though I’ll point out it’s not free, nor does it have array functions to pull specific data points directly into the spreadsheet?
26. Nakul Goyal August 16, 2011 at 7:18 pm

    Great work Tom, thanks for sharing SEOGadget.
27. Ravi Pathak August 16, 2011 at 7:34 pm

    Hi Richard,

    Thanks, yes you are right. The Tatvic plugin is not getting array data. The most compelling feature for our customer has been the “Refresh”. When you do reports, you need do it same for each period. The refresh function ensure that you can use cell reference from excel as dates & change it to next period, refresh it and you have same set of data updated for new period.

    I understand your opinion on pricing and I am all for free tools & I am going to be adding it to our newsletter for our price sensitive customers as well.

    Thanks again for your comment & great work !!
28. MagentoWebDeveloper August 17, 2011 at 2:28 am

    Thanks to you ALL at SEOgadget. I saw you speak at Mozcon and I am thankful to have heard you. You are an inspiration to work smarter and faster.
29. Ragdog August 17, 2011 at 10:39 am

    If only there were something like this for Mac users and openoffice !
30. Innes August 17, 2011 at 10:42 am

    Precisely!, we are always working from Macs and much of the print software is run from them and this has grown to become a pain in the neck over time!
31. Luminaire enfant August 17, 2011 at 10:57 am

    Great ! Very interesting gadget after the Panda revolution. Now that CPCs become higher and higher, this gadget is a real investment. It is not only a very precious tool but it is also free (even no warranty)

    It seems easy to use but will be there a tutorial ?

    Again thank you for sharing this Gadget.
32. richardbaxterseo August 17, 2011 at 11:07 am

    Hi there – I made a tutorial video for SEOmoz: http://www.seomoz.org/blog/search-volume-data-excel hopefully that’s of use!
33. Flashdrive Pro August 17, 2011 at 1:29 pm

    Anyone know how long it usually takes Google to approve an API account? I’m dying to see this thing in action!!
34. richardbaxterseo Post author Follow August 17, 2011 at 1:56 pm

    Hey – usually ~2 weeks. They don’t notify you by email, so keep checking in to your account to find out what’s what.
35. Nakul Goyal August 17, 2011 at 2:48 pm

    My colleague got one approved fairly fast. I think it was around 7-10 days.
36. Pozycjonowanie Gdyni August 25, 2011 at 9:01 pm

    Is that working on LibreOffice Calc?
37. kari August 27, 2011 at 6:01 am

    Hi , thansk for this, it really speed my work a lot
38. YagilH August 29, 2011 at 11:20 pm

    Hi, I keep getting the error:

    AuthenticationError.NOT_ADS_USER @ ; trigger:’680964584052′ Service[TargetingIdeaService.get

    I changed my seogadget_AdAPIAddIn.xll.config to have the following entries:

    Please help.
39. YagilH August 29, 2011 at 11:23 pm

    And again…

    add key=”Email” value=”MyName@gmail.com”
    add key=”Password” value=”MyPWA”
    add key=”ClientEmail” value=”MyName@gmail.com”
    add key=”DeveloperToken” value=”MyToken”
    add key=”AdWordsApi.Server” value=”https://adwords-sandbox.google.com”
40. richardbaxterseo Post author Follow August 30, 2011 at 9:21 am

    That error looks a lot like Adwords does not recognise your username / password. Have you tried an uninstall / reinstall using the setup file?
41. Richard Baxter Post author Follow September 6, 2011 at 10:25 am

    Hi Chad, your comment slipped through the net I’m afraid. The tool itself doesn’t have the functionality to choose a proxy but it uses your computer’s internet connection, so if you’re connected to a proxy the requests from the Excel plugin will be too.
42. Richard Baxter Post author Follow September 6, 2011 at 10:26 am

    To everyone leaving requests for a MAC version – so sorry! ExcelDNA doesn’t support MAC so neither can we at this time.
43. Flashdrive Pro September 7, 2011 at 9:08 am

    Just got it approved today. So far no dice getting the tool to work though. Every time I close Excel after entering the API info and install the addon, Excel crashes and I get #VALUE! instead of the goods. Using Win 7 x64 and Office 2010.
44. Richard Baxter Post author Follow September 7, 2011 at 9:20 am

    Hi – do the functions appear, i.e “=getadwordsavg” as you’re typing the query?

    I use getadwordsavg just to test on a single keyword. You may need to run the full uninstall via the setup file, close Excel and start again.
45. Flashdrive Pro September 7, 2011 at 9:46 am

    Thanks, Richard! Downloaded the latest version, did a full-install, and now it’s working like a champ. Thanks for making such a awesome tool available for such a great price!
46. Richard Baxter Post author Follow September 7, 2011 at 10:36 am

    No problem! Spread the word – why people want to use the Google KW tool is totally beyond me!
47. ainsley September 9, 2011 at 5:18 pm

    Sigh! Would have been good to know before spending days getting an API and trying desperately to make it work on a mac.

    Thanks for all the effort on this, look forward to getting the mac version.
48. Trevor September 19, 2011 at 12:24 pm

    Thanks Richard excellent plugin. Downloaded fine and installed.
49. Euan September 22, 2011 at 5:01 pm

    has anyone just had their adwords api token revoked when used in conjunction with this? I’d applied using an already existing MCC level account and happily used the tool for a number of weeks and it’s now been revoked. There’s apparently been a spate of these as discussed on search engine land. Just wondered if anyone else had this issue? I’m not exactly a heavy user!
50. Richard September 22, 2011 at 5:12 pm

    Hi Euan,

    Many SEO folk have had their token revoked – specifically, when the MCC appears to have no PPC account management activity. I’d like to make it clear that this extension is NOT a causal factor to developer token revocation and you can reapply via the MCC.

    Richard
51. euan September 22, 2011 at 5:21 pm

    Thanks Richard, I certainly didn’t mean to imply using the extension resulted in the revoking of the token and sorry if it came across that way.

    The extension has been a wonderful time saver and I hope our token will be re-issued so we can continue to take advantage of it.
52. Richard September 22, 2011 at 5:32 pm

    Oops – yes of course! Hope you get your token back!!
53. Lisa Schotte September 27, 2011 at 2:52 pm

    google wants a screen shot or a design document of the application. can i just send them the actual plugin. i guess they are not handing out apis as easily as they used to.
54. Darren Shaw October 8, 2011 at 5:25 am

    Hey Richard,

    I’m also wondering about the global monthly search volume. Is there a function for that?

    Thanks

    Darren
55. lee @ Only Ecommerce October 14, 2011 at 1:11 pm

    Excellent, can’t wait to trial this out! Looks great, just need to buy some api credits
56. Luminaire enfant October 14, 2011 at 1:30 pm

    @Lisa Schotte, google asked me the same question (for which application ? would you send a screen shot or document of the application)
57. Lisa Schotte October 14, 2011 at 2:05 pm

    Google still has not issued me an api for this. I sent them all the details of this plugin. Has anyone else ran into this issue if so what did you do to get the api.
58. Luminaire enfant October 14, 2011 at 2:38 pm

    I am interested in this answer too.
59. Tom October 27, 2011 at 6:11 pm

    Incredibly powerful and a huge time saver. Can’t believe it’s free too! Many thanks
60. Francisco MEza November 3, 2011 at 6:26 pm

    For some reason I can’t get this to work on my PC (Windows 7 x64 with Microsoft .NET Framework 4 Client Profile) for Excel 2010 x64. Macros are fully enabled. I can see the plugin populates the cell when I put =getadwordavg(“cats”), but I get a #VALUE!

    It works perfect on my laptop Excel 2003 though. My conclusion is that there may be a problem getting the add-in to sync with the Adwords api in Windows 7. Already uninstalled and reinstalled the plugin with no luck.

    Any ideas or suggestions would be great.
61. Alexander Pokorny November 8, 2011 at 10:16 pm

    Hi Richard,

    It’s an amazing tool thank for creating this, I’m sure there were many hours/weeks put into it!

    Is anyone getting a error like this?
    Error: Google.Api.Ads.AdWords.Lib.AdWordsApiException – RateExceededError

    It’s about every 15 keywords on average when requesting volume. Using this formula: =getAdWordAvg(A1,”EXACT”,”US”,”WEB”)

    Thanks!
62. Mark Simons November 9, 2011 at 10:01 am

    Holy Post Batman. I am working on a Analytics to Excel thingamajig and I can see some of the ideas in this going into that.

    Hopefully I can get it to a point where I can share it with everyone sooner rather than later!
63. Alexandre November 15, 2011 at 10:46 am

    Hi,

    Great post, great tool. Thank you.

    I’m just wondering if we can define the language. The results are different depedning on the language. For example CH-DE and CH-FR don’t provide the same data. Can we put the language in the fonction?
64. Psycholog Gdynia December 28, 2011 at 12:37 am

    Ive read all info, but i didnt found is that plugin for open source projects? Plz some1 help me with that..
65. Rohan December 30, 2011 at 4:40 am

    Hey Richard,

    This tools looks really exciting and can save me a huge amount of time. I wanted to ask, can I also get competition data and approx CPC data also with the keyword search volume? Will be a huge help to have this all in one place.

    Thanks again for sharing this great tool.
66. Nik December 30, 2011 at 10:21 am

    Hi Richard,

    Great plugin, struggled to get access intially but all sorted now.

    Nik
67. Richard Baxter Post author Follow January 31, 2012 at 4:41 pm

    Hey everyone!

    For those asking for global search volumes, we’ve had that feature all along – by default:

    =getAdWordAvg(“cats”)

    Would give you global search on exact match (550,000 searches). If you don’t specify a country location code, you get global

    Hope that helps!
68. Harm te Molder February 1, 2012 at 7:58 am

    And in one try I figured out how to still use the other variables:

    =getAdWordAvg(“cats”;”broad”;;”web”)

    i.e. Still use semicolons but just leave the space for country location code empty.
69. Richard Baxter February 1, 2012 at 8:44 am

    I don’y normally use semicolons – I’ll do something like this:

    =getAdWordAvg(“cats”,”BROAD”,”GB”,”WEB”)

    Try playing with the array formulas (though turn off auto-recalculate!)
70. Harm te Molder February 1, 2012 at 11:09 am

    Sorry, that’s a Dutch thing (we use a comma instead of a point for decimals, so can’t use commas as variable seperators).
71. Richard Baxter Post author Follow February 1, 2012 at 11:10 am

    Cool – I didn’t know that #ExcelTrivia
72. Jenni February 4, 2012 at 1:09 pm

    Could any one help me how to get one Google Adwords API key?
73. Referencement Yandex February 4, 2012 at 2:22 pm

    If you want to get Google Adwords API you must have An account in MCC ( My Client Center) which allows you to handle multiple Adwords Accounts. If you didn’t activate MCC while creating your gmail account you can’t have the access to MCC. You must create another account here http://www.google.com/intl/en/adwords/myclientcenter/ Once created you can ask for google Adwords api. You will have to fill in a form, your request will be sent to google who will validate it or not
74. Antti February 13, 2012 at 5:55 am

    Thanks for a great API! This is a true timesaver! I also recommend to try http://nielsbosma.se/
75. Unlock Stuff February 23, 2012 at 1:57 am

    Just stumbled upon this now, kicking myself that I did’nt know about this way of doing keyword research earlier. Have tweeted about it to spread the word.
76. Li Ma March 1, 2012 at 10:10 pm

    Thanks for sharing this great API AddIn for Excel! I am having some problem after installed the Setup file. I always gave me an error message when I run a =getAdwords formula.
77. Thomas Schonenberger March 6, 2012 at 9:23 pm

    Hi Richard

    It seems that the tool has been hit by the latest API update on Google’s end. We have it installed on several machines and are now getting an error that “You are accessing an AdWords API version that has been discontinued”

    Is this a difficult thing to rectify? Does it need to be fixed by your developer team or is it possible for us to update settings somehow? Or is this tied to my API token?

    Any help appreciated!
    Tom
78. richard March 6, 2012 at 9:41 pm

    Hi Tom

    Yes we’ve updated the tool for the latest api version. just download the zip linked to in this post – it’s impossible to download the old version.

    Announcement here: https://seogadget.co.uk/update-adwords-api/
79. Trond March 7, 2012 at 10:32 am

    Hello Richard.

    Is it possible to do the same in Google Docs?

    I would be very happy if you could tip me of a way that makes it possible to automate all or part of the process via Google Docs, without the use of Excel.

    I also want to be able to import lists of place names, occupations, illnesses, and more from either files or database locally with us and get dumped this data directly into Google Docs that then handles keyword analysis automatically based on the imported data.

    Maybe you or someone else can point me in the right direction?
    Where can get/buy what I need?

    Any idea?

    Thank you in advance!

    // Trond
80. Ben Neale March 8, 2012 at 4:43 pm

    Thanks for this – I’m planning on using for a keyword report – having read Dan Peskin’s post on SEOMoz – “How to Build an Advanced Keyword Analysis Report in Excel”.

    I’ve applied for the Adwords API – having set up a new MCC account – as you’ve suggested, but my application is still pending approval a week later. How long does it take typically? And what are the criteria for approval?
81. Richard Baxter March 8, 2012 at 4:52 pm

    Hey Ben

    It takes at least two weeks buddy – sometimes longer. Best of luck!

    Richard
82. Richard Baxter March 8, 2012 at 4:53 pm

    Hey Trond

    I’m not sure we know how to get adowrds API data into GDocs. You might need to roll your own scraper. I sugegst starting out with Distilled’s how to: http://www.distilled.net/blog/distilled/guide-to-google-docs-importxml/

    Bests,
83. Ben Neale March 8, 2012 at 4:57 pm

    Thanks Richard – that’s good to know. I’ll be patient then. I read somewhere else it was 2 days.
84. Richard Baxter Post author Follow March 8, 2012 at 5:05 pm

    Haha! I’d be delighted if it was 2 days…
85. Scott March 8, 2012 at 5:53 pm

    Awesomeness again from the SEOGadget team! – Now is being a Mac user going to make this throw a wobbly? – I´ve had issues with Mac Excel extensions not quite performing as they should!
86. Richard Baxter March 8, 2012 at 5:59 pm

    Alas, Scott. No there is no support for Mac. It’s not us, (I’d love to support those shiny, virus proof little beauties), it’s ExcelDNA – the framework the extension is built in. Sorry!
87. Scott March 8, 2012 at 8:28 pm

    Bugger!
88. Ben Neale March 8, 2012 at 8:39 pm

    I’m on a Mac, and although I have Excel for Mac, I also run Excel for Windows on Parallels for anything that requires Excel to interact with an API. Once I have the data, I’ll save it and open the xls on Excel 2011 for Mac to do any data manipulation and reporting. It’s not ideal, but actually it’s a pretty good workflow.
89. Scott March 8, 2012 at 9:21 pm

    Thats an excellent workaround Ben thanks!
90. Ben Neale March 13, 2012 at 8:45 pm

    Hi Richard,

    I’ve just had a follow up email from Google, asking more questions about what i’m going to be using it for. Would it be OK to mention / link to your Excel Extension and Excel DNA?

    Ben
91. Galyna April 3, 2012 at 12:06 am

    Can’t wait to use the tool but also waiting for API approval.

    @Ben, how about you? Have your account been approved? What did you write back to Google?
92. Ben Neale April 3, 2012 at 12:32 am

    I’ve hd several follow up emails from Google – normally about a week or so apart – each asking for more information – about how I am going to be using the API, and who else is going to be using it. I’ve explained that it’s really quite simple ( I want to be able to get Search Volumes from the Keywords Tool into Excel, and sent then links to this page and others which describe how it’s used.

    However they are asking for quite detailed information – hopefully grant e access soon. I’d like to get on with using it!
93. Galyna April 3, 2012 at 12:39 am

    Thanks for respond! I’d really appreciate if you will share once you get approved and maybe any other details Google needed from you.
94. Damian April 4, 2012 at 2:31 pm

    Hi

    Nice Tool iLove

    Do you integrate the new beta version of the keyword group idea function (soon)?
    http://rowanbarnes.me/ad-group-ideas-beta-google-adwords-keyword-tool-2/

    Best regards
    Damian
95. Chris April 24, 2012 at 10:12 pm

    Any idea of how much this cost’s? For example Cost/Query? Any suggestions to get approved by Google?

    Thanks
96. Sumit May 4, 2012 at 11:00 pm

    Hi,

    Thanks for the tool , its great.
    Also,is it possible to extract campaign/adgroup performance level data using this tool ?

    Thanks,
    Sumit
    S
97. Tony River May 19, 2012 at 12:42 am

    I got this a couple weeks ago, requested approval for an api connection, but my status is still “pending” nearly a month later. Yesterday I finally got an email asking me to for some additional info, I hope I don’t have to wait another month. This is what I am getting, in case the current “pending” key should have worked. TargetingIdeaService.get Error: Google.Api.Ads.AdWords.Lib.AdWordsApiException – QuotaCheckError.INCOMPLETE_SIGNUP_USER_INFO_PENDING @
98. Newbie11 May 31, 2012 at 1:59 am

    Hi there,
    I input the incorrect developer toekn on settup. How can I correct this?
99. Jan May 31, 2012 at 8:28 pm

    Hi, i wrote a long article about the API as well, so if you’re interested check it out: http://www.kammerath.net/google-adwords-api.html Cheers, Jan
100. Alam June 3, 2012 at 7:58 pm

     @Richard Baxter
     Is it free to get Google Adwords API Key? Its asking for my Credit card.How i can use Google Adwords keyword finding in Microsoft Excel for free?
101. Alam June 3, 2012 at 11:25 pm

     @Richard Baxter,
     If i create account for Google Adwords API Key using my Credit card and get approved by google for developer token, then if i Setup the Microsoft Excel tools And Use for keyword research, is it gonna charge from my credit card?
102. Ben Neale June 6, 2012 at 10:25 am

     Nearly 3 months after my application – with about half a dozen email during the first 3 weeks, followed by 2 months of silence, I have finally heard back from Google. They declined my application, with the following explanation:

     “Please note, as per the API T&C’s, usage of the AdWords API exclusively for Targeting Idea Service (TIS) and Traffic Estimation Service (TES) such as keyword research and keyword suggestions is not allowed. Due to this, we are unable to approve your token application.”

     Given that I told them how I would be using the API on day one, you’d think they could have mentioned this then, and saved me the bother!

     Any ideas about what my next move should be would be greatly appreciated.

     Ben
103. Alam June 6, 2012 at 6:46 pm

     please anyone help me in buying API.i need details about cost, how many keywords i can get, how long its going to stay, how i have to pay and many more if you know
104. Sumit June 21, 2012 at 7:07 am

     Hello,

     Is there a way i can pull campaign performance report using this plug in ?

     Thanks,
     Sumit
105. Jon July 5, 2012 at 12:00 pm

     $0.25 per 1000 queries.
106. Jon July 5, 2012 at 12:01 pm

     You can’t for free.
107. Jon July 5, 2012 at 12:01 pm

     It is.
108. Sean July 31, 2012 at 7:24 pm

     Is it possible for me to modify this for use with Bing’s API? Or do you happen to have an updated one that works with both Google and Bing?

     Thanks,
     Sean
109. Marcel September 5, 2012 at 9:13 am

     Hi there,
     thank you for this tools of awesomenes. I have a little problem though: the tool never throws me results for january if I enter the following request: =arrayGetAdWordStats(“fahrrad”;”EXACT”;”DE”;”WEB”). Could you help me with that? Thanks in advance,
     Marcel
110. Richard September 6, 2012 at 12:16 am

     Hi Marcel,

     Looks like you’re using teh array formula for a single keyword – if you make a table (CTRL+L) and name it “KW” with a list of keywords, the formula would look like this:

     =arrayGetAdWordStats(KW;”EXACT”;”DE”;”WEB”)

     For a single keyword, a formula more like this will work:

     =getadwordavg(“fahrrad”;”EXACT”;”DE”;”WEB”)

     Hope that helps,
111. Marcel September 7, 2012 at 2:58 pm

     Hi Richard,
     thank you very much for your answer. I appreciate your support.
     Unfortunatelly it still doesn’t work. If I request the getAdWordStats I still don’t receive results for january no matter whether I use arrays or single cells.
     The formula =getAdWordStats(B2;”EXACT”;”DE”;”WEB”) – B2 beeing the KW “bmx” in this case – presents the following column of figures:

     27100,0,22200,22200,22200,22200,27100,18100,22200,22200,33100,33100,33100

     Any idea? Sorry for spamming the comments
     Thanks again,
     Marcel
112. Freddy September 24, 2012 at 9:31 am

     Hi Richard,

     Same here

     Tried for a couple of kwds in broad web and searched in the land down under but no luck here.

     Thanks for your support

     Looking for your help.

     Freddy
113. Damian November 27, 2012 at 11:17 am

     Hi

     Why is the Broad-Request not anymore possible? Because in the Keyword Research Tool of AdWords, Broad is still available…

     Thanks
114. Jeff Gold Follow November 27, 2012 at 4:47 pm

     Hi Richard – I’m getting this message. Any ideas? thanks for your help. “TargetingIdeaService.get Error: System.IO.FileNotFoundException – Could not load file or assembly ‘System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=…”
115. Thomas Schonenberger Follow December 11, 2012 at 12:23 pm

     Hi Richard

     Been using this plugin for a long time now and it really makes a big difference. Great piece of work that you have given away.

     Lately a few of us have had a severe problem with [RateExceededError]. It used to be 1 in 15 like Alexander above mentioned, but now it has become so severe that the tool is not useable.

     How do we go about throttling down or fine tuning the settings for the query rate? It seems we simply hitting it too fast, or is this a error a sign of another problem?

     Any help most appreciated!
116. Thomas Schonenberger Follow December 11, 2012 at 2:51 pm

     Thank you Mr.Baxter for the quick response – Seems I should be using the =arrayGetAdWordStats(Sheet1!A1:A345,”EXACT”,”GB”,”") function instead of running a single api query per line!
     Tom
117. Richard Baxter Post author Follow December 13, 2012 at 1:07 pm

     No problem!
118. Jack Follow December 19, 2012 at 10:57 am

     I guess I’m late to the party. Just found this, having a look now.
119. Gus January 9, 2013 at 12:09 am

     Hi Richard,

     Wondering if you have encounter the following issue when installing the AddIn:

     “Run-time error ’1004′ – Unable to set the installed property of AddIn class”?

     Windows XP – Excel 2007

     Any advice is highly appreciated.

     Cheers,

     Gus
120. Richard Baxter Post author Follow January 9, 2013 at 1:51 pm

     Hi Gus,

     I asked our developer, Tom. Here’s what he said:

     It’s a known bug with Excel (not just XP) with no apparent fix. Seems to be caused by corruption of the registry which happens over time as new versions/addins are installed/uninstalled.

     Work around, rebuild machine and re-install or simply manually enable the add-in.

     For that to happen the XLL and (credentials modifed) config file need to be in the Addins folder (most likely there already as this failed attempt at auto-registering happens after the copying of files), then just go to the background menu and enable the addin.

     Hope that helps!
121. Gus Follow January 10, 2013 at 9:17 am

     Thanks Richard,

     Will give it a try and let you know how it goes!

     Cheers!
122. Espen February 14, 2013 at 1:07 pm

     Hi!

     First of all thx for an awesome tool.
     If i would only get it too work properly itwould be great.
     When i am trying one of sthe standard functions=getAdWordIdeas(A1,”EXACT”,”NO”,”WEB”,”20″)i get the following error: the formula you typed contains error.
     If i then click on the desired keyword column it changes formula to:=getAdWordIdeas(A1). It the produces ideas but not specified for Norway any longer. Please help.
     Thx in advance:)
123. Espen February 15, 2013 at 6:57 am

     It worked when i use the formula insert function:) But one showstopper for me is that i can’t define language. is this possible?
124. Nigel Follow March 25, 2013 at 12:55 pm

     Great tool, but what are the chances of getting this to work on MAC?