Run ILG Inclusion/Exclusion Filter

OVERVIEW:

• Define ILG Inclusion List criteria
• Define ILG Exclusion List criteria
• Run ILG Inclusion / Exclusion process to filter out any brand or bad keywords

PROCESS:

• Define ILG Inclusion List criteria
  • The criteria are stored in table dbo.ILG_Inclusion_List_Config. Generally,
    • If keyword is from user or KWG, then it should be in ILG inclusion list
    • If keyword is from EDW, it needs to have Google SEO clicks >= 3 and is not longer than 40 characters

• Define ILG Exclusion List criteria
• There are three places script finds excluded keywords automatically:
  • Site_Brand_KW_Pattern: Patterns for brand keywords
    • Bad_KW_Pattern: Patterns that are bad for using as keywords
    • Negative_KW_Pattern: Negative strings like ‘sex’

When each site was set up it gets default lists of Site_Brand_KW_Pattern and Bad_KW_Pattern. After that, we don’t maintain the same list across different POS, i,e. each POS can have its own lists.

• Run ILG Inclusion / Exclusion process to filter

Rebuild the keyword index and execute stored procedure to update ILG inclusion/exclusion list.

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/ILG/trunk/util/update-ilg-inclusion-exclusion-list.sql

NOTES:

To check how many keywords need to be checked overall:

USE gkms_{POS}

declare @max int, @value int

set @max = (select top 1 id from kw with(nolock) order by id desc)
set @value = (select value from config with(nolock) where name = 'Exclusion_Checked_Max_KW_ID')

select
 (@max - @value) diff