I love scaling and automating, so my current setup is an Excel keyword opportunity model with the various business metrics described (CR, AOV etc) along with my basic costs for optimizing each keyword or landing page (x dollars for writing, x dollars for link acquisition giveaways etc). The model returns an ROI for the first month right away, so I normally just pull 50-100 keywords through the model each time I have time to take on new optimization campaigns and pick the most obvious opportunities.
If you are feeling a bit more ambitious an idea could be to combine this with some sort of relative score of competitiveness of the current SERP for each keyword, which could make the decision process even easier. Nick Eubanks of www.seonick.com has written about this before, however with other metrics than I use myself.
Feel free to reach out on simontorring@gmail.com if you need any help or input.
We've been talking to both existing customer's and prospective SEO agencies around California. Many are asking for exactly what you're describing: 'to combine this with some sort of relative score of competitiveness of the current SERP for each keyword'.
Comments
Hey Mike,
I love scaling and automating, so my current setup is an Excel keyword opportunity model with the various business metrics described (CR, AOV etc) along with my basic costs for optimizing each keyword or landing page (x dollars for writing, x dollars for link acquisition giveaways etc). The model returns an ROI for the first month right away, so I normally just pull 50-100 keywords through the model each time I have time to take on new optimization campaigns and pick the most obvious opportunities.
If you are feeling a bit more ambitious an idea could be to combine this with some sort of relative score of competitiveness of the current SERP for each keyword, which could make the decision process even easier. Nick Eubanks of www.seonick.com has written about this before, however with other metrics than I use myself.
Feel free to reach out on simontorring@gmail.com if you need any help or input.
- Simon
Simon,
We've been talking to both existing customer's and prospective SEO agencies around California. Many are asking for exactly what you're describing: 'to combine this with some sort of relative score of competitiveness of the current SERP for each keyword'.
I'll reach out to you personally! - Mike