Now from the “Site” section, select the website. Now give the name to the data source and select “Search console” to create the data source. Now go back to the Looker Studio page and create a second data source with Google Search Console. Now you have the Keywords and Landing pages from the keywords sheet as dimensions. Select the sheet tab with keywords from the “Worksheet” section and click on the “Connect” button. Now click on the Keywords spreadsheet you have prepared in the “Spreadsheet” section. Now search the keywords sheet you prepared earlier through any option on the page.Give a name to this data source and click on “Google Sheets”.Click “Create” and select “Data source” from the drop-down list.First, let’s create a data source with the keywords sheet that we have prepared.Now we have to create two data sources, one with the Google Search Console and another with the keywords sheet that we have prepared on Google sheets in the first step.Now open the Google Looker Studio from the Google account on which you have access to the website GSC account.
You can add as many keywords as you want later that you want to track, which makes this tool scalable per your needs. This sheet will work as a data source for the rank tracker dashboard.
Prepare a Google sheet with all the keywords and the targeted URLs of the particular website you want to track and name the sheet whatever you want to be. Steps to Create the Keywords Rank Tracking Dashboard on Looker Studio You must prepare a list of keywords on a Google sheet that you want to track. You need to have access to the website GSC (Google Search Console) account to get the average positions of the keywords. The keywords positions are the average positions of the keywords/queries from the GSC. You can track unlimited keywords through this dashboard and customize this dashboard as per your needs. In this article, I will explain everything about the keyword rank tracking tool you can build on Google Data Studio, now called “Looker Studio,” for free.