Simple Web Analytics Report to Help You Lower PPC Spending
By Igor Mordkovich on Sep 11, 2006 in Google, Increase Conversion Rate, General, Online Marketing, PPC (Pay Per Click)

Are you close to going over your budget or do you feel that you might be wasting money on some non-performing keywords with your PPC program? … here is a quick report to help you.
As you know Google allows you to add “negative keywords” into your campaign that it will exclude. What that means is … if your prospect types in a word “free” with a relevant keyword, Google can exclude your ad from showing up in the paid search results. Many advertisers do this simply because … well, they don’t want to pay $5 per click for a person who’s searching for their product with a goal to pay nothing for it.
There is a simple report you can run using your web analytics to find these negative keywords you might not want to pay for.
Create a report to show you those visits that bounce from your home page. Basically …. a 1 page visit. There is already a red flag. Then … filter out those visits that come from your PPC engine. Depending on your web analytics tool, you should be able to see the exact search phrase that 1 page visitor typed for which you paid.
I noticed that whenever advertisers do this report for the first time, they are amazed at how much money they waste on keywords variations they wouldn’t want to bid for.
Want an example?
EX1. “Free your keyword”
EX2. “Stock report your keyword”
EX3. “Your keyword Jobs“


We are currently using Google analytics and I do not see a way to do this. Is there an additional tool I can add to see this data?
greg | Sep 18, 2006 | Reply
Greg, you can create that report using Google Analytics.
Simply go to your Marketing Optimizations … then click on “Search Engine Marketing” then click on “Overall Keyword Conversion”.
The be sure you’re displaying 500 keywords instead of 10 that they usually show.
This report will show you the words people type when they click on your ad.
Igor Mordkovich | Sep 19, 2006 | Reply
Thanks Igor
That is a great Tip!
greg | Sep 19, 2006 | Reply