Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Point Radii Implementation
-
Fix Version/s: Point Radii Implementation
-
Component/s: None
-
Labels:None
-
Environment:
Environment: YELL1
Build
SMS-CORE: p16
SMS-SERVICE: p3
Description
Location are targeted to 'All Location worldwide' for the District seLocationlevel in pointRadii build where as in production build its targeted to the "London(City)".
We have deployed Bing account with district in production and PointRadii build.
With Point radii build
Location are targeted to 'All Location worldwide' in Bing Adcenter.(PointRadiiBuild-BING-District(566).jpg)
Database
mysql> select * from bce_campaign where name like '%BNGB04%';
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | searchEngineUserID | searchEngineIdentifier | name | description | timezone | daylightSaving | budgetAmount | budgetPeriod | contentTargeting | status | bingTargetId |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1195 | 84947 | 170489842 | BNGB04_1000000024_566_BNGB04-1_GT | BNGB04_1000000024_566_BNGB04-1_GT | GreenwichMeanTimeDublinEdinburghLisbonLondon | 0.081 | DailyBudgetStandard | NULL | Paused | NULL | |
| 1196 | 84947 | 170489843 | BNGB04_1000000024_566_BNGB04-1_GM | BNGB04_1000000024_566_BNGB04-1_GM | GreenwichMeanTimeDublinEdinburghLisbonLondon | 0.081 | DailyBudgetStandard | NULL | Paused | NULL |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> select * from bce_campaignProximityTargetMap ptm, bce_target t where t.id=ptm.targetID and campaignID=1195;
Empty set (0.00 sec)
mysql> select * from bce_campaignTargetMap tm,bce_target t where t.id=tm.targetID and campaignID=1195;
Empty set (0.00 sec)
With Production build
Location are targeted to "London(City)" in Bing Adcenter.(ProductionBuild-BING-District(566).jpg)
mysql> select * from bce_campaign where name like '%BNGP04%';
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | searchEngineUserID | searchEngineIdentifier | name | description | timezone | daylightSaving | budgetAmount | budgetPeriod | contentTargeting | status | bingTargetId |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1171 | 84935 | 80955734 | BNGP04_1000000024_566_BNGP04-1_GT | BNGP04_1000000024_566_BNGP04-1_GT | GreenwichMeanTimeDublinEdinburghLisbonLondon | 0.081 | DailyBudgetStandard | NULL | Paused | NULL | |
| 1172 | 84935 | 80955735 | BNGP04_1000000024_566_BNGP04-1_GM | BNGP04_1000000024_566_BNGP04-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=1171;
------------------------------------------------------------------------------------------+
| campaignID | targetID | isExclude | id | bingTargetId | targetType | code | description |
------------------------------------------------------------------------------------------+
| 1171 | 3643 | false | 3643 | 0 | city | London, ENG GB | London, London ENG GB |
------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select * from bce_campaignProximityTargetMap ptm, bce_target t where t.id=ptm.targetID and campaignID=1171;
Empty set (0.00 sec)
