I would like a listing of all site names and contact details for sites in the Clickbank "Diet" category - supplied in an Excel spreadsheet, or CSV format.
## Deliverables
I would like a listing of all site names and contact details for sites in the Clickbank "Diet" category - supplied in an Excel spreadsheet. Here is a link to the category:
<[login to view URL]>
In the listing, I would like to see:
1.) Site name (as listed in the Clickbank Marketplace above)
2). Site URL (obtained by visiting the site).
3). Product name - the name of the product being sold at the site.
4). Contact name of the person who signed the sales letter.
5). A live email address of either: a). the person who wrote the sales letter, or if that is not available - b). a live email address displayed somewhere else on the site.
6). The URL of a form that is in use to submit support enquiries (only necessary if there was no email obtained in 5 above).
7). The Clickbank nickname of the site. All links from the Clickbank Marketplace are in the form:
<[login to view URL]>
...and in this example "burnthefat" is the Clickbank nickname.
So an example of a completed site would be:
1). Burn The Fat Feed The Muscle.
2). [login to view URL]
3). Burn The Fat Feed The Muscle.
4). Tom Venuto.
5). N/A
6). <[login to view URL]>
7). burnthefat
All sites to be presented so that each new site is on a separate row in the Excel spreadsheet, with 1) to 7) above displayed in columns A through G.
There are currently 88 sites in total in the category.
## Platform
I have Microsoft Excel 2002, so any version of Excel earlier than that should be OK.