For any SEO specialist, forecasting organic traffic is one of the most important tasks, allowing for regular evaluation of a chosen strategy’s effectiveness. In practice, covering all relevant keywords — potentially thousands — is extremely time-consuming and complex.
Our SEO Traffic Forecasting Tool by DzenWay (created by Bohdan Kravets) solves this problem in minutes. It not only saves hours of work but also allows you to flexibly customize growth models for keyword groups, tailored to the specific needs of your project.
Key features
- Quick analysis: Instantly generate a monthly traffic forecast for any number of keywords.
- Versatility: Use it to forecast traffic for an existing website or assess a brand-new niche.
- Flexible configuration: Define the growth model for keyword groups and customize the position-to-CTR correlation to fit your business specifics.
How to use it
1. Prepare initial data
You’ll need to gather the following:
- Keywords: A list of target search queries.
- Keyword Volume: Monthly search volume for each keyword.
- Keyword Position: Current ranking position for each keyword.
Note: When forecasting for a new niche with no website, enter keyword positions as 80–100 or higher.
Once collected, paste this data into the “Keywords input” tab.
2. Duplicating Keywords by Month
To generate a yearly forecast, run the script that duplicates each keyword 12 times — once for every month. To do this, click on the “Keywords Tool” menu in the top bar of Google Sheets and select “Duplicate Keywords by Months”.
After a few seconds, the script will complete its task and create a new tab called “Duplicated by Month” with the duplicated data.
Copy all the cells containing information from this tab.
3. Paste data and run calculations
Go to the “Here” tab and paste the copied data into the white, empty cells.
⚠️ Note: The gray cells contain formulas. Make sure to drag them down to the bottom of the table so that calculations are applied to all keywords.
View the final output in the RESULTS tab. There, you’ll also find a seasonality coefficient column, which you can adjust if needed.
Advanced configuration
The default version of the tool uses standard settings based on average values. If you need more precise customization, switch to the advanced mode: “Dzenway SEO Traffic Prediction”.
1. Setting the growth model for keyword positions
In the GrowthModel tab, you can define monthly growth rates for 5 keyword groups.
Specify the expected position increase per month, based on each keyword’s starting rank. Adjust these parameters to match your own insights and the specifics of your niche.
2. Configuring position-to-CTR mapping
Customize the formula that defines the CTR (Click-Through Rate) based on keyword position.
For example, you might set Position 1 to 40% CTR, and so on.
Tune these values based on your project’s specifics to ensure that the final projections accurately reflect real traffic dynamics.
Ready to Get Started?
Now that you’re familiar with how to use Dzenway SEO Traffic Prediction, you can generate SEO traffic forecasts for any keyword volume in just a few clicks.
This tool is an indispensable asset for SEO specialists and business owners who want to adapt strategies quickly and maximize performance with data-driven decisions.
