We are advertising through Google Adwords and need to extract competitor data based on specific search terms. We have a list of 40,000 keywords to work with so the script will need to be able to gather large amounts of searches while at the same time not raising any red flags with google, we have looked into using a proxy but are open to any advice or ideas on how to achieve this. The raw extracted data then needs to be parsed to include specific ad copies along with the keyword that triggered the ad within csv format. It would be great if we could do the same for organic content as wel while distinguishing between the two.
In addition to the creation of this code we will also require a quick turorial for use.
Please refer to the attached excel file as a demonstation as to how our output should look,