Can anyone please point me in the direction of any tools that one could use in-house to help manage a reasonable-sized account?
Having worked in the keyword mgmt space for the last 5 years, I can tell you of a few different tools out there:
SearchCenter (Omniture's tool, well-integrated with their SiteCatalyst web analytics product which is the 800-lb player in that space)
DART Search (part of Doubleclick which is now part of Google). Tool's been around a long time and is now in Google's hands.
Efficient Frontier Express (a good option is you want good optimization math and don't need campaign administrative features)
Marin Software (new entrant into the space but have flexible terms and a relatively slick UI)
Acquisio (targeted towards agencies)
ESearchVision (Paris-based but claim to have good math. IMO there's some serviceware to it, but that's just MO)
I'd stay away from Atlas Search as by their own admission its automated campaign mgmt feature doesn't work in opaque bid marketplaces (ie G, Y! or MSN). Again, just my $0.02.
-Shorebreak
I'm mainly enquiring on behalf of a group of brand managers who manage some campaigns as a part of their job. Basically they should just be getting on with things like creating content or landing pages, and both the bidding and the account structure should be managed by something else.
Thanks for your suggestions so far.
Shorebreak - you used to work for Efficient Frontier right?