I need an SEO ROI Calculator that can predict:
Cost of SEO
Current Organic Traffic
Revenue From Organic
Transactions from Organic
Leads from Organic (MQLs)
MQLs to Customers Conversions %
Average Order Value (AOV) / Average Sale Value
Projected Organic Growth
Projected Organic Traffic
Projected Orders/Leads from Organic
Projected Revenue from Organic
This would be in Google Sheets where all I would have to do is plug and play numbers on the fly and the outputs are automatically produce. There should be two columns this calculator produces outlets for: 1 for Ecommerce and 2. Lead Generation
You can see a reference here: [login to view URL] Go to the timestamp of 06:47. (The blue fields are areas that data cannot be inputted.
In an additional tab I would like an area where I can enter in keywords that I want to go after. Showcase their current rankings, target rankings I want to achieve, search volume of that keyword, Value Per click (current CPC). Then in this same section will show me if I put in $X amount total investment for SEO for these keywords and move the current rankings to the target keywords it will showcase how much total SEO ROI % will be from everything. I will attach an excel doc of it to this project.
A set of instructions must be provided on how to use this an adjusted if corrections are needed from not understanding the project.