Category: SWXL Templates

OVERVIEW:

dbo.SWXL_Category.category_name is used by the GSI, so make sure it is correct and that dbo.Template.line_of_business matches it.

PROCESS:

select
 t.template_id, t.template_name, t.line_of_business, sc.category_name
from
 template t
 join SWXL_Category_template sct on sct.template_id = t.template_id
 join SWXL_Category sc on sc.swxl_category_id = sct.swxl_category_id
where
 t.is_active = 1
 and t.line_of_business != sc.category_name

NOTE:

These can be different but should be the same, particularly before sending workbook to specialist.

DEPENDENCIES:

• Import/Update: EDW Keyword & URL Data

OVERVIEW:

• Generate EDW KW-URL Associations (Primary language only)
• Generate Region-Name Associations – All languages
• Generate Special-Regions Associations – All languages

PROCESS:

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/KWUrlAssociation/trunk/EDWAssociation/script/edw-assoc.pl

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/KWUrlAssociation/trunk/OtherAssociations/Region_Names.sql

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/KWUrlAssociation/trunk/OtherAssociations/Special_Regions.sql

Primary Language Only. Ask the client to review the Regions in the GSI and their associated Priorities, for the top 100 to 1,000 regions (some will do more, 100 should be the minimum).

The MMG QA role should also check the top Regions, comparing what is listed in the GSI to the Specialist Workbook. Also look at the regions in the top 500 that do not have very high search volume or Gross Bookings numbers – make notes on those that fit that description and are not Specialist-requested top regions.

This task should be run only on the Primary language, as Secondary languages’ Region Priorities should be a clone of the Primary. If any updates are made, they should be cloned to the secondaries

OVERVIEW:

• Generate Summary Tables – “Maintenance Version”

PROCESS:

1. Insert a new ‘fm.Summary_Version’ entry with ‘is_live’ = False

   insert into fm.summary_version (version, Last_updated, is_live, Note) values ('',getdate(), 0, '');

2. Update config ‘fm.summary.DbVersion’.

   update config set value = '', note = '', updated = getdate() where component = 'fm.summary';

3. Generate Summary Tables

   exec fm.usp_update_Summary_Historical_All;

4. Copy to both prod01 and gsi.myersmediagroup.com:

   use global_swxl; exec [dbo].[usp_global_summary_update_all] @site_id = ?;