Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Extensions
-
Fix Version/s: None
-
Component/s: AdMax
-
Labels:None
-
Environment:
Environment : YELL1 VM
Build Details
Bidmgr:p12-r2809
MMS:p6-r3390
Description
1. When we create a new account then HighEndMobile targets is not getting added to the campaignTargetMap table.
We have created a new campaign (Adexts35) and it does not have Mobile targets (HighEndMobile)
mysql> select * from gce_campaign where name like '%Adexts35%';
--------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | searchEngineUserID | searchEngineIdentifier | name | budgetAmount | budgetPeriod | contentTargeting | startDay | endDay | status |
--------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1006762 | 84384 | 253887256 | Adexts35_1000003233_733_Adexts35-1_GT | 0.020 | Daily | AllPlacements | 2013-07-17 | 2037-12-30 | Paused |
| 1006763 | 84384 | 253887376 | Adexts35_1000003233_733_Adexts35-1_GM | 0.020 | Daily | None | 2013-07-17 | 2037-12-30 | Paused |
--------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> select * from gce_target gt,gce_campaignTargetMap gm where gt.id=gm.targetID and campaignID=1006762;
-------------------------------------------------------------------------------------------------------
| id | targetType | code | description | criterionID | campaignID | targetID | isExclude | hasBidModifier |
-------------------------------------------------------------------------------------------------------
| 1 | network | GoogleSearch | Google Search | 0 | 1006762 | 1 | false | false |
| 2 | network | SearchNetwork | Search Partners | 0 | 1006762 | 2 | false | false |
| 3 | network | ContentNetwork | The content network | 0 | 1006762 | 3 | false | false |
| 13 | language | en | English | 1000 | 1006762 | 13 | false | false |
| 1004 | city | Reading, ENG GB | 1007009 | 1006762 | 1004 | false | false | |
| 2553 | proximity | 52451456,-990659 | 0 | 1006762 | 2553 | false | false |
-------------------------------------------------------------------------------------------------------
6 rows in set (0.00 sec)
###############################################################################
2. When we redeploy the old account which has HighEndMobile target then on redeployment mobile target is getting removed from the gce_campaignTargetMap table.
We have picked an account (JB1T10) which has mobile targets in campaignTargetMap table.
mysql> select * from gce_campaign where name like '%JB1T10%';
----------------------------------------------------------------------------------------------------------------------------------------------------+
| id | searchEngineUserID | searchEngineIdentifier | name | budgetAmount | budgetPeriod | contentTargeting | startDay | endDay | status |
----------------------------------------------------------------------------------------------------------------------------------------------------+
| 1006562 | 84282 | 137829176 | JB1T10_1000000003_736_JB1T10-1_GT | 0.020 | Daily | AllPlacements | 2013-07-08 | 2037-12-30 | Paused |
| 1006563 | 84282 | 137829296 | JB1T10_1000000003_736_JB1T10-1_GM | 0.020 | Daily | None | 2013-07-08 | 2037-12-30 | Paused |
----------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> select * from gce_target gt,gce_campaignTargetMap gm where gt.id=gm.targetID and campaignID=1006562;
-------------------------------------------------------------------------------------------------------
| id | targetType | code | description | criterionID | campaignID | targetID | isExclude | hasBidModifier |
-------------------------------------------------------------------------------------------------------
| 1 | network | GoogleSearch | Google Search | 0 | 1006562 | 1 | false | false |
| 2 | network | SearchNetwork | Search Partners | 0 | 1006562 | 2 | false | false |
| 3 | network | ContentNetwork | The content network | 0 | 1006562 | 3 | false | false |
| 13 | language | en | English | 1000 | 1006562 | 13 | false | false |
| 1007 | city | Redhill, ENG GB | 1007012 | 1006562 | 1007 | false | false | |
| 2551 | proximity | 56241064,-190672 | 0 | 1006562 | 2551 | false | false | |
| 2552 | platform | HighEndMobile | HighEndMobile | 30001 | 1006562 | 2552 | false | true |
-------------------------------------------------------------------------------------------------------
7 rows in set (0.00 sec)
After Redeploy mobile target is removed from the campaignTargetMap table and we observed in the listener log that it gets removed after redeploy
Snippet of listener log after redeploy [Attached complete log in the mail]
2013-07-17 08:22:31.821 (3) [pool-7-thread-48]: JB1T10_1000000003_736_JB1T10-1_GM target sync:
2013-07-17 08:22:31.821 (3) [pool-7-thread-48]: Deleting old target platform_HighEndMobile
2013-07-17 08:22:31.842 (3) [pool-7-thread-48]: ----------------Google Content Editor starting
2013-07-17 08:22:31.884 (3) [P177T1]: CampaignTargetChangeRequest (accountID 80825): Sending 2 update requests
2013-07-17 08:22:31.885 (3) [P177T1]: Removing targets from Google :1 values: [type=platform, code=HighEndMobile, exclude=false, id=2552, criterionId=30001]
mysql> select * from gce_target gt,gce_campaignTargetMap gm where gt.id=gm.targetID and campaignID=1006562;
-------------------------------------------------------------------------------------------------------
| id | targetType | code | description | criterionID | campaignID | targetID | isExclude | hasBidModifier |
-------------------------------------------------------------------------------------------------------
| 1 | network | GoogleSearch | Google Search | 0 | 1006562 | 1 | false | false |
| 2 | network | SearchNetwork | Search Partners | 0 | 1006562 | 2 | false | false |
| 3 | network | ContentNetwork | The content network | 0 | 1006562 | 3 | false | false |
| 13 | language | en | English | 1000 | 1006562 | 13 | false | false |
| 1007 | city | Redhill, ENG GB | 1007012 | 1006562 | 1007 | false | false | |
| 2551 | proximity | 56241064,-190672 | 0 | 1006562 | 2551 | false | false |
-------------------------------------------------------------------------------------------------------
6 rows in set (0.00 sec)
