Page Comparison

...

There are several reasons for a preferred publisher to be ignored in a consolidation:

• The Data loaded in the SD_ table do not use the Publisher Code in the B_PUBID column. This publisher code must be loaded in UPPERCASE.
  If the value in B_PUBID does not match an existing publisher code, then this publisher is considered at the last position in the preferred publisher consolidation. Other publishers' values will always be taken into account for consolidation.
• When the PublisherID built-in attribute used in a Custom Ranking consolidation, then the literal values specified in the SemQL expression should be equal to the Publisher Code. These values are also in UPPERCASE.
  If the SemQL clause does not contain literal that match exactly  the publisher codes, then the clause will never work as expected.

...