Tools To Run Zipcode Data

Create Queue from Zip Ping Data

Check Ping Completion

Add New API and Locations to all_api_ctiy2

When Done=1 for all_api_city2 -> Start Here
Check City Price

Check Data

This script is running on allinonelocal.com/cron/x10.php
Calculate city price for all_api_city2 based on zipcode data.

All records must be done=1 in all_api_city2 to run this.
Create zip tables on account12

Create API Location Targets (Account10)

Create HIGH API Location Targets (Account10)

Create $38 target (Account10)

Create city targets (Account10)

Fix GEO Tables for account12. Don't run.

Script used to create adwords export and modify all_adwords_adsource_champs
Don't run without updating. It will create multiple of the same export campaign
Create API Location Targets (Account10)

Create Library Table

Create Library4 table

Add Pictures from all keyword rows (600) Needs edit for limit

Add Pictures from API rows (600)

Create Library NEW API Rows

Add Prompts from Variable Table Where done=0

Add Prompts from Variable Table For All API rows

Create Library Table

Create Library4 table

Update Campaign IDS

Update Campaign Ids in adwords_export

Check these before running

Update Campaign IDS

Check Business and same as

Copy same API data for pings

Check cj task and update with business and same as ID

Copy angi data for same as

Match Strings

Update KYWRDS for match_string

Update aa_new_key_targets for match string