---------------------------- ID: 1 Address: /SMB-BES/BudgetEstimateService Encoding: UTF-8 Content-Type: text/xml;charset=UTF-8 Headers: {content-type=[text/xml;charset=UTF-8], connection=[Keep-Alive], host=[localhost:8443], Content-Length=[668], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache-HttpClient/4.1.1 (java 1.5)], accept-encoding=[gzip,deflate], Content-Type=[text/xml;charset=UTF-8]} Payload: Bing 421 57 USD en true -------------------------------------- 11:53:19,953 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container 11:53:19,955 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container 11:53:20,002 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container 11:53:20,004 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container 11:53:20,032 DEBUG [JdbcTemplate] Executing prepared SQL query 11:53:20,032 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 11:53:20,934 DEBUG [BingTrafficEstimator] BES - BingTrafficEstimator max keywords: 1000 11:53:20,940 INFO [BudgetEstimateDAO] Query: SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=? 11:53:20,942 DEBUG [JdbcTemplate] Executing prepared SQL query 11:53:20,942 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?] 11:53:24,341 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container 11:53:24,341 WARN [InterceptorsFactory] EJBTHREE-1246: Do not use InterceptorsFactory with a ManagedObjectAdvisor, InterceptorRegistry should be used via the bean container 11:53:24,363 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 421 11:53:24,394 DEBUG [JdbcTemplate] Executing prepared SQL query 11:53:24,397 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ] 11:53:27,551 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 11:53:27,555 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int 11:53:27,555 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String 11:53:27,556 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType 11:53:27,558 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean 11:53:27,568 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean 11:53:27,568 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean 11:53:27,568 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean 11:53:27,758 DEBUG [KeywordServiceImpl] 33 keywords found for KL: 421 11:53:27,764 DEBUG [JdbcTemplate] Executing prepared SQL query 11:53:27,764 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?] 11:53:28,162 DEBUG [JdbcTemplate] Executing prepared SQL query 11:53:28,162 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?] 11:53:28,568 DEBUG [KeywordServiceImpl] 33 keywords found for KL: 421 11:53:31,525 DEBUG [SearchEngineBudgetEstimateRetriever] Getting estimates for 183/United States 11:53:31,532 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport car hire MatchType: broad isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false 11:53:31,532 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport car hires MatchType: broad isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport car rental MatchType: broad isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport car rentals MatchType: broad isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport rent a car MatchType: broad isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport rent a van MatchType: broad isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport van hire MatchType: broad isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport van rental MatchType: broad isGeoModifiable: true isGeoModified: true isGeoTarget: true isMobile: true isNegative: false 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: apprentice MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: apprentices MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: apprenticeship MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,533 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: apprenticeships MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,534 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: career MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,534 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: careers MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,534 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: college MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,534 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: colleges MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,534 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: course MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,534 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: courses MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,534 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: dealer MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,534 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: dealers MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,543 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: job MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,543 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: jobs MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,543 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: part MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,543 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: parts MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,543 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: sale MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,543 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: sales MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,543 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: school MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,544 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: schools MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,544 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: styling MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,544 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: tuning MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,544 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: vacancies MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,544 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: vacancy MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,544 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: work MatchType: broad isGeoModifiable: false isGeoModified: false isGeoTarget: true isMobile: true isNegative: true 11:53:31,547 INFO [BingTrafficEstimator] Starting Bing BES thread: 266 11:53:33,752 INFO [BingTrafficEstimator] Finished Bing BES thread 266 11:53:33,755 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport car hire 11:53:33,756 DEBUG [SearchEngineBudgetEstimateRetriever] Lower Clicks: 0.07828572 11:53:33,756 DEBUG [SearchEngineBudgetEstimateRetriever] Lower CPC: 8.120438 11:53:33,756 DEBUG [SearchEngineBudgetEstimateRetriever] Upper Clicks: 0.31314287 11:53:33,756 DEBUG [SearchEngineBudgetEstimateRetriever] Upper CPC: 8.115876 11:53:33,756 DEBUG [SearchEngineBudgetEstimateRetriever] Total Cost: 2.5414286 11:53:33,756 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,756 DEBUG [SearchEngineBudgetEstimateRetriever] thisMax now: 2.5414286 11:53:33,756 DEBUG [SearchEngineBudgetEstimateRetriever] MaxPrice now: 2.5414286 11:53:33,757 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,757 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport car hires 11:53:33,757 DEBUG [SearchEngineBudgetEstimateRetriever] Lower Clicks: 0.114285715 11:53:33,757 DEBUG [SearchEngineBudgetEstimateRetriever] Lower CPC: 2.975 11:53:33,757 DEBUG [SearchEngineBudgetEstimateRetriever] Upper Clicks: 0.45714286 11:53:33,757 DEBUG [SearchEngineBudgetEstimateRetriever] Upper CPC: 2.975 11:53:33,757 DEBUG [SearchEngineBudgetEstimateRetriever] Total Cost: 1.36 11:53:33,757 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] thisMax now: 1.36 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] MaxPrice now: 3.9014287 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport car rental 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] Lower Clicks: 4.493143 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] Lower CPC: 3.307262 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] Upper Clicks: 17.972572 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] Upper CPC: 3.307262 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] Total Cost: 59.44 11:53:33,758 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,759 DEBUG [SearchEngineBudgetEstimateRetriever] thisMax now: 59.44 11:53:33,759 DEBUG [SearchEngineBudgetEstimateRetriever] MaxPrice now: 63.341427 11:53:33,759 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,759 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport car rentals 11:53:33,759 DEBUG [SearchEngineBudgetEstimateRetriever] Lower Clicks: 22.222857 11:53:33,759 DEBUG [SearchEngineBudgetEstimateRetriever] Lower CPC: 2.5458987 11:53:33,759 DEBUG [SearchEngineBudgetEstimateRetriever] Upper Clicks: 88.891426 11:53:33,759 DEBUG [SearchEngineBudgetEstimateRetriever] Upper CPC: 2.5459309 11:53:33,759 DEBUG [SearchEngineBudgetEstimateRetriever] Total Cost: 226.31143 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] thisMax now: 226.31143 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] MaxPrice now: 289.65286 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport rent a car 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] Lower Clicks: 0.3577143 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] Lower CPC: 2.4281151 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] Upper Clicks: 1.4308572 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] Upper CPC: 2.430112 11:53:33,760 DEBUG [SearchEngineBudgetEstimateRetriever] Total Cost: 3.4771428 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] thisMax now: 3.4771428 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] MaxPrice now: 293.13 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport rent a van 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] Lower Clicks: 0.0 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] Lower CPC: 0.0 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] Upper Clicks: 0.0 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] Upper CPC: 0.0 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] Total Cost: 0.0 11:53:33,761 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,762 DEBUG [SearchEngineBudgetEstimateRetriever] thisMax now: 0.0 11:53:33,762 DEBUG [SearchEngineBudgetEstimateRetriever] MaxPrice now: 293.13 11:53:33,762 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,762 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport van hire 11:53:33,762 DEBUG [SearchEngineBudgetEstimateRetriever] Lower Clicks: 0.0 11:53:33,766 DEBUG [SearchEngineBudgetEstimateRetriever] Lower CPC: 0.0 11:53:33,766 DEBUG [SearchEngineBudgetEstimateRetriever] Upper Clicks: 0.0 11:53:33,766 DEBUG [SearchEngineBudgetEstimateRetriever] Upper CPC: 0.0 11:53:33,766 DEBUG [SearchEngineBudgetEstimateRetriever] Total Cost: 0.0 11:53:33,766 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,766 DEBUG [SearchEngineBudgetEstimateRetriever] thisMax now: 0.0 11:53:33,766 DEBUG [SearchEngineBudgetEstimateRetriever] MaxPrice now: 293.13 11:53:33,766 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,767 DEBUG [SearchEngineBudgetEstimateRetriever] Keyword: airport van rental 11:53:33,767 DEBUG [SearchEngineBudgetEstimateRetriever] Lower Clicks: 0.312 11:53:33,767 DEBUG [SearchEngineBudgetEstimateRetriever] Lower CPC: 2.1978023 11:53:33,767 DEBUG [SearchEngineBudgetEstimateRetriever] Upper Clicks: 1.248 11:53:33,767 DEBUG [SearchEngineBudgetEstimateRetriever] Upper CPC: 2.1955128 11:53:33,767 DEBUG [SearchEngineBudgetEstimateRetriever] Total Cost: 2.74 11:53:33,767 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,767 DEBUG [SearchEngineBudgetEstimateRetriever] thisMax now: 2.74 11:53:33,767 DEBUG [SearchEngineBudgetEstimateRetriever] MaxPrice now: 295.87 11:53:33,768 DEBUG [SearchEngineBudgetEstimateRetriever] ************* 11:53:33,771 DEBUG [SearchEngineBudgetEstimateRetriever] Raw estimate found for keywordListID 421-183 11:53:33,774 INFO [BudgetEstimateDAO] Requesting most recent budget estimate 11:53:33,774 INFO [BudgetEstimateDAO] Query: SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1 11:53:33,774 DEBUG [JdbcTemplate] Executing prepared SQL query 11:53:33,774 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1] 11:53:34,128 INFO [BudgetEstimateDAO] No cached budget estimates found 11:53:34,129 INFO [BudgetEstimateDAO] Query: INSERT INTO bingBudgetEstimates (keywordListID, bingLocationTargetID, currencyCode, languageCode, minPrice, maxPrice, minClicks, maxClicks, time) VALUES (?,?,?,?,?,?,?,?,?) 11:53:34,133 DEBUG [JdbcTemplate] Executing prepared SQL update 11:53:34,135 DEBUG [JdbcTemplate] Executing prepared SQL statement [INSERT INTO bingBudgetEstimates (keywordListID, bingLocationTargetID, currencyCode, languageCode, minPrice, maxPrice, minClicks, maxClicks, time) VALUES (?,?,?,?,?,?,?,?,?)] 11:53:34,335 DEBUG [JdbcTemplate] SQL update affected 1 rows 11:53:34,706 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 11:53:35,195 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 73.96714 11:53:35,196 DEBUG [BudgetEstimateServiceImpl] maxPrice = 295.87 11:53:35,196 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 295.87 11:53:35,197 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 9005.351 11:53:35,197 DEBUG [BudgetEstimateServiceImpl] Set origin to: SEARCHENGINE 11:53:35,198 INFO [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 8 11:53:35,198 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 8.046 11:53:35,198 DEBUG [BudgetEstimateServiceImpl] maxPrice = 9005.351 11:53:35,198 DEBUG [BudgetEstimateServiceImpl] minClicks = 3.0 11:53:35,198 DEBUG [BudgetEstimateServiceImpl] maxClicks = 3357.584 11:53:35,198 INFO [BudgetEstimateServiceImpl] Request time: 15231 millis / SE API calls time: 2211 millis 11:53:37,444 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: successBing42157USDensearch_engine2015-08-28T11:53:33.771-07:008.0469005.3513.03357.584 -------------------------------------- 11:54:08,265 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 11:54:08,266 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 11:54:08,268 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 11:54:09,948 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 11:55:09,707 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 11:55:09,708 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 11:55:09,709 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 11:55:11,390 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 11:56:11,147 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 11:56:11,149 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 11:56:11,150 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 11:56:12,832 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 11:57:12,602 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 11:57:12,604 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 11:57:12,605 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 11:57:14,287 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 11:57:15,502 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 2 Address: /SMB-BES/BudgetEstimateService Encoding: UTF-8 Content-Type: text/xml;charset=UTF-8 Headers: {content-type=[text/xml;charset=UTF-8], connection=[Keep-Alive], host=[localhost:8443], Content-Length=[669], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache-HttpClient/4.1.1 (java 1.5)], accept-encoding=[gzip,deflate], Content-Type=[text/xml;charset=UTF-8]} Payload: Bing 421 57 USD en false -------------------------------------- 11:57:15,508 DEBUG [JdbcTemplate] Executing prepared SQL query 11:57:15,508 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 11:57:16,452 INFO [BudgetEstimateDAO] Query: SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=? 11:57:16,453 DEBUG [JdbcTemplate] Executing prepared SQL query 11:57:16,453 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT blt.id, blt.description, blt.type, blt.code, bbem.budgetEstimateMultiplier FROM mms_common.bingLocationTargets blt JOIN bingBudgetEstimateMap bbem on bbem.bingLocationTargetID = blt.id WHERE bbem.businessLocationID=?] 11:57:17,444 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 421 11:57:17,449 DEBUG [JdbcTemplate] Executing prepared SQL query 11:57:17,449 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id)where k.keywordListID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ] 11:57:18,178 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 11:57:18,178 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int 11:57:18,178 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String 11:57:18,178 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType 11:57:18,179 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean 11:57:18,179 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean 11:57:18,179 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean 11:57:18,179 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean 11:57:18,493 DEBUG [KeywordServiceImpl] 33 keywords found for KL: 421 11:57:18,493 DEBUG [JdbcTemplate] Executing prepared SQL query 11:57:18,493 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?] 11:57:18,974 DEBUG [JdbcTemplate] Executing prepared SQL query 11:57:18,974 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?] 11:57:19,453 DEBUG [KeywordServiceImpl] 33 keywords found for KL: 421 11:57:19,455 INFO [BudgetEstimateDAO] Requesting most recent budget estimate later than 2014-01-16 17:34:21 11:57:19,455 INFO [BudgetEstimateDAO] Query: SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1 11:57:19,455 DEBUG [JdbcTemplate] Executing prepared SQL query 11:57:19,455 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT bbe.id, bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.minPrice, bbe.maxPrice, bbe.minClicks, bbe.maxClicks, bbe.time FROM bingBudgetEstimates bbe WHERE bbe.keywordListID=? and bbe.bingLocationTargetID=? and bbe.currencyCode=? and bbe.languageCode=? and bbe.time>? ORDER BY bbe.keywordListID, bbe.bingLocationTargetID, bbe.currencyCode, bbe.languageCode, bbe.time DESC LIMIT 1] 11:57:19,952 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 73.96714/295.87 11:57:19,952 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 73.96714 11:57:19,952 DEBUG [BudgetEstimateServiceImpl] maxPrice = 295.87 11:57:19,953 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 295.87 11:57:19,953 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 9005.351 11:57:19,953 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE 11:57:19,953 INFO [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 8 11:57:19,953 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 8.046 11:57:19,953 DEBUG [BudgetEstimateServiceImpl] maxPrice = 9005.351 11:57:19,953 DEBUG [BudgetEstimateServiceImpl] minClicks = 3.0 11:57:19,953 DEBUG [BudgetEstimateServiceImpl] maxClicks = 3357.584 11:57:19,953 INFO [BudgetEstimateServiceImpl] Request time: 4446 millis 11:57:22,146 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 2 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: successBing42157USDencache2015-08-28T11:53:33.000-07:008.0469005.3513.03357.584