SEO campaigns Profitability
And I explain a bit here …
Investing in SEO: Well, that, the cost of your SEO campaign. What I get paid to seo, further purchases of bonds (the buy), etc …
Keywords: The compete effectively and resulted from an effort seo. Goes with stop words and variations that lead to the same url optimized.
Location: In the SERPS
Visits Through Google, since the CTR used are those of a study from Google.
Conversions: Onjetivos accomplished through SEO.
Cost Unit visit: Calculated automatically. (Total cost between visits total)
Revenue Forms: To be determined by you, you ought to give an approximate value of the income you could generate a sale through form. Excel in all forms I guess just in sales, whereas he should incorporate a% success on forms received. Perhaps in the beta 2 excel.
Net Benefits: Automatic (Revenue – Cost)
ROI: Return on investment (revenues – costs) of costs.
Current CTR: Automatic. This cell is only informative and nested conditionals by placing the CTR on Google, according to the position.
Costs + 1 position: It is the position estimated potential visits and what it would take up position to compete. Failure Not all keywords are the same to compete, so that future versions will try to find an optimal way to do it.
Potential benefits pos + 1: A potential costs them less potential revenue to cover a position, recalculating the visits and revenues through the current ROI.
Graph: To view which should be easier to compete.
Clarifications.
Sometimes it says it is not advisable to compete in position 4, ie in the fifth always going to say that the position 4 has a lower CTR than the fifth, so it must be modified in future versions to recalculate +2 positions.
Improving conversion is triggered if the benefits seen are negative, but not always depend on the% of conversions because they increase the visits for the same investment could be positive.
Finally, you can download it here and most of all you are looking for feedback to improve it, use it in my work and of course share it …
A greeting!