Step 1: Create a Merchant Step 2: Create an order for the merchant. Step 3: Check the log # The sample Listner Log for the SE update for the first time campaign Deployment. JobExecutor running job [2013-01-10_073820_a175_AccountWorkerProcessResults_syncAccountsGroupsListings_VFHlvRXvM8]: /usr/bin/java -Xms256m -Xmx1536m -Xincgc -cp /usr/local/tsa/bidmgr/libs/jst.jar:/usr/local/tsa/bidmgr/libs/tsa.jar:/usr/local/tsa/bidmgr/libs/bidmgrtsa.jar:/usr/local/tsa/bidmgr/libs/jdb.jar:/usr/local/tsa/bidmgr/libs/bidmgrse.jar:/usr/local/tsa/bidmgr/libs/bidmgrclients.jar:/usr/local/tsa/bidmgr/libs/bidmgrseov.jar:/usr/local/tsa/bidmgr/libs/bidmgrsefwht.jar:/usr/local/tsa/bidmgr/libs/bidmgrsegoogle.jar:/usr/local/tsa/bidmgr/libs/adwords-api-8.7.0.jar:/usr/local/tsa/bidmgr/libs/bidmgrsemsn.jar:/usr/local/tsa/bidmgr/libs/bidmgrsemsnwsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrseyahoo.jar:/usr/local/tsa/bidmgr/libs/bidmgrseyahoowsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrsessp.jar:/usr/local/tsa/bidmgr/libs/bidmgrsesspwsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrseask.jar:/usr/local/tsa/bidmgr/libs/bidmgrseaskwsdl.jar:/usr/local/tsa/bidmgr/libs/model.jar:/usr/local/tsa/bidmgr/libs/log4j.jar:/usr/local/tsa/bidmgr/libs/axis14/axis.jar:/usr/local/tsa/bidmgr/libs/thirdparty/xercesImpl.jar:/usr/local/tsa/bidmgr/libs/thirdparty/jaxp-1.2.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-httpclient.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-codec.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-logging.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-discovery.jar:/usr/local/tsa/bidmgr/libs/thirdparty/wsdl4j.jar:/usr/local/tsa/bidmgr/libs/thirdparty/jaxrpc.jar:/usr/local/tsa/bidmgr/libs/thirdparty/saaj.jar:/usr/local/tsa/bidmgr/libs/thirdparty/mysql.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-cli.jar:/usr/local/tsa/bidmgr/libs/thirdparty/activation.jar:/usr/local/tsa/bidmgr/libs/thirdparty/mail.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-collections-3.2.1.jar com.thesearchagency.searchengines.SearchEngineUpdater -d 3 --inactive --accountid 175 --accounts --seaccount 961,962,963 --groups --listings Step 4: Execute the Query to get the status of the listings. [SELECT * FROM `st-tracker`.searchEngineListings where searchEngineAccountID in (,,)]; # Following is the Query executed for searchEngineListings for first time. mysql> SELECT * FROM `st-tracker`.searchEngineListings where searchEngineAccountID in (961,962,963); +------+--------+-----------------------+-----------+------------------------+-----------------------------+-----------------------+---------------------+------+----------------------------+----------------------------------+----------------------------------+-------------------------+------------------+---------------------+-------------------------+----------------------------------+----------+---------+--------------------+------------------------+---------------------+---------------------+ | id | altKey | searchEngineAccountID | listingID | searchEngineIdentifier | searchEngineGroupIdentifier | searchEngineMatchType | searchEngineGroupID | type | title | description1 | description2 | url | displayURL | searchEngineImageID | iconSearchEngineImageID | hash | calcHash | enabled | searchEngineStatus | searchEngineStatusText | lastChecked | lastModified | +------+--------+-----------------------+-----------+------------------------+-----------------------------+-----------------------+---------------------+------+----------------------------+----------------------------------+----------------------------------+-------------------------+------------------+---------------------+-------------------------+----------------------------------+----------+---------+--------------------+------------------------+---------------------+---------------------+ | 3193 | NULL | 961 | 0 | 17916499836 | 5765784156 | NULL | 714 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 4b1b549bf6460596d546a040c7628731 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:48 | | 3194 | NULL | 961 | 0 | 17916499956 | 5765784156 | NULL | 714 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploy.com | www.redeploy.com | 0 | 0 | e128a63ee490c0ff55360330d9facac1 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:48 | | 3195 | NULL | 961 | 0 | 17916500076 | 5765784156 | NULL | 714 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 6c393c378300db16f43a36d57e61e321 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:48 | | 3196 | NULL | 961 | 0 | 17916500196 | 5765784156 | NULL | 714 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 48df5e1dde5beeb3ab811e6699bad4f3 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:48 | | 3185 | NULL | 962 | 0 | 17916498756 | 5765784276 | NULL | 713 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 48df5e1dde5beeb3ab811e6699bad4f3 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:47 | | 3186 | NULL | 962 | 0 | 17916498876 | 5765784276 | NULL | 713 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 4b1b549bf6460596d546a040c7628731 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:47 | | 3187 | NULL | 962 | 0 | 17916498996 | 5765784276 | NULL | 713 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploy.com | www.redeploy.com | 0 | 0 | e128a63ee490c0ff55360330d9facac1 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:47 | | 3188 | NULL | 962 | 0 | 17916499116 | 5765784276 | NULL | 713 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 6c393c378300db16f43a36d57e61e321 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:47 | | 3189 | NULL | 963 | 0 | 17916499236 | 5765784396 | NULL | 715 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 4b1b549bf6460596d546a040c7628731 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:48 | | 3190 | NULL | 963 | 0 | 17916499356 | 5765784396 | NULL | 715 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploy.com | www.redeploy.com | 0 | 0 | e128a63ee490c0ff55360330d9facac1 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:48 | | 3191 | NULL | 963 | 0 | 17916499476 | 5765784396 | NULL | 715 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 6c393c378300db16f43a36d57e61e321 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:48 | | 3192 | NULL | 963 | 0 | 17916499596 | 5765784396 | NULL | 715 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 48df5e1dde5beeb3ab811e6699bad4f3 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 07:38:48 | +------+--------+-----------------------+-----------+------------------------+-----------------------------+-----------------------+---------------------+------+----------------------------+----------------------------------+----------------------------------+-------------------------+------------------+---------------------+-------------------------+----------------------------------+----------+---------+--------------------+------------------------+---------------------+---------------------+ Step 5: Recreate an order for the Merchant with different BL and BA. Step 6: Check the log. Note : Please see the parametes values passed to the SE UPDate. # The sample Listner Log for the SE update for the redeployment of the campaign. JobExecutor running job [2013-01-10_080508_a175_campaignUpdateWorkerCampaignSync_QSHTos6o6X]: /usr/bin/java -Xms256m -Xmx1536m -Xincgc -cp /usr/local/tsa/bidmgr/libs/jst.jar:/usr/local/tsa/bidmgr/libs/tsa.jar:/usr/local/tsa/bidmgr/libs/bidmgrtsa.jar:/usr/local/tsa/bidmgr/libs/jdb.jar:/usr/local/tsa/bidmgr/libs/bidmgrse.jar:/usr/local/tsa/bidmgr/libs/bidmgrclients.jar:/usr/local/tsa/bidmgr/libs/bidmgrseov.jar:/usr/local/tsa/bidmgr/libs/bidmgrsefwht.jar:/usr/local/tsa/bidmgr/libs/bidmgrsegoogle.jar:/usr/local/tsa/bidmgr/libs/adwords-api-8.7.0.jar:/usr/local/tsa/bidmgr/libs/bidmgrsemsn.jar:/usr/local/tsa/bidmgr/libs/bidmgrsemsnwsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrseyahoo.jar:/usr/local/tsa/bidmgr/libs/bidmgrseyahoowsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrsessp.jar:/usr/local/tsa/bidmgr/libs/bidmgrsesspwsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrseask.jar:/usr/local/tsa/bidmgr/libs/bidmgrseaskwsdl.jar:/usr/local/tsa/bidmgr/libs/model.jar:/usr/local/tsa/bidmgr/libs/log4j.jar:/usr/local/tsa/bidmgr/libs/axis14/axis.jar:/usr/local/tsa/bidmgr/libs/thirdparty/xercesImpl.jar:/usr/local/tsa/bidmgr/libs/thirdparty/jaxp-1.2.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-httpclient.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-codec.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-logging.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-discovery.jar:/usr/local/tsa/bidmgr/libs/thirdparty/wsdl4j.jar:/usr/local/tsa/bidmgr/libs/thirdparty/jaxrpc.jar:/usr/local/tsa/bidmgr/libs/thirdparty/saaj.jar:/usr/local/tsa/bidmgr/libs/thirdparty/mysql.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-cli.jar:/usr/local/tsa/bidmgr/libs/thirdparty/activation.jar:/usr/local/tsa/bidmgr/libs/thirdparty/mail.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-collections-3.2.1.jar com.thesearchagency.searchengines.SearchEngineUpdater -d 3 --inactive --seaccount 963,961,962,961,962,963 --groups --listings Step 7: Execute the Query to get the status of the listings. [SELECT * FROM `st-tracker`.searchEngineListings where searchEngineAccountID in (?,?,?,?,?,?);] # Following is the Query executed for searchEngineListings for deleted campaigns.(Which contains deleted and enabled textads for deleted campaigns) mysql> SELECT * FROM `st-tracker`.searchEngineListings where searchEngineAccountID in (961,962,963) order by searchEngineAccountID; +------+--------+-----------------------+-----------+------------------------+-----------------------------+-----------------------+---------------------+------+----------------------------+----------------------------------+----------------------------------+-----------------------------+----------------------+---------------------+-------------------------+----------------------------------+----------+---------+--------------------+------------------------+---------------------+---------------------+ | id | altKey | searchEngineAccountID | listingID | searchEngineIdentifier | searchEngineGroupIdentifier | searchEngineMatchType | searchEngineGroupID | type | title | description1 | description2 | url | displayURL | searchEngineImageID | iconSearchEngineImageID | hash | calcHash | enabled | searchEngineStatus | searchEngineStatusText | lastChecked | lastModified | +------+--------+-----------------------+-----------+------------------------+-----------------------------+-----------------------+---------------------+------+----------------------------+----------------------------------+----------------------------------+-----------------------------+----------------------+---------------------+-------------------------+----------------------------------+----------+---------+--------------------+------------------------+---------------------+---------------------+ | 3193 | NULL | 961 | 0 | 17916499836 | 5765784156 | NULL | 714 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 4b1b549bf6460596d546a040c7628731 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3194 | NULL | 961 | 0 | 17916499956 | 5765784156 | NULL | 714 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploy.com | www.redeploy.com | 0 | 0 | e128a63ee490c0ff55360330d9facac1 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3195 | NULL | 961 | 0 | 17916500076 | 5765784156 | NULL | 714 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 6c393c378300db16f43a36d57e61e321 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3196 | NULL | 961 | 0 | 17916500196 | 5765784156 | NULL | 714 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 48df5e1dde5beeb3ab811e6699bad4f3 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3197 | NULL | 961 | 0 | 17916739116 | 5765784156 | NULL | 714 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6302994b348d0c331f017745e77aa563 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3198 | NULL | 961 | 0 | 17916739236 | 5765784156 | NULL | 714 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 2179ec3c82e3431048fc6f8fc8f47f0f | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3199 | NULL | 961 | 0 | 17916739356 | 5765784156 | NULL | 714 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 350f6ec5f6a28b358b60c97807d076d6 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3200 | NULL | 961 | 0 | 17916739476 | 5765784156 | NULL | 714 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6228bf7ec712c76f259df610dbb7ff0b | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3185 | NULL | 962 | 0 | 17916498756 | 5765784276 | NULL | 713 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 48df5e1dde5beeb3ab811e6699bad4f3 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3186 | NULL | 962 | 0 | 17916498876 | 5765784276 | NULL | 713 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 4b1b549bf6460596d546a040c7628731 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3187 | NULL | 962 | 0 | 17916498996 | 5765784276 | NULL | 713 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploy.com | www.redeploy.com | 0 | 0 | e128a63ee490c0ff55360330d9facac1 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3188 | NULL | 962 | 0 | 17916499116 | 5765784276 | NULL | 713 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 6c393c378300db16f43a36d57e61e321 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3201 | NULL | 962 | 0 | 17916739596 | 5765784276 | NULL | 713 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6228bf7ec712c76f259df610dbb7ff0b | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3202 | NULL | 962 | 0 | 17916739716 | 5765784276 | NULL | 713 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6302994b348d0c331f017745e77aa563 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3203 | NULL | 962 | 0 | 17916739836 | 5765784276 | NULL | 713 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 2179ec3c82e3431048fc6f8fc8f47f0f | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3204 | NULL | 962 | 0 | 17916739956 | 5765784276 | NULL | 713 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 350f6ec5f6a28b358b60c97807d076d6 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3189 | NULL | 963 | 0 | 17916499236 | 5765784396 | NULL | 715 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 4b1b549bf6460596d546a040c7628731 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3190 | NULL | 963 | 0 | 17916499356 | 5765784396 | NULL | 715 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploy.com | www.redeploy.com | 0 | 0 | e128a63ee490c0ff55360330d9facac1 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3191 | NULL | 963 | 0 | 17916499476 | 5765784396 | NULL | 715 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 6c393c378300db16f43a36d57e61e321 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3192 | NULL | 963 | 0 | 17916499596 | 5765784396 | NULL | 715 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 48df5e1dde5beeb3ab811e6699bad4f3 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3205 | NULL | 963 | 0 | 17916740076 | 5765784396 | NULL | 715 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6302994b348d0c331f017745e77aa563 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3206 | NULL | 963 | 0 | 17916740196 | 5765784396 | NULL | 715 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 2179ec3c82e3431048fc6f8fc8f47f0f | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3207 | NULL | 963 | 0 | 17916740316 | 5765784396 | NULL | 715 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 350f6ec5f6a28b358b60c97807d076d6 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3208 | NULL | 963 | 0 | 17916740436 | 5765784396 | NULL | 715 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6228bf7ec712c76f259df610dbb7ff0b | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | +------+--------+-----------------------+-----------+------------------------+-----------------------------+-----------------------+---------------------+------+----------------------------+----------------------------------+----------------------------------+-----------------------------+----------------------+---------------------+-------------------------+----------------------------------+----------+---------+--------------------+------------------------+---------------------+---------------------+ # Following is the Query executed for searchEngineListings for the old and new campaigns. mysql> SELECT * FROM `st-tracker`.searchEngineListings where searchEngineAccountID in (961,962,963,964,965,966); +------+--------+-----------------------+-----------+------------------------+-----------------------------+-----------------------+---------------------+------+-----------------------------+-------------------------------------+-------------------------------------+-----------------------------+----------------------+---------------------+-------------------------+----------------------------------+----------+---------+--------------------+------------------------+---------------------+---------------------+ | id | altKey | searchEngineAccountID | listingID | searchEngineIdentifier | searchEngineGroupIdentifier | searchEngineMatchType | searchEngineGroupID | type | title | description1 | description2 | url | displayURL | searchEngineImageID | iconSearchEngineImageID | hash | calcHash | enabled | searchEngineStatus | searchEngineStatusText | lastChecked | lastModified | +------+--------+-----------------------+-----------+------------------------+-----------------------------+-----------------------+---------------------+------+-----------------------------+-------------------------------------+-------------------------------------+-----------------------------+----------------------+---------------------+-------------------------+----------------------------------+----------+---------+--------------------+------------------------+---------------------+---------------------+ | 3193 | NULL | 961 | 0 | 17916499836 | 5765784156 | NULL | 714 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 4b1b549bf6460596d546a040c7628731 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3194 | NULL | 961 | 0 | 17916499956 | 5765784156 | NULL | 714 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploy.com | www.redeploy.com | 0 | 0 | e128a63ee490c0ff55360330d9facac1 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3195 | NULL | 961 | 0 | 17916500076 | 5765784156 | NULL | 714 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 6c393c378300db16f43a36d57e61e321 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3196 | NULL | 961 | 0 | 17916500196 | 5765784156 | NULL | 714 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 48df5e1dde5beeb3ab811e6699bad4f3 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3197 | NULL | 961 | 0 | 17916739116 | 5765784156 | NULL | 714 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6302994b348d0c331f017745e77aa563 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3198 | NULL | 961 | 0 | 17916739236 | 5765784156 | NULL | 714 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 2179ec3c82e3431048fc6f8fc8f47f0f | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3199 | NULL | 961 | 0 | 17916739356 | 5765784156 | NULL | 714 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 350f6ec5f6a28b358b60c97807d076d6 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3200 | NULL | 961 | 0 | 17916739476 | 5765784156 | NULL | 714 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6228bf7ec712c76f259df610dbb7ff0b | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:05:31 | | 3185 | NULL | 962 | 0 | 17916498756 | 5765784276 | NULL | 713 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 48df5e1dde5beeb3ab811e6699bad4f3 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3186 | NULL | 962 | 0 | 17916498876 | 5765784276 | NULL | 713 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 4b1b549bf6460596d546a040c7628731 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3187 | NULL | 962 | 0 | 17916498996 | 5765784276 | NULL | 713 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploy.com | www.redeploy.com | 0 | 0 | e128a63ee490c0ff55360330d9facac1 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3188 | NULL | 962 | 0 | 17916499116 | 5765784276 | NULL | 713 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 6c393c378300db16f43a36d57e61e321 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3201 | NULL | 962 | 0 | 17916739596 | 5765784276 | NULL | 713 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6228bf7ec712c76f259df610dbb7ff0b | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3202 | NULL | 962 | 0 | 17916739716 | 5765784276 | NULL | 713 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6302994b348d0c331f017745e77aa563 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3203 | NULL | 962 | 0 | 17916739836 | 5765784276 | NULL | 713 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 2179ec3c82e3431048fc6f8fc8f47f0f | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3204 | NULL | 962 | 0 | 17916739956 | 5765784276 | NULL | 713 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 350f6ec5f6a28b358b60c97807d076d6 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3189 | NULL | 963 | 0 | 17916499236 | 5765784396 | NULL | 715 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 4b1b549bf6460596d546a040c7628731 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3190 | NULL | 963 | 0 | 17916499356 | 5765784396 | NULL | 715 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploy.com | www.redeploy.com | 0 | 0 | e128a63ee490c0ff55360330d9facac1 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3191 | NULL | 963 | 0 | 17916499476 | 5765784396 | NULL | 715 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 6c393c378300db16f43a36d57e61e321 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3192 | NULL | 963 | 0 | 17916499596 | 5765784396 | NULL | 715 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploy.com | www.redeploy.com | 0 | 0 | 48df5e1dde5beeb3ab811e6699bad4f3 | true | false | deleted | Deleted | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3205 | NULL | 963 | 0 | 17916740076 | 5765784396 | NULL | 715 | text | {KeyWord:Wonderful Hostel} | Great Service & Location. | The Better Hostel - Contact Us. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6302994b348d0c331f017745e77aa563 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3206 | NULL | 963 | 0 | 17916740196 | 5765784396 | NULL | 715 | text | The Right Hostel | A Charming Hostel - Come & Stay. | You'll Have A Great Stay Here! | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 2179ec3c82e3431048fc6f8fc8f47f0f | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3207 | NULL | 963 | 0 | 17916740316 | 5765784396 | NULL | 715 | text | {KeyWord:The Right Hostel} | You'll Have A Great Stay Here! | A Charming Hostel - Come & Stay. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 350f6ec5f6a28b358b60c97807d076d6 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3208 | NULL | 963 | 0 | 17916740436 | 5765784396 | NULL | 715 | text | Wonderful Hostel | The Better Hostel - Contact Us. | Great Service & Location. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6228bf7ec712c76f259df610dbb7ff0b | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:06:32 | | 3217 | NULL | 964 | 0 | 17916744636 | 5765791956 | NULL | 716 | text | {KeyWord:Heat Pumps} | See Our Range Of Services Now. | Full Range Of Heat Pump Services. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | bf238da14b5e64e04841088bb6f81145 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:40 | | 3218 | NULL | 964 | 0 | 17916744756 | 5765791956 | NULL | 716 | text | Heat Pump Experts | Your Heat Pump Specialists. | Great Service, Competitive Pricing. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6cb2b60e280f283a4f8078fe25a366cd | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:40 | | 3219 | NULL | 964 | 0 | 17916744876 | 5765791956 | NULL | 716 | text | {KeyWord:Heat Pump Experts} | Great Service, Competitive Pricing. | Your Heat Pump Specialists. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 06c60a5f0746349f9eb5908374d32ebe | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:40 | | 3220 | NULL | 964 | 0 | 17916744996 | 5765791956 | NULL | 716 | text | Heat Pumps | Full Range Of Heat Pump Services. | See Our Range Of Services Now. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 1771eb8eac7c55ec13a3c57f1f40d86f | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:40 | | 3209 | NULL | 965 | 0 | 17916745596 | 5765792076 | NULL | 717 | text | Heat Pumps | Full Range Of Heat Pump Services. | See Our Range Of Services Now. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 1771eb8eac7c55ec13a3c57f1f40d86f | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:38 | | 3210 | NULL | 965 | 0 | 17916745716 | 5765792076 | NULL | 717 | text | {KeyWord:Heat Pumps} | See Our Range Of Services Now. | Full Range Of Heat Pump Services. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | bf238da14b5e64e04841088bb6f81145 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:38 | | 3211 | NULL | 965 | 0 | 17916745836 | 5765792076 | NULL | 717 | text | Heat Pump Experts | Your Heat Pump Specialists. | Great Service, Competitive Pricing. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6cb2b60e280f283a4f8078fe25a366cd | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:38 | | 3212 | NULL | 965 | 0 | 17916745956 | 5765792076 | NULL | 717 | text | {KeyWord:Heat Pump Experts} | Great Service, Competitive Pricing. | Your Heat Pump Specialists. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 06c60a5f0746349f9eb5908374d32ebe | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:38 | | 3213 | NULL | 966 | 0 | 17916745116 | 5765792196 | NULL | 718 | text | {KeyWord:Heat Pumps} | See Our Range Of Services Now. | Full Range Of Heat Pump Services. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | bf238da14b5e64e04841088bb6f81145 | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:40 | | 3214 | NULL | 966 | 0 | 17916745236 | 5765792196 | NULL | 718 | text | Heat Pump Experts | Your Heat Pump Specialists. | Great Service, Competitive Pricing. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 6cb2b60e280f283a4f8078fe25a366cd | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:40 | | 3215 | NULL | 966 | 0 | 17916745356 | 5765792196 | NULL | 718 | text | {KeyWord:Heat Pump Experts} | Great Service, Competitive Pricing. | Your Heat Pump Specialists. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 06c60a5f0746349f9eb5908374d32ebe | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:40 | | 3216 | NULL | 966 | 0 | 17916745476 | 5765792196 | NULL | 718 | text | Heat Pumps | Full Range Of Heat Pump Services. | See Our Range Of Services Now. | http://www.redeploycamp.com | www.redeploycamp.com | 0 | 0 | 1771eb8eac7c55ec13a3c57f1f40d86f | true | false | ok | Enabled | 0000-00-00 00:00:00 | 2013-01-10 08:07:40 | +------+--------+-----------------------+-----------+------------------------+-----------------------------+-----------------------+---------------------+------+-----------------------------+-------------------------------------+-------------------------------------+-----------------------------+----------------------+---------------------+-------------------------+----------------------------------+----------+---------+--------------------+------------------------+---------------------+---------------------+