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.