Category: SWXL Templates

OVERVIEW:

For all languages, perform the final SEO Interface update POST SWXL generation, so the Client will have the latest SWXL data to analyze, and we can begin importing monthly performance data against the final set of KWs in G1 and G2.

PROCESS:

Run https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/ILG/trunk/util/update-live-swxl.sql.

Regardless of the POS language, most will have English terms show up from EDW data. Therefore, we should import the default exclusion-list patterns from the E.com US POS.

Additionally, if there is an active SWXL from a region sharing the same language (e.g., AT-DE, ES-MX, etc.) we should consider importing the other (existing) POS’ exclusion list and patterns.

The exclusion list patterns are contained in the following tables:

• Bad_KW_Pattern
• Negative_KW_Pattern
• Site_Brand_KW_Pattern

Clone Exclusion Data/Patterns to 2nd Language
Clone Exclusion Data/Patterns to 3rd Language

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