On site form:
#1. Upload a CSV / plug into the Hitwise API / enter a list of keywords (up to 10,000).
#2. Enter a URL
The script will them crawl the entire site mentioned in #2 and check each URL against against the keywords attached, based on the following criteria:
i. Keyword in URL
ii. Keyword in Hx tags
iii. More than 3 instances of the keyword in the copy?
If i, ii and iii answer 'yes' then the URL that's been checked will answer 'yes' to that keyword being present on that page.
We'll need to check each page for every keyword based on that criteria.
The output of the site will be a CSV with a new column header for i, 11 and iii. There will be a cross in each box if the keyword
is found in the URL, signifying a 'yes'.
we'll also need a graph that shows the % coverage of the keywords. For example, if we input 1,000 keywords into the system and 500 are 'yes' and 500 'no'
then we'll need a graph to represent the 'coverage'. We'll need to display non-coverage too.
#4. Hitwise API
- An optional extra is to use the Hitwise API (through our account) to gather the keywords for the survey.
We're using PHP/MYSQL for this with cpanel.
We'll need a great looking interface for this, but as easy as possible to use.
6 freelancers are bidding on average $188 for this job
I am interested & confident for this task. Though I am new to this site, but I have previous experience in MySQL, PHP, Software Architecture I have read all of your requirement. You can select me for the job.