THE ATTACHED FILES:
----------------------------
Please take a look at the two files I have attached to this project. They will help you understand my project as I attempt to explain it.
The SPREADSHEET is something I currently use to plan out Keyword Research for building new websites. I enter a bunch of data, and it tells me through the conditional color formatting weather the keyword metrics are good, medium or bad.
The PICTURE is a crappy representation of what I basically want done here with this project. I want the basic idea of the spreadsheet, put into a WordPress blog / script that I can use instead of doing everything manually with spreadsheets.
WHAT I WANT:
---------------------------
What I want from the online script is that it will allow me to input my keywords and it will scrape the 4 pieces of data from Google for me (BROAD, PHRASE, INTITLE, INURL) instead of me having to look them up, as it's very time consuming. It will also apply the correct color to the cell as the data is populated, but I cover that in a bit.
VOL & CPC I will have to input manually for now, but would love it if you knew how to get those metrics automated as well :)
I will also manually input the Project Name, Group Names, Titles, URL, H1 & Desc. Just need those to be editable, and saveable.
PROJECTS & GROUPS:
----------------------------
Notice how there is also a PROJECT name, with 4 GROUPS.
A GROUP is a set of keywords. It can be any number keywords 1 - infinity, but they belong in one group as they are likely similar subject keywords. I need the ability to add as many keywords to a group as needed. I guess just create a single blank field below and if it gets filled out, add another blank field.
THE PROJECT is the set of groups. It can also range from 1 - infinity. I would like to start with a default of 2-4 groups open and ready to input keywords, and add more groups as needed. I also need the ability to be able to save or re-open, or start new projects.
CONDITIONAL COLOR FORMATTING RULES:
----------------------------
Each "cell" will be colored GREEN, YELLOW or RED based on very simple conditional formatting rules (ie, if result is higer than 100, than cell will be yellow). Here are the rules for each label.
If VOLUME is “= or <” 499, than cell color will be RED
If VOLUME is “between” 500 - 999, than cell color will be YELLOW
If VOLUME is “= or >” 1000, than cell color will be GREEN
If CPC is “= or <” $0.59, than cell color will be RED
If CPC is “between” $0.60 - $0.99, than cell color will be YELLOW
If CPC is “= or >” $1.00, than cell color will be GREEN
If BROAD MATCH is “= or >” 5,000,000, than cell color will be RED
If BROAD MATCH is “between” 1,000,000 – 4,999,999, than cell color will be YELLOW
If BROAD MATCH is “= or <” 999,999, than color will be cell GREEN
If PHRASE MATCH is “= or >” 500,000, than cell color will be RED
If PHRASE MATCH is “between” 100,000 – 499,999, than cell color will be YELLOw
If PHRASE MATCH is “= or <” 99,999, than cell color will be GREEN
If ALLINTITLE is “= or >” 5000, than cell color will be RED
If ALLINTITLE is “between” 1000 – 4999, than cell color will be YELLOW
If ALLINTITLE is “= or <” 1000, than cell color will be GREEN
If ALLINURL is “= or >” 5000, than cell color will be RED
If ALLINURL is “between” 1000 – 4999, than cell color will be YELLOW
If ALLINURL is “= or <” 1000, than cell color will be GREEN
VERY SPECIAL INSTRUCTIONS:
--------------------------
- You must have excellent design/css skills as I want you to make this look very professional.
- If you do an outstanding job, I will likely rehire you to complete the next tasks on the job.
- Please reply to this project with the words RAVEN BOX If you do not, you will honestly NOT be picked, as I took the time to write detailed instructions, so if you don't take the time to read them, you are not the coder I am looking for.