This is a very simple macro for someone who understands how
to write it.
There would be an excel sheet with 2 main field - URL, Anchor text (keyword)
Each tab is for different clients. If you feel, we need to make different files
for each client, that ok, we can do that.
Now the macro would have to check the following:
1) Links should be working/Live
2) Anchor text should be matching
3) Keywords should be used in the links
4) Right anchor text and correct domain name
5) Run a macro to check this
6) Variations of anchor text.
7) Any email id which is present in the sheet should be detected.
It should be downloaded from drop box
Run the macros and get the report
Upload the macros back to drop box
PS: We are looking for someone on regular basis as we have
many more similar small projects and can give more orders
for someone who can do the work on time and budget