I need a simple tool to filter a number of URL's based on criteria I enter. I have define the criteria below as default however I'd like to be able to edit these OR add more.
The fields that meet the criteria will be flagged with REMOVE in the first column and coloured RED (will need to add this column (labelled STATUS) in the first column position)
There will be about 12 columns of data - sample file included.
We first need to define the columns and then set the rules as follows:
If Domain PR (column) = 0 or N/A and OBL (column) >40 then flag
If OBL (column) > 40 and Bad Word Count (column) > 3 then flag
If Title (column) has the word "suspended" or "error" or "page could not be found" or "page not found" within the title then flag (not case sensitive)
If Domain PR (column) = 0 or N/A and Word Count (column) is 24 then flag
If Domain PR (column) <1 and Word Count (column) 3 then flag
The results are then displayed with the REMOVE status shown.
We can then create a TXT file including ONLY the Flagged results with a simple "EXPORT FLAGGED LINKS" button.
We can also export all links for manual sorting.
During export, any duplicate URL's are removed.