Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Apponaug
-
Fix Version/s: Apponaug
-
Component/s: Other / Misc.
-
Labels:None
-
Environment:
Build Details
BidMgr : Apponaug build 15
SMB Core : Apponaug build 14
Description
After migrating the legacy accounts, hasModifier value hasn't set to true for campaigns.
Step 1:
Before Migration of campaigns
select * from gce_campaignTargetMap a, gce_target t where a.campaignID in (235) and a.targetid = id;
-----------------------------------------------------------------------------------------------
| campaignID | targetID | isExclude | hasBidModifier | id | targetType | code | description | criterionID |
-----------------------------------------------------------------------------------------------
| 235 | 61 | false | false | 61 | language | en | en | 1000 |
| 235 | 93 | false | false | 93 | platform | Desktop | Desktop | 30000 |
| 235 | 95 | false | false | 95 | platform | Tablet | Tablet | 30002 |
| 235 | 99 | false | false | 99 | network | GoogleSearch | Google Search | 0 |
| 235 | 100 | false | false | 100 | network | SearchNetwork | Search Partners | 0 |
| 235 | 319 | false | false | 319 | country | US | United States | 2840 |
-----------------------------------------------------------------------------------------------
6 rows in set (0.00 sec)
mysql> select * from gce_campaignTargetMap a, gce_target t where a.campaignID in (236) and a.targetid = id;
-----------------------------------------------------------------------------------------------
| campaignID | targetID | isExclude | hasBidModifier | id | targetType | code | description | criterionID |
-----------------------------------------------------------------------------------------------
| 236 | 61 | false | false | 61 | language | en | en | 1000 |
| 236 | 93 | false | false | 93 | platform | Desktop | Desktop | 30000 |
| 236 | 95 | false | false | 95 | platform | Tablet | Tablet | 30002 |
| 236 | 99 | false | false | 99 | network | GoogleSearch | Google Search | 0 |
| 236 | 100 | false | false | 100 | network | SearchNetwork | Search Partners | 0 |
| 236 | 319 | false | false | 319 | country | US | United States | 2840 |
-----------------------------------------------------------------------------------------------
6 rows in set (0.00 sec)
mysql> select * from gce_campaignTargetMap a, gce_target t where a.campaignID in (237) and a.targetid = id;
-----------------------------------------------------------------------------------------------
| campaignID | targetID | isExclude | hasBidModifier | id | targetType | code | description | criterionID |
-----------------------------------------------------------------------------------------------
| 237 | 61 | false | false | 61 | language | en | en | 1000 |
| 237 | 94 | false | false | 94 | platform | HighEndMobile | HighEndMobile | 30001 |
| 237 | 99 | false | false | 99 | network | GoogleSearch | Google Search | 0 |
| 237 | 100 | false | false | 100 | network | SearchNetwork | Search Partners | 0 |
| 237 | 319 | false | false | 319 | country | US | United States | 2840 |
-----------------------------------------------------------------------------------------------
Step 2: Run the migration script for legacy account
nohup /usr/local/tsa/bidmgr/google-enhanced-campaign-migrator.sh -d3 --seuser
Step 3: After Migration of campaigns
mysql> select * from gce_campaignTargetMap a, gce_target t where a.campaignID in (235) and a.targetid = id;
-----------------------------------------------------------------------------------------------
| campaignID | targetID | isExclude | hasBidModifier | id | targetType | code | description | criterionID |
-----------------------------------------------------------------------------------------------
| 235 | 61 | false | false | 61 | language | en | en | 1000 |
| 235 | 93 | false | false | 93 | platform | Desktop | Desktop | 30000 |
| 235 | 95 | false | false | 95 | platform | Tablet | Tablet | 30002 |
| 235 | 99 | false | false | 99 | network | GoogleSearch | Google Search | 0 |
| 235 | 100 | false | false | 100 | network | SearchNetwork | Search Partners | 0 |
| 235 | 319 | false | false | 319 | country | US | United States | 2840 |
-----------------------------------------------------------------------------------------------
6 rows in set (0.00 sec)
mysql> select * from gce_campaignTargetMap a, gce_target t where a.campaignID in (236) and a.targetid = id;
-----------------------------------------------------------------------------------------------
| campaignID | targetID | isExclude | hasBidModifier | id | targetType | code | description | criterionID |
-----------------------------------------------------------------------------------------------
| 236 | 61 | false | false | 61 | language | en | en | 1000 |
| 236 | 93 | false | false | 93 | platform | Desktop | Desktop | 30000 |
| 236 | 95 | false | false | 95 | platform | Tablet | Tablet | 30002 |
| 236 | 99 | false | false | 99 | network | GoogleSearch | Google Search | 0 |
| 236 | 100 | false | false | 100 | network | SearchNetwork | Search Partners | 0 |
| 236 | 319 | false | false | 319 | country | US | United States | 2840 |
-----------------------------------------------------------------------------------------------
6 rows in set (0.00 sec)
mysql> select * from gce_campaignTargetMap a, gce_target t where a.campaignID in (237) and a.targetid = id;
-----------------------------------------------------------------------------------------------
| campaignID | targetID | isExclude | hasBidModifier | id | targetType | code | description | criterionID |
-----------------------------------------------------------------------------------------------
| 237 | 61 | false | false | 61 | language | en | en | 1000 |
| 237 | 94 | false | false | 94 | platform | HighEndMobile | HighEndMobile | 30001 |
| 237 | 99 | false | false | 99 | network | GoogleSearch | Google Search | 0 |
| 237 | 100 | false | false | 100 | network | SearchNetwork | Search Partners | 0 |
| 237 | 319 | false | false | 319 | country | US | United States | 2840 |
-----------------------------------------------------------------------------------------------
Expected:
For HighEndMobile platform, hasModifier value should be "true" after migration.
Note : When new campaigns are created then HighEndMobile is added for every campaign with hasBidModifier set to true.
