We will put Florea and her 3 other competitors next to each other (you can easily do it for fewer/more competitors) and we will observe which queries those competitors appear and at the same time Florea does not appear. Method: 2.1. Pairing data to Excel 2.2. URL segmentation and pivot table creation 2.3. Preparation of comparison table and matching of data 2.
- Identify interesting query segments and sort them into the STDC framework 2.5. Import and prepare output 2.6. Process the outputs into an action plan The Mongolia Email List first step will be to pair the data of all competitors into one Excel. 2.1. Pairing data into one Excel We will make a copy of the original Florea.cz dataset (without modifications), which we downloaded from the Domain profiler.
We download the data of our competitors from , for example article. We open the Florea.cz dataset without modifications and go to the last line (in our case, line 6261 ) in which the data is located and copy the data from the other competitors' datasets below it. This means, we open the first competitor (e.g. Flora-online.cz ), go to cell A2 and use the keyboard shortcut Shift+Ctrl+down arrow to mark all rows in the first column, and when we also press the right arrow ( we keep Shift+Ctrl pressed ), we will mark all the data (after pressing Ctrl+C ) that we want to copy.