----------------------------
ID: 180
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[452], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Bing</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:36:39,246 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,246 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
10:36:39,250 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:36:39,253 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 181
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[454], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:36:39,255 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,255 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
10:36:39,259 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:36:39,260 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=?
10:36:39,260 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,260 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=?]
10:36:39,262 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
10:36:39,262 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,262 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
10:36:39,265 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1126
10:36:39,265 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,265 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,'(-+|[[:>:]])')) ]
10:36:39,266 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:36:39,267 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:36:39,267 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:36:39,267 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:36:39,267 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:36:39,267 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:36:39,267 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:36:39,267 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:36:39,267 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
10:36:39,267 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,267 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
10:36:39,268 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:39,268 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,268 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:36:39,269 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,269 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:36:39,269 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
10:36:39,269 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,269 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
10:36:39,270 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:39,272 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1126
10:36:39,272 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,272 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,'(-+|[[:>:]])')) ]
10:36:39,274 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:36:39,274 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:36:39,274 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:36:39,274 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:36:39,274 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:36:39,274 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:36:39,274 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:36:39,274 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:36:39,275 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:39,275 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,275 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:36:39,279 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,279 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:36:39,280 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:39,281 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:36:39,281 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
10:36:39,281 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,281 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]
10:36:39,282 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 75020.42/300081.56
10:36:39,282 DEBUG [BudgetEstimateServiceImpl] #########################################################################
10:36:39,282 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 147
10:36:39,282 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 183
10:36:39,282 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 1126
10:36:39,282 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 75020.42
10:36:39,282 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 300081.56
10:36:39,282 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 10144.894
10:36:39,282 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 40579.574
10:36:39,282 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 300081.56
10:36:39,282 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.122763) and BA Multiplier (1.0): maxPrice = 1121260.5
10:36:39,282 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:36:39,282 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request(excluding negative keywords) :51
10:36:39,282 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 22.185
10:36:39,282 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 1121260.5
10:36:39,282 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:36:39,282 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 151626.36
10:36:39,282 INFO  [BudgetEstimateServiceImpl] Request time: 37 millis
10:36:39,288 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:36:39,288 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
10:36:39,288 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:39,288 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
10:36:39,289 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 180
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Bing</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2019-03-04T09:35:42.000Z</lastUpdateTime><minimumPrice>22.185</minimumPrice><maximumPrice>1121260.5</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>151626.36</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
10:36:39,289 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 2582.3547/3506.9019
10:36:39,289 DEBUG [BudgetEstimateServiceImpl] #########################################################################
10:36:39,289 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
10:36:39,289 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 5
10:36:39,289 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 1126
10:36:39,289 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 2582.3547
10:36:39,289 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 3506.9019
10:36:39,289 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 356.33408
10:36:39,289 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 435.51935
10:36:39,289 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 3506.9019
10:36:39,290 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (1.0) and BA Multiplier (1.0): maxPrice = 106739.05
10:36:39,290 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:36:39,290 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :70
10:36:39,290 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
10:36:39,290 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 21.741
10:36:39,290 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 106739.05
10:36:39,290 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:36:39,290 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 13255.837
10:36:39,290 INFO  [BudgetEstimateServiceImpl] Request time: 36 millis
10:36:39,296 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 181
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2019-02-28T12:35:36.000Z</lastUpdateTime><minimumPrice>21.741</minimumPrice><maximumPrice>106739.05</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>13255.837</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
10:36:50,881 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 182
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[454], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:36:50,883 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,883 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
10:36:50,889 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:36:50,901 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
10:36:50,901 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,901 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
10:36:50,905 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
10:36:50,905 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,905 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
10:36:50,907 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1126
10:36:50,908 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,908 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,'(-+|[[:>:]])')) ]
10:36:50,911 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:36:50,911 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:36:50,911 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:36:50,911 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:36:50,911 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:36:50,911 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:36:50,911 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:36:50,911 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:36:50,912 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:50,912 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,912 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:36:50,913 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,913 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:36:50,914 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:50,924 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:36:50,924 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
10:36:50,924 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,924 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
10:36:50,925 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 2582.3547/3506.9019
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] #########################################################################
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 5
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 1126
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 2582.3547
10:36:50,925 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 3506.9019
10:36:50,925 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 356.33408
10:36:50,925 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 435.51935
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 3506.9019
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (1.0) and BA Multiplier (1.0): maxPrice = 106739.05
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:36:50,925 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :70
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
10:36:50,925 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 21.741
10:36:50,925 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 106739.05
10:36:50,925 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:36:50,925 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 13255.837
10:36:50,925 INFO  [BudgetEstimateServiceImpl] Request time: 43 millis
10:36:50,931 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 182
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2019-02-28T12:35:36.000Z</lastUpdateTime><minimumPrice>21.741</minimumPrice><maximumPrice>106739.05</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>13255.837</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
10:36:50,963 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 183
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[452], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Bing</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:36:50,965 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,965 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
10:36:50,969 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:36:50,979 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=?
10:36:50,979 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,979 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=?]
10:36:50,981 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
10:36:50,981 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,981 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
10:36:50,983 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1126
10:36:50,983 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,983 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,'(-+|[[:>:]])')) ]
10:36:50,985 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:36:50,985 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:36:50,985 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:36:50,985 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:36:50,985 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:36:50,985 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:36:50,985 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:36:50,985 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:36:50,986 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:50,986 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,986 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:36:50,987 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,987 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:36:50,988 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:50,997 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:36:50,997 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
10:36:50,997 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:50,997 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]
10:36:50,999 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 75020.42/300081.56
10:36:50,999 DEBUG [BudgetEstimateServiceImpl] #########################################################################
10:36:50,999 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 147
10:36:50,999 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 183
10:36:50,999 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 1126
10:36:50,999 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 75020.42
10:36:50,999 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 300081.56
10:36:50,999 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 10144.894
10:36:50,999 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 40579.574
10:36:50,999 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 300081.56
10:36:50,999 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.122763) and BA Multiplier (1.0): maxPrice = 1121260.5
10:36:50,999 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:36:50,999 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request(excluding negative keywords) :51
10:36:50,999 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 22.185
10:36:50,999 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 1121260.5
10:36:50,999 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:36:50,999 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 151626.36
10:36:50,999 INFO  [BudgetEstimateServiceImpl] Request time: 35 millis
10:36:51,005 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 183
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Bing</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2019-03-04T09:35:42.000Z</lastUpdateTime><minimumPrice>22.185</minimumPrice><maximumPrice>1121260.5</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>151626.36</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
10:36:53,050 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 184
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:getCampaignsByCustomerID xmlns:core="http://thesearchagency.com/smb/core"><customerID>f0e3ed90-74d0-4b13-b3f4-0569cb4bdfc4</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
10:36:53,052 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:53,052 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
10:36:53,055 WARN  [CustomerDAO] Unable to find account: bpID f0e3ed90-74d0-4b13-b3f4-0569cb4bdfc4
10:36:53,055 INFO  [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=false, smb-admax-deployment-service.hostname=localhost}
10:36:53,055 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:53,055 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, isPrimary, budgetType, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
10:36:53,058 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 184
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getCampaignsByCustomerIDResponse xmlns:ns2="http://thesearchagency.com/smb/core"><CampaignListResponse><customerID>f0e3ed90-74d0-4b13-b3f4-0569cb4bdfc4</customerID></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
10:36:53,176 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 185
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], transfer-encoding=[chunked], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><core:deployCampaigns xmlns:core="http://thesearchagency.com/smb/core">
<deployCampaignsRequest>
    <header>
        <requestID>15df2061-7c95-4848-abdf-c739477dba30</requestID>
        <retryID>1</retryID>
    </header>
    <customer>
        <customerID>f0e3ed90-74d0-4b13-b3f4-0569cb4bdfc4</customerID>
        <domainName>test.com</domainName>
        <budget>
            <attributes>
                <entry>
                    <key>GOOGLE</key>
                    <value>0.5</value>
                </entry>
                <entry>
                    <key>BING</key>
                    <value>1.0</value>
                </entry>
            </attributes>
        </budget>
        <anniversaryDate>2019-03-04</anniversaryDate>
        <currencyCode>USD</currencyCode>
        <timeZone>America/New_York</timeZone>
        <isBudgetCustomized>false</isBudgetCustomized>
        <countryCode>US</countryCode>
    </customer>
    <campaignList>
        <campaignID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <distribution>Bing</distribution>
        <businessAreaID>10419</businessAreaID>
        <keywordListID>1126</keywordListID>
        <businessLocationID>57</businessLocationID>
        <customLandingPage>
            <destinationURL>http://test.com</destinationURL>
            <displayURL>test.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <isPrimary>false</isPrimary>
        <budget xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <budgetType>DEFAULT</budgetType>
        <campaignDataList>
            <type>phoneNumber</type>
            <attributes>
                <entry>
                    <key>number</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">3105825700</value>
                </entry>
                <entry>
                    <key>countryCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">US</value>
                </entry>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>location</type>
            <attributes>
                <entry>
                    <key>number</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">3105825700</value>
                </entry>
                <entry>
                    <key>city</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Glendale</value>
                </entry>
                <entry>
                    <key>countryCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">US</value>
                </entry>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>companyName</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">AdMax Local</value>
                </entry>
                <entry>
                    <key>postalCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">91203</value>
                </entry>
                <entry>
                    <key>streetAddress1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">801 N. Brand Boulevard</value>
                </entry>
                <entry>
                    <key>streetAddress2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Suite 1020</value>
                </entry>
                <entry>
                    <key>provinceName</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">CA</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>callout</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>calloutText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Emergency</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>callout</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>calloutText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reach US</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>callout</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>calloutText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Directions</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>siteLink</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>linkText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Home</value>
                </entry>
                <entry>
                    <key>url</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/home</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>siteLink</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>linkText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Office</value>
                </entry>
                <entry>
                    <key>url</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/office</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesc</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California Area. Beautiful Fresh Flower Delivery.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">test.com</value>
                </entry>
                <entry>
                    <key>adURLPath2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California</value>
                </entry>
                <entry>
                    <key>adURLPath1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flower_Delivery</value>
                </entry>
                <entry>
                    <key>adHeadline1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Serving California}</value>
                </entry>
                <entry>
                    <key>adHeadline2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Need to Send Flowers?</value>
                </entry>
                <entry>
                    <key>adHeadline3</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://test.com</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <demographics/>
                </audience>
                <cta/>
                <media/>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesc</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flowers to California. Deliver Flowers to Someone Special.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">test.com</value>
                </entry>
                <entry>
                    <key>adURLPath2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California</value>
                </entry>
                <entry>
                    <key>adURLPath1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flower_Delivery</value>
                </entry>
                <entry>
                    <key>adHeadline1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Serving California}</value>
                </entry>
                <entry>
                    <key>adHeadline2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Need to Send Flowers?</value>
                </entry>
                <entry>
                    <key>adHeadline3</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://test.com</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <demographics/>
                </audience>
                <cta/>
                <media/>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesc</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California Area. Beautiful Fresh Flower Delivery.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">test.com</value>
                </entry>
                <entry>
                    <key>adURLPath2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California</value>
                </entry>
                <entry>
                    <key>adURLPath1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flower_Delivery</value>
                </entry>
                <entry>
                    <key>adHeadline1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Need to Send Flowers?</value>
                </entry>
                <entry>
                    <key>adHeadline2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Serving California</value>
                </entry>
                <entry>
                    <key>adHeadline3</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://test.com</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <demographics/>
                </audience>
                <cta/>
                <media/>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesc</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flowers to California. Deliver Flowers to Someone Special.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">test.com</value>
                </entry>
                <entry>
                    <key>adURLPath2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California</value>
                </entry>
                <entry>
                    <key>adURLPath1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flower_Delivery</value>
                </entry>
                <entry>
                    <key>adHeadline1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Need to Send Flowers?</value>
                </entry>
                <entry>
                    <key>adHeadline2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Serving California</value>
                </entry>
                <entry>
                    <key>adHeadline3</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://test.com</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <demographics/>
                </audience>
                <cta/>
                <media/>
            </socialInfo>
        </campaignDataList>
    </campaignList>
    <campaignList>
        <campaignID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <distribution>Google</distribution>
        <businessAreaID>10419</businessAreaID>
        <keywordListID>1126</keywordListID>
        <businessLocationID>57</businessLocationID>
        <customLandingPage>
            <destinationURL>http://test.com</destinationURL>
            <displayURL>test.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <isPrimary>false</isPrimary>
        <budget xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <budgetType>DEFAULT</budgetType>
        <campaignDataList>
            <type>phoneNumber</type>
            <attributes>
                <entry>
                    <key>number</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">3105825700</value>
                </entry>
                <entry>
                    <key>countryCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">US</value>
                </entry>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>location</type>
            <attributes>
                <entry>
                    <key>number</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">3105825700</value>
                </entry>
                <entry>
                    <key>city</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Glendale</value>
                </entry>
                <entry>
                    <key>countryCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">US</value>
                </entry>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>companyName</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">AdMax Local</value>
                </entry>
                <entry>
                    <key>postalCode</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">91203</value>
                </entry>
                <entry>
                    <key>streetAddress1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">801 N. Brand Boulevard</value>
                </entry>
                <entry>
                    <key>streetAddress2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Suite 1020</value>
                </entry>
                <entry>
                    <key>provinceName</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">CA</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>callout</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>calloutText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Emergency</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>callout</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>calloutText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Reach US</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>callout</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>calloutText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Directions</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>siteLink</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>linkText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Home</value>
                </entry>
                <entry>
                    <key>url</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/home</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>siteLink</type>
            <attributes>
                <entry>
                    <key>isEnabled</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">true</value>
                </entry>
                <entry>
                    <key>linkText</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Office</value>
                </entry>
                <entry>
                    <key>url</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://www.merchantsite.com/office</value>
                </entry>
            </attributes>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesc</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California Area. Beautiful Fresh Flower Delivery.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">test.com</value>
                </entry>
                <entry>
                    <key>adURLPath2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California</value>
                </entry>
                <entry>
                    <key>adURLPath1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flower_Delivery</value>
                </entry>
                <entry>
                    <key>adHeadline1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Serving California}</value>
                </entry>
                <entry>
                    <key>adHeadline2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Need to Send Flowers?</value>
                </entry>
                <entry>
                    <key>adHeadline3</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://test.com</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <demographics/>
                </audience>
                <cta/>
                <media/>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesc</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flowers to California. Deliver Flowers to Someone Special.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">test.com</value>
                </entry>
                <entry>
                    <key>adURLPath2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California</value>
                </entry>
                <entry>
                    <key>adURLPath1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flower_Delivery</value>
                </entry>
                <entry>
                    <key>adHeadline1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">{KeyWord:Serving California}</value>
                </entry>
                <entry>
                    <key>adHeadline2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Need to Send Flowers?</value>
                </entry>
                <entry>
                    <key>adHeadline3</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://test.com</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <demographics/>
                </audience>
                <cta/>
                <media/>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesc</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California Area. Beautiful Fresh Flower Delivery.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">test.com</value>
                </entry>
                <entry>
                    <key>adURLPath2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California</value>
                </entry>
                <entry>
                    <key>adURLPath1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flower_Delivery</value>
                </entry>
                <entry>
                    <key>adHeadline1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Need to Send Flowers?</value>
                </entry>
                <entry>
                    <key>adHeadline2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Serving California</value>
                </entry>
                <entry>
                    <key>adHeadline3</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://test.com</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <demographics/>
                </audience>
                <cta/>
                <media/>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <entry>
                    <key>adDesc2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesc</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flowers to California. Deliver Flowers to Someone Special.</value>
                </entry>
                <entry>
                    <key>adDisplayURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">test.com</value>
                </entry>
                <entry>
                    <key>adURLPath2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">California</value>
                </entry>
                <entry>
                    <key>adURLPath1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Flower_Delivery</value>
                </entry>
                <entry>
                    <key>adHeadline1</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Need to Send Flowers?</value>
                </entry>
                <entry>
                    <key>adHeadline2</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Serving California</value>
                </entry>
                <entry>
                    <key>adHeadline3</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string"/>
                </entry>
                <entry>
                    <key>adDesURL</key>
                    <value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">http://test.com</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <demographics/>
                </audience>
                <cta/>
                <media/>
            </socialInfo>
        </campaignDataList>
    </campaignList>
</deployCampaignsRequest>
</core:deployCampaigns></soap:Body></soap:Envelope>
--------------------------------------
10:36:53,183 INFO  [AdMaxAccountDeploymentBD] deployCampaigns: customerID = f0e3ed90-74d0-4b13-b3f4-0569cb4bdfc4, requestID = 15df2061-7c95-4848-abdf-c739477dba30
10:36:53,216 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:53,216 DEBUG [JdbcTemplate] Executing prepared SQL statement [select mms_common.gmbBusinessAreaCategoryMap.gmbCategoryID from mms_common.gmbBusinessAreaCategoryMap where mms_common.gmbBusinessAreaCategoryMap.businessAreaID = ?]
10:36:53,218 INFO  [ValidationUtils] TIMEZONE = America/New_York
10:36:53,218 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:53,218 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
10:36:53,225 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 185
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:deployCampaignsResponse xmlns:ns2="http://thesearchagency.com/smb/core"><deployCampaignsResponse><header><requestID>15df2061-7c95-4848-abdf-c739477dba30</requestID><retryID>1</retryID></header><result><resultCode>failure</resultCode><resultString>all non-deleted campaigns for the customer must be included in the request; please add the missing ones or delete them first (via updateCampaignStatus) then re-submit request</resultString></result></deployCampaignsResponse></ns2:deployCampaignsResponse></soap:Body></soap:Envelope>
--------------------------------------
10:36:55,125 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 186
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[452], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Bing</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:36:55,127 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,127 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
10:36:55,128 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 187
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[454], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:36:55,129 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,130 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
10:36:55,132 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:36:55,133 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:36:55,142 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
10:36:55,142 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=?
10:36:55,142 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,142 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=?]
10:36:55,142 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,142 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
10:36:55,144 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
10:36:55,144 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,144 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
10:36:55,144 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
10:36:55,144 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,144 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
10:36:55,148 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1126
10:36:55,148 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1126
10:36:55,148 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,148 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,'(-+|[[:>:]])')) ]
10:36:55,148 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,148 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,'(-+|[[:>:]])')) ]
10:36:55,150 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:36:55,150 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:36:55,150 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:36:55,150 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:36:55,150 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:36:55,150 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:36:55,150 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:36:55,150 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:36:55,151 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:55,151 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,151 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:36:55,152 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,152 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:36:55,152 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:36:55,152 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:36:55,152 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:36:55,152 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:36:55,152 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:36:55,152 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:36:55,152 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:36:55,152 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:36:55,154 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:55,154 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,154 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:36:55,154 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,155 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:36:55,155 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:55,157 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:55,165 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:36:55,165 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
10:36:55,165 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,165 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]
10:36:55,166 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:36:55,166 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
10:36:55,166 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,166 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
10:36:55,166 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 75020.42/300081.56
10:36:55,166 DEBUG [BudgetEstimateServiceImpl] #########################################################################
10:36:55,166 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 147
10:36:55,166 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 183
10:36:55,166 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 1126
10:36:55,166 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 75020.42
10:36:55,166 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 300081.56
10:36:55,166 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 10144.894
10:36:55,166 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 40579.574
10:36:55,166 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 300081.56
10:36:55,166 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.122763) and BA Multiplier (1.0): maxPrice = 1121260.5
10:36:55,166 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:36:55,166 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request(excluding negative keywords) :51
10:36:55,166 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 22.185
10:36:55,166 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 1121260.5
10:36:55,166 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:36:55,166 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 151626.36
10:36:55,166 INFO  [BudgetEstimateServiceImpl] Request time: 40 millis
10:36:55,167 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 2582.3547/3506.9019
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] #########################################################################
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 5
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 1126
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 2582.3547
10:36:55,167 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 3506.9019
10:36:55,167 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 356.33408
10:36:55,167 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 435.51935
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 3506.9019
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (1.0) and BA Multiplier (1.0): maxPrice = 106739.05
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:36:55,167 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :70
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
10:36:55,167 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 21.741
10:36:55,167 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 106739.05
10:36:55,167 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:36:55,167 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 13255.837
10:36:55,167 INFO  [BudgetEstimateServiceImpl] Request time: 38 millis
10:36:55,173 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 186
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Bing</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2019-03-04T09:35:42.000Z</lastUpdateTime><minimumPrice>22.185</minimumPrice><maximumPrice>1121260.5</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>151626.36</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
10:36:55,173 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 187
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2019-02-28T12:35:36.000Z</lastUpdateTime><minimumPrice>21.741</minimumPrice><maximumPrice>106739.05</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>13255.837</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
10:36:55,564 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 189
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[454], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Google</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:36:55,564 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 188
Address: /SMB-BES/BudgetEstimateService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], Accept=[*/*], host=[aml-svc-campaign:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[452], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesRequest xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateCriteriaList><distribution>Bing</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
10:36:55,567 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,567 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
10:36:55,568 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,568 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.GeoModTargetLocationID, bl.status, bl.isSellable, blt.type, blm.parentBusinessLocationID, blt2.distributionID, blt2.useSEDefinedTargets, blt2.usePointRadiusTargets from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID join businessLocationTargets blt2 on blt2.businessLocationID = bl.id where bl.id=?]
10:36:55,572 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:36:55,572 INFO  [AuthChallengeProcessor] digest authentication scheme selected
10:36:55,582 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=?
10:36:55,582 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,582 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=?]
10:36:55,584 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
10:36:55,584 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,584 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
10:36:55,585 INFO  [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?
10:36:55,585 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,585 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?]
10:36:55,587 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1126
10:36:55,587 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,587 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,'(-+|[[:>:]])')) ]
10:36:55,589 INFO  [BudgetEstimateDAO] Query: SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?
10:36:55,589 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,589 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT be_babem.businessAreaID, be_babem.budgetEstimateMultiplier, be_babem.maxCpc FROM budget_estimate.businessAreaBudgetEstimateMultiplier be_babem JOIN biz_function_location.keywordLists bfl_kl on be_babem.businessAreaID = bfl_kl.businessFunctionID WHERE bfl_kl.id=?]
10:36:55,591 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 1126
10:36:55,592 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,592 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,'(-+|[[:>:]])')) ]
10:36:55,593 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:36:55,593 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:36:55,593 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:36:55,593 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:36:55,593 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:36:55,593 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:36:55,593 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:36:55,593 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:36:55,594 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:55,595 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,595 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:36:55,596 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,596 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:36:55,596 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:55,598 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
10:36:55,598 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
10:36:55,598 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
10:36:55,598 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
10:36:55,598 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
10:36:55,598 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
10:36:55,598 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
10:36:55,598 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
10:36:55,600 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:55,600 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,600 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
10:36:55,601 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,601 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
10:36:55,601 DEBUG [KeywordServiceImpl] 70 keywords found for KL: 1126
10:36:55,606 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:36:55,606 INFO  [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1
10:36:55,606 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,606 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.keywordListID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.keywordListID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1]
10:36:55,607 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 2582.3547/3506.9019
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] #########################################################################
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 5
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 1126
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 2582.3547
10:36:55,607 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 3506.9019
10:36:55,607 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 356.33408
10:36:55,607 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 435.51935
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 3506.9019
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (1.0) and BA Multiplier (1.0): maxPrice = 106739.05
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:36:55,607 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :70
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
10:36:55,607 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 21.741
10:36:55,607 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 106739.05
10:36:55,607 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:36:55,607 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 13255.837
10:36:55,607 INFO  [BudgetEstimateServiceImpl] Request time: 41 millis
10:36:55,610 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2016-01-23 08:18:05
10:36:55,610 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
10:36:55,610 DEBUG [JdbcTemplate] Executing prepared SQL query
10:36:55,610 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]
10:36:55,616 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 75020.42/300081.56
10:36:55,616 DEBUG [BudgetEstimateServiceImpl] #########################################################################
10:36:55,616 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 147
10:36:55,616 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 183
10:36:55,616 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 1126
10:36:55,616 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 75020.42
10:36:55,616 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 300081.56
10:36:55,616 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 10144.894
10:36:55,616 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 40579.574
10:36:55,616 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 300081.56
10:36:55,616 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.122763) and BA Multiplier (1.0): maxPrice = 1121260.5
10:36:55,616 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
10:36:55,616 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request(excluding negative keywords) :51
10:36:55,616 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 22.185
10:36:55,616 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 1121260.5
10:36:55,616 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 3.0
10:36:55,616 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 151626.36
10:36:55,616 INFO  [BudgetEstimateServiceImpl] Request time: 50 millis
10:36:55,618 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 189
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Google</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2019-02-28T12:35:36.000Z</lastUpdateTime><minimumPrice>21.741</minimumPrice><maximumPrice>106739.05</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>13255.837</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
10:36:55,625 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 188
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:getBudgetEstimatesResponse xmlns:ns2="http://thesearchagency.com/smb/core/"><budgetEstimateResultList><result><resultCode>success</resultCode></result><budgetEstimateCriteria><distribution>Bing</distribution><keywordListID>1126</keywordListID><businessLocationID>57</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2019-03-04T09:35:42.000Z</lastUpdateTime><minimumPrice>22.185</minimumPrice><maximumPrice>1121260.5</maximumPrice><minimumClicks>3.0</minimumClicks><maximumClicks>151626.36</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------