Category: SWXL Templates

The tasks associated with this grouping are those that allow us to provide an SEO Specialist with an easy-to-review/edit workbook that will contain Top Regions, Root Terms, LOB KW variants, URL Templates, etc.

DEPENDENCIES:

• For New SWXLs:
  • Generate/Import: All Root Terms to send to STAT for rank & rSV
  • Generate/Import: All Research Terms to send to STAT for rank & rSV”
• For Update SWXLs:
  • Import/Update: Latest G1-2 STAT Rank and SV Data

OVERVIEW:

Run the KW-URL Association processes for STAT Google, Bing and Yahoo.

PROCESS:

Run with the “-a” parameter:

https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/DataSources/STAT/script/merge.pl

 

OVERVIEW:

Client Review of:

• KW priority
• SWXL groups
• G1 Top Keywords: Exclusions, URL Associations, General G1 Membership

For all languages, communicate with the PMs which timestamps refer to the live and updated versions.

For example:

Summary versions:
Last update before Live: 005.008.20151117
Production Version: 005.009.20151130
Current Maint. Version: 005.010.20151202

The tasks associated with this grouping are typically those that are done prior to the actual generation of the workbook sent to the SEO Specialist for feedback/input, or are precursor tasks. There are other tasks that may be tagged “IDS” that are grouped in other areas, but are also IDS-type tasks.

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 = ?;

OVERVIEW:

Update Atlas/Gaia version in GKMS database – All Languages

Update SWXL database references to the latest datasource versions of Atlas/Gaia.
This data is used in URL and KWGeneration processes and includes Regions, Airports, POIs and Activities.

PROCESS:

1. The ‘AtlasVersion’ value in Config table needs to be updated to specify which version in the datasources database to reference.

   set-config.pl gkms_us AtlasVersion 20170724

2. Run:

   build-db.pl gkms_us update.inc --nocreate

   https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/SiteMapManager/trunk/db/synonym/atlas/update.inc

3. Make sure views and synonyms point to the right version.
4. Update your .mmg_conf.pl file.

NOTES:

After this point, KW Generation preprocess should be considered out of date.