Between school returns, those of clients and personal projects. I don’t have enough time so I’ll be concise.<\/p>\n
First, let’s rephrase the context:
\nDuring a Growth Hacking course we had to launch a product and get a maximum of feedback in 1 week… the rather vague instructions just had to be worked out to validate an MVP (minimum viable product) while respecting the AARRR framework.<\/p>\n
The idea of the group:
\nWe play the role of an importer of Brazilian products looking for potential new customers (restaurant).<\/p>\n
dinner event, landing page, social networks….. not bad for finding qualified lead but not enough.<\/p>\n
So how do we expand this base?<\/p>\n
By Scrapping Trip Advisor… finally we get to the heart of the matter<\/p>\n
Let’s start with Adrien Lachaize scrapping small definition:
\n“Web Scraping is a technique for extracting information from websites. This technique focuses mainly on the transformation of unstructured data (HTML format) on the web into structured data (database or spreadsheet).”<\/p>\n
In our case, a restaurant’s page on Trip Advisor always follows the same architecture, which makes it much easier to extract data.
\nOften we read occasionally that it is necessary to make scripts in python, javascript etc. passing the art of scrapping as a complicated practice….. but this is not true (in most cases;)<\/p>\n
Here we use only a macro in google sheet and 2, 3 HTML knowledge.
\nThis macro allowed us to get the information we needed: name, address, Tel, Mail and that’s all.<\/p>\n
The most complicated thing to do is to retrieve the links an example of a querie exists in the header –> use it with the Mozbar extension to collect all the links from a google search \ud83d\ude09 <\/p>\n
Here is the link to observe, understand the macro… If you ever want to use it create a copy in your drive.<\/p>\n