Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: Point Radii Implementation
-
Fix Version/s: None
-
Component/s: AdMax
-
Labels:None
-
Environment:
Environment: Yell1
Build:
SMS-CORE: p7
SMS-service- p2
Description
There were 7 seLocationLevel are there in location table. We used all type of seLocationLevel to deploy an account (not sure in production we are using all these seLocationlevel) with production and point radii build. Here is our observation.
mysql> select distinct(seLocationLevel) from locations;
------------------
seLocationLevel |
------------------
city |
district |
region |
country |
coverage_package |
coverage_area |
proximity |
------------------
7 rows in set (0.00 sec)
seLocationlevel: district
- We deployed an account in both production and point radii build using district id(1162) as Serviceareaid in CPP and there is a discrepancy in production and point radii build.
- Production build has target location as London, England, United Kingdom (city) in Google Adwords. Please refer ProductionBuild-1162-district.jpg
- Radii build has target location as All Countries and territories in Google Adwords. Please refer PointRadiiBuil-1162-district.jpg
mysql> select * from locations where id=1162;
-------------------------------------------------------------------------------------------------------
id | parentLocationID | description | seLocationIdentifier | seLocationLevel | demandMapMultiplier | shortDescription |
-------------------------------------------------------------------------------------------------------
1162 | 1038 | East London | London, ENG GB | district | 0.0507 | East London |
-------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
seLocationlevel: Region
- We deployed an account in both production and point radii build using district id(1040) as Serviceareaid in CPP and there is a discrepancy in production and point radii build.
- Production build has target location as Scotland, United Kingdom (Province) in Google Adwords. Please refer ProductionBuild-1040-region.jpg
- Radii build has target location as All Countries and territories in Google Adwords. Please refer PointRadiiBuil-1040-Region.jpg
mysql> select * from locations where id=1040;
-------------------------------------------------------------------------------------------------------
id | parentLocationID | description | seLocationIdentifier | seLocationLevel | demandMapMultiplier | shortDescription |
-------------------------------------------------------------------------------------------------------
1040 | 1042 | Scotland | GB-SCT | region | 0.913856 | Scotland |
-------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
seLocationlevel: Country
- We deployed an account in both production and point radii build using district id(1042) as Serviceareaid in CPP and there is a discrepancy in production and point radii build.
- Production build has target location as, United Kingdom (country) in Google Adwords. Please refer ProductionBuild-1042- country.jpg
- Radii build has target location as All Countries and territories in Google Adwords. Please refer RadiiBuild-1042-country.jpg
mysql> select * from locations where seLocationLevel like '%country%' order by id desc limit 10;
----------------------------------------------------------------------------------------------------------
id | parentLocationID | description | seLocationIdentifier | seLocationLevel | demandMapMultiplier | shortDescription |
----------------------------------------------------------------------------------------------------------
1042 | 0 | United Kingdom | GB | country | 0.6 | United Kingdom |
----------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)
seLocationlevel: city, coverage_package, proximity, coverage_area
- We deployed an account in both production and point radii build using City, coverage_package, proximity , coverage_area ids and its working as expected i.e. adding proximity targets.