{SEO KOLKATA}{Allahabad Bank Building}{KOLKATA}{700129}{WEST BENGAL}{INDIA}{9836720921}
Allahabad Bank Building 700129 KOLKATA, WEST BENGAL
Phone: 9836720921

How You Can Forecast SEO Potential with Help of Google Data Studio

Posted on June 22, 2019 Posted in SEO

Everyone has been in this situation before. Someone is pitching the clients or the boss to find out a long-term and fruitful SEO strategy!

When the pitch went great, they love their ideas, and then the CMO says that

CMO: “So, if we partner with you, how much growth can we expect?”

SEO: “Oh, it doesn’t work like that. It’s actually impossible to forecast any specific improvements or ranking positions, because there’s no way to manually force a keyword to rank in a specific position. In addition, we can’t force users to take actions, only encourage them through…. Blah blah blah.”

CMO: “Cool, sounds great! So, what kind of growth can we expect?”


SEO Potential with Help of Google Data Studio

Caveats towards Forecasting SEO Potential

Trying to forecast on the SEO performance is quite a difficult task. It is easy to forecast on the SEO potential if you have consistent and reliable data from the search engines, but alas, there are no such resources. Before you start to present the new forecast model for pitching, it might make you think again about your intentions. It is quite impossible to be accurate, and these projects can merely bring some potential lifts. Here are some of the factors that prohibit accurate forecasting as like-

  • Algorithm updates
  • Competitive changes
  • Seasonality


How the Forecasting Model Work

Designing this model requires a little more work from your end. You might think that it was as simple as entering the domain name, but it involves more research and exercise. The data is then sourced to the Google sheets and it is presented in the Data Studio. The data studio dashboard is quite interactive and helps you to filter down several keywords and position to increase the scenario. The first thing that you should do is to source the data and plug it in the Google sheets.


  1. Finding the Source Data

Before you start, you have to make a duplicate copy of the SEO forecasting Google sheet. This is where you store all the source data. Now, you have to collect the source data. The core data that you look for comes from the keyword research. You can use any one of the keyword research tools as like. All the things that you need to include are-

  • Top 150 keywords you want to target
  • Average site conversion rate.
  • Average monthly search volume
  • Current position for the domain
  • Average traffic percentage by the device

The forecasting model is for showing the impact that SEO can have on small set of data. There point lies is that “Look at how much of a difference improvements on just 150 keywords can make. Imagine what would happen with an expanded optimization plan!”

The most interesting thing that this forecasting model does it that is solely looking at the impact of the targeted specific keywords in the SEO efforts. This means that it does not count for all search terms that lead to the organic traffic on the website. You can look at the top 150 keywords that you will believe will be impacting their performance. Once you have the 150 keywords, the current position and volume is that you will need to paste it on the Google sheet. After you have entered the keywords, you have to enter in some Google analytics data on the “Average CTR data and Inputs” tab. For this, you will require –

  • Average % of the organic desktop traffic
  • Average % organic desktop conversion rate
  • Average % organic mobile traffic
  • Average organic mobile conversion rate


  1. Connect the Google Sheets to Data Studio Template

We are close to the fun part. The next step involves duplicating the SEO Impact Analysis Scenarios Data Studio Template. Here, how you can connect the Google sheets to the Data Studio-

  • Open the link to the SEO Forecasting Data Studio Template
  • At the top of the page, click the copy image icon
  • It will help to generate the popup and ask to choose the “New Data Source”. Click the dropdown and then select the “Create New Data Source” at the bottom
  • As a data source, find and choose the Google sheets
  • Find the raw data sheet and select the data source


  1. Features of This SEO Forecasting Dashboard

The main feature of this SEO forecasting dashboard is to show how much impact the position changes can impact the CTR and site traffic. The number is calculated by factoring the average monthly search volume, where the average CTR by position and the current position. When you move your cursor over the bar graph, you can see new data populated by each one of the positions. Want to narrow your keywords? You can use the built-in feature that allow you to filter the results by specified keywords on you choose.


Put SEO Forecasting in Action

Why just use the quick numbers in the pitch desk when you provide by compelling visualizations to show the value? There are some other features in this dashboard for helping you to offer forecasting data to the prospective clients.


Thus, this blog provides information about how to forecast the SEO potential with the help of Google Data Studio.

100% Real Google & Trustpilot Reviews

Feedback and Testimonials from Our Clients

    TS Web Technologies, have been totally professional and have given me amazing results. After trusting them to design my company website and ongoing SEO and SMO, they have been totally professional and have given me amazing results. My company website is very modern and has given me a lot of business and admirers. Overall a fantastic company and very fair pricing. I would highly recommend them to everyone. Great job and thank you.

    Jonathan Davis

    I own a small business and had a cheap website initially. I was totally frustrated because of the negligible exposure of my website to the customers. On the recommendation of one of my friends I hired TS Web Technologies for a new design of my website. The result was amazing. They gave my website a fresh and stunning look. Also it helped in getting high number of organic search results. The search engines drive more traffic to my site.
    Thanks Guys for your great services.

    Ambi Klain

    Finally, I have found a trustworthy website development and SEO service company! They are so fast & responsive in their job. I had hired them a few days ago and all I had in return is good ranking of my website. They did what they promised to me as well as they are so friendly & professional. Their services are so great that my business move on beyond my expectation!! Thumbs up for you guys & Thanks for your great work!

    Charles Davis

    I have worked together with Soumya and Tapash for over 5 years now and completed a lot of successful projects. They have a fantastic web design team and very skilled developers who are now my “go to guys” for any web design or development work. Their SEO strategies do work and the time lines given are realistic.
    I am happy to speak with anyone if they are not sure about using these guys and wish them only the very best in the future.

    Mathew Balcombe

    TS Web Technologies has been guiding me through the SEO process at an extremely professional level. I will be doing some further on page work for now but once finished will certainly be rehiring his team again. The reporting level has been just outstanding. We are only at the first month of link building so obviously I can’t comment just yet on the site’s rankings. He has been very upfront about the process and answered all of my questions in a punctual and factual manner.

    Tom Clark

    I have been working with TS Web Technologies for a year now. The service is excellent. My clients are very happy as they are ranking on the first page of Google in less than one month for at least 3 out of 8 of the keywords. They also give support besides SEO should you have any problems. Their English is also excellent which really helps.

    Sandy Joselyn

    T.S Web Technologies is known to me as a company that has proven their excellence in the field of SEO. I had hired their services a few months ago and all I had in return is my cherished business and good ranking of my website. The best part of their services is that the rank of keywords remain consistent in-spite of the harsh algorithmic changes by the giant search engine. Thanks and looking forward to work with you.

    John Marshall

    T.S Web Technologies is a company that has proven their great and excellent work. Their services are so great that my business move on beyond my expectation. Many thanks to you.

    Jennifer James

    Great service!! I was really surprised they did the job on time. They have really wonderful web designer. Highly recommend them.

    Keira Darcy

    Thanks to the team for excellent service. Very happy thank you.

    Carol Trehearn

    Great people with great thinking!!
    TS Web Technologies is by far the most amazing professional company I have ever come across. The kind of service is simply outstanding. I am highly satisfied with the kind of service they have offered to me. I can bet they will come up with great results for any given project.

    Jason Hover

    I am impressed by the SEO services that TS Web Technologies offers. Especially their SEO team and the CEOs Soumya and Tapas are attentive and they are always available. Their SEO strategies, implemented for our company have improved our ranking in the search engine result. i would recommend to take their help.

    Petwants Bocaraton

Client Rating is 4.5

Client Rating 5

We Work with Global Brands

Convinced? Ask for Your 30 Minutes FREE Consultation!