good reporting tool

[smallcompany]

My post is here, under AdWords, although it relates to any PPC engine; simply because most of PPC people look here first.
I am looking for a tool that gives you an option to aggregate reports from multiple accounts and multiple engines. My aim is to see a report that shows the total cost of a particular keyword, wherever it is located.

Thanks

[BDuns]

huh...one thing i though of that may make things difficult is that our keyword lists in google are so much longer than those in yahoo or msn.

so, using the keywords widget and widgets....

google will accept both. yahoo and msn may only take "widget," because their system will cover both the singular and plural versions. In your report, however, you'll probably find that the numbers you get for the keyword "widget" is including impressions from yahoo and msn searches for both widget AND widgets.

Plus, with the differences in the match type from engine to engine, you will probably get some pretty skewed results.

I think i'm getting confusing, but my point in all of this is that actual search queries that will trigger your ads will be so different from engine to engine. So you'll be able to see how much that keyword is costing in total...you won't really have a lot of information to help you decide what to do about that keyword.

[Zuckerman]

You could probably set up some quick & easy Excel formulas using v-lookups that could help in the short term, especially if you have a relatively small keyword set

[smallcompany]

We talk about close to 50 accounts across three major PPC engines - Unlimited URLs.

My idea is to have application that would be able to maintain “groups” you would create however you want. That means you pick two campaigns from one account, and one from another one, for example. Or you search for keyword “so and so” and get the result, from all accounts that have such keyword.
The end result should be that you can see the total cost of given keyword, ad group(s), campaign(s) or whole account(s).

Right now, we have to manually pick data and add in Excel, then to compare to earnings. No business can function efficiently this way. If I can aggregate the cost and check it daily, that would make the change, regardless the fact that we would continue to maintain our bids manually.