KWG QA

OVERVIEW:

QA the eSV generated from the KWG run. Look at eSV factors if they need adjusting. Check Hotel Properties eSV calculation because the eSV for T1 terms is generated from Hotels GB and not rSV. This is an internal QA review of the report itself; it is a preliminary review before we ask the SEO Specialist to review Keyword Generation in the GSI.

PROCESS:

The scripts needed to generate the KWG QA report can be found in:
https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/KWGeneration/trunk/KWExplosion/qa

Particularly, the following scripts may be most useful:
https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/KWGeneration/trunk/KWExplosion/qa/kw-count-by-template.sql

CHECK:

1. All URL templates have had the correct KW variants successfully generated for them.
2. That Multi-City and Neighborhood URL templates have had the most important terms generated and assigned to them.

NOTES:

https://docs.google.com/a/myersmediagroup.com/document/d/1gtUgKgA4YYxhm6JVTp4bC4lYKhwXHgNrdTO1EJFb3Rg/edit#heading=h.f8220438e5cc