Collect names, addresses, & logos for approx. 350 Self Storage companies, advertising in the Yellow Pages and having a web site address. [url removed, login to view]+storage&eventType=pagination&locationClue=All+States&pageNumber=10&referredBy=[url removed, login to view]
Output is to be:
1. One excel file and also one csv file – same as Project 7 (one file per Company). One spreadsheet for the main location, and a separate spreadsheet for the branch locations if applicable (these are probably easiest to obtain from the Yellow Pages by clicking on the “other locations” link on each advertisement).
2. A file containing all the logo images (same file names as in the files referred to in (1).
3. Consolidate the data in (1) into one file, containing all the companies – same as Project 8.
4. Prepare advertisements for each company using the csv template attached. (This will be a lot easier than Projects 9 or 10, because we can assume each company has the same four products. Images are to be rotated – 10% of companys use image 1; 10% use image 2; 10% use image 3, etc).
5. Status log for the above