Remove Location Targets (City Only) at Bing AdCenter

Overview
This task related to step 3 at YELL-813, gathers all the location targets that points to 'City' and removes them from SMS (gce_target table), and at AdWords. For more information about this task please look at YELL-813 Task Flow.

This task -
a. Retrieves all the location targets from SMS databases and stores the information at bce_campaign_location_target_summary.
Script at - https://bitbucket.org/tsa/sms-common/commits/3e2eb1849de1ad0ca6200c63ff717344543e74be#chg-db-structure/content_editor_bing/data/bce_campaign_location_target_summary_data.sql

b. Removes the location targets from SMS and Bing AdCenter, optionally in batches by retrieving the information at bce_campaign_location_target_summary stored by Step a.

Configuration
1. Create bce_campaign_location_targer_summary table at content_editor_bing at every shard
Script at - https://bitbucket.org/tsa/sms-common/commits/3e2eb1849de1ad0ca6200c63ff717344543e74be#chg-db-structure/content_editor_bing/tables/bce_campaign_location_target_summary.sql

2. Get location-target-remover.tgz from
File at - https://bitbucket.org/tsa/sms-core/commits/bc003012fd97bc7fa9f65969e7f82d237a030ac9#chg-tools/location-target-remover/location-target-remover-0.0.1-SNAPSHOT-assemble.tar.gz

3. Unzip to /usr/local/tsa

Testing
1. Retrieve all 'City' targets and add them to gce_campaign_location_target_summary
Please use the script at - https://bitbucket.org/tsa/sms-common/commits/3e2eb1849de1ad0ca6200c63ff717344543e74be#chg-db-structure/content_editor_bing/data/bce_campaign_location_target_summary_data.sql

Please run the script at all shards.

2. Remove location targets based on the information stored at gce_campaign_location_target_summary
Download the .tgz file. (Configuration section, Step 2), and unzip to /usr/local/tsa

Usage: java -jar location-target-remover-0.0.1-SNAPSHOT.jar [parameters - see below for more information]
/usr/local/tsa/location-target-remover-0.0.1-SNAPSHOT$ java -jar location-target-remover-0.0.1-SNAPSHOT.jar
usage: java -jar location-target-remover
-a all location targets
-b <batchSize> batched migration
-d <distributionId> distribution id of the search engine
-h <shard> database shard number indexed from 1
-s <startSeUserId> starting from search engine user id
-t <threads> number of threads

To test at test-environment, please use the shard number as 4
Example: java -jar location-target-remover-0.0.1-SNAPSHOT.jar -a -d147 -h4 -t20

Please configure the log4j.properties set at /conf folder, and point the same to any log output.