13:41:12,099 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2329
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:12,099 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2330
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:12,101 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,101 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=?]
13:41:12,102 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,102 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=?]
13:41:12,119 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:12,119 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:12,150 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=?
13:41:12,150 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,150 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=?]
13:41:12,151 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=?
13:41:12,152 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,152 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=?]
13:41:12,152 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=?
13:41:12,152 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,152 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=?]
13:41:12,164 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:12,165 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=?
13:41:12,166 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,166 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=?]
13:41:12,166 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,166 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,'(-+|[[:>:]])')) ]
13:41:12,167 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:12,167 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:12,167 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:12,167 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:12,167 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:12,167 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:12,167 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:12,167 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:12,168 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:12,168 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,168 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,'(-+|[[:>:]])')) ]
13:41:12,169 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:12,169 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,169 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:12,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:12,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:12,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:12,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:12,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:12,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:12,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:12,170 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:12,171 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,171 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:12,171 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:12,171 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,171 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:12,172 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:12,172 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,172 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:12,173 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:12,188 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:12,188 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
13:41:12,188 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,189 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]
13:41:12,189 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:12,189 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:12,189 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:12,189 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:12,190 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:12,190 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:12,190 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:12,190 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:12,190 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:12,190 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:12,190 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:12,189 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
13:41:12,190 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:12,190 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]
13:41:12,190 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:12,190 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:12,190 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:12,191 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:12,191 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:12,191 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:12,191 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:12,191 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:12,191 INFO  [BudgetEstimateServiceImpl] Request time: 91 millis
13:41:12,191 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:12,192 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:12,192 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:12,192 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:12,192 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:12,192 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:12,192 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:12,192 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:12,192 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:12,192 INFO  [BudgetEstimateServiceImpl] Request time: 92 millis
13:41:12,196 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2330
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:12,196 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2329
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:13,196 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2331
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:13,198 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,198 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=?]
13:41:13,203 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:13,211 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2332
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:13,212 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,213 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=?]
13:41:13,217 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:13,228 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=?
13:41:13,228 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,228 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=?]
13:41:13,230 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=?
13:41:13,230 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,230 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=?]
13:41:13,232 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=?
13:41:13,232 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,232 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=?]
13:41:13,232 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:13,233 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,233 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,'(-+|[[:>:]])')) ]
13:41:13,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:13,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:13,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:13,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:13,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:13,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:13,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:13,234 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:13,234 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=?
13:41:13,234 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,234 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=?]
13:41:13,235 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:13,235 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,235 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:13,236 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,236 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:13,236 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:13,236 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,236 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,'(-+|[[:>:]])')) ]
13:41:13,237 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:13,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:13,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:13,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:13,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:13,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:13,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:13,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:13,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:13,240 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:13,240 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,240 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:13,240 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,240 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:13,241 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:13,254 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:13,254 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
13:41:13,254 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,254 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]
13:41:13,256 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:13,256 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:13,256 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:13,256 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:13,256 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:13,256 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:13,256 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:13,256 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:13,256 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:13,256 INFO  [BudgetEstimateServiceImpl] Request time: 59 millis
13:41:13,261 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2331
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:13,263 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:13,263 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
13:41:13,263 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:13,263 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]
13:41:13,264 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:13,264 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:13,264 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:13,264 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:13,264 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:13,264 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:13,264 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:13,264 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:13,264 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:13,264 INFO  [BudgetEstimateServiceImpl] Request time: 52 millis
13:41:13,269 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2332
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:15,382 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2333
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:15,383 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:15,383 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=?]
13:41:15,388 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:15,411 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=?
13:41:15,411 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:15,411 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=?]
13:41:15,413 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=?
13:41:15,413 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:15,413 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=?]
13:41:15,415 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:15,415 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:15,415 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,'(-+|[[:>:]])')) ]
13:41:15,417 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:15,417 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:15,417 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:15,417 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:15,417 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:15,417 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:15,417 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:15,417 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:15,418 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:15,418 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:15,418 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:15,419 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:15,419 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:15,420 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:15,434 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:15,434 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
13:41:15,434 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:15,434 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]
13:41:15,435 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:15,435 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:15,435 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:15,435 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:15,435 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:15,435 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:15,435 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:15,435 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:15,435 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:15,435 INFO  [BudgetEstimateServiceImpl] Request time: 52 millis
13:41:15,440 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2333
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:25,233 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2334
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:25,235 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:25,235 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=?]
13:41:25,242 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:25,265 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=?
13:41:25,265 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:25,265 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=?]
13:41:25,266 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=?
13:41:25,266 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:25,266 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=?]
13:41:25,269 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:25,269 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:25,269 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,'(-+|[[:>:]])')) ]
13:41:25,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:25,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:25,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:25,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:25,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:25,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:25,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:25,270 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:25,272 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:25,272 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:25,272 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:25,273 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:25,273 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:25,273 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:25,293 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:25,293 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
13:41:25,293 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:25,293 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]
13:41:25,294 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:25,294 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:25,294 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:25,294 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:25,294 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:25,294 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:25,294 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:25,294 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:25,294 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:25,294 INFO  [BudgetEstimateServiceImpl] Request time: 60 millis
13:41:25,299 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2334
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:26,948 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2335
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>3216d08c-ae4c-4356-a3ba-69d2e413c979</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:41:26,949 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:26,949 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:41:26,950 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:26,950 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:41:26,950 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:41:26,950 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=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
13:41:26,950 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:26,950 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:41:26,951 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
13:41:26,957 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23391: Deleted -> Deleted
13:41:26,957 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23391 -> TERMINATED
13:41:26,958 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23392: Deleted -> Deleted
13:41:26,958 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23392 -> TERMINATED
13:41:26,960 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23393: Deleted -> Deleted
13:41:26,960 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23393 -> TERMINATED
13:41:26,961 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23397: Deleted -> Deleted
13:41:26,961 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23397 -> TERMINATED
13:41:26,963 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23401: Deleted -> Deleted
13:41:26,963 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23401 -> TERMINATED
13:41:26,964 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23405: Deleted -> Deleted
13:41:26,964 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23405 -> TERMINATED
13:41:26,966 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23409: Deleted -> Deleted
13:41:26,966 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23409 -> TERMINATED
13:41:26,968 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23419: Deleted -> Deleted
13:41:26,968 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23419 -> TERMINATED
13:41:26,969 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23423: Deleted -> Deleted
13:41:26,969 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23423 -> TERMINATED
13:41:26,971 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23433: Deleted -> Deleted
13:41:26,971 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23433 -> TERMINATED
13:41:26,973 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23443: Deleted -> Deleted
13:41:26,973 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23443 -> TERMINATED
13:41:26,974 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23447: Deleted -> Deleted
13:41:26,974 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23447 -> TERMINATED
13:41:26,976 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23448: Deleted -> Deleted
13:41:26,976 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23448 -> TERMINATED
13:41:26,977 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23451: Deleted -> Deleted
13:41:26,977 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23451 -> TERMINATED
13:41:26,979 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23452: Deleted -> Deleted
13:41:26,979 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23452 -> TERMINATED
13:41:26,980 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23455: Deleted -> Deleted
13:41:26,980 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23455 -> TERMINATED
13:41:26,982 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23458: Deleted -> Deleted
13:41:26,982 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23458 -> TERMINATED
13:41:26,984 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23461: Deleted -> Deleted
13:41:26,984 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23461 -> TERMINATED
13:41:26,985 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23464: Deleted -> Deleted
13:41:26,985 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23464 -> TERMINATED
13:41:26,987 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23465: Deleted -> Deleted
13:41:26,987 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23465 -> TERMINATED
13:41:26,989 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23468: Deleted -> Deleted
13:41:26,989 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23468 -> TERMINATED
13:41:26,990 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23469: Deleted -> Deleted
13:41:26,990 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23469 -> TERMINATED
13:41:26,992 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23472: Deleted -> Deleted
13:41:26,992 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23472 -> TERMINATED
13:41:26,993 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23475: Deleted -> Deleted
13:41:26,993 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23475 -> TERMINATED
13:41:26,995 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23478: Deleted -> Deleted
13:41:26,995 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23478 -> TERMINATED
13:41:26,996 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23481: Deleted -> Deleted
13:41:26,996 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23481 -> TERMINATED
13:41:26,997 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23482: Deleted -> Deleted
13:41:26,997 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23482 -> TERMINATED
13:41:26,999 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23486: Deleted -> Deleted
13:41:26,999 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23486 -> TERMINATED
13:41:27,000 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23490: Deleted -> Deleted
13:41:27,000 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23490 -> TERMINATED
13:41:27,003 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23494: Deleted -> Deleted
13:41:27,003 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23494 -> TERMINATED
13:41:27,005 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23498: Deleted -> Deleted
13:41:27,005 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23498 -> TERMINATED
13:41:27,006 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23502: Deleted -> Deleted
13:41:27,006 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23502 -> TERMINATED
13:41:27,008 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23503: Deleted -> Deleted
13:41:27,008 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23503 -> TERMINATED
13:41:27,010 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23506: Deleted -> Deleted
13:41:27,010 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23506 -> TERMINATED
13:41:27,011 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23509: Deleted -> Deleted
13:41:27,011 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23509 -> TERMINATED
13:41:27,013 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23512: Deleted -> Deleted
13:41:27,013 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23512 -> TERMINATED
13:41:27,014 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23515: Deleted -> Deleted
13:41:27,014 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23515 -> TERMINATED
13:41:27,016 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23518: Deleted -> Deleted
13:41:27,016 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23518 -> TERMINATED
13:41:27,017 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23521: Deleted -> Deleted
13:41:27,017 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23521 -> TERMINATED
13:41:27,019 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23524: Deleted -> Deleted
13:41:27,019 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23524 -> TERMINATED
13:41:27,020 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23525: Deleted -> Deleted
13:41:27,020 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23525 -> TERMINATED
13:41:27,022 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23528: Deleted -> Deleted
13:41:27,022 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23528 -> TERMINATED
13:41:27,023 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23531: Deleted -> Deleted
13:41:27,023 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23531 -> TERMINATED
13:41:27,025 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23532: Deleted -> Deleted
13:41:27,025 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23532 -> TERMINATED
13:41:27,026 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23539: Deleted -> Deleted
13:41:27,026 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23539 -> TERMINATED
13:41:27,028 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23542: Deleted -> Deleted
13:41:27,028 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23542 -> TERMINATED
13:41:27,029 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23614: Active -> Active
13:41:27,029 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23614 -> ACTIVE
13:41:27,031 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23615: Active -> Active
13:41:27,031 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23615 -> ACTIVE
13:41:27,032 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23616: Active -> Active
13:41:27,032 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23616 -> ACTIVE
13:41:27,033 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:41:27,033 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,033 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:41:27,038 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,038 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:41:27,039 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,039 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:41:27,040 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,040 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
13:41:27,045 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2335
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>3216d08c-ae4c-4356-a3ba-69d2e413c979</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>23391</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23392</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23393</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23397</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23401</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23405</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23409</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23419</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23423</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23433</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23443</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23447</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23448</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23451</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23452</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23455</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23458</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23461</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23464</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>12661</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23465</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>12661</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23468</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23469</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23472</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23475</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23478</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23481</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23482</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23486</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23490</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23494</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23498</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23502</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23503</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23506</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23509</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23512</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23515</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23518</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23521</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23524</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23525</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23528</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23531</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23532</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23539</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23542</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23614</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>active</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23615</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>active</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23616</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>active</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:27,343 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2336
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>3216d08c-ae4c-4356-a3ba-69d2e413c979</customerID></core:getCampaignsByCustomerID></soap:Body></soap:Envelope>
--------------------------------------
13:41:27,344 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,344 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
13:41:27,345 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:27,345 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
13:41:27,345 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
13:41:27,345 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=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
13:41:27,345 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,345 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:41:27,346 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
13:41:27,349 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23391: Deleted -> Deleted
13:41:27,349 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23391 -> TERMINATED
13:41:27,351 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23392: Deleted -> Deleted
13:41:27,351 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23392 -> TERMINATED
13:41:27,352 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23393: Deleted -> Deleted
13:41:27,352 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23393 -> TERMINATED
13:41:27,353 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23397: Deleted -> Deleted
13:41:27,353 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23397 -> TERMINATED
13:41:27,355 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23401: Deleted -> Deleted
13:41:27,355 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23401 -> TERMINATED
13:41:27,356 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23405: Deleted -> Deleted
13:41:27,356 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23405 -> TERMINATED
13:41:27,358 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23409: Deleted -> Deleted
13:41:27,358 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23409 -> TERMINATED
13:41:27,359 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23419: Deleted -> Deleted
13:41:27,359 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23419 -> TERMINATED
13:41:27,361 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23423: Deleted -> Deleted
13:41:27,361 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23423 -> TERMINATED
13:41:27,362 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23433: Deleted -> Deleted
13:41:27,362 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23433 -> TERMINATED
13:41:27,363 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23443: Deleted -> Deleted
13:41:27,363 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23443 -> TERMINATED
13:41:27,365 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23447: Deleted -> Deleted
13:41:27,365 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23447 -> TERMINATED
13:41:27,366 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23448: Deleted -> Deleted
13:41:27,366 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23448 -> TERMINATED
13:41:27,368 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23451: Deleted -> Deleted
13:41:27,368 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23451 -> TERMINATED
13:41:27,369 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23452: Deleted -> Deleted
13:41:27,369 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23452 -> TERMINATED
13:41:27,370 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23455: Deleted -> Deleted
13:41:27,370 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23455 -> TERMINATED
13:41:27,372 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23458: Deleted -> Deleted
13:41:27,372 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23458 -> TERMINATED
13:41:27,373 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23461: Deleted -> Deleted
13:41:27,373 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23461 -> TERMINATED
13:41:27,374 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23464: Deleted -> Deleted
13:41:27,374 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23464 -> TERMINATED
13:41:27,376 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23465: Deleted -> Deleted
13:41:27,376 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23465 -> TERMINATED
13:41:27,377 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23468: Deleted -> Deleted
13:41:27,377 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23468 -> TERMINATED
13:41:27,378 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23469: Deleted -> Deleted
13:41:27,378 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23469 -> TERMINATED
13:41:27,380 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23472: Deleted -> Deleted
13:41:27,380 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23472 -> TERMINATED
13:41:27,381 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23475: Deleted -> Deleted
13:41:27,381 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23475 -> TERMINATED
13:41:27,383 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23478: Deleted -> Deleted
13:41:27,383 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23478 -> TERMINATED
13:41:27,384 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23481: Deleted -> Deleted
13:41:27,384 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23481 -> TERMINATED
13:41:27,386 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23482: Deleted -> Deleted
13:41:27,386 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23482 -> TERMINATED
13:41:27,387 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23486: Deleted -> Deleted
13:41:27,387 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23486 -> TERMINATED
13:41:27,389 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23490: Deleted -> Deleted
13:41:27,389 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23490 -> TERMINATED
13:41:27,390 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23494: Deleted -> Deleted
13:41:27,390 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23494 -> TERMINATED
13:41:27,391 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23498: Deleted -> Deleted
13:41:27,392 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23498 -> TERMINATED
13:41:27,393 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23502: Deleted -> Deleted
13:41:27,393 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23502 -> TERMINATED
13:41:27,394 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23503: Deleted -> Deleted
13:41:27,395 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23503 -> TERMINATED
13:41:27,396 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23506: Deleted -> Deleted
13:41:27,396 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23506 -> TERMINATED
13:41:27,397 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23509: Deleted -> Deleted
13:41:27,397 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23509 -> TERMINATED
13:41:27,399 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23512: Deleted -> Deleted
13:41:27,399 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23512 -> TERMINATED
13:41:27,400 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23515: Deleted -> Deleted
13:41:27,400 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23515 -> TERMINATED
13:41:27,401 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23518: Deleted -> Deleted
13:41:27,401 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23518 -> TERMINATED
13:41:27,403 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23521: Deleted -> Deleted
13:41:27,403 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23521 -> TERMINATED
13:41:27,404 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23524: Deleted -> Deleted
13:41:27,404 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23524 -> TERMINATED
13:41:27,406 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23525: Deleted -> Deleted
13:41:27,406 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23525 -> TERMINATED
13:41:27,407 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23528: Deleted -> Deleted
13:41:27,407 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23528 -> TERMINATED
13:41:27,409 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23531: Deleted -> Deleted
13:41:27,409 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23531 -> TERMINATED
13:41:27,410 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23532: Deleted -> Deleted
13:41:27,410 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23532 -> TERMINATED
13:41:27,411 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23539: Deleted -> Deleted
13:41:27,411 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23539 -> TERMINATED
13:41:27,413 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23542: Deleted -> Deleted
13:41:27,413 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23542 -> TERMINATED
13:41:27,414 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23614: Active -> Active
13:41:27,414 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23614 -> ACTIVE
13:41:27,416 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23615: Active -> Active
13:41:27,416 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23615 -> ACTIVE
13:41:27,417 INFO  [AdMaxDeploymentServiceImpl] getCampaignStatus 23616: Active -> Active
13:41:27,417 INFO  [AdMaxDeploymentWS] getCampaignsByCustomerID: 23616 -> ACTIVE
13:41:27,418 INFO  [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
13:41:27,418 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,418 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
13:41:27,420 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,420 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
13:41:27,421 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,421 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:41:27,422 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,423 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID =  ?  AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
13:41:27,424 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2336
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>3216d08c-ae4c-4356-a3ba-69d2e413c979</customerID><domain>www.merchantsite.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>23391</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23392</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23393</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23397</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23401</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23405</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23409</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23419</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23423</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23433</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23443</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23447</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23448</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23451</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23452</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23455</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23458</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23461</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23464</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>12661</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23465</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>12661</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23468</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23469</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23472</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23475</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23478</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23481</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23482</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23486</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23490</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23494</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23498</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23502</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23503</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23506</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23509</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23512</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23515</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23518</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23521</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23524</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23525</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23528</campaignID><businessAreaID>10002</businessAreaID><keywordListID>2996</keywordListID><businessLocationID>3578</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23531</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23532</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23539</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23542</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>3680</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>terminated</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23614</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>active</campaignStatus><distribution>Facebook</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23615</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>active</campaignStatus><distribution>Bing</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList><campaignList><campaignID>23616</campaignID><businessAreaID>10004</businessAreaID><keywordListID>3927</keywordListID><businessLocationID>12542</businessLocationID><customLandingPage><destinationURL>http://www.merchantsite.com/</destinationURL><displayURL>www.merchantsite.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>active</campaignStatus><distribution>Google</distribution><localeName>en_US</localeName><isPrimary>false</isPrimary></campaignList></CampaignListResponse></ns2:getCampaignsByCustomerIDResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:27,483 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2337
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=[578], 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:updateCampaignStatus xmlns:core="http://thesearchagency.com/smb/core">
<updateCampaignStatusRequest>
    <header>
        <requestID>f856ae12-3871-4a0f-b82f-bd86a1980c46</requestID>
    </header>
    <customerID>3216d08c-ae4c-4356-a3ba-69d2e413c979</customerID>
    <campaignStatusList>
        <campaignID>23614</campaignID>
        <campaignStatus>terminated</campaignStatus>
    </campaignStatusList>
</updateCampaignStatusRequest>
</core:updateCampaignStatus></soap:Body></soap:Envelope>
--------------------------------------
13:41:27,484 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,484 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:41:27,485 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,485 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
13:41:27,487 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,487 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
13:41:27,499 WARN  [QueueUtils] Setting message priority to 4
13:41:27,505 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,505 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:41:27,506 INFO  [AdMaxDeploymentFauxSyncMessenger] Starting campaign status update blocking loop
13:41:27,506 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,506 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:41:27,539 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,539 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?]
13:41:27,541 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,541 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from mms_common.campaigns where advertID = ?]
13:41:27,541 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:27,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:41:27,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:41:27,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:41:27,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:27,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:41:27,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:41:27,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:41:27,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:41:27,542 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
13:41:27,542 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,542 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
13:41:27,544 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,544 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
13:41:27,545 DEBUG [JdbcTemplate] Executing prepared SQL update
13:41:27,545 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)]
13:41:27,546 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:41:27,549 WARN  [QueueUtils] Setting message priority to 9
13:41:27,552 INFO  [AdMaxDeploymentRequestMDB] Sent UPDATE request to listener. BPID: 3216d08c-ae4c-4356-a3ba-69d2e413c979 DeployID: f856ae12-3871-4a0f-b82f-bd86a1980c46
13:41:27,935 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:27,935 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL]
13:41:28,507 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:28,507 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:41:29,509 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:29,509 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:41:30,522 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:30,522 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:41:31,532 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:31,532 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:41:32,534 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:32,534 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:41:33,535 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:33,535 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:41:33,700 INFO  [AdMaxDeploymentResponseMDB] Response MDB triggered.
13:41:33,711 DEBUG [JdbcTemplate] Executing prepared SQL update
13:41:33,711 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.campUpdateResp(deploymentID, responseMsg) values (?, ?) on duplicate key update responseMsg = ?]
13:41:33,713 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:41:33,713 WARN  [AdMaxDeploymentFauxSyncMessenger] Put update ok for deploy f856ae12-3871-4a0f-b82f-bd86a1980c46
13:41:33,714 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:33,714 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
13:41:33,714 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
13:41:33,740 INFO  [CallbackPersistentManager] Adding a CallbackEvent
13:41:33,741 DEBUG [JdbcTemplate] Executing prepared SQL update
13:41:33,741 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into callbackEvent(customerId,createdDate,modifiedDate, eventCode) values(?,?,?,?) on duplicate key update modifiedDate = ?]
13:41:33,741 DEBUG [JdbcTemplate] SQL update affected 2 rows
13:41:33,742 INFO  [AdMaxDeploymentResponseMDB] Handling update campaign status.
13:41:34,537 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:34,537 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
13:41:35,541 INFO  [AdMaxDeploymentFauxSyncMessenger] Exited blocking loop
13:41:35,544 DEBUG [JdbcTemplate] Executing prepared SQL update
13:41:35,544 DEBUG [JdbcTemplate] Executing prepared SQL statement [delete from mms_common.campUpdateResp where deploymentID = ?]
13:41:35,545 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:41:35,546 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2337
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:updateCampaignStatusResponse xmlns:ns2="http://thesearchagency.com/smb/core"><updateCampaignStatusResponse><header><requestID>f856ae12-3871-4a0f-b82f-bd86a1980c46</requestID></header><customerID>3216d08c-ae4c-4356-a3ba-69d2e413c979</customerID><campaignResult><campaignID>23614</campaignID><result><resultCode>success</resultCode><resultString>Information: [23614_S1:SUCCEEDED] [23614_S2:SUCCEEDED] [23614_S3:SUCCEEDED] [23614_S4:SUCCEEDED] </resultString></result></campaignResult></updateCampaignStatusResponse></ns2:updateCampaignStatusResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:35,588 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2338
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=[678], 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:updateCampaignBudgetAccrualStatus xmlns:core="http://thesearchagency.com/smb/core">
<updateCampaignBudgetAccrualStatusRequest>
    <header>
        <requestID>f856ae12-3871-4a0f-b82f-bd86a1980c46</requestID>
    </header>
    <customerID>3216d08c-ae4c-4356-a3ba-69d2e413c979</customerID>
    <campaignBudgetAccrualStatusList>
        <campaignID>23614</campaignID>
        <campaignBudgetAccrualStatus>paused</campaignBudgetAccrualStatus>
    </campaignBudgetAccrualStatusList>
</updateCampaignBudgetAccrualStatusRequest>
</core:updateCampaignBudgetAccrualStatus></soap:Body></soap:Envelope>
--------------------------------------
13:41:35,625 INFO  [AdMaxAccountDeploymentBD] validated: []
13:41:35,625 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:35,625 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
13:41:35,628 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:35,628 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
13:41:35,629 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:35,629 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
13:41:35,635 INFO  [AdMaxAccountDeploymentBD] Account: Account [theAccountID=2388, theDescription=3216d08c-ae4c-4356-a3ba-69d2e413c979, theTier=1, thePriority=50, theReportClickOuts=0, theReportConversions=0, theConversionTypes=[], isBidManaged=1, isActive=true, thePerformanceMetric=cpa, theProvidesConversionData=true, theAddConversionDate=false, theFractionalConversionCounts=false, theHideNullSources=0, theNowTime=Mon Jul 23 13:41:35 UTC 2018, theWarehouseDB=warehouse_1, theDatabaseInstance=1, theWarehouseInstance=1, isOnline=true, currencyCode=, theSites=[Site [theSiteId=2387, theAccountId=2388, isDefault=true, theDescription=3216d08c-ae4c-4356-a3ba-69d2e413c979_Main, theInternalURLPattern=, hasIgnorePixels=false, theWaypoints=[Waypoint [theWaypointId=4773, theSiteId=2387, theGroupId=0, theType=2, theConverstionType=null, theDefaultCost=0.0, theDefaultValue=0.0, theTestingURL=, theDestinationURL=, theDescription=Page View, thePassParams=, theDebounceWindow=30, theLimitPerWindow=1, theLastTestedDate=null, theTestStatus=null], Waypoint [theWaypointId=4774, theSiteId=2387, theGroupId=0, theType=4, theConverstionType=null, theDefaultCost=0.0, theDefaultValue=0.0, theTestingURL=, theDestinationURL=, theDescription=Conversion, thePassParams=, theDebounceWindow=0, theLimitPerWindow=0, theLastTestedDate=null, theTestStatus=null]]]]]
13:41:35,635 INFO  [AdMaxAccountDeploymentBD] Updating CampaignID [23614] budget accrual status to [paused]
13:41:35,636 DEBUG [CampaignBudgetAccrualStatusServiceBD] Entering CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus
13:41:35,637 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:35,637 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxCampaignBudgetAccrualStatus where admaxCampaignID = ? ]
13:41:35,644 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:35,644 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where id = ? ]
13:41:35,645 INFO  [CampaignBudgetAccrualStatusServiceBD] CampaignId [6706] CampaignBudgetAccrualStatus [9420] end date set to Mon Jul 23 00:00:00 UTC 2018
13:41:35,645 DEBUG [CampaignBudgetAccrualStatusServiceBD] CampaignBudgetAccrualStatus - Creating new CampaignBudgetAccrualStatus for campaign [6706] with start date of Tue Jul 24 00:00:00 UTC 2018, null end date, and paused status
13:41:35,645 DEBUG [JdbcTemplate] Executing prepared SQL update
13:41:35,645 DEBUG [JdbcTemplate] Executing prepared SQL statement [update admaxCampaignBudgetAccrualStatus set endDate = ?, status = ? where id = ? ]
13:41:35,650 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:41:35,651 DEBUG [JdbcTemplate] Executing prepared SQL update
13:41:35,651 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into admaxCampaignBudgetAccrualStatus(id,admaxCampaignID,startDate,endDate,status) values(?,?,?,?,?)on duplicate key update endDate=?, status=?]
13:41:35,656 DEBUG [JdbcTemplate] SQL update affected 1 rows
13:41:35,657 DEBUG [CampaignBudgetAccrualStatusServiceBD] Exiting CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus method.
13:41:35,658 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2338
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:updateCampaignBudgetAccrualStatusResponse xmlns:ns2="http://thesearchagency.com/smb/core"><updateCampaignBudgetAccrualStatusResponse><header><requestID>f856ae12-3871-4a0f-b82f-bd86a1980c46</requestID></header><customerID>3216d08c-ae4c-4356-a3ba-69d2e413c979</customerID><campaignResult><campaignID>23614</campaignID><result><resultCode>success</resultCode></result></campaignResult></updateCampaignBudgetAccrualStatusResponse></ns2:updateCampaignBudgetAccrualStatusResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:35,710 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2339
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>f856ae12-3871-4a0f-b82f-bd86a1980c46</requestID>
        <retryID>1</retryID>
    </header>
    <customer>
        <customerID>3216d08c-ae4c-4356-a3ba-69d2e413c979</customerID>
        <domainName>www.merchantsite.com</domainName>
        <budget>
            <attributes>
                <entry>
                    <key>FACEBOOK</key>
                    <value>62.5</value>
                </entry>
                <entry>
                    <key>GOOGLE</key>
                    <value>0.4</value>
                </entry>
                <entry>
                    <key>BING</key>
                    <value>0.1</value>
                </entry>
            </attributes>
        </budget>
        <anniversaryDate>2018-07-23</anniversaryDate>
        <currencyCode>USD</currencyCode>
        <timeZone>America/New_York</timeZone>
        <countryCode>US</countryCode>
    </customer>
    <campaignList>
        <campaignID>23615</campaignID>
        <distribution>Bing</distribution>
        <businessAreaID>10004</businessAreaID>
        <keywordListID>3927</keywordListID>
        <businessLocationID>12542</businessLocationID>
        <customLandingPage>
            <destinationURL>http://www.merchantsite.com/</destinationURL>
            <displayURL>www.merchantsite.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <isPrimary>false</isPrimary>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo - Top B&amp;B. We'll See You Soon!</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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:Aliso Viejo B&amp;B Room}</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">Find a B&amp;B</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>980</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-5.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo B&amp;B. We'll Make Your Experience Perfect.</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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">Find a B&amp;B</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">Aliso Viejo B&amp;B Room</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>979</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-4.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo B&amp;B. We'll Make Your Experience Perfect.</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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:Aliso Viejo B&amp;B Room}</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">Find a B&amp;B</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>978</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-3.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo - Top B&amp;B. We'll See You Soon!</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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">Find a B&amp;B</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">Aliso Viejo B&amp;B Room</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>977</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-2.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
    </campaignList>
    <campaignList>
        <campaignID xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
        <distribution>Facebook</distribution>
        <businessAreaID>10004</businessAreaID>
        <keywordListID>3927</keywordListID>
        <businessLocationID>12542</businessLocationID>
        <customLandingPage>
            <destinationURL>http://www.merchantsite.com/</destinationURL>
            <displayURL>www.merchantsite.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <isPrimary>true</isPrimary>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo - Top B&amp;B. We'll See You Soon!</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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">Aliso Viejo B&amp;B Room</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">Find a B&amp;B</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>980</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-5.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo B&amp;B. We'll Make Your Experience Perfect.</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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">Find a B&amp;B</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">Aliso Viejo B&amp;B Room</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>979</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-4.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo B&amp;B. We'll Make Your Experience Perfect.</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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">Aliso Viejo B&amp;B Room</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">Find a B&amp;B</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>978</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-3.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo - Top B&amp;B. We'll See You Soon!</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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">Find a B&amp;B</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">Aliso Viejo B&amp;B Room</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>977</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-2.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
    </campaignList>
    <campaignList>
        <campaignID>23616</campaignID>
        <distribution>Google</distribution>
        <businessAreaID>10004</businessAreaID>
        <keywordListID>3927</keywordListID>
        <businessLocationID>12542</businessLocationID>
        <customLandingPage>
            <destinationURL>http://www.merchantsite.com/</destinationURL>
            <displayURL>www.merchantsite.com</displayURL>
        </customLandingPage>
        <localeName>en_US</localeName>
        <isPrimary>false</isPrimary>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo - Top B&amp;B. We'll See You Soon!</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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:Aliso Viejo B&amp;B Room}</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">Find a B&amp;B</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>980</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-5.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo B&amp;B. We'll Make Your Experience Perfect.</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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">Find a B&amp;B</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">Aliso Viejo B&amp;B Room</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>979</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-4.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo B&amp;B. We'll Make Your Experience Perfect.</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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:Aliso Viejo B&amp;B Room}</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">Find a B&amp;B</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>978</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-3.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
        <campaignDataList>
            <type>adContent</type>
            <attributes>
                <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">Aliso Viejo - Top B&amp;B. We'll See You Soon!</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">www.merchantsite.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">Aliso_Viejo</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">B&amp;B</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">Find a B&amp;B</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">Aliso Viejo B&amp;B Room</value>
                </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://www.merchantsite.com/</value>
                </entry>
            </attributes>
            <socialInfo>
                <audience>
                    <ageFrom>18</ageFrom>
                    <ageTo>65</ageTo>
                    <gender>all</gender>
                    <demographics>
                        <demographic>
                            <id>6002714895372</id>
                            <name>Frequent Travelers</name>
                            <type>behaviors</type>
                        </demographic>
                        <demographic>
                            <id>6002926108721</id>
                            <name>Vacations</name>
                            <type>interests</type>
                        </demographic>
                    </demographics>
                </audience>
                <cta>
                    <objective>website_clicks</objective>
                    <type>learn_more</type>
                </cta>
                <media>
                    <id>977</id>
                    <mediaListId>195</mediaListId>
                    <url>https://aml-qa.s3.us-west-1.amazonaws.com/usa/10004/images/image-10004-2.jpg</url>
                    <type>image</type>
                    <status>enabled</status>
                </media>
            </socialInfo>
        </campaignDataList>
    </campaignList>
</deployCampaignsRequest>
</core:deployCampaigns></soap:Body></soap:Envelope>
--------------------------------------
13:41:35,712 INFO  [AdMaxAccountDeploymentBD] deployCampaigns: customerID = 3216d08c-ae4c-4356-a3ba-69d2e413c979, requestID = f856ae12-3871-4a0f-b82f-bd86a1980c46
13:41:35,722 ERROR [AdMaxAccountDeploymentBD] exception in deployCampaigns for customerID = 3216d08c-ae4c-4356-a3ba-69d2e413c979, requestID = f856ae12-3871-4a0f-b82f-bd86a1980c46
com.thesearchagency.core.smb.service.admaxdeployment.AdMaxDeploymentException: Facebook minimum monthly budget 62.5 is less than 124.0
        at com.thesearchagency.core.smb.service.admaxdeployment.mapper.CampaignRequestMapper.toCoreCampaigns(CampaignRequestMapper.java:184)
        at com.thesearchagency.core.smb.service.admaxdeployment.mapper.CampaignRequestMapper.toCoreAccount(CampaignRequestMapper.java:122)
        at com.thesearchagency.core.smb.service.admaxdeployment.component.AdMaxAccountDeploymentBD.deployCampaigns(AdMaxAccountDeploymentBD.java:106)
        at com.thesearchagency.core.smb.service.admaxdeployment.binding.AdMaxDeploymentWS.deployCampaigns(AdMaxDeploymentWS.java:121)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:129)
        at org.jboss.wsf.stack.cxf.AbstractInvoker._invokeInternal(AbstractInvoker.java:164)
        at org.jboss.wsf.stack.cxf.AbstractInvoker.invoke(AbstractInvoker.java:112)
        at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
        at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)
        at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:255)
        at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:113)
        at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:97)
        at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:461)
        at org.jboss.wsf.stack.cxf.ServletControllerExt.invoke(ServletControllerExt.java:172)
        at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:57)
        at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:162)
        at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:90)
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:179)
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:103)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:159)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:748)
13:41:35,724 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2339
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>f856ae12-3871-4a0f-b82f-bd86a1980c46</requestID><retryID>1</retryID></header><result><resultCode>failure</resultCode><resultString>unexpected error; please contact support for requestID f856ae12-3871-4a0f-b82f-bd86a1980c46</resultString></result></deployCampaignsResponse></ns2:deployCampaignsResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:37,788 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2340
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:37,790 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:37,790 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=?]
13:41:37,804 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:37,835 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=?
13:41:37,835 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:37,835 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=?]
13:41:37,837 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=?
13:41:37,837 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:37,837 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=?]
13:41:37,839 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:37,840 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:37,840 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,'(-+|[[:>:]])')) ]
13:41:37,841 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:37,841 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:37,841 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:37,841 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:37,841 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:37,841 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:37,841 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:37,841 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:37,842 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:37,842 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:37,842 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:37,843 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:37,843 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:37,844 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:37,880 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:37,880 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
13:41:37,880 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:37,880 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]
13:41:37,881 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:37,881 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:37,881 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:37,881 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:37,881 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:37,881 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:37,881 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:37,881 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:37,881 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:37,881 INFO  [BudgetEstimateServiceImpl] Request time: 92 millis
13:41:37,887 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2340
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:38,208 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2341
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:38,209 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,209 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=?]
13:41:38,214 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:38,235 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2342
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:38,237 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,237 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=?]
13:41:38,239 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=?
13:41:38,239 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,239 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=?]
13:41:38,241 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=?
13:41:38,241 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,241 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=?]
13:41:38,242 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:38,243 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:38,243 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,243 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,'(-+|[[:>:]])')) ]
13:41:38,246 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:38,246 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:38,246 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:38,246 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:38,246 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:38,246 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:38,246 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:38,246 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:38,248 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:38,248 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,248 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:38,249 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,249 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:38,250 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:38,259 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=?
13:41:38,259 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,259 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=?]
13:41:38,260 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=?
13:41:38,260 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,260 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=?]
13:41:38,261 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:38,261 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
13:41:38,261 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,261 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]
13:41:38,262 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:38,262 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:38,262 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:38,262 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:38,262 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:38,262 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:38,262 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:38,262 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:38,262 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:38,262 INFO  [BudgetEstimateServiceImpl] Request time: 53 millis
13:41:38,272 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:38,272 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,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,'(-+|[[:>:]])')) ]
13:41:38,275 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:38,275 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:38,275 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:38,275 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:38,275 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:38,275 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:38,275 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:38,275 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:38,276 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:38,276 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,276 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:38,277 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,277 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:38,278 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:38,278 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2341
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:38,296 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:38,297 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
13:41:38,297 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:38,297 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]
13:41:38,298 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:38,298 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:38,298 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:38,298 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:38,298 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:38,298 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:38,298 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:38,298 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:38,298 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:38,298 INFO  [BudgetEstimateServiceImpl] Request time: 62 millis
13:41:38,303 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2342
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:43,530 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2343
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:43,532 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,532 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=?]
13:41:43,537 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:43,561 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=?
13:41:43,561 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,561 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=?]
13:41:43,563 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=?
13:41:43,563 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,563 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=?]
13:41:43,565 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:43,565 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,565 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,'(-+|[[:>:]])')) ]
13:41:43,566 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:43,566 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:43,566 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:43,567 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:43,567 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:43,567 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:43,567 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:43,567 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:43,568 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:43,568 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,568 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:43,569 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,569 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:43,569 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:43,590 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:43,590 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
13:41:43,590 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,590 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]
13:41:43,591 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:43,591 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:43,591 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:43,591 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:43,591 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:43,591 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:43,591 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:43,591 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:43,591 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:43,591 INFO  [BudgetEstimateServiceImpl] Request time: 60 millis
13:41:43,596 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2343
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------
13:41:43,637 INFO  [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2344
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=[457], 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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteriaList></ns2:getBudgetEstimatesRequest></soap:Body></soap:Envelope>
--------------------------------------
13:41:43,639 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,639 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=?]
13:41:43,644 INFO  [AuthChallengeProcessor] digest authentication scheme selected
13:41:43,658 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=?
13:41:43,659 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,659 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=?]
13:41:43,660 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=?
13:41:43,660 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,660 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=?]
13:41:43,663 DEBUG [KeywordServiceImpl] Getting keywords for KeywordList: 3927
13:41:43,663 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,663 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,'(-+|[[:>:]])')) ]
13:41:43,664 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
13:41:43,664 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
13:41:43,664 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String
13:41:43,664 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType
13:41:43,664 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean
13:41:43,664 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean
13:41:43,664 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean
13:41:43,664 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean
13:41:43,666 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:43,666 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,666 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where id = ?]
13:41:43,666 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,666 DEBUG [JdbcTemplate] Executing prepared SQL statement [select merchantUUID from biz_function_location.keywordLists where id = ?]
13:41:43,667 DEBUG [KeywordServiceImpl] 81 keywords found for KL: 3927
13:41:43,688 INFO  [BudgetEstimateDAO] Requesting most recent budget estimate later than 2018-01-24 07:16:41
13:41:43,688 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
13:41:43,688 DEBUG [JdbcTemplate] Executing prepared SQL query
13:41:43,688 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]
13:41:43,689 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 58.951054/80.05698
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] #########################################################################
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] Distribution ID : 3
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] Location Target ID : 66232
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] KeywordList ID : 3927
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 58.951054
13:41:43,689 DEBUG [BudgetEstimateServiceImpl]                                  maxPrice = 80.05698
13:41:43,689 DEBUG [BudgetEstimateServiceImpl]                                  minClicks = 32.506325
13:41:43,689 DEBUG [BudgetEstimateServiceImpl]                                  maxClicks = 39.72996
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 80.05698
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] Budget estimate using BL multiplier (0.0012837) and BA Multiplier (1.0): maxPrice = 3.128
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE
13:41:43,689 INFO  [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request :81
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0
13:41:43,689 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 2.303
13:41:43,689 DEBUG [BudgetEstimateServiceImpl]                             maxPrice = 3.128
13:41:43,689 DEBUG [BudgetEstimateServiceImpl]                             minClicks = 1.27
13:41:43,689 DEBUG [BudgetEstimateServiceImpl]                             maxClicks = 1.552
13:41:43,689 INFO  [BudgetEstimateServiceImpl] Request time: 51 millis
13:41:43,694 INFO  [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2344
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>3927</keywordListID><businessLocationID>12542</businessLocationID><currencyCode>USD</currencyCode><languageCode>en</languageCode></budgetEstimateCriteria><budgetEstimate><origin>cache</origin><lastUpdateTime>2018-07-17T14:43:05.000Z</lastUpdateTime><minimumPrice>2.303</minimumPrice><maximumPrice>3.128</maximumPrice><minimumClicks>1.27</minimumClicks><maximumClicks>1.552</maximumClicks></budgetEstimate></budgetEstimateResultList></ns2:getBudgetEstimatesResponse></soap:Body></soap:Envelope>
--------------------------------------