YIn the competition analysis , I have creat a code in Google Colab, which will help you facilitate the process as follows:
You can, in a single search, extract the first 10 results for all the terms relat to a specific search. For example: “best vacuum cleaners”, “best vacuum cleaners in Colombia”, “vacuum cleaners with the best reviews”, “vacuum cleaner companies in Bogotá”, among others.
You can download these results in an xlsx file to open in Excel or upload it later to a tool like Google Sheets.
Here I give you the two resources to extract the results
ou will see the article I wrote to extract the first 10 results from Google massively, in which I explain the step by step to create a document in Google Colab and how to run the Python code in the tool.
Is the Google Colab file if you want to use it directly engineer database without having to see the code explanation.
Extracting data from Google Ads with Python
Analyzing digital competition also refers to understanding the main competitors in advertising, especially Google Ads.
extract-information-google-ads
Can you imagine all the analysis potential you can have by analyzing the ads that are display directly in the search engine? By doing so, we can extract data such as the following:
And doing this activity also allows us to have a good 5 big seo mistakes to avoid in 2024 resource to optimize landing pages , or to generate better texts in our own ads. However, as you can imagine, doing this activity ad by ad is really exhausting, especially when we are looking to analyze large volumes of data.
To do this, the goal
Is to extract the three or four ads that are display after both fans data the top of the results on Google and those locat after the last result.
If you enter 10 search terms, we are talking about approximately 40 ads that you extract in just one click.
As with the SEO exercise, it is necessary to create an account in SerpApi and thus have access to an API key that will allow you to extract Google ads massively.