Compute KW Variant eSV Factors

DEPENDENCIES:

• Request review of Top 100 Regions
• Request review of LOB KW Variants
• Run 03a-Updated_Latest_Data.sql

OVERVIEW:

Generate eSV Factors after the average SV has been calculated for all keyword variants. This includes standard and new URL templates. eSV Factors will be used to
generate KW priority in future steps.

PROCESS:

1. After getting SEOClarity data back, to update eSV factors, run https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/KWGeneration/trunk/KWExplosion/sql/update-eSV-factor.sql
   (This is also step 5B of eSV-Research-process.txt. Run first with defaults to do a dry-run and review.)
2. Review all eSV factors on kw variants for all URL templates. This should be done once on any new SWXL to ensure the data didn’t incorrectly assign any factors.
   https://docs.google.com/a/myersmediagroup.com/document/d/1gtUgKgA4YYxhm6JVTp4bC4lYKhwXHgNrdTO1EJFb3Rg/edit#heading=h.f8220438e5cc

NOTES:

When manually setting eSV factors, avoid using the same value. For example, you can set one factor to be 0.011 and the other one 0.009, instead of setting them both to be 0.01.