Welcome to WebmasterWorld Guest from 220.127.116.11
- how regular are your clicks?
- do they vary from day to day? (is that seasonal or random)?
- do you get a regular conversion to sales from your clicks?
- is there any consistency to the revenues?
If you are in a thin market you will get really inconsistent results, but if you persevere you will win.
Search for an online chi squared calculator, Calculate the result, and if the p value result is under 0.05, then you've got a statistically significant difference in those proportions.
I have a related question. I understand the statistical overall significance of say 3000 clicks and 30 buys. The question is how accurate can you predict which individual keywords produced these results if you have a total of 500 keywords and 30 conversions on those keywords?
Say that these 30 buys were generated by 25 individual keywords (and thus many keywords have 1 conversion attached) how significant is this conversion rate hence how certain can you be that you need to invest in these specific keyword?
Any statistical wizards?
Any of those keywords drops below what is 'currently' acceptable for the last 1000 impressions, or if your key phrase doesn't get near 1000 impressions, then your successful Campaign is GONE!
If your only worry is how to calculate statistics, then very well done. Can you give us all a tutorial?
For tracking so many keywords, you really need a very large sample to begin with. We often find that some keywords do well one month, and yet a completely different set do well the next month, so most of the keywords over a period of time are significent, but if you make too many changes each month, you might be missing out on some conversions over time.
For my most active client, I track around 1000 KWs. I generally wait to determine their significance (although I do look through this info and make small adjustments every couple weeks) until either:
1. The keyword clicks should generate x sales determined by the conversion % you are attempting to reach. (So, if you want to track 10 sales, and 1% conversion, then 1000 clicks)
2. The kw click cost is equal to double the average profit of a sale (I do occasionally lose money by waiting this long, but it's also saved me from killing underperforming keywords that suddenly have a surge).
3. Every 500 clicks for highly targeted, high cost KWs. Every 1000-5000 clicks for more general targeted, cheaper KWs.
4. The beginning of each month, I run the above reports for the previous month for 1-3. And also run a report (since branding is imporntant to us) of the entire campaign (based on ad base (i.e. google, ov, verizon) compared to sales, as a keyword that might only cost us a couple hundred a month, which loses money, we sometimes continue to run it anyway.
Note: For some campaigns, with small KW base and highly targeted words, we do combine the entire campaign together to determine signifigence, some of these campaigns only generate 100-500 clicks for a month across all ad groups.
Very imporntant, if you have a site with repeat customers. You want to determine what % of people buy from your site multiple times in a year. Then determine the profit per year of your average repeat customer. This savings (not having to pay someone to send them to your site, as they return directly) can be applied to increasing your ad dollars, taking a small loss or breaking even on your ads, as over the year, they will have spent more than what your KW cost implies.
With so many keywords, and the fact that some of the keywords I'm only looking for a .1% conversion rate (high profit/sale), it might take a couple months to hit all those conditions for any individual keyword. So often patience helps in getting your initial sample to begin tracking changes in search patterns and KW significance.
The post length got away from me, so I hope this helps.
Thanx for your elaborate and very useful post. As we just started using the Google conversion tracker (and did not use anything to do this before) and our product has a trial period of 14 days we have not seen enough conversions since the Google tool came out to be significant. I'll try some of your metrics to evaluate the performance of my campaign.
I have to say that this tool does make optimizing campaigns much more fun and profitable :-)