Update Collections to Adjust KW priorities

OVERVIEW:

Primary Language Only. One common method used to adjust priorities of keywords is to group them in collections with boost values which influence the priorities of those keywords. Note that only entries with a boost value need to be updated and while a SWXL may have any number of boosted collections, the standard ones are:

  • User Association keywords. We boost priority for keywords in this collection, as most of the keywords are important. This is especially important for new keywords we didn’t have in GKMS before because they will have no other data to give them priority.
  • ‘SV = 0’ keywords. If keywords have no real search volume, i.e. no one searches for it, we should lower its priority.
  • ‘Expedia POS Top Targets’. If the client specifies Top Target keywords, these need to be in a boosted collection to ensure they get placed in G1.

PROCESS:

  • Review the dbo.collection_info.query column which describes how each collection is updated.
  • Update the dbo.collection_info.last_updated column

Run the scripts located in:
https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/DB/tools/db_builder/GKMS/common/USP/update_collection/

NOTES:

See http://gkms-{pos}.mmg.local:8080/collections.aspx for an admin overview of the database tables.

History

Leave a Reply