I'm confused as to how to quickly yet accurately put together an answer to potential clients how much traffic and cost they can expect with PPC. For example, if a client has a 5,000/month budget. I go and collect hundreds of keywords that would be good for their product. If I put these in google traffic estimator, I will have to assume the same CPC on all these keywords...results won't be accurate as some keywords will be $.05, some $3.00. How do I take these keywords and give an accurate click and cost number to the client, it takes hours to take a long list and keep testing CPC's in google traffic estimator to find the exact point they hit 1-3 ad position. Basically, I need a quick way to put together answers to proposals. Here's how many clicks you can expect at this cost?
I dont think that collecting hundreds of keywords will be good to your client's website... You should pick a set of keywords that will have high conversion rate which will mean higher profit to your client...
Isn't it necessary to find all those long tail keywords that will bring in small highly targeted visitors?
Mutt, you're doing it way wrong. Don't just go and pick up every keyword from the keyword tool. Look at the landing page, and history of the keywords. Also, ask your client, which keywords he thinks is more relevant to the product being sold. I have had tons of experience with targeting wrong keywords (naive in the beginning, I know) But, always... always target only those keywords which are relevant to your landing page and site (improves quality score.. overall)
Yeah, sound like you are making this more complicated then it needs to be. Just use a couple broad keywords that are relevant to the business, plug them into the traffic estimator and you should get a rough idea of what a click will cost. $2, $5, etc. Whatever the avreage click price looks like, you can then estimate the amount of traffic they will get. So, a $5000/month budget at $5/click should yield: 1000 visitors. You may want to take it a step further and try to estimate the ROI for the campaign. Use this AdWords ROI calculator to determine the return on investment for the campaign.