+ Start a Discussion
ChelseyChelsey 

Multi City Lead Queues

I am trying to create 2 lead queues for my sales team based on the Lead City field:

 

1. Northern CA

2. Southern CA

 

The problem I am having is how to add the 675 city names to the assignment rule for Nor Cal and the 1,071 city names for So. Cal.

 

Thoughts?

 

 

Nor Cal cities are:

 

SALINAS,
BIG SUR,
CARMEL BY THE SEA,
CARMEL,
CARMEL VALLEY,
CHUALAR,
GONZALES,
GREENFIELD,
JOLON,
KING CITY,
LOCKWOOD,
MARINA,
MONTEREY,
PACIFIC GROVE,
PEBBLE BEACH,
SAN LUCAS,
SEASIDE,
SOLEDAD,
SPRECKELS,
BELMONT,
BRISBANE,
BURLINGAME,
DALY CITY,
EL GRANADA,
HALF MOON BAY,
LA HONDA,
LOMA MAR,
LOS ALTOS,
MENLO PARK,
ATHERTON,
PORTOLA VALLEY,
MILLBRAE,
MOUNTAIN VIEW,
MONTARA,
MOSS BEACH,
PACIFICA,
PESCADERO,
REDWOOD CITY,
SAN BRUNO,
SAN CARLOS,
SAN GREGORIO,
SOUTH SAN FRANCISCO,
SUNNYVALE,
SAN FRANCISCO,
SACRAMENTO,
PALO ALTO,
STANFORD,
SAN MATEO,
ALAMEDA,
AMERICAN CANYON,
DISCOVERY BAY,
DANVILLE,
ALAMO,
ANGWIN,
ANTIOCH,
BENICIA,
BETHEL ISLAND,
BIRDS LANDING,
BRENTWOOD,
BYRON,
CALISTOGA,
CANYON,
CLAYTON,
CONCORD,
PLEASANT HILL,
CROCKETT,
DIABLO,
EL CERRITO,
FAIRFIELD,
TRAVIS AFB,
FREMONT,
HAYWARD,
CASTRO VALLEY,
HERCULES,
KNIGHTSEN,
LAFAYETTE,
LIVERMORE,
MARTINEZ,
MORAGA,
NAPA,
NEWARK,
OAKLEY,
OAKVILLE,
ORINDA,
PINOLE,
PITTSBURG,
PLEASANTON,
POPE VALLEY,
DUBLIN,
PORT COSTA,
RIO VISTA,
RODEO,
RUTHERFORD,
SAINT HELENA,
DEER PARK,
SAN LEANDRO,
SAN LORENZO,
SAN RAMON,
SUISUN CITY,
SUNOL,
UNION CITY,
VALLEJO,
WALNUT CREEK,
YOUNTVILLE,
OAKLAND,
EMERYVILLE,
PIEDMONT,
BERKELEY,
ALBANY,
RICHMOND,
EL SOBRANTE,
SAN PABLO,
SAN RAFAEL,
GREENBRAE,
KENTFIELD,
BELVEDERE TIBURON,
BODEGA,
BODEGA BAY,
BOLINAS,
CORTE MADERA,
ROHNERT PARK,
DILLON BEACH,
FAIRFAX,
COTATI,
FOREST KNOLLS,
INVERNESS,
LAGUNITAS,
LARKSPUR,
MARSHALL,
MILL VALLEY,
NOVATO,
NICASIO,
OLEMA,
PENNGROVE,
PETALUMA,
POINT REYES STATION,
ROSS,
SAN ANSELMO,
SAN GERONIMO,
SAN QUENTIN,
SAUSALITO,
STINSON BEACH,
TOMALES,
VALLEY FORD,
WOODACRE,
APTOS,
ALVISO,
AROMAS,
BEN LOMOND,
BOULDER CREEK,
BROOKDALE,
CAMPBELL,
CAPITOLA,
CASTROVILLE,
COYOTE,
CUPERTINO,
DAVENPORT,
FELTON,
FREEDOM,
GILROY,
HOLLISTER,
HOLY CITY,
LOS GATOS,
MILPITAS,
MORGAN HILL,
MOSS LANDING,
MOUNT HERMON,
NEW ALMADEN,
PAICINES,
REDWOOD ESTATES,
SAN JUAN BAUTISTA,
SAN MARTIN,
SANTA CLARA,
SANTA CRUZ,
SCOTTS VALLEY,
SARATOGA,
SOQUEL,
TRES PINOS,
WATSONVILLE,
SAN JOSE,
MOUNT HAMILTON,
STOCKTON,
ACAMPO,
ALTAVILLE,
ANGELS CAMP,
ARNOLD,
AVERY,
BURSON,
CAMPO SECO,
CLEMENTS,
COPPEROPOLIS,
DOUGLAS FLAT,
FARMINGTON,
FRENCH CAMP,
GLENCOE,
HATHAWAY PINES,
HOLT,
LINDEN,
LOCKEFORD,
LODI,
MOKELUMNE HILL,
MOUNTAIN RANCH,
MURPHYS,
RAIL ROAD FLAT,
SAN ANDREAS,
SHEEP RANCH,
VALLECITO,
VALLEY SPRINGS,
VICTOR,
WALLACE,
WEST POINT,
WILSEYVILLE,
WOODBRIDGE,
ATWATER,
BALLICO,
TRACY,
BIG OAK FLAT,
CATHEYS VALLEY,
CERES,
CHINESE CAMP,
COLUMBIA,
COULTERVILLE,
CRESSEY,
CROWS LANDING,
DARDANELLE,
DELHI,
DENAIR,
EL NIDO,
EL PORTAL,
EMPIRE,
ESCALON,
GROVELAND,
GUSTINE,
HICKMAN,
HILMAR,
HORNITOS,
HUGHSON,
JAMESTOWN,
KEYES,
LA GRANGE,
LATHROP,
LE GRAND,
LIVINGSTON,
LONG BARN,
MANTECA,
MARIPOSA,
MERCED,
MIDPINES,
MI WUK VILLAGE,
MOCCASIN,
MODESTO,
NEWMAN,
OAKDALE,
PATTERSON,
PINECREST,
PLANADA,
RIPON,
RIVERBANK,
SALIDA,
SNELLING,
SONORA,
SOULSBYVILLE,
STANDARD,
STEVINSON,
STRAWBERRY,
TUOLUMNE,
TURLOCK,
TWAIN HARTE,
VERNALIS,
WATERFORD,
WESTLEY,
WINTON,
YOSEMITE NATIONAL PARK,
SANTA ROSA,
ALBION,
ANNAPOLIS,
BOONVILLE,
BOYES HOT SPRINGS,
BRANSCOMB,
CALPELLA,
CAMP MEEKER,
CASPAR,
CAZADERO,
CLEARLAKE,
CLEARLAKE OAKS,
CLEARLAKE PARK,
CLOVERDALE,
COBB,
COMPTCHE,
COVELO,
DOS RIOS,
DUNCANS MILLS,
ELDRIDGE,
ELK,
EL VERANO,
FINLEY,
FORESTVILLE,
FORT BRAGG,
FULTON,
GEYSERVILLE,
GLEN ELLEN,
GLENHAVEN,
GRATON,
GUALALA,
GUERNEVILLE,
HEALDSBURG,
HOPLAND,
JENNER,
KELSEYVILLE,
KENWOOD,
LAKEPORT,
LAYTONVILLE,
LITTLE RIVER,
LOWER LAKE,
LUCERNE,
MANCHESTER,
MENDOCINO,
MIDDLETOWN,
MONTE RIO,
NAVARRO,
NICE,
OCCIDENTAL,
PHILO,
HIDDEN VALLEY LAKE,
POINT ARENA,
POTTER VALLEY,
REDWOOD VALLEY,
RIO NIDO,
SEBASTOPOL,
SONOMA,
STEWARTS POINT,
TALMAGE,
UKIAH,
UPPER LAKE,
VILLA GRANDE,
VINEBURG,
WESTPORT,
WILLITS,
WINDSOR,
WITTER SPRINGS,
YORKVILLE,
THE SEA RANCH,
EUREKA,
ALDERPOINT,
BLOCKSBURG,
ARCATA,
MCKINLEYVILLE,
BAYSIDE,
BLUE LAKE,
BRIDGEVILLE,
BURNT RANCH,
CARLOTTA,
CRESCENT CITY,
CUTTEN,
FERNDALE,
FIELDS LANDING,
FORT **bleep**,
FORTUNA,
GARBERVILLE,
GASQUET,
HONEYDEW,
HOOPA,
HYDESVILLE,
KLAMATH,
KNEELAND,
KORBEL,
LOLETA,
MAD RIVER,
MIRANDA,
MYERS FLAT,
ORICK,
ORLEANS,
PETROLIA,
PHILLIPSVILLE,
REDWAY,
RIO DELL,
SALYER,
SAMOA,
SCOTIA,
SMITH RIVER,
SOMES BAR,
REDCREST,
TRINIDAD,
WEOTT,
WILLOW CREEK,
LEGGETT,
PIERCY,
WHITETHORN,
ZENIA,
AMADOR CITY,
AUBURN,
WEST SACRAMENTO,
BROOKS,
CAPAY,
CARMICHAEL,
CITRUS HEIGHTS,
CLARKSBURG,
COLOMA,
COOL,
COURTLAND,
DAVIS,
DIAMOND SPRINGS,
DIXON,
EL DORADO,
ELK GROVE,
ELMIRA,
ELVERTA,
ESPARTO,
FAIR OAKS,
FIDDLETOWN,
FOLSOM,
FORESTHILL,
GALT,
GARDEN VALLEY,
GEORGETOWN,
GREENWOOD,
GRIZZLY FLATS,
GUINDA,
HERALD,
HOOD,
IONE,
ISLETON,
JACKSON,
KIT CARSON,
KNIGHTS LANDING,
KIRKWOOD,
LINCOLN,
LOOMIS,
LOTUS,
MCCLELLAN,
MADISON,
MARTELL,
MATHER,
MOUNT AUKUM,
NEWCASTLE,
NICOLAUS,
NORTH HIGHLANDS,
ROSEVILLE,
ORANGEVALE,
PENRYN,
PILOT HILL,
PINE GROVE,
PIONEER,
PLACERVILLE,
PLEASANT GROVE,
PLYMOUTH,
RANCHO CORDOVA,
REPRESA,
RESCUE,
RIO LINDA,
RIO OSO,
RIVER PINES,
ROBBINS,
ROCKLIN,
RUMSEY,
RYDE,
SHERIDAN,
SHINGLE SPRINGS,
SLOUGHHOUSE,
SOMERSET,
SUTTER CREEK,
THORNTON,
VACAVILLE,
VOLCANO,
WALNUT GROVE,
WHEATLAND,
WILTON,
WINTERS,
WOODLAND,
YOLO,
ZAMORA,
DRYTOWN,
ALTA,
APPLEGATE,
CAMINO,
CHICAGO PARK,
COLFAX,
DUTCH FLAT,
EMIGRANT GAP,
GOLD RUN,
KYBURZ,
ECHO LAKE,
MEADOW VISTA,
NORDEN,
POLLOCK PINES,
SODA SPRINGS,
TWIN BRIDGES,
WEIMAR,
GRANITE BAY,
EL DORADO HILLS,
ANTELOPE,
MARYSVILLE,
BEALE AFB,
ALLEGHANY,
ARBUCKLE,
ARTOIS,
BANGOR,
BELDEN,
BERRY CREEK,
BIGGS,
BROWNS VALLEY,
BROWNSVILLE,
BUTTE CITY,
CAMPTONVILLE,
CANYON DAM,
CEDAR RIDGE,
CHALLENGE,
CHICO,
CLIPPER MILLS,
COLUSA,
CRESCENT MILLS,
DOBBINS,
DOWNIEVILLE,
DUNNIGAN,
DURHAM,
ELK CREEK,
FEATHER FALLS,
FORBESTOWN,
FOREST RANCH,
GLENN,
GOODYEARS BAR,
GRASS VALLEY,
PENN VALLEY,
GREENVILLE,
GRIDLEY,
GRIMES,
HAMILTON CITY,
LIVE OAK,
MAGALIA,
MAXWELL,
MEADOW VALLEY,
MERIDIAN,
NELSON,
NEVADA CITY,
NORTH SAN JUAN,
OLIVEHURST,
OREGON HOUSE,
ORLAND,
OROVILLE,
PARADISE,
PALERMO,
PRINCETON,
QUINCY,
RACKERBY,
RICHVALE,
ROUGH AND READY,
SMARTSVILLE,
STIRLING CITY,
STONYFORD,
STORRIE,
STRAWBERRY VALLEY,
SUTTER,
TAYLORSVILLE,
TWAIN,
WASHINGTON,
WILLIAMS,
WILLOWS,
YUBA CITY,
REDDING,
ADIN,
ANDERSON,
BELLA VISTA,
BIEBER,
BIG BAR,
BIG BEND,
BURNEY,
CALLAHAN,
CANBY,
CASSEL,
CASTELLA,
SHASTA LAKE,
CHESTER,
CORNING,
COTTONWOOD,
DORRIS,
DOUGLAS CITY,
DUNSMUIR,
ETNA,
FALL RIVER MILLS,
FLOURNOY,
FORKS OF SALMON,
FORT JONES,
FRENCH GULCH,
GAZELLE,
GERBER,
GREENVIEW,
GRENADA,
HAPPY CAMP,
HAT CREEK,
HAYFORK,
HORNBROOK,
HYAMPOM,
IGO,
JUNCTION CITY,
KLAMATH RIVER,
LAKEHEAD,
LEWISTON,
LOOKOUT,
LOS MOLINOS,
MCARTHUR,
MCCLOUD,
MACDOEL,
MANTON,
MILL CREEK,
MILLVILLE,
MINERAL,
MONTAGUE,
MONTGOMERY CREEK,
MOUNT SHASTA,
NUBIEBER,
OAK RUN,
OBRIEN,
OLD STATION,
PALO CEDRO,
PASKENTA,
PAYNES CREEK,
PLATINA,
PROBERTA,
RED BLUFF,
ROUND MOUNTAIN,
SCOTT BAR,
SEIAD VALLEY,
SHASTA,
SHINGLETOWN,
TEHAMA,
TRINITY CENTER,
VINA,
WEAVERVILLE,
WEED,
WHISKEYTOWN,
WHITMORE,
YREKA,
ALTURAS,
BLAIRSDEN-GRAEAGLE,
CEDARVILLE,
CHILCOOT,
CLIO,
COLEVILLE,
DAVIS CREEK,
DOYLE,
EAGLEVILLE,
FLORISTON,
FORT BIDWELL,
HERLONG,
JANESVILLE,
LAKE CITY,
LIKELY,
LITCHFIELD,
LOYALTON,
MADELINE,
MARKLEEVILLE,
MILFORD,
PORTOLA,
RAVENDALE,
CALPINE,
SIERRA CITY,
SIERRAVILLE,
SUSANVILLE,
STANDISH,
BECKWOURTH,
TERMO,
TOPAZ,
TULELAKE,
VINTON,
WENDEL,
WESTWOOD,
CARNELIAN BAY,
HOMEWOOD,
TAHOMA,
KINGS BEACH,
TAHOE CITY,
OLYMPIC VALLEY,
TAHOE VISTA,
SOUTH LAKE TAHOE,
TRUCKE

ChelseyChelsey

I found a solution, albeit a very long one.

 

  • Create a new assignment rule
  • Select the Sort Order
  • For the Criteria, Lead : City equals and then I paste in as many cities as the field will allow

 

I then created 25 rows of Criteria until all the Cities were covered and any that were left I just created a 2nd Assignment rule to include those the same as I did here.

 

The final step was to create an Advanced Filter condition:

1or 2 or 3 or 4 or 5 or 6 or 7 or 8 or 9 or 10 or 11 or 12 or 13 or 14 or 15 or 16 or 17 or 18 or 19 or 20 or 21 or 22 or 23 or 24 or 25

 

 

I am sure there is a better way to do this, or I hope anyway, but as a non-programmer, it works.

fifedogfifedog
what I did was used a break in Zip codes.  Find the zip code in the middle of the state and use a greater than 9XXXX for north other wise send it south.  There may be some small over lap but for those leads would it really matter that much in that small area?