A critical part of any good business model is adjusting for relative competition.

I use a relative measure of keyword difficulty to do this, either average domain authority or competitiveness index, but you could just as easily use keyword difficulty score.

In the simple model I call it 'Average SERP CI ,' but it doesn't have to be, feel free to throw average SERP DA in there and everything will still work, just make sure you keep your metrics consistent between column G and the competitive weightings in H2 and H3.

Cell H2: Cost Multiplier - The cost multiplier is pretty much exactly what it sounds like; it multiplies your cost based on the competitiveness threshold you set.

This represents how much more expensive it is for you to create content that can compete for a first page ranking based on your website's relative authority. If your website has a DA of 60, it is going to be easier for you to compete in SERP's where the average is only 50 versus 70.

Cell H3: CI Threshold - This is the authority or competitiveness threshold where it becomes more expensive for you to compete.

This threshold should be relatively close to your website's authority score, so if you have a DA of 40, you might want to set this at 50.