Uploaded image for project: 'SMB - Optus'
  1. SMB - Optus
  2. OPTUS-116

The entry of platform “High End Mobile” is not added to the GT/GM campaigns after migration.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5.3
    • Fix Version/s: None
    • Component/s: Other / Misc.
    • Labels:
      None
    • Environment:

      QA environment

      SMB Core - 1.5.3 - RELEASE : Build 22
      SMB - Optus - 1.5.3 – RELEASE : Build 26
      SMB Core - Bid Manager - 1.5.3 - RELEASE: Build 23

      Description

      After migrating the legacy accounts, the entry of platform “High End Mobile” is not added to the GT/GM campaigns after migration, it is only added when we redeploy the campaigns.

      Steps:

      1.Run the migration script for legacy account

      nohup /usr/local/tsa/bidmgr/google-enhanced-campaign-migrator.sh -d3 --seuser 57523

      2. Check in the DB

      Before Migration
      mysql> select * from gce_campaignTargetMap Ct,gce_target t where Ct.campaignID in (select id from gce_campaign where searchEngineUserID=57523) and Ct.targetID=t.id;
      -----------------------------------------------------------------------------------------------------------------------

      campaignID targetID isExclude hasBidModifier id targetType code description criterionID

      -----------------------------------------------------------------------------------------------------------------------

      1754 1 false false 1 network GoogleSearch Google Search 0
      1754 2 false false 2 network SearchNetwork Search Partners 0
      1754 3 false false 3 network ContentNetwork Content Network (Selected Placements) 0
      1754 13 false false 13 language en English 1000
      1754 1454 false false 1454 platform Desktop Desktop 30000
      1754 1456 false false 1456 platform Tablet Tablet 30002
      1755 1 false false 1 network GoogleSearch Google Search 0
      1755 2 false false 2 network SearchNetwork Search Partners 0
      1755 13 false false 13 language en English 1000
      1755 57 false false 57 country AU Australia 2036
      1755 1454 false false 1454 platform Desktop Desktop 30000
      1755 1456 false false 1456 platform Tablet Tablet 30002
      1756 1 false false 1 network GoogleSearch Google Search 0
      1756 2 false false 2 network SearchNetwork Search Partners 0
      1756 3 false false 3 network ContentNetwork Content Network (Selected Placements) 0
      1756 13 false false 13 language en English 1000
      1756 1455 false false 1455 platform HighEndMobile HighEndMobile 30001

      -----------------------------------------------------------------------------------------------------------------------
      17 rows in set (0.03 sec)

      After Migration

      mysql> select * from gce_campaignTargetMap Ct,gce_target t where Ct.campaignID in (select id from gce_campaign where searchEngineUserID=57523) and Ct.targetID=t.id;
      -----------------------------------------------------------------------------------------------------------------------

      campaignID targetID isExclude hasBidModifier id targetType code description criterionID

      -----------------------------------------------------------------------------------------------------------------------

      1754 1 false false 1 network GoogleSearch Google Search 0
      1754 2 false false 2 network SearchNetwork Search Partners 0
      1754 3 false false 3 network ContentNetwork Content Network (Selected Placements) 0
      1754 13 false false 13 language en English 1000
      1754 1454 false false 1454 platform Desktop Desktop 30000
      1754 1456 false false 1456 platform Tablet Tablet 30002
      1755 1 false false 1 network GoogleSearch Google Search 0
      1755 2 false false 2 network SearchNetwork Search Partners 0
      1755 13 false false 13 language en English 1000
      1755 57 false false 57 country AU Australia 2036
      1755 1454 false false 1454 platform Desktop Desktop 30000
      1755 1456 false false 1456 platform Tablet Tablet 30002
      1756 1 false false 1 network GoogleSearch Google Search 0
      1756 2 false false 2 network SearchNetwork Search Partners 0
      1756 3 false false 3 network ContentNetwork Content Network (Selected Placements) 0
      1756 13 false false 13 language en English 1000
      1756 1455 false false 1455 platform HighEndMobile HighEndMobile 30001

      -----------------------------------------------------------------------------------------------------------------------
      17 rows in set (0.00 sec)

      Expected :

      Platform for the GT/MO should be updated to HighEngd Mobile.

        Attachments

          Activity

            People

            • Assignee:
              manasa.denning Manasa Denning
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: