Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: unspecified
-
Fix Version/s: None
-
Component/s: Search Engine Data
-
Labels:None
-
Environment:
Operating System: Linux
Platform: PC
-
Bugzilla Id:1938
Description
Worldhum was effected by the bug the CCC ran out of searchEngine adgroup ids.
the data has been re-pulled search engine side and data feed side, but we are
still not getting accurate data. It appears that the sync is failing.
The problem appears to be missing searchEngineGroupIdentifiers and landingPageURLs.
mysql> select * from sources where accountID=374 and keyword='myanmar'\G
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 1. row ***************************
id: 273091391
altKey: go374t10341s_myanmar
accountID: 374
siteID: 0
searchEngineAccountID: 19972
keywordID: 0
distributionID: 3
searchEngineIdentifier: NULL
searchEngineGroupIdentifier:
searchEngineMatchType: broad
searchEngineGroupID: 425350
isBiddable: false
campaignID: 0
description: Keyword "myanmar"
type: 1
keyword: myanmar
sourceURL:
cost: NULL
maxCost: 0
waypointID: NULL
landingURL:
passParams:
trackPerformance: true
searchEngineStatus: unknown
searchEngineStatusText:
lastChecked: 0000-00-00 00:00:00 - 2. row ***************************
id: 245770221
altKey: go374t10341c_myanmar
accountID: 374
siteID: 0
searchEngineAccountID: 19972
keywordID: 0
distributionID: 3
searchEngineIdentifier: 17186240
searchEngineGroupIdentifier: 833646701
searchEngineMatchType: content
searchEngineGroupID: 425520
isBiddable: false
campaignID: 0
description: Keyword: [myanmar] content
type: 1
keyword: myanmar
sourceURL:
cost: 1
maxCost: 5
waypointID: NULL
landingURL:
http://www.worldhum.com/dispatches/item/under_the_banyon_tree_in_burma_20080130/?refcd=GO374T10341c_myanmar&tsacr=GO {creative}
passParams:
trackPerformance: true
searchEngineStatus: ok
searchEngineStatusText: Active
lastChecked: 0000-00-00 00:00:00
*************************** 3. row ***************************
id: 245294191
altKey: go374t10341s_myanmar
accountID: 374
siteID: 0
searchEngineAccountID: 19972
keywordID: 0
distributionID: 3
searchEngineIdentifier: 17186240
searchEngineGroupIdentifier: 833646701
searchEngineMatchType: broad
searchEngineGroupID: 425520
isBiddable: true
campaignID: 0
description: Keyword: [myanmar] broad
type: 1
keyword: myanmar
sourceURL:
cost: 1
maxCost: 5
waypointID: NULL
landingURL:
http://www.worldhum.com/dispatches/item/under_the_banyon_tree_in_burma_20080130/?refcd=GO374T10341s_myanmar&tsacr=GO{creative}passParams:
trackPerformance: true
searchEngineStatus: ok
searchEngineStatusText: Active
lastChecked: 0000-00-00 00:00:00
3 rows in set (3.01 sec)
- 1. row ***************************
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-