Details
-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: TBD
-
Component/s: None
-
Labels:None
-
Environment:
Environment: YELL1
SMS-CORE: p18
SMS-SERVICE: p7
Description
When we redeploy a Bing account by changing the latitudeDegrees and longitudeDegrees in pointRadius table then Bing targets tables are not getting updated.
Updated latitudeDegrees and longitudeDegrees values are getting added to Bing Adcenter but not for bce_campaignProximityTargetMap and bce_campaignTargetMap tables.
Steps to Reproduce
1. Deploy a Bing account with city selocationlevel
serviceareaID 1031 and
2. Change the latitudeDegrees and longitudeDegrees location in pointradius table.
3. Redeploy the account
Expected behavior: Newly updated latitudeDegrees and longitudeDegrees value should be updated in database (bce_campaignProximityTargetMap and bce_campaignTargetMap tables) and in Bing Adcenter.
Actual behavior: Newly updated latitudeDegrees and longitudeDegrees value is updated only in Bing Adcenter not in the database.
EX:
1. Deployed a new bing account with 1031 as service area id and verify in Bing Adcenter (BeforeRedeployBngAdcenter.jpg) and database.
mysql> select * from pointRadius where locationID=1031;
-----------------------------------------------------------
| id | locationID | latitudeDegrees | longitudeDegrees | radiusMeters |
-----------------------------------------------------------
| 9951 | 1031 | 52.234503 | -0.681360 | 23000 |
-----------------------------------------------------------
2. Account deployed successfully and bce targets tables are updated
mysql> select * from bce_campaign where name like '%BNGB01%';
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | searchEngineUserID | searchEngineIdentifier | name | description | timezone | daylightSaving | budgetAmount | budgetPeriod | contentTargeting | status | bingTargetId |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1189 | 84944 | 90806532 | BNGB01_1000000024_1031_BNGB01-1_GT | BNGB01_1000000024_1031_BNGB01-1_GT | GreenwichMeanTimeDublinEdinburghLisbonLondon | 0.081 | DailyBudgetStandard | NULL | Active | NULL | |
| 1190 | 84944 | 90806533 | BNGB01_1000000024_1031_BNGB01-1_GM | BNGB01_1000000024_1031_BNGB01-1_GM | GreenwichMeanTimeDublinEdinburghLisbonLondon | 0.081 | DailyBudgetStandard | NULL | Paused | NULL |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> select * from bce_campaignTargetMap tm,bce_target t where t.id=tm.targetID and campaignID=1189;
-------------------------------------------------------------------------------------------------------+
| campaignID | targetID | isExclude | id | bingTargetId | targetType | code | description |
-------------------------------------------------------------------------------------------------------+
| 1189 | 4235 | false | 4235 | 0 | proximity | 52.23450469970703,-0.6813600063323975 |
-------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select * from bce_campaignProximityTargetMap ptm, bce_target t where t.id=ptm.targetID and campaignID=1189;
----------------------------------------------------------------------------------------------------------------------------------------------------
| campaignID | targetID | latitudeInDegrees | longitudeInDegrees | radius | radiusUnits | id | bingTargetId | targetType | code | description |
----------------------------------------------------------------------------------------------------------------------------------------------------
| 1189 | 4235 | 52.234504699707030 | -0.6813600063323975 | 30 | miles | 4235 | 0 | proximity | 52.23450469970703,-0.6813600063323975 |
----------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
3. Update/Change the latitudeDegrees and longitudeDegrees value in pointRadius table for 1031 locationID.
mysql> select * from pointRadius where locationID=1031;
-----------------------------------------------------------
| id | locationID | latitudeDegrees | longitudeDegrees | radiusMeters |
-----------------------------------------------------------
| 9951 | 1031 | 55.432320 | -0.651360 | 23000 |
-----------------------------------------------------------
1 row in set (0.00 sec)
4.Redeploy the account
5.latitudeDegrees and longitudeDegrees value are updated fine in Bing Adcenter (AfterRedeployBngAdcenter.jpg)
6. latitudeDegrees and longitudeDegrees value not updated in databases
mysql> select * from bce_campaignProximityTargetMap ptm, bce_target t where t.id=ptm.targetID and campaignID=1189;
----------------------------------------------------------------------------------------------------------------------------------------------------
| campaignID | targetID | latitudeInDegrees | longitudeInDegrees | radius | radiusUnits | id | bingTargetId | targetType | code | description |
----------------------------------------------------------------------------------------------------------------------------------------------------
| 1189 | 4235 | 52.234504699707030 | -0.6813600063323975 | 30 | miles | 4235 | 0 | proximity | 52.23450469970703,-0.6813600063323975 |
----------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
mysql> select * from bce_campaignTargetMap tm,bce_target t where t.id=tm.targetID and campaignID=1189;
-------------------------------------------------------------------------------------------------------+
| campaignID | targetID | isExclude | id | bingTargetId | targetType | code | description |
-------------------------------------------------------------------------------------------------------+
| 1189 | 4235 | false | 4235 | 0 | proximity | 52.23450469970703,-0.6813600063323975 |
-------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
