Generate SWXL Workbooks

DEPENDENCIES:

• Import/Update Hotel GB
• New Language SWXL: Need to ask for KW Variants from Specialist
• URL Templates
• KW Root Terms
• KW Variants
• Generate KW Variant eSV Factors for all URL Templates

OVERVIEW:

To collect an initial review from the SEO Specialist we provide them with the following items:

• KW Variants per LOB
• URL Templates to include (and inform of new custom URLs)
• KW root terms (New SWXL Only)

Workbook templates can be found on Google Drive:
https://drive.google.com/open?id=0BxGkM7mSsh-4bUxUMHBWYnBieDQ

• {pos} SWXL Workbook Main yyyymmdd.xlsx
• {pos} SWXL Workbook Previous Boosted Collections yyyymmdd.xlsx
• {pos} SWXL Workbook URL Reassign yyyymmss.xlsx
• (there may be others needed on a case-by-case basis)

DETAILS:

Most of the scripts to dump the data for the workbook are in: https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/SiteMapManager/trunk/SWXL-workbook/

Generate SWXL Main Workbook

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/SiteMapManager/trunk/SWXL-workbook

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/SiteMapManager/trunk/SWXL-workbook/workbook-lob-kw-variants.pl

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/SiteMapManager/trunk/SWXL-workbook/workbook-top-100-regions.sql

Generate SWXL Previous Boosted Collections Workbook

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/SiteMapManager/trunk/SWXL-workbook/Previous_User_Associations_and_Boosted_Collections%.sql.

Generate SWXL URL Level Reassignments Workbook

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/SiteMapManager/trunk/SWXL-workbook/workbook-url-level-reassign.sql

• Generate Workbooks – Primary language
• Generate Workbooks – 2nd language
• Generate Workbooks – 3rdlanguage

NEW SWXL:

Post LOB Link Category Names (localized). Create a tab within the workbook that indicates how SWXL will display LOB category names. These will typically include:

• Activities, a.k.a Things to Do
• Car Rentals a.k.a. Car Hire
• Cruises
• Flights
• Hotels
• Vacation Packages a.k.a Holiday Packages City Breaks
• General

NOTES:

Update template_elements based on changes noted during sample_url verification

For custom templates that we need to generate keywords, populate kwg.datafeed, kwg,datafeed_type, kwg,template_datafeed, kwg,kw_variants