{"id":3148,"date":"2023-07-05T20:16:11","date_gmt":"2023-07-05T20:16:11","guid":{"rendered":"https:\/\/singularity.digital\/?p=3148"},"modified":"2026-01-30T02:57:05","modified_gmt":"2026-01-30T02:57:05","slug":"content-revenue-template-how-to","status":"publish","type":"post","link":"https:\/\/singularity.digital\/pt\/insights\/content-revenue-template-how-to\/","title":{"rendered":"How to Use The Content Revenue Template"},"content":{"rendered":"\n

Like all good projects, SEO needs to start with a plan. To be a truly successful campaign, it needs to start with the data that\u2019ll point you in the right direction from day 0. Before you\u2019ve typed your first letter of content, you should already know that the best case scenario outcome is financially viable.<\/p>\n\n\n\n

Leading on from that, you should also be clear on which terms bring you the best effort:result ratio and how to measure \u2018success\u2019.<\/p>\n\n\n\n

With so much data and so many variables involved, it can be tough to compile all of this into a meaningful format. That\u2019s where our Keyword Opposition to Benefit (KOB) template<\/a> comes in. You enter a list of relevant competitor keywords and some base metrics, then the template gives you the projections you need to see.<\/p>\n\n\n\n

To take it a step further, you can also enter your month on month traffic and lead volumes to see how your actual results track against those projections over time. Doing work without measuring results leaves a lot of potential revenue on the table.<\/p>\n\n\n\n

Below, you\u2019ll find an overview of how to use this template and what you\u2019re looking at on the dashboard.<\/p>\n\n\n\n

Note: This file relies on data from Ahrefs or SEMrush. Both are paid SEO platforms, neither of which we are affiliated with.<\/p>\n\n\n\n

The Dashboard<\/h2>\n\n\n\n

Consisting of 6 graphs that use the metrics you’ll put into the rest of this sheet. The first 3 graphs give you the best-case scenario for traffic, leads, and revenue if you were to write and rank every piece of content in the 1st, 2nd, 3rd or 4th spot on Google.<\/p>\n\n\n\n

Taking the statistics for each keyword, conversion rate and LTV we can return monthly numbers for each of the metrics below. These graphs represent the best case scenario for you when considering engaging in an\u00a0SEO-led content<\/a>\u00a0strategy.<\/p>\n\n\n\n

\"Screenshot<\/p>\n\n\n\n

The bottom 3 graphs give you a more realistic view of ranking returns. More realistic because they expect that at any given time you will only be able to rank between 10-30% of your target keywords in the top 4 spots of Google. <\/p>\n\n\n\n

Each line in the graph represents a ranking scenario between 10 and 30% and each mark on the X-axis represents the position you keywords are ranking at minimum. The final graph shows your actual performance so you can measure it against the projections presented here as you engage content marketing. <\/p>\n\n\n\n

At the top of the dashboard sheet you’ll see the yellow table below. We’ve added dummy data to it but if you enter your own data here as the months go on and you get results the graph will fill in for you and allow you to use this in reporting.<\/p>\n\n\n\n

Monthly organic traffic forecast<\/h3>\n\n\n\n

This chart shows your best case scenario if you were to improve your ranking to position 1, 2, 3 or 4 for all the keywords you\u2019ve entered.<\/p>\n\n\n\n

\"Chart<\/p>\n\n\n\n

What you\u2019re looking at here isn\u2019t attainable metrics, it\u2019s a snapshot of your absolute ceiling if you were to target the keyword set you\u2019ve entered. If the numbers you see here are lower than you would deem to be a feasible end result, you\u2019ll need to look at a different strategy or at least a new keyword set.<\/p>\n\n\n\n

Monthly organic leads forecast<\/h3>\n\n\n\n

Following on from the previous chart, this one gives us those same metrics but for organic leads rather than traffic.<\/p>\n\n\n\n

These metrics are based on the average conversion rates you entered.<\/p>\n\n\n\n

\"Chart<\/p>\n\n\n\n

<(Projected Traffic * Website Conversion Rate)\u00a0\u00a0<\/i><\/p>\n\n\n\n

Monthly LTV forecast<\/h3>\n\n\n\n

Marketing is about revenue. This third chart shows what these ceiling metrics look like as bottom line figures\u2014the total amount of LTV revenue you could possibly make from this keyword set.<\/p>\n\n\n\n

((Projected Traffic * Website Conversion Rate) * Lead Conversion Rate) * LTV<\/p>\n\n\n\n

At any point on the graph below you can see the lifetime value generated monthly from your content marketing efforts. <\/i>
\"Chart<\/p>\n\n\n\n

Realistic monthly traffic projections<\/h3>\n\n\n\n

From the small nimble content team to the 80 person strong freelance writer organisations like Zapier. No one ranks in the first position of Google for every keyword they target. The following 3 graphs are based on that fact. Unlike the first graphs these give you traffic, leads and revenue projections based on ranking somewhere in the top 4 results for between 10% to 40% of the keywords you added into the KOB sheet.<\/p>\n\n\n\n

These are best used to help tamper and set expectations for you and your team when looking at realistic returns. Especially in the beginning. When trying to rank for just 10% of your keywords in the top 4 spots of Google is a tall order.<\/p>\n\n\n\n

Each line in the graph represents a ranking scenario. That ranking scenario changing by how many keywords from the previous KOB you have in positions 1-4 (depending on the X-axis).<\/p>\n\n\n\n

For example, if you ranked #4 for 10% of the keywords entered, you would get X traffic. This can be compared against ranking #3 for 20% of those keywords to see just how much of an influence you can have with relatively mild improvements.<\/p>\n\n\n\n\n

\n \n

Clarity Over Chaos<\/h3>\n \n

Content doesn\u2019t need to be complicated. We help you simplify and scale what works.<\/p>\n \n \n \n

\n Book an Intro Call<\/a>\n \n <\/div>\n \n<\/div>\n\n