Post by kmstfatema on Mar 5, 2024 5:13:17 GMT
In this article we see an uncommon method for analyzing the positioning of a website . This type of analysis is useful for defining and prioritizing optimization interventions, searching for the situations in which there is the greatest margin for improvement. The technique we will use is very visual and: It allows you to identify at a glance some elements that you can work on. It allows for better communication (for example, with the customer, who can be shown graphically what you intend to do). Once set up, it is easily reproducible by simply replacing the input data. We will mainly use the free Orange tool : data visualization, machine learning and data mining software. Orange: Data visualization software Data recovery and preparation The first step involves the recovery of all the data on which the analysis will focus.
Having a good amount of data is important for any type Germany Telegram Number Data of analysis and, in this case, we will mainly use those made available by Google's Search Console . The data to be recovered are: Click; Impressions; Click to Rate (CTR); Average position. The basic data from which to start the analysis For this step, the use of the Google Sheet addon is very useful: "Search Analytics for Sheets" , which allows direct export from SC and allows you to associate each key and data with the relevant reference page. Using the Search Analytics for Sheets addon We can select a time horizon relating to the data we want to analyze. The choice of period must be made with two criteria: Have sufficient data for a good analysis; Obtain an average position and relative CTR that reflects current events as much as possible. A time horizon must therefore be selected that is neither too broad nor too short. To the "Base" data we can add all the information that allows for a more complete analysis such as: Title and Meta Description (obtainable via Screaming Frog) Conversion data (from Google Analytics or Google Ads) Off-site information (e.g. number of incoming links to the page) In this example we will only add information relating to the page titles.
After collecting the data, it is essential to prepare it correctly : the format of all fields containing values must be numeric. The advice is to use the custom format shown in the image because it avoids using the (,) in the whole part of the number which can cause problems. Better to use the custom format Before importing the data into the tool that we will use for the analysis, we can filter all the less interesting keys (for example, remove branded keywords). Let's now see how to import the data and analyze it. Import Data into Orange and build the tree To import data into Orange we must use the "File" function and enter the address of the Sheet we created in the appropriate field. How to import data into Orange software After the import we will have to set the “Type” and “Role” fields as shown: Setting the “Type” and “Role” fields in the Orange software Subsequently, we build the analysis tree which will contain all the necessary elements. We will use: Data Table: to view the tables containing the data.
Having a good amount of data is important for any type Germany Telegram Number Data of analysis and, in this case, we will mainly use those made available by Google's Search Console . The data to be recovered are: Click; Impressions; Click to Rate (CTR); Average position. The basic data from which to start the analysis For this step, the use of the Google Sheet addon is very useful: "Search Analytics for Sheets" , which allows direct export from SC and allows you to associate each key and data with the relevant reference page. Using the Search Analytics for Sheets addon We can select a time horizon relating to the data we want to analyze. The choice of period must be made with two criteria: Have sufficient data for a good analysis; Obtain an average position and relative CTR that reflects current events as much as possible. A time horizon must therefore be selected that is neither too broad nor too short. To the "Base" data we can add all the information that allows for a more complete analysis such as: Title and Meta Description (obtainable via Screaming Frog) Conversion data (from Google Analytics or Google Ads) Off-site information (e.g. number of incoming links to the page) In this example we will only add information relating to the page titles.
After collecting the data, it is essential to prepare it correctly : the format of all fields containing values must be numeric. The advice is to use the custom format shown in the image because it avoids using the (,) in the whole part of the number which can cause problems. Better to use the custom format Before importing the data into the tool that we will use for the analysis, we can filter all the less interesting keys (for example, remove branded keywords). Let's now see how to import the data and analyze it. Import Data into Orange and build the tree To import data into Orange we must use the "File" function and enter the address of the Sheet we created in the appropriate field. How to import data into Orange software After the import we will have to set the “Type” and “Role” fields as shown: Setting the “Type” and “Role” fields in the Orange software Subsequently, we build the analysis tree which will contain all the necessary elements. We will use: Data Table: to view the tables containing the data.