I have 2 data files, onecontaining keywords and the other containing organic and paid search resultsfor those keywords.? I'd likesomeone to build a simple web based interface and API that takes as input a domainname and outputs a ranked list of up to 10 organic keywords and 10 paid keywordsthat are associated with that domain.
## Deliverables
Data supplied:
* Keywords (about 100K)
o Keyword
o Number of monthly searches for the keyword
o Value (not needed for this project)
* Search Results (about 1.3 Million)
o Keyword
o Type (Organic or Paid)
o SERP position on page (1-10)
o Title
o Description
o URL
o Website (extracted from URL)
o Date gathered (not needed for this project)
o Time gathered (not needed for this project)
Samples of both are attached
For a given domain name, calculate the ranking of both organic and paid keywords. ? Start by finding all keywords associated with the domain, then use this formula:
Organic Rank - Number of monthly searches for the keyword * (25/Organic keyword rank)
Paid Rank - Number of monthly searches for the keyword * (9/Paid keyword rank)
Output two columns, one for organic and one for paid results:
For the Organic category show:
* the total number of Organic keywords associated with the domain (at the top) and then for each of up to 10 keywords:
o SERP position of the keyword
o Keyword
* "More" button if there are > 10 keywords available which expands the listing to show 10 more, and then 10 more, etc.
For the Paid category show:
* the total number of paid keywords associated with the domain (at the top) and then for each of up to 10 paid keywords:
o SERP position of the keyword
o Keyword
* Upon rollover or click, the actual paid listing from the SERP
* Title
* Description
* URL
* "More" button if there are > 10 keywords available which expands the listing to show 10 more, and then 10 more, etc.
Phase I
Display the information on an interactive web page (with a private login), which includes
* A search bar where the user is prompted to enter a domain name
* organic and paid search results populate on the same page the user entered the domain name.
Screen Mockup attached
Phase II
Create an API so that the functionality can be accessed programmatically
Phase III
I am not very technical so I’ll need a little help moving the code to a hosting facility. ? You can give me some guidance on which type of hosting environment would best house your code. ? I’ll sign up for it and give you the credentials so you can load your software.
Any other questions, please ask.